Home > Back-end >  Help!!!!!! HTTP Status 500 - Request processing failed
Help!!!!!! HTTP Status 500 - Request processing failed

Time:05-28

After running SSM Java program, the login background is this display:
HTTP Status 500 - Request processing failed; Nested exception is org. Springframework. JDBC. BadSqlGrammarException:
The exception

Org. Springframework. Web. Util. NestedServletException: Request processing failed; Nested exception is org. Springframework. JDBC. BadSqlGrammarException:
# # # Error querying the database. Cause: Java, SQL, SQLSyntaxErrorException: 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 'admin a where 1=1

And a.u sername='admin' 'at line 1
# # # The error may exist in The com/entity/admin. XML
# # # The error may involve com. Dao. AdminDAO. GetAdminByCond - The Inline
# # # The error occurred while setting The parameters
# # # SQL: select a. * from admin a where 1=1 and a.u sername=?
# # # Cause: Java. SQL. SQLSyntaxErrorException: 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 'admin a where 1=1

And a.u sername='admin' 'at line 1
; Bad SQL grammar []; Nested exception is Java. SQL. SQLSyntaxErrorException: 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 'admin a where 1=1

And a.u sername='admin' 'at line 1
Org. Springframework. Web. Servlet. FrameworkServlet. The processRequest (FrameworkServlet. Java: 982)
Org. Springframework. Web. Servlet. FrameworkServlet. DoPost (FrameworkServlet. Java: 872)
Javax.mail. Servlet. HTTP. HttpServlet. Service (HttpServlet. Java: 648)
Org. Springframework. Web. Servlet. FrameworkServlet. Service (846) FrameworkServlet. Java:
Javax.mail. 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: 197)
Org. Springframework. Web. Filter. OncePerRequestFilter. DoFilter (OncePerRequestFilter. Java: 107)
  • Related