mapper映射错误

来源：互联网发布：k软件音画制作编辑：程序博客网时间：2024/06/01 09:37

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 querying database.  Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jk.contrat_product_c' doesn't exist### The error may exist in file [E:\张\.metadata\.plugins\org.eclipse.wst.server.core\tmp1\webapps\jk\WEB-INF\classes\org\mapper\ContractProduct.xml]### The error may involve org.jk.mapper.ContractProductMapper.find-Inline### The error occurred while setting parameters### SQL: select * from contrat_product_c   where 1=1### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jk.contrat_product_c' doesn't exist; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jk.contrat_product_c' doesn't existorg.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:948)org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:827)javax.servlet.http.HttpServlet.service(HttpServlet.java:624)org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:812)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:107)

这个错误的原因是我在mapper中没有设置返回结果集!!!!

0 0