请稍等 ...
×

采纳答案成功！

向帮助你的同学说点啥吧！感谢那些助人为乐的人

为什么测试用户模块时只有login.do接口回复的信息是500

<html><head><title>Apache Tomcat/7.0.75 - Error report</title><style><!--H1 {fontfamily:Tahoma,Arial,sansserif;color:white;backgroundcolor:#525D76;fontsize:22px;} H2 {fontfamily:Tahoma,Arial,sansserif;color:white;backgroundcolor:#525D76;fontsize:16px;} H3 {fontfamily:Tahoma,Arial,sansserif;color:white;backgroundcolor:#525D76;fontsize:14px;} BODY {fontfamily:Tahoma,Arial,sansserif;color:black;backgroundcolor:white;} B {fontfamily:Tahoma,Arial,sansserif;color:white;backgroundcolor:#525D76;} P {fontfamily:Tahoma,Arial,sansserif;background:white;color:black;fontsize:12px;}A {color : black;}A.name {color : black;}HR {color : #525D76;}--></style> </head><body><h1>HTTP Status 500 - Request processing failed; nested exception is org.springframework.jdbc.BadSqlGrammarException: </h1><HR size="1" noshade="noshade"><p><b>type</b> Exception report</p><p><b>message</b> <u>Request processing failed; nested exception is org.springframework.jdbc.BadSqlGrammarException: </u></p><p><b>description</b> <u>The server encountered an internal error that prevented it from fulfilling this request.</u></p><p><b>exception</b> <pre>org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.jdbc.BadSqlGrammarException: ### Error querying 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 'id, username, password, email, phone, question, answer, role, create_time, updat' at line 1 ### The error may exist in file [C:\apache-tomcat-7.0.75\webapps\ROOT\WEB-INF\classes\mappers\UserMapper.xml] ### The error may involve com.mmall.dao.UserMapper.selectLogin-Inline ### The error occurred while setting parameters ### SQL: id, username, password, email, phone, question, answer, role, create_time, update_time            from mmall_user        where username = ?        and password = ? ### 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 'id, username, password, email, phone, question, answer, role, create_time, updat' at line 1 ; bad SQL grammar []; nested exception is 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 'id, username, password, email, phone, question, answer, role, create_time, updat' at line 1 org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:943) org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:833) javax.servlet.http.HttpServlet.service(HttpServlet.java:650) org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:807) javax.servlet.http.HttpServlet.service(HttpServlet.java:731) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88) org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:108)</pre></p><p><b>root cause</b> <pre>org.springframework.jdbc.BadSqlGrammarException: ### Error querying 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 'id, username, password, email, phone, question, answer, role, create_time, updat' at line 1 ### The error may exist in file [C:\apache-tomcat-7.0.75\webapps\ROOT\WEB-INF\classes\mappers\UserMapper.xml] ### The error may involve com.mmall.dao.UserMapper.selectLogin-Inline ### The error occurred while setting parameters ### SQL: id, username, password, email, phone, question, answer, role, create_time, update_time            from mmall_user        where username = ?        and password = ? ### 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 'id, username, password, email, phone, question, answer, role, create_time, updat' at line 1 ; bad SQL grammar []; nested exception is 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 'id, username, password, email, phone, question, answer, role, create_time, updat' at line 1 org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:231) org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73) org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:75) org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:447) com.sun.proxy.$Proxy19.selectOne(Unknown Source) org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:167) org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:82) org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:53) com.sun.proxy.$Proxy20.selectLogin(Unknown Source) com.mmall.service.impl.UserServiceImpl.login(UserServiceImpl.java:32) com.mmall.controller.portal.UserController.login(UserController.java:32) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) java.lang.reflect.Method.invoke(Method.java:606) org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:214) org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132) org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104) org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:748) org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:689) org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:83) org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:945) org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:876) org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:931) org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:833) javax.servlet.http.HttpServlet.service(HttpServlet.java:650) org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:807) javax.servlet.http.HttpServlet.service(HttpServlet.java:731) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88) org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:108)</pre></p><p><b>root cause</b> <pre>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 'id, username, password, email, phone, question, answer, role, create_time, updat' at line 1 sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) java.lang.reflect.Constructor.newInstance(Constructor.java:526) com.mysql.jdbc.Util.handleNewInstance(Util.java:406) com.mysql.jdbc.Util.getInstance(Util.java:381) com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030) com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491) com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423) com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936) com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060) com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542) com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734) com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:995) org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172) org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) java.lang.reflect.Method.invoke(Method.java:606) org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59) com.sun.proxy.$Proxy25.execute(Unknown Source) org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:63) org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79) org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63) org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324) org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156) org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109) org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:83) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) java.lang.reflect.Method.invoke(Method.java:606) org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49) com.github.pagehelper.SqlUtil._processPage(SqlUtil.java:401) com.github.pagehelper.SqlUtil.processPage(SqlUtil.java:374) com.github.pagehelper.PageHelper.intercept(PageHelper.java:250) org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61) com.sun.proxy.$Proxy23.query(Unknown Source) org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148) org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141) org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:77) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) java.lang.reflect.Method.invoke(Method.java:606) org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:434) com.sun.proxy.$Proxy19.selectOne(Unknown Source) org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:167) org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:82) org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:53) com.sun.proxy.$Proxy20.selectLogin(Unknown Source) com.mmall.service.impl.UserServiceImpl.login(UserServiceImpl.java:32) com.mmall.controller.portal.UserController.login(UserController.java:32) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) java.lang.reflect.Method.invoke(Method.java:606) org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:214) org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132) org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104) org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:748) org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:689) org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:83) org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:945) org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:876) org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:931) org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:833) javax.servlet.http.HttpServlet.service(HttpServlet.java:650) org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:807) javax.servlet.http.HttpServlet.service(HttpServlet.java:731) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88) org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:108)</pre></p><p><b>note</b> <u>The full stack trace of the root cause is available in the Apache Tomcat/7.0.75 logs.</u></p><HR size="1" noshade="noshade"><h3>Apache Tomcat/7.0.75</h3></body></html>
慕的地4500152 2017-05-23 17:55:32
源自：6-9  用户模块所有功能自测试
1108
收起

正在回答 回答被采纳积分+3

5回答

Geely 2017-05-26 00:06:43

hi同学你好。。。最好贴带格式的文字呀哈。 updat ....你那个截图sql报错的位置多明显

0 回复 有任何疑惑可以回复我~
收起回答
取消 回复
Blegend 2017-05-24 10:43:48

···我不是老师，老师可比我厉害多了  笑哭/xk  

是这个问题吗

0 回复 有任何疑惑可以回复我~
收起回答
取消 回复
Blegend 2017-05-24 09:46:18

同学  错误信息已经写的很清楚了，语法错误，你SQL写的有问题， 没有写SELECT

0 回复 有任何疑惑可以回复我~
收起回答
  • 提问者 慕的地4500152 #1 
    <select id="checkUsername" resultType="int" parameterType="string" >
    select count(1) from mmall_user
    where username = #{username}
  </select>
我已经写了啊
    回复 有任何疑惑可以回复我~ 2017-05-24 09:56:31
  • Blegend 回复 提问者 慕的地4500152 #2 
    不是这个句，其他的SQL也必须写对，要不mysql自动实现dao层会出问题的，你看你错误信息，哪句有错都写着呢
    回复 有任何疑惑可以回复我~ 2017-05-24 10:13:45
  • Blegend #3 
    mybatis 不是mysql  打错了
    回复 有任何疑惑可以回复我~ 2017-05-24 10:19:57
点开查看后面1条评论
取消 回复
提问者 慕的地4500152 2017-05-24 09:21:55

错误截图

https://img1.sycdn.imooc.com/szimg//5924e01d0001f78412300768.jpg

https://img1.sycdn.imooc.com/szimg//5924e01d0001307410230794.jpg

https://img1.sycdn.imooc.com/szimg//5924e01d0001869315500771.jpg

https://img1.sycdn.imooc.com/szimg//5924e01e0001730b11410789.jpg

https://img1.sycdn.imooc.com/szimg//5924e01e000166ba13090798.jpg

https://img1.sycdn.imooc.com/szimg//5924e02f0001097111210723.jpg

https://img1.sycdn.imooc.com/szimg//5924e02f0001e4d712690722.jpg


0 回复 有任何疑惑可以回复我~
收起回答
取消 回复
Blegend 2017-05-23 18:15:37

同学，你应该把错误信息的截图发上来，你发的这个你觉得别人能看清楚吗····

0 回复 有任何疑惑可以回复我~
收起回答
取消 回复

相似问题

为什么测试用户模块时只有login.do接口回复的信息是对的
901 0 1
用Restlet测试获取用户信息模块时，报ServerResponse不能转换为User
1243 0 6
在用户功能模块中有两个获取用户信息的接口
1249 0 4
用户修改接口测试时
891 0 5
获取用户信息接口请求未发送到后端服务器
482 0 5

登录后可查看更多问答，登录/注册

问题已解决，确定采纳
还有疑问，暂不采纳
从0开始 独立完成企业级Java电商网站服务端开发
  • 参与学习       9502    人
  • 解答问题       8820    个

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

了解课程

本课精华内容

问答

源配置能干嘛？它的作用是啥？目的又是什么？为什么这么配置？

11.3k 10

老师为什么我的阿里云远程就连不进去 改了安全组也不行

2.3k 22

【upload.do】504 (剧终，解决办法看下面我的最新一条评论)

1.9k 21

Could not get JDBC Connection无法登录了

2.8k 21

这是怎么回事前面GIT命令和maven执行不了

2.5k 18

查看更多本课问答
微信客服

购课补贴
联系客服咨询优惠详情

 帮助反馈 APP下载

慕课网APP
您的移动学习伙伴

 公众号

扫描二维码
关注慕课网微信公众号