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 'library.admin' doesn't exist ### The error may exist in com/yx/dao/AdminMapper.xml ### The error may involve defaultParameterMap ### The error occurred while setting parameters ### SQL: select * from admin where username=? and password=? ### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'library.admin' doesn't exist ; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'library.admin' doesn't exist org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1013) org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:908) javax.servlet.http.HttpServlet.service(HttpServlet.java:681) org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:882) javax.servlet.http.HttpServlet.service(HttpServlet.java:764) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200) org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
时间: 2023-08-06 10:05:29 浏览: 89
org.springframework.web.util.NestedServletException: 请求处理失败;嵌套异常是org.springframework.jdbc.BadSqlGrammarException:
### 查询数据库时出错。原因:com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:表 'library.admin' 不存在
### 错误可能出现在com/yx/dao/AdminMapper.xml中
### 错误可能涉及defaultParameterMap
### 在设置参数时发生错误
### SQL:select * from admin where username=? and password=?
### 原因:com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:表 'library.admin' 不存在
;错误的SQL语法[];嵌套异常是com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:表 'library.admin' 不存在
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1013)
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:908)
javax.servlet.http.HttpServlet.service(HttpServlet.java:681)
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:882)
javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)