FAQ（57）：java.sql.SQLException: Can not issue data manipulation statements with executeQuery().

1、场景：springmvc+spring 实现功能

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.add(UserDaoImpl.java:199)
  com.User.Service.UserServiceImpl.add(UserServiceImpl.java:36)
  com.User.Controller.UserController.addUserSave(UserController.java:177)
  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)

解决：

原因是这句：st.executeQuery("insert  into  student  values('"+name+"','"+age+"','"+introduce+"')") ;

我是看了书上一个例子，然后开始模仿，发现问题后，发现书上其他程序语句都是用这句，

后来看了几个网页，才明白这句应该该成这样子：st.execute("insert  into  student  values('"+name+"','"+age+"','"+introduce+"')") ;

最后总结：如果你的SQL 语句是诸如update,insert的更新语句，应该用statement的execute()方法，如果用的是statement的executeQuery()就会出现上诉问题