SQL injection in BasePeer

문서 > 코드 분석 > Static Analysis Rules > SQL injection in BasePeer

이 페이지는 아직 한국어로 제공되지 않으며 번역 작업 중입니다. 번역에 관한 질문이나 의견이 있으시면 언제든지 저희에게 연락해 주십시오.

Metadata

ID: java-security/sql-injection-turbine

Language: Java

Severity: Warning

Category: Security

Description

When issuing a SQL query with Turbine, make sure you do not build your query manually and use all the utility functions available with the library.

Learn More

CWE-89: Improper Neutralization of Special Elements used in an SQL Command
Potential SQL Injection with Turbine

Non-Compliant Code Examples

class Foobar {

    public void test() {
        List<Record> BasePeer.executeQuery( "select * from Customer where id=" + inputId );
    }
}

Compliant Code Examples

class Foobar {

    public void test() {
        Criteria c = new Criteria();
        c.add( CustomerPeer.ID, inputId );

        List<Customer> customers = CustomerPeer.doSelect( c );
    }
}