KSQL.executeUpdate能执行插入操作吗？

crj

KSQL.executeUpdate(sql, null, PersonDataModel, null);这个能执行插入的操作吗，sql语句写成插入语句，我执行的是操作不了的，如果这个方法不能执行插入操作，那我怎么样才能执行插入操作呢？谢谢了！

jason2014

ksql不行的话，可以用sql啊

忘了忘了

可以用sq了 。类似这样HashMap<String, String> sqlDetail = new HashMap<String, String>();
                String outSql = "update T_CompanyBanks set fAAmt = ((select fAAmt T_CompanyBanks where fid = '"+bankOutId+"' ) - "+amt+" - "+hcAmt+") " +
                " where fid = '"+bankOutId+"'";
                sqlDetail.put(DatabaseProduct.MSSQL.name(), outSql);
                SQL.executeUpdate(sqlDetail, null, dataUrl);

crj

KSQL.executeUpdate这个支持插入功能，可就是总提示错误

忘了忘了

crj 发表于 2014-8-4 14:04
KSQL.executeUpdate这个支持插入功能，可就是总提示错误

错误提示贴出来看看

jason2014

crj 发表于 2014-8-4 14:04
KSQL.executeUpdate这个支持插入功能，可就是总提示错误

提示错误那就是你代码问题了

crj

忘了忘了 发表于 2014-8-4 14:06
错误提示贴出来看看

<action process="/xusteelOA/workTime/process/threadJob/threadJobProcess" activity="mainActivity" name="getThreadAction" executeContext="" content-type="application/xml"><parameters/></action>
java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:592)
        at com.justep.system.action.Engine.invokeActions(Native Method)
        at com.justep.system.action.Engine.invokeActions(Unknown Source)
        at com.justep.business.server.BusinessServer.doAction(Unknown Source)
        at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
        at com.justep.business.server.BusinessServer.excute(Unknown Source)
        at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
        at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        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:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:595)
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: INSERT  INTO  leaveSummary (fBH,fName,fHZRQ,deptID,deptNames,monthLeaveDays,version,fID) values ('000059','郑迪文','2014-08-31 23:59:59','046DFE4BD7624367BFF2FFBB72BD0715','null','0',0,'1407132924062000059')
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlInsert(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlExecuteUpdate(Unknown Source)
        at com.justep.system.data.KSQL.executeUpdate(Unknown Source)
        at com.justep.system.data.KSQL.executeUpdate(Unknown Source)
        at com.justep.system.data.KSQL.executeUpdate(Unknown Source)
        at WorkTime.LeaveSummary(WorkTime.java:157)
        at WorkTime.getThread(WorkTime.java:26)
        ... 26 more
Caused by: com.justep.exception.KSQLException: 编码: JUSTEP154115; 提示: KSQL语法错误,   leaveSummary ^^(fBH,fName,fHZR中未找到需要的元素, 位置27期望是<Identifier>
        at com.justep.exception.KSQLException.create(Unknown Source)
        at com.justep.system.ksql.token.TokenManager.matchToken(Unknown Source)
        at com.justep.system.ksql.token.TokenManager.match(Unknown Source)
        at com.justep.system.ksql.parser.AbstractParser.modifyConceptNode(Unknown Source)
        at com.justep.system.ksql.parser.InsertParser.start(Unknown Source)
        at com.justep.system.ksql.parser.InsertParser.start(Unknown Source)
        at com.justep.system.ksql.parser.AbstractParser.parse(Unknown Source)
        ... 33 more

忘了忘了

crj 发表于 2014-8-4 14:15
java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Nati ...

看看你的sql语句是 怎么写的，看看你的workTime.java的26和157行是怎么回事，报错了

crj

157行就是执行KSQL语句的那行，KSQL.executeUpdate(sql, null, LeaveSummaryDataModel, null);

crj

忘了忘了 发表于 2014-8-4 14:20
看看你的sql语句是 怎么写的，看看你的workTime.java的26和157行是怎么回事，报错了 ...

157行就是执行KSQL语句的那行，KSQL.executeUpdate(sql, null, LeaveSummaryDataModel, null);