登录状态重置密码问题

来源:6-9 用户模块所有功能自测试

凯里K

2019-08-16

当旧密码错误的时候,有旧密码错误提示,旧密码正确就报错,不提示成功。而且对照课程源码复制粘贴改了两次还是一样。

Apache Tomcat/7.0.75 - Error report

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语句。

0
0

从0开始 独立完成企业级Java电商网站服务端开发

前后端分离,数据库接口设计,架构设计,功能开发,上线运维

9476 学习 · 8804 问题

查看课程