Caused by: 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 11
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
@Test
public void testUpdateUser() {
// 查询
User user = this.userMapper.queryUserById(11L);
// 更新
user.setAge(28);
user.setPassword("111111");
this.userMapper.updateUser(user);
}
<update id="updateUser" parameterType="cn.itcast.pojo.User">
update tb_user
set
user_name = #{userName},
password = #{password},
name = #{name},
age = #{age},
sex = #{sex},
birthday = #{birthday},
updated = NOW()
where
(id = #{id});
</update>
又遇到这个问题了,简直快无语了,然后把之前可以跑成功的代码复制过来就好了,对比也没发现有什么不同,就是这么奇怪吗?写代码就是磨练心性,不急不躁,心平气和
对比发现id那里少了一个},原来不仅要比对字段和属性,更重要的是比对你的符号是否正确,对数据库的语句确实是不太熟悉,需要进行一波复习。。。