Gentle0503 2018-02-14 03:54 采纳率: 64.7%
浏览 7930
已结题

HTTP Status 500 - Request processing failed;

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 'select group_concat(distinct

concat(
  'max(if(cname = ''',cname,
  ' at line 2

The error may exist in file [UsercourseMapping.xml]

The error may involve defaultParameterMap

The error occurred while setting parameters

SQL: set @sql = null; select group_concat(distinct concat( 'max(if(cname = ''',cname, ''', score, 0)) as ''', cname, '''' ) ) into @sql from usercourse; set @sql = concat('select uid as 学号, uname as 姓名,sum(score) as 总分, ', @sql, ' from usercourse where bid=1 group by uid '); prepare stmt from @sql; execute stmt; deallocate prepare stmt;

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 'select group_concat(distinct

concat(
  'max(if(cname = ''',cname,
  ' at line 2

; 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 'select group_concat(distinct
concat(
'max(if(cname = ''',cname,
' at line 2
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:963)
org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:842)
javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:827)
javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:91)
org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:106)

  • 写回答

4条回答

  • we82206307 2018-02-14 04:03
    关注

    你的sql有一个错误You have an error in your SQL syntax

    评论

报告相同问题?

悬赏问题

  • ¥100 关于使用MATLAB中copularnd函数的问题
  • ¥20 在虚拟机的pycharm上
  • ¥15 jupyterthemes 设置完毕后没有效果
  • ¥15 matlab图像高斯低通滤波
  • ¥15 针对曲面部件的制孔路径规划,大家有什么思路吗
  • ¥15 钢筋实图交点识别,机器视觉代码
  • ¥15 如何在Linux系统中,但是在window系统上idea里面可以正常运行?(相关搜索:jar包)
  • ¥50 400g qsfp 光模块iphy方案
  • ¥15 两块ADC0804用proteus仿真时,出现异常
  • ¥15 关于风控系统,如何去选择