SQL injection in SqlUtil.execQuery

Metadata

ID: java-security/potential-sql-injection

Language: Java

Severity: Warning

Category: Security

CWE: 89

The parameter of the SQL query should be properly escaped and validated.

class Foobar {

    public void test() {
        SqlUtil.execQuery("select * from UserEntity t where id = " + parameterInput);
    }
}

class Foobar {

    public void test() {
        SqlUtil.execQuery("select * from UserEntity t where id = " + sanitize(parameterInput));
    }
}

1
2
rulesets:
  - java-security     # Rules to enforce Java security.

Create a static-analysis.datadog.yml with the content above at the root of your repository
Use our free IDE Plugins or add Code Analysis scans to your CI pipelines
Get feedback on your code

For more information, please read the Code Analysis documentation

Identify code vulnerabilities directly in your
VS Code editor

Identify code vulnerabilities directly in
JetBrains products