登录状态重置密码问题
来源: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 = ?

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
相似问题