编码: JUSTEP150210; KSQL拼接查询报错

一诺佳人 · 发表于 2017-5-9 16:08:36

总是提示这个错误，可以确认，是KSQL拼接的问题，怎么修改？
编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: UPDATE articleMove articleMove SET articleMove.f1stName='system', articleMove.f1sID='PSN01', articleMove.f1stTime=:currentDateTime()articleMove.f1stAdvice ='已确认！' where articleMove='3AB07020D64B43A29FD89F3BCAD10B63'

import java.text.SimpleDateFormat;
import java.util.Iterator;

import com.justep.system.context.ContextHelper;
import com.justep.system.data.KSQL;
import com.justep.system.data.Row;
import com.justep.system.data.Table;
import com.justep.system.process.ProcessUtils;
import com.justep.system.util.BizUtils;

public class OutboundProcess {
//生成连续的出库单编号CKD20161010001
public static void outboundProcessBeforeSaveArticleMoveAction() {
//拿到前台传过来的TABLE参数
Table table=(Table)ContextHelper.getActionContext().getParameter("table");
//拿到新增的行
Iterator<Row>  rows=table.iterator(com.justep.system.data.ModifyState.NEW);
//生成当前日期的字符串
SimpleDateFormat sDateFormat=new SimpleDateFormat("yyyyMMdd");
String sDate=sDateFormat.format(new java.util.Date());
//配置单据编号字符串
while (rows.hasNext()){
      Row row=rows.next();
   //给FNO字段赋值
   row.setValue("fNo", BizUtils.createNextSequenceString("CKD"+sDate, "0000"));
}
}
//出库申请环节完毕后，将销售计划意见加入库表
public static void applyAfterAdvance() {
try{
String taskID=ProcessUtils.getProcessContext().getTask().getId(); //拿到当前流程ID
String ksql = "select SA_Task.sContent from SA_Task SA_Task where SA_Task= '"+taskID+"'";
com.justep.system.data.Table table = KSQL.select(ksql, null, "/system/data", null);//查出当前流程记录
   Iterator<Row> rows=table.iterator();                                                 //拿到操作者意见
   Row row=rows.next();
   String sContent=row.getString("sContent");


//如果操作者留下了附言，将附言记录到库表中
if(sContent!=null){
      String key=ProcessUtils.getProcessData1();
      String ksql1="UPDATE articleMove articleMove SET articleMove.fReportAdvice ='"+sContent+"' where articleMove='"+key+"'";
      KSQL.executeUpdate(ksql1, null, "/DEMOERP/DEMOERP/data", null);//将操作者意见存进库表中
      }
}catch(Exception e){
      throw new RuntimeException(e.getMessage());
}
}
//出库环节完毕后，将库管员姓名，ID，时间，意见写出库表中
public static void outboundAfterAdvance() {
try{
String taskID=ProcessUtils.getProcessContext().getTask().getId(); //拿到当前流程ID
String ksql = "select SA_Task.sContent  from SA_Task SA_Task  where SA_Task='"+taskID+"'";
com.justep.system.data.Table table=KSQL.select(ksql, null, "/system/data", null);//查出当前流程记录
   Iterator<Row> rows=table.iterator();                                                    //拿到操作者意见
   Row row=rows.next();
   String sContent=row.getString("sContent");
//如果操作者留下了附言，将附言记录到库表中

      String key=ProcessUtils.getProcessData1();
      String ksql1="UPDATE articleMove articleMove SET articleMove.f1stName='"+ContextHelper.getOperator().getName()+"', articleMove.f1sID='"+ContextHelper.getOperator().getID()+"', articleMove.f1stTime=:currentDateTime()";
      if(sContent!=null)
      ksql1=ksql1+"articleMove.f1stAdvice ='"+sContent+"'" ;
      ksql1=ksql1+" where articleMove='"+key+"'";
      KSQL.executeUpdate(ksql1, null, "/DEMOERP/DEMOERP/data", null);//将操作者意见存进库表中

      /**更新收货意见
      if(sContent!=null){
      String key=ProcessUtils.getProcessData1();
      String ksql1 = "UPDATE articleMove articleMove SET articleMove.f1stAdvice ='"+sContent+"' where articleMove='"+key+"'";
      KSQL.executeUpdate(ksql1, null, "/DEMOERP/DEMOERP/data", null);//将操作者意见存进库表中
   }
         **/
}catch(Exception e){
throw new RuntimeException(e.getMessage());
}
}
//流程异常结束时，更新流程状态
public static void outboundProcessAfterAbort() {
try{
String key=ProcessUtils.getProcessData1();//拿到当前主表ID
String ksql = "UPDATE articleMove articleMove SET articleMove.fProcState='已终止' where articleMove='"+key+"'";
KSQL.executeUpdate(ksql, null, "/DEMOERP/DEMOERP/data", null);
}catch(Exception e){
throw new RuntimeException(e.getMessage());
}

}
//流程正常结束时，更新流程状态
public static void outboundProcessAfterAdvance() {
   try{
String key=ProcessUtils.getProcessData1();//拿到当前主表ID
String ksql = "UPDATE articleMove articleMove SET articleMove.fProcState='已完成' where articleMove='"+key+"'";
KSQL.executeUpdate(ksql, null, "/DEMOERP/DEMOERP/data", null);
}catch(Exception e){
throw new RuntimeException(e.getMessage());
}
}
}

