|
在Java文件中,执行KSQL语句,编辑sActualFinishTime的值
String ksql5 = "update SA_Task st set st.sStatusID='tesFinished'," +
"st.sStatusName='完成', " +
"st.sContent='同意', " +
"st.sCreateTime= :sActualFinishTime, " + // 要修改的字段
"st.sETField31= :sETField31 " +
"where st.sData1 = :sData1 and st.sActivity = :activity " +
"and st.sAIStatusID= :sAIStatusID " +
"and st.sStatusID='tesExecuting'";
Map<String, Object> params5 = new HashMap<String, Object>();
params5.put("sActualFinishTime", 要改的值); // 参数的传值
不管是Date还是String,都提示KSQL执行错误,怎么办
|
|