天天看点

Cause: java.sql.SQLException: sql injection violation, syntax error: ERROR. token : USE, pos : 229

11:32:23 [http-nio-8081-exec-1] ERROR c.k.c.exception.BDExceptionHandler - 
### Error querying database.  Cause: java.sql.SQLException: sql injection violation, syntax error: ERROR. token : USE, pos : 229 : SELECT
        c.OBJECT_SID,
        c.CREATED,
        IFNULL( cot.SEX, '未知' ) AS SEX,
        IFNULL( c.STATUSTWO, 0 ) AS STATUSTWO,
        IFNULL( dic.value, '未知' ) AS STATUSTWO_NAME,
        c.CREATED_BY,
        IFNULL( use.name, '未知' ) AS CREATED_BY_NAME,
        
        FROM
        ccpm_crm_customer c
        LEFT JOIN crm_custome_ext cce ON cce.CUSTOMER_SID = c.OBJECT_SID
        LEFT JOIN sys_user use ON c.CREATED_BY=use.user_id
        
         WHERE  c.IS_ACTIVE = ?
         order by OBJECT_SID desc
           

可以通过

token : USE

快速定位到错误原因

错误原因:use是限定词,不能作为别名使用,换一个别名即可