Open source software supply chain lighting plan, waiting for you>>>
1. Spring integrates spring MVC
2、Log:
java.sql.SQLException: Can not issue data manipulation statements with executeQuery().
com.mysql.jdbc.Statement.checkForDml(Statement.java:298)
com.mysql.jdbc.Statement.executeQuery(Statement.java:750)
com.User.Dao.UserDaoImpl.modify(UserDaoImpl.java:367)
com.User.Service.UserServiceImpl.modify(UserServiceImpl.java:53)
com.User.Controller.UserController.modifyUserSave(UserController.java:503)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)
org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97)
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827)
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738)
org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967)
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901)
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)
javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
javax.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)
Solution: there are many methods of statement. The executeQuery () method is used to execute “query select” SQL, but the SQL I call here is “update”, which can be changed to the execute () method.
Similar Posts:
- FAQ 57: java.sql.SQLException: Can not issue data manipulation statements with executeQuery().
- Request processing failed; nested exception is java.lang.NullPointerException
- [Solved] Nested exception is org.apache.ibatis.binding.BindingException: Invalid bound statement (not found):
- java.lang.UnsatisfiedLinkError: no rxtxSerial in java.library.path
- java.security.cert.CertificateException: No subject alternative DNS name matching
- [Solved] javax.servlet.jsp.JspTagException: Don’t know how to iterate over supplied “items” in xxx
- springcloud Load balancer does not have available server for client:XXXX
- [Soloved] Fastdfs Error: java.net.SocketTimeoutException: connect timed out
- [Solved] Java.net.SocketException: Connection timed out (Write failed)