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

修改 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文件,发现少了一个逗号 另外,Date类型的属性 不能加!=‘ ’ 的校验 否则也会报错:

经验分享 程序员 微信小程序 职场和发展