Error updating database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'born_date='2010-04-05 00:00:00',info='测试'' at line 1
### The error may involve com.imooc.sm.dao.StaffDao.update-Inline
### The error occurred while setting parameters
### SQL: update staff set account=?,password=?,status=?,did=?,name=?,sex=?,id_number=?,work_time=?,leave_time?,born_date=?,info=?
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'born_date='2010-04-05 00:00:00',info='测试'' at line 1
; bad SQL grammar []
下面是的映射文件里面的Sql
update staff set account=#{account},password=#{password},status=#{status},did=#{did},name=#{name},sex=#{sex},id_number=#{idNumber},work_time=#{workTime},leave_time#{leaveTime},born_date=#{bornDate},info=#{info}