关于DateTime类型的字段，如何设置值

951234935

现在不知道在DateTime类型的字段里，怎么给它设置值，调用的是后台Action，ksql代码如下：
String ksql = "insert into ERP_StockArchives a (a.fCustomerID,a.fStockCode,a.fStockName,a.fStockSortID,a.fMainMeasurementUnitID,a.fStartUseDate,a.fIsSelfMade,a.fStockABCSort,a.fMPSPiece,a.fAllowBOMParentPart,a.fAllowBOMChildPart,a.fPieceWork,a.fCreateTime,a.fCreatePsnID) values ('"+fCustomerID+"','"+fMaterielCode+"','"+name+"','"+fStockSortID+"','"+fMeteringUnitID+"',StringToDate('" + time + "'),'是','A','是','是','是','1',StringToDate('" + time + "'),'"+fPersonID+"')";
其中用StringToDate的都是DateTime类型的字段，我这样写有问题吗？

951234935

后台报的错误：
2016-09-16 11:08:34 excute stream action, params:{"actions":[{"accept":"application/json","action":"NewMaterielCode","actionFlag":"__action_0__","activity":"Taskbookmanagement","contentType":"json","executeContext":"","executor":"","parameters":{"fCustomerID":"9E9BEEAF5293421EB37F914C3E605FC5","fMaterielCode":"6666","fMeteringUnitID":"D165DF6851DC4D81864F4398F1B88948","fPersonID":"aACdy6Bys2StaM6wYet","fStockSortID":"E0114ED7F9164CE4B73A768B71C94A31","name":"原子弹"},"process":"/erp/marketSys/process/ProArchives/proArchivesProcess"},{"accept":"application/json","action":"NewMaterielCode","actionFlag":"__action_1__","activity":"Taskbookmanagement","contentType":"json","executeContext":"","executor":"","parameters":{"fCustomerID":"9E9BEEAF5293421EB37F914C3E605FC5","fMaterielCode":"77777","fMeteringUnitID":"D165DF6851DC4D81864F4398F1B88948","fPersonID":"aACdy6Bys2StaM6wYet","fStockSortID":"E0114ED7F9164CE4B73A768B71C94A31","name":"氢弹"},"process":"/erp/marketSys/process/ProArchives/proArchivesProcess"},{"accept":"application/json","action":"saveERP_TaskBookSonAction","actionFlag":"__action_2__","activity":"Taskbookmanagement","contentType":"json","executeContext":"","executor":"","parameters":{"table":{"@type":"table","rows":[{"fBomConfirmDate":{"changed":"1"},"fBomConfirmPersonID":{"changed":"1"},"fBomStatus":{"changed":"1"},"fContractID":{"changed":"1"},"fCustomerBatch":{"changed":"1","value":"222222"},"fCustomerSalesman":{"changed":"1","value":"张三"},"fCustomerSalesmanID":{"changed":"1","value":"52553280F0B1403F9F9501FCD6ED6D60"},"fCustomerToken":{"changed":"1","value":"222"},"fDeliveryDate":{"changed":"1","value":"2016-09-27"},"fEditionCode":{"changed":"1","value":"222"},"fMainID":{"changed":"1","value":"5B7AFDF2D8F140A4AEADF75FE7716158"},"fMarkerVariable":{"changed":"1","value":"是"},"fMaterielCode":{"changed":"1","value":"010102010004"},"fMeaUniName":{"changed":"1","value":"平方米"},"fMeteringUnitID":{"changed":"1","value":"D165DF6851DC4D81864F4398F1B88948"},"fProduceOrderID":{"changed":"1"},"fProjectName":{"changed":"1"},"fRawMaterial":{"changed":"1","value":"客户提供"},"fRemark":{"changed":"1"},"fStandard":{"changed":"1","value":"客户提供"},"fSuitNum":{"changed":"1"},"fSumNum":{"changed":"1","value":"2222"},"fTaskBookSonName":{"changed":"1","value":"钢片"},"userdata":{"id":{"value":"7EB5738686DA4AA6BA7092AF430998CE"},"isModified":true,"recordState":"new"},"version":{"changed":"1","value":0}},{"fBomConfirmDate":{"changed":"1"},"fBomConfirmPersonID":{"changed":"1"},"fBomStatus":{"changed":"1"},"fContractID":{"changed":"1"},"fCustomerBatch":{"changed":"1","value":"33333"},"fCustomerSalesman":{"changed":"1","value":"李四"},"fCustomerSalesmanID":{"changed":"1","value":"3D549F9D683744F2927CB99E1B2CDFA1"},"fCustomerToken":{"changed":"1","value":"33333"},"fDeliveryDate":{"changed":"1","value":"2016-09-20"},"fEditionCode":{"changed":"1","value":"333333"},"fMainID":{"changed":"1","value":"5B7AFDF2D8F140A4AEADF75FE7716158"},"fMarkerVariable":{"changed":"1","value":"否"},"fMaterielCode":{"changed":"1","value":"6666"},"fMeaUniName":{"changed":"1","value":"平方米"},"fMeteringUnitID":{"changed":"1","value":"D165DF6851DC4D81864F4398F1B88948"},"fProduceOrderID":{"changed":"1"},"fProjectName":{"changed":"1"},"fRawMaterial":{"changed":"1","value":"客户提供"},"fRemark":{"changed":"1"},"fStandard":{"changed":"1","value":"客户提供"},"fSuitNum":{"changed":"1"},"fSumNum":{"changed":"1","value":"3333"},"fTaskBookSonName":{"changed":"1","value":"原子弹"},"userdata":{"id":{"value":"0166811CC37544D888CE23D20FFD0436"},"isModified":true,"recordState":"new"},"version":{"changed":"1","value":0}},{"fBomConfirmDate":{"changed":"1"},"fBomConfirmPersonID":{"changed":"1"},"fBomStatus":{"changed":"1"},"fContractID":{"changed":"1"},"fCustomerBatch":{"changed":"1","value":"4444"},"fCustomerSalesman":{"changed":"1","value":"李四"},"fCustomerSalesmanID":{"changed":"1","value":"3D549F9D683744F2927CB99E1B2CDFA1"},"fCustomerToken":{"changed":"1","value":"44444"},"fDeliveryDate":{"changed":"1","value":"2016-09-20"},"fEditionCode":{"changed":"1","value":"4444444"},"fMainID":{"changed":"1","value":"5B7AFDF2D8F140A4AEADF75FE7716158"},"fMarkerVariable":{"changed":"1","value":"否"},"fMaterielCode":{"changed":"1","value":"77777"},"fMeaUniName":{"changed":"1","value":"平方米"},"fMeteringUnitID":{"changed":"1","value":"D165DF6851DC4D81864F4398F1B88948"},"fProduceOrderID":{"changed":"1"},"fProjectName":{"changed":"1"},"fRawMaterial":{"changed":"1","value":"自备"},"fRemark":{"changed":"1"},"fStandard":{"changed":"1","value":"自备"},"fSuitNum":{"changed":"1"},"fSumNum":{"changed":"1","value":"4444"},"fTaskBookSonName":{"changed":"1","value":"氢弹"},"userdata":{"id":{"value":"7C6759F36CAC4F7F9AF71F5F341F4BC4"},"isModified":true,"recordState":"new"},"version":{"changed":"1","value":0}}],"userdata":{"idColumnDefine":"ERP_TaskBookSon","idColumnName":"ERP_TaskBookSon","idColumnType":"String","model":"/erp/marketSys/data","relationAlias":"fBomConfirmDate,fBomConfirmPersonID,fBomStatus,fContractID,fCustomerBatch,fCustomerSalesman,fCustomerSalesmanID,fCustomerToken,fDeliveryDate,fEditionCode,fMainID,fMarkerVariable,fMaterielCode,fMeaUniName,fMeteringUnitID,fProduceOrderID,fProjectName,fRawMaterial,fRemark,fStandard,fSuitNum,fSumNum,fTaskBookSonName,version","relationTypes":"Date,String,String,String,String,String,String,String,Date,String,String,String,String,String,String,String,String,String,String,String,String,String,String,Integer","relations":"ERP_TaskBookSon.fBomConfirmDate,ERP_TaskBookSon.fBomConfirmPersonID,ERP_TaskBookSon.fBomStatus,ERP_TaskBookSon.fContractID,ERP_TaskBookSon.fCustomerBatch,ERP_CustomerContacts.fName,ERP_TaskBookSon.fCustomerSalesmanID,ERP_TaskBookSon.fCustomerToken,ERP_TaskBookSon.fDeliveryDate,ERP_TaskBookSon.fEditionCode,ERP_TaskBookSon.fMainID,ERP_TaskBookSon.fMarkerVariable,ERP_TaskBookSon.fMaterielCode,ERP_MeasurementUnit.fName,ERP_TaskBookSon.fMeteringUnitID,ERP_TaskBookSon.fProduceOrderID,ERP_ProjectArchives.fProjectName,ERP_TaskBookSon.fRawMaterial,ERP_TaskBookSon.fRemark,ERP_TaskBookSon.fStandard,ERP_TaskBookSon.fSuitNum,ERP_TaskBookSon.fSumNum,ERP_TaskBookSon.fTaskBookSonName,ERP_TaskBookSon.version","updateMode":"whereVersion"}}},"process":"/erp/marketSys/process/ProArchives/proArchivesProcess"}]}
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.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.RuntimeException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: insert into ERP_StockArchives a (a.fCustomerID,a.fStockCode,a.fStockName,a.fStockSortID,a.fMainMeasurementUnitID,a.fStartUseDate,a.fIsSelfMade,a.fStockABCSort,a.fMPSPiece,a.fAllowBOMParentPart,a.fAllowBOMChildPart,a.fPieceWork,a.fCreateTime,a.fCreatePsnID) values ('9E9BEEAF5293421EB37F914C3E605FC5','6666','原子弹','E0114ED7F9164CE4B73A768B71C94A31','D165DF6851DC4D81864F4398F1B88948',StringToDate('2016/9/16 11:08:34'),'是','A','是','是','是','1',StringToDate('2016/9/16 11:08:34'),'aACdy6Bys2StaM6wYet')
        at MarketSys.NewMaterielCode(MarketSys.java:119)
        ... 27 more

jishuang

time的值是怎么获取的？

951234935

jishuang 发表于 2016-9-18 10:01
time的值是怎么获取的？

可以了，我知道了一个方法  :currentDateTime()  。之前都是，自己取时间，然后再格式化，现在很简单了。谢谢，可以结贴了！