### Error updating database. Cause: java.sql.SQLException: sql injection violat, syntax error: TODO

时间:2024-03-25 15:09:39

修改 mapper.xml 报错
请求异常:parsererror出错了:有错误发生,但无法归类到某一更为具体的异常中 ### Error updating database. Cause: java.sql.SQLException: sql injection violation, syntax error: TODO : pos 166, line 11, column 24, token COMMA : update COLL_HELP_SELL_APP SET APPLY_TYPE = ?, DEALER_SEQ = ?, RECEIVE_DEALER_SEQ = ? APPLY_OPERATOR = ?, APPLY_DATETIME = ?, APPROVE_OPERATOR = ?, APPROVE_DATETIME = ?, APPROVE_STATUS = ? APPLY_REMARK = ?, CREATOR = ?, LAST_OPERATOR = ?, CREATE_DATETIME = ?, MODIFY_DATETIME = ? where APPLY_SEQ = ? AND APPROVE_STATUS = ? ### SQL: update COLL_HELP_SELL_APP SET APPLY_TYPE = ?, DEALER_SEQ = ?, RECEIVE_DEALER_SEQ = ? APPLY_OPERATOR = ?, APPLY_DATETIME = ?, APPROVE_OPERATOR = ?, APPROVE_DATETIME = ?, APPROVE_STATUS = ? APPLY_REMARK = ?, CREATOR = ?, LAST_OPERATOR = ?, CREATE_DATETIME = ?, MODIFY_DATETIME = ? where APPLY_SEQ = ? AND APPROVE_STATUS = ? ###

排查xml文件,发现少了一个逗号
### Error updating database. Cause: java.sql.SQLException: sql injection violat, syntax error: TODO
另外,Date类型的属性 不能加!=‘ ’ 的校验
否则也会报错:
### Error updating database. Cause: java.sql.SQLException: sql injection violat, syntax error: TODO