报错信息
[异常信息:org.springframework.jdbc.BadSqlGrammarException:
### Error updating database. Cause: java.sql.SQLSyntaxErrorException: ORA-00933: SQL 命令未正确结束
### The error may involve com.pty.sal.dao.SalEmployeeDao.updateById-Inline
### The error occurred while setting parameters
### SQL: UPDATE sal_employee SET id=? emp_name=? emp_code=? sex=? department_code=? department_name=? WHERE id=?
### Cause: java.sql.SQLSyntaxErrorException: ORA-00933: SQL 命令未正确结束
; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: ORA-00933: SQL 命令未正确结束
]
[异常堆栈信息:org.springframework.jdbc.BadSqlGrammarException:
### Error updating database. Cause: java.sql.SQLSyntaxErrorException: ORA-00933: SQL 命令未正确结束
### The error may involve com.pty.sal.dao.SalEmployeeDao.updateById-Inline
### The error occurred while setting parameters
### SQL: UPDATE sal_employee SET id=? emp_name=? emp_code=? sex=? department_code=? department_name=? WHERE id=?
### Cause: java.sql.SQLSyntaxErrorException: ORA-00933: SQL 命令未正确结束
; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: ORA-00933: SQL 命令未正确结束
错误原因:如图,修改的sql语句不应该有id,因为是根据id进行查找的