level 1
kelly凡
楼主
Criteria sql = new Criteria();
sql.append(" INSERT INTO ").append(table)
.append("MSG_ID,STATE,RETURN_CODE,RETURN_MSG,CREATE_TIME) VALUES(")
.append(","+wxDownHandle.getMsgId()+
"','"+wxDownHandle.getState()+
"','"+wxDownHandle.getReturnCode()+
"','"+wxDownHandle.getReturnMsg()+
"','"+wxDownHandle.getCreateTime()+
"','"+ DataUnit.values());
this.getDbTemplate().insertOrUpdate(sql.build());
一直报You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near错误
2021年11月11日 02点11分
1
sql.append(" INSERT INTO ").append(table)
.append("MSG_ID,STATE,RETURN_CODE,RETURN_MSG,CREATE_TIME) VALUES(")
.append(","+wxDownHandle.getMsgId()+
"','"+wxDownHandle.getState()+
"','"+wxDownHandle.getReturnCode()+
"','"+wxDownHandle.getReturnMsg()+
"','"+wxDownHandle.getCreateTime()+
"','"+ DataUnit.values());
this.getDbTemplate().insertOrUpdate(sql.build());
一直报You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near错误