请稍等 ...
×

采纳答案成功！

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

login.do报500错误

Hello word成功显示; http post 端口号前面的冒号等等我都注意了, 还是找不出原因. 拜托老师 朋友们帮忙查看一下问题在哪或者有可能在哪?
下面错误, 截图等等都有.

以下是Restlet Client显示的500错误内容:

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: FUNCTION shorin.count does not exist. Check the 'Function Name Parsing and Resolution' section in the Reference Manual
### The error may exist in file [/Library/Tomcat-8.5.8/webapps/ROOT/WEB-INF/classes/mappers/UserMapper.xml]
### The error may involve com.waanzok.dao.UserMapper.checkUsername-Inline
### The error occurred while setting parameters
### SQL: select     count (1) from mmall_user     where username = ?
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: FUNCTION shorin.count does not exist. Check the 'Function Name Parsing and Resolution' section in the Reference Manual
; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: FUNCTION shorin.count does not exist. Check the 'Function Name Parsing and Resolution' section in the Reference Manual
	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:648)
	org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:807)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
	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)
root cause

org.springframework.jdbc.BadSqlGrammarException: 
### Error querying database.  Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: FUNCTION shorin.count does not exist. Check the 'Function Name Parsing and Resolution' section in the Reference Manual
### The error may exist in file [/Library/Tomcat-8.5.8/webapps/ROOT/WEB-INF/classes/mappers/UserMapper.xml]
### The error may involve com.waanzok.dao.UserMapper.checkUsername-Inline
### The error occurred while setting parameters
### SQL: select     count (1) from mmall_user     where username = ?
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: FUNCTION shorin.count does not exist. Check the 'Function Name Parsing and Resolution' section in the Reference Manual
; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: FUNCTION shorin.count does not exist. Check the 'Function Name Parsing and Resolution' section in the Reference Manual
	org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:95)
	org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
	org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
	org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:75)
	org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:447)
	com.sun.proxy.$Proxy21.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.$Proxy22.checkUsername(Unknown Source)
	com.waanzok.service.impl.UserServiceImpl.login(UserServiceImpl.java:40)
	com.waanzok.controller.portal.UserController.login(UserController.java:49)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:498)
	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:648)
	org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:807)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
	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)
root cause

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: FUNCTION shorin.count does not exist. Check the 'Function Name Parsing and Resolution' section in the Reference Manual
	sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
	sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	java.lang.reflect.Constructor.newInstance(Constructor.java:423)
	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:62)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:498)
	org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59)
	com.sun.proxy.$Proxy27.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:62)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:498)
	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.$Proxy25.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:62)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:498)
	org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:434)
	com.sun.proxy.$Proxy21.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.$Proxy22.checkUsername(Unknown Source)
	com.waanzok.service.impl.UserServiceImpl.login(UserServiceImpl.java:40)
	com.waanzok.controller.portal.UserController.login(UserController.java:49)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:498)
	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:648)
	org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:807)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
	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)
note The full stack trace of the root cause is available in the Apache Tomcat/8.5.8 logs.

以下是Mac的 IDEA最下面自动显示的debug内容: (不知道有没有用)

[15:55:54.546][DEBUG][org.mybatis.spring.SqlSessionUtils][http-nio-8088-exec-6] Creating a new SqlSession
[15:55:54.547][DEBUG][org.mybatis.spring.SqlSessionUtils][http-nio-8088-exec-6] SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@546fb5fa] was not registered for synchronization because synchronization is not active
[15:55:54.554][DEBUG][o.m.s.t.SpringManagedTransaction][http-nio-8088-exec-6] JDBC Connection [jdbc:mysql://IP地址/shorin?characterEncoding=utf-8, UserName=shorin@IP地址, MySQL-AB JDBC Driver] will not be managed by Spring
[15:55:54.554][DEBUG][com.waanzok.dao.UserMapper.checkUsername][http-nio-8088-exec-6] ==>  Preparing: select count (1) from mmall_user where username = ? 
[15:55:54.555][DEBUG][com.waanzok.dao.UserMapper.checkUsername][http-nio-8088-exec-6] ==> Parameters: admin(String)
[15:55:54.557][DEBUG][org.mybatis.spring.SqlSessionUtils][http-nio-8088-exec-6] Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@546fb5fa]
[15:55:56.000][DEBUG][org.mybatis.spring.SqlSessionUtils][http-nio-8088-exec-7] Creating a new SqlSession
[15:55:56.001][DEBUG][org.mybatis.spring.SqlSessionUtils][http-nio-8088-exec-7] SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1f8cbbfc] was not registered for synchronization because synchronization is not active
[15:55:56.007][DEBUG][o.m.s.t.SpringManagedTransaction][http-nio-8088-exec-7] JDBC Connection [jdbc:mysql://IP地址/shorin?characterEncoding=utf-8, UserName=shorin@IP地址, MySQL-AB JDBC Driver] will not be managed by Spring
[15:55:56.007][DEBUG][com.waanzok.dao.UserMapper.checkUsername][http-nio-8088-exec-7] ==>  Preparing: select count (1) from mmall_user where username = ? 
[15:55:56.008][DEBUG][com.waanzok.dao.UserMapper.checkUsername][http-nio-8088-exec-7] ==> Parameters: admin(String)
[15:55:56.011][DEBUG][org.mybatis.spring.SqlSessionUtils][http-nio-8088-exec-7] Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1f8cbbfc]

以下是Restlet Client截图:
图片描述
以下是DB截图:
图片描述
ShorinChen 2018-10-29 17:26:45
源自：6-9  用户模块所有功能自测试
7779
收起

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

2回答

Geely 2018-11-04 21:59:12

赞一个，解决了就好，同学，这两天忙，刚看到。

0 回复 有任何疑惑可以回复我~
收起回答
取消 回复
提问者 ShorinChen 2018-10-30 12:08:33

已解决
count() 中 count和()中不能有空格... 低级错误

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

相似问题

500的错误
831 0 2
自己写的注册页面一直报错500，找不到原因，麻烦帮看一下
1434 0 9
login.do 500错误
1174 0 1
老师这个接口报错 500
828 0 3
login.do错误500
1183 1 3

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

问题已解决，确定采纳
还有疑问，暂不采纳
从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
您的移动学习伙伴

 公众号

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