mysql只能select,不能insert?
connector/j 3 mysql 4 tomcat 5
以root執行,all privallege,不是許可權問題啊。
exception
javax.servlet.ServletException: Can not issue data manipulation statements with executeQuery()
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:867)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:800)
org.apache.jsp.bookshop.register_jsp._jspService(register_jsp.java:97)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
root cause
java.sql.SQLException: Can not issue data manipulation statements with executeQuery()
com.mysql.jdbc.Statement.executeQuery(Statement.java:1104)
org.apache.jsp.bookshop.register_jsp._jspService(register_jsp.java:73)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
以root執行,all privallege,不是許可權問題啊。
exception
javax.servlet.ServletException: Can not issue data manipulation statements with executeQuery()
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:867)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:800)
org.apache.jsp.bookshop.register_jsp._jspService(register_jsp.java:97)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
root cause
java.sql.SQLException: Can not issue data manipulation statements with executeQuery()
com.mysql.jdbc.Statement.executeQuery(Statement.java:1104)
org.apache.jsp.bookshop.register_jsp._jspService(register_jsp.java:73)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
相關文章
- 解析MySQL中INSERT INTO SELECT的使用MySql
- mysql insert into ... select的鎖問題MySql
- mysql update join,insert select 語法MySql
- insert into select
- insert into 與 select into 的區別
- select into from 和 insert into select 的用法和區別
- MySQL SELECT..INTO OUTFILE語句只能匯出1000行的故障MySql
- SQLite語句(二):INSERT DELETE UPDATE SELECTSQLitedelete
- MySQL INSERT DELAYEDMySql
- sqlserver不能直接create table as select ......SQLServer
- 字串資料不能用DW,只能用DB字串
- MySQL 4.1.0 中文參考手冊 --- 6.4 資料操縱:SELECT, INSERT, UPDATE, DELETE (轉)MySqldelete
- oracle SELECT INTO 和 INSERT INTO SELECT 兩種表複製語句詳解Oracle
- 加快insert into select速度with hints and nologging
- DBeaver如何生成select,update,delete,insert語句delete
- MySQL 提高Insert效能MySql
- 處理input file限制只能拍照不能選相簿
- mysql select稽核MySql
- insert into select 批量載入出錯解決方案
- Default Locking for INSERT, UPDATE, DELETE, and SELECT ... FOR UPDATE (351)delete
- 解決Mysql中只能通過localhost登陸不能通過ip登陸的問題MySqllocalhost
- mysql insert導致死鎖MySql
- mysql insert的特殊用法MySql
- 【MySQL】Insert buffer 漫談MySql
- mysql INSERT ... ON DUPLICATE KEY UPDATEMySql
- [20180907]insert+with+select.txt
- mysqPoint型別查詢和插入操作:insert和select型別
- insert into select 與 create table as的用法和區別(轉)
- mysql之select into outfileMySql
- MySql 中 select 使用MySql
- 【MySQL】四、Insert buffer 漫談MySql
- 如何優化MySQL insert效能優化MySql
- java-Mybatis XML 對映器(select,insert, update 和 delete)JavaMyBatisXMLdelete
- Category為什麼只能加方法不能加成員變數?Go變數
- win10能上微信不能上網 win10只能用微信不能開網頁Win10網頁
- MySQL:SELECT COUNT 小結MySql
- MYSQL SELECT INTO臨時表MySql
- SELECT INTO FROM mysql Undeclared variableMySql