The Java Cafe

The Java Cafe is a community of 3,747 amazing users

Java and Cloud content, by the community for the community

Create new account Log in
Cover image for SQL injection cheat sheet

SQL injection cheat sheet

brianverm profile image πŸ§‘πŸΌβ€πŸ’» Brian Vermeer ・Updated on ・1 min read

SQL injection is one of the most dangerous vulnerabilities for online applications. It occurs when a user adds untrusted data to a database query. For instance, when filling in a web form. If SQL injection is possible, smart attackers can create user input to steal valuable data, bypass authentication, or corrupt the records in your database.

There are different types of SQL injection attacks, but in general, they all have a similar cause. The untrusted data that the user enters is concatenated with the query string. Therefore the user’s input can alter the query’s original intent.

These are the 8 best practices we discuss in this article

  1. Do not rely on client-side input validation
  2. Use a database user with restricted privileges
  3. Use prepared statements and query parameterization
  4. Scan your code for SQL injection vulnerabilities
  5. Use an ORM layer
  6. Don’t rely on blocklisting
  7. Perform input validation
  8. Be careful with stored procedures

Read the full article

SQL Injection cheat sheet

Discussion (0)

Editor guide