一般出现这样的问题就是少些了字符,空格,逗号、引号、子母大小写的问题,唉,以后还是要规范一下代码书写的习惯。
问题描述
hobby=?, content=?, birthday=? where id = ? and id != 1
2020-12-04 09:44:14,864 [main] DEBUG [com.neusoft.usermanage.dao.UserinfoDao.updateUser] - ==> Parameters: 123456(String), test02(String), 2(String), 1(String), 0(String), http://www.jd.com(String), 打游(String), this 22222is content(String), 2020-12-04 09:44:14.516(Timestamp), 5(Integer)
2020-12-04 09:44:14,877 [main] DEBUG [org.mybatis.spring.SqlSessionUtils] - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1788cb61]
2020-12-04 09:44:14,919 [main] ERROR [com.neusoft.usermanage.service.UserServiceImpl] - UserinfoServiceImpl–>>updateUser
org.springframework.jdbc.BadSqlGrammarException: