登录状态重置密码问题
来源:6-9 用户模块所有功能自测试
凯里K
2019-08-16
当旧密码错误的时候,有旧密码错误提示,旧密码正确就报错,不提示成功。而且对照课程源码复制粘贴改了两次还是一样。
HTTP Status 500 - Request processing failed; nested exception is org.springframework.jdbc.BadSqlGrammarException:
type Exception report
message Request processing failed; nested exception is org.springframework.jdbc.BadSqlGrammarException:
description The server encountered an internal error that prevented it from fulfilling this request.
exception
org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.jdbc.BadSqlGrammarException: ### 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 'now() where id = 24' at line 26 ### The error may involve com.mmall.dao.UserMapper.updateByPrimaryKeySelective-Inline ### The error occurred while setting parameters ### SQL: update mmall_user SET username = ?, password = ?, email = ?, phone = ?, question = ?, answer = ?, role = ?, create_time = ?, now() where id = ?![图片描述](http://img.mukewang.com/szimg/5d56482e09856d5d11470088.jpg) ![图片描述](http://img1.sycdn.imooc.com/szimg/5d56483d094cf8fb12650287.jpg)![图片描述](http://img1.sycdn.imooc.com/szimg/5d56480d099a1ebf00000000.jpg)
1回答
-
geelylucky
2019-08-16
update mmall_user SET username = ?, password = ?, email = ?, phone = ?, question = ?, answer = ?, role = ?, create_time = ?, now() where id = ?
这个sql语句有语法问题,now()前面连字段都没有。检查UserMapper.xml里面的updateByPrimaryKeySelective这条sql语句。
00
相似问题