jishuang · 发表于 2017-5-9 17:28:29

少了空格

一诺佳人 · 发表于 2017-5-9 18:56:40

   String ksql1="UPDATE articleMove articleMove SET articleMove.f1stName='"+ContextHelper.getOperator().getName()+"', articleMove.f1sID='"+ContextHelper.getOperator().getID()+"', articleMove.f1stTime=:currentDateTime()";
         if(sContent!=null)
         ksql1=ksql1+"articleMove.f1stAdvice ='"+sContent+"'" ;
         ksql1=ksql1+" where articleMove='"+key+"'";
         KSQL.executeUpdate(ksql1, null, "/DEMOERP/DEMOERP/data", null);//将操作者意见存进库表中

请问，这个空间格应该加在哪里？怎么拼接？

jishuang · 发表于 2017-5-10 09:47:57

在上面画圈的后面或者下面画圈的前面都可以啊

一诺佳人 · 发表于 2017-5-10 11:12:49

articleMove.f1stTime=:currentDateTime() ";或是ksql1=ksql1+" articleMove.f1stAdvice ='"+sContent+"'" ;
你是说这样吗？这两种我都试了，提报一样的错误。

能把正确的贴出来吗？

jishuang · 发表于 2017-5-10 13:35:02

把具体的错误信息发一下

一诺佳人 · 发表于 2017-5-10 13:37:32

本帖最后由一诺佳人于 2017-5-10 13:39 编辑

网页上提示
编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: UPDATE articleMove articleMove SET articleMove.f1stName= 'system', articleMove.f1sID='PSN01', articleMove.f1stTime=:currentDateTime() articleMove.f1stAdvice ='萨达' where articleMove='3AB07020D64B43A29FD89F3BCAD10B63'
隐藏详细
java.lang.reflect.InvocationTargetException
at sun.reflect.GeneratedMethodAccessor127.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
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.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:723)
at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
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)
at com.justep.system.action.Engine.invokeAction(Native Method)
at com.justep.system.action.Engine.invokeAction(Unknown Source)
at com.justep.model.impl.UtilImplementInstance.invokeAction(Unknown Source)
at com.justep.model.impl.UtilImplementInstance.invokeAction(Unknown Source)
at com.justep.system.action.ActionUtils.invokeAction(Unknown Source)
at com.justep.system.process.ProcessUtils.advanceProcess(Unknown Source)
at ExternalProcessProcedure.advanceProcess(ExternalProcessProcedure.java:30)
... 26 more
Caused by: java.lang.RuntimeException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: UPDATE articleMove articleMove SET articleMove.f1stName= 'system', articleMove.f1sID='PSN01', articleMove.f1stTime=:currentDateTime() articleMove.f1stAdvice ='萨达' where articleMove='3AB07020D64B43A29FD89F3BCAD10B63'
at OutboundProcess.outboundAfterAdvance(OutboundProcess.java:75)
... 37 more
TOMCAT上提示
编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: UPDATE articleMove articleMove SET articleMove.f1stName= 'system', articleMove.f1sID='PSN01', articleMove.f1stTime=:currentDateTime() articleMove.f1stAdvice ='萨达' where articleMove='3AB07020D64B43A29FD89F3BCAD10B63'
at OutboundProcess.outboundAfterAdvance(OutboundProcess.java:75)

jishuang · 发表于 2017-5-10 14:23:17

把空格改为,你前面都知道用,自己仔细看看ksql就能看出问题

一诺佳人 · 发表于 2017-5-10 16:00:36

搞定了。不是空格的原因，而是有个字段名拼写错误导致的，结贴吧，感谢耐心指导！

		自动登录	找回密码
密码			注册

[结贴] 编码: JUSTEP150210; KSQL拼接查询报错