4MySQLSyntaxErrorException: You have an error in your SQL syntax; check the ma

qqwe

　　下面是我遇到的错误：
　　### 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 ')' at line 9
　　 ### The error may involve defaultParameterMap
　　### The error occurred while setting parameters
　　### SQL: insert into dept_p (dept_id,dept_name,parent_id,state,create_time) values(?, ?, ?, ?, ?, )
　　### 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 ')' at line 9

　　错误分析：



<insert id="saveDept">
         insert into dept_p
             (dept_id,dept_name,parent_id,state,create_time)
         values(#{deptId},
                #{deptName},
                #{parentDept.deptId},
                #{state},
                #{createTime},
               )
</insert>

     

　　错误原因是右括号前多了一个逗号。