自定义action 保存数据库失败，麻烦大神看看

shuangmianxia

怀疑是不是连接数据库有问题

shuangmianxia

上传的报错图片

cgrddv

shuangmianxia 发表于 2016-8-5 18:31
上传的报错图片

发一下后台报的错，看一下

shuangmianxia

cgrddv 发表于 2016-8-5 19:39
发一下后台报的错，看一下

这就是报错文件

cgrddv

shuangmianxia 发表于 2016-8-8 08:07

上面还有吗，你清空一下控制台，然后执行操作，把整个错误都发出来

shuangmianxia

cgrddv 发表于 2016-8-8 09:15
上面还有吗，你清空一下控制台，然后执行操作，把整个错误都发出来

com.justep.baas.action.ActionException: Action[cqkcy/ybgh/saveplb]执行失败，SQL执行失败，SQL:INSERT INTO yhplb (gsID,lx,Username,nr,shzt) VALUES('1','1','123','123asdfa56785','1')
        at com.justep.baas.action.Engine.execAction(Unknown Source)
        at com.justep.baas.action.Engine.execAction(Unknown Source)
        at com.justep.baas.servlet.BaasServlet.execService(Unknown Source)
        at com.justep.baas.servlet.BaasServlet.service(Unknown Source)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:497)
        ... 16 more
Caused by: com.justep.baas.data.sql.SQLException: SQL执行失败，SQL:INSERT INTO yhplb (gsID,lx,Username,nr,shzt) VALUES('1','1','123','123asdfa56785','1')
        at com.justep.baas.data.DataUtils.queryData(Unknown Source)
        at cqkcy.savepl.saveplb(savepl.java:24)
        at cqkcy.Ybgh__do.saveplb(Ybgh__do.java:267)
        ... 20 more
Caused by: java.sql.SQLException: Can not issue data manipulation statements with executeQuery().
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:998)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:937)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:872)
        at com.mysql.jdbc.StatementImpl.checkForDml(StatementImpl.java:472)
        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1966)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
        ... 23 more
八月 08, 2016 9:52:14 上午 org.apache.catalina.core.StandardWrapperValve invoke
严重: Servlet.service() for servlet WeX5_Baas_Servlet threw exception
java.sql.SQLException: Can not issue data manipulation statements with executeQuery().
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:998)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:937)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:872)
        at com.mysql.jdbc.StatementImpl.checkForDml(StatementImpl.java:472)
        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1966)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
        at com.justep.baas.data.DataUtils.queryData(Unknown Source)
        at cqkcy.savepl.saveplb(savepl.java:24)
        at cqkcy.Ybgh__do.saveplb(Ybgh__do.java:267)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:497)
        at com.justep.baas.action.Engine.execAction(Unknown Source)
        at com.justep.baas.action.Engine.execAction(Unknown Source)
        at com.justep.baas.servlet.BaasServlet.execService(Unknown Source)
        at com.justep.baas.servlet.BaasServlet.service(Unknown Source)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:745)

cgrddv

shuangmianxia 发表于 2016-8-8 09:52
com.justep.baas.action.ActionException: Action[cqkcy/ybgh/saveplb]执行失败，SQL执行失败，SQL:INSER ...

INSERT INTO yhplb (gsID,lx,Username,nr,shzt) VALUES('1','1','123','123asdfa56785','1')，先去数据库单独执行这条语句，看看可不可以成功

shuangmianxia

cgrddv 发表于 2016-8-8 10:15
INSERT INTO yhplb (gsID,lx,Username,nr,shzt) VALUES('1','1','123','123asdfa56785','1')，先去数据库 ...

可以执行成功

cgrddv

shuangmianxia 发表于 2016-8-8 10:28
可以执行成功

方便＋qq吗？601464511，可以帮你远程看一下

shuangmianxia

问题解决，非常感谢版主耐心帮助