错误描述:
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 querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: #42000
### The error may exist in com/javapandeng/mapper/ItemMapper.xml
### The error may involve com.javapandeng.mapper.ItemMapper.load-Inline
### The error occurred while setting parameters
### SQL: select id,name,price,discount,gatherNum,purchaseNum,url1,url2,url3,url4,url5,describe,pam1,pam2,pam3,val1,val2,val3,type,category_id_one,category_id_two,isDelete from item where id=?
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: #42000
; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: #42000
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:978)
org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:857)
javax.servlet.http.HttpServlet.service(HttpServlet.java:618)
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:842)
javax.servlet.http.HttpServlet.service(HttpServlet.java:725)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
com.javapandeng.filter.SystemContextFilter.doFilter(SystemContextFilter.java:35)
org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
首先错误提示第一句话就是:
The error may exist in com/javapandeng/mapper/ItemMapper.xml
还有这句话
The error occurred while setting parameters
这句话很关键:
SQL: select id,name,price,discount,gatherNum,purchaseNum,url1,url2,url3,url4,url5,describe,pam1,pam2,pam3,val1,val2,val3,type,category_id_one,category_id_two,isDelete from item where id=?
说明错误在这句话。
然后顺腾摸瓜,原来是describe这个地方有问题,因为describe是sql关键字,所有才会报错
有两个个解决方案:
1.把describe改为describes
2.改为和describe相似的词