SQL查出来的数据可以用java操作嘛

Shyloc

SQL查出来的数据可以用java操作嘛

jishuang

具体需求要做什么？

Shyloc

这里面的应缴费用的计算方式，都是     类别金额×亩数，但是这个补缴金额这个类别比较特殊，他不用乘，所以我想把数据用SQL查出来以后，用java对数据进行判断操作

jishuang

如果用平台的API操作的返回的是table,可以参考http://bbs.wex5.com/forum.php?mod=viewthread&tid=33592

Shyloc

我用着一段代码完成了值的更新，但是出现了另一个bug，保存的时候他就提示   更新模式是WHERE_VERSION时, 必须有version
我很确定，就是这一段代码导致的。

jishuang

更新模式是WHERE_VERSION时, 必须有version是data保存提示的，跟这段代码什么关系？

Shyloc

我把这段代码注释掉。程序正常运行。。我把注释取消，错误重现

jishuang

data保存跟这段代码什么关系？

Shyloc

改了data里的数据。。。就这样，你不明白，我也不明白。确实是这段代码一加上就不能保存，保存就报错。下面是完整报错信息
2020-07-02 10:44:42 excute stream action, params:{"actions":[{"accept":"application/json","action":"savePER_LANDAction","actionFlag":"__action_0__","activity":"per_land_infoActivity","contentType":"json","executeContext":"","executor":"","parameters":{"table":{"@type":"table","rows":[],"userdata":{"idColumnDefine":"PER_LAND","idColumnName":"PER_LAND","idColumnType":"String","model":"/land2/infoManage/data","relationAlias":"actual,admin_name,com_name,end_date,fper_id,fwell,gene_date,idcard,land_location,land_number,per_land_id,per_name,receivable,remarks,start_date,used_per,user_name,valid,version,well_location","relationTypes":"Decimal,String,String,Date,String,String,Date,String,String,Decimal,String,String,Decimal,Text,Date,String,String,String,Integer,String","relations":"PER_LAND.actual,PER_LAND.admin_name,COM.com_name,PER_LAND.end_date,PER_LAND.fper_id,PER_LAND.fwell,PER_LAND.gene_date,PERSON.idcard,PER_LAND.land_location,PER_LAND.land_number,PER_LAND.per_land_id,PERSON.per_name,PER_LAND.receivable,PER_LAND.remarks,PER_LAND.start_date,PER_LAND.used_per,PERSON[1].per_name,PER_LAND.valid,PER_LAND.version,WELL.well_location","sys.count":3,"sys.rowid":"PER_LAND","updateMode":"whereVersion"}}},"process":"/land2/infoManage/process/per_land_info/per_land_infoProcess"},{"accept":"application/json","action":"savePER_LANDAction","actionFlag":"__action_1__","activity":"per_land_infoActivity","contentType":"json","executeContext":"","executor":"","parameters":{"table":{"@type":"table","rows":[{"cost":{"changed":"1","originalValue":"110000.0000","value":"1100.00"},"item":{"value":"补交水费"},"item_bill":{},"item_money":{"value":"1100.00"},"land_location":{},"per_land_id":{"value":"CB00000091"},"rest":{"changed":"1","originalValue":"110000.0000","value":"1100.00"},"sum":{},"userdata":{"id":{"value":"6B36E175BD4548B29D33E75A837397FD"},"isModified":true,"recordState":"edit"}}],"userdata":{"idColumnDefine":"PER_LAND","idColumnName":"PER_LAND","idColumnType":"String","model":"/land2/infoManage/data","relationAlias":"cost,item,item_bill,item_money,land_location,per_land_id,rest,sum","relationTypes":"String,String,String,Decimal,String,String,String,String","relations":"EXPRESS,CHARGE_ITEM.item,CHARGE_BILL.item_bill,CHARGE_ITEM_DETAIL.item_money,PER_LAND.land_location,PER_LAND.per_land_id,EXPRESS,EXPRESS","updateMode":"whereVersion"}}},"process":"/land2/infoManage/process/per_land_info/per_land_infoProcess"}]}
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 com.justep.micro.service.MicroServiceFilter.doFilter(Unknown Source)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        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: com.justep.exception.BusinessException: 编码: JUSTEP150164; 提示: 更新模式是WHERE_VERSION时, 必须有version
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.util.Utils.check(Unknown Source)
        at com.justep.system.data.impl.TableImpl.normalizeSaveInfo(Unknown Source)
        at com.justep.system.data.impl.TableImpl.save(Unknown Source)
        at com.justep.system.data.BizData.save(Unknown Source)
        at BizProcedure.save(BizProcedure.java:18)
        ... 30 more
2020-07-02 10:45:23 excute stream action, params:{"actions":[{"accept":"application/json","action":"savePER_LANDAction","actionFlag":"__action_0__","activity":"per_land_infoActivity","contentType":"json","executeContext":"","executor":"","parameters":{"table":{"@type":"table","rows":[],"userdata":{"idColumnDefine":"PER_LAND","idColumnName":"PER_LAND","idColumnType":"String","model":"/land2/infoManage/data","relationAlias":"actual,admin_name,com_name,end_date,fper_id,fwell,gene_date,idcard,land_location,land_number,per_land_id,per_name,receivable,remarks,start_date,used_per,user_name,valid,version,well_location","relationTypes":"Decimal,String,String,Date,String,String,Date,String,String,Decimal,String,String,Decimal,Text,Date,String,String,String,Integer,String","relations":"PER_LAND.actual,PER_LAND.admin_name,COM.com_name,PER_LAND.end_date,PER_LAND.fper_id,PER_LAND.fwell,PER_LAND.gene_date,PERSON.idcard,PER_LAND.land_location,PER_LAND.land_number,PER_LAND.per_land_id,PERSON.per_name,PER_LAND.receivable,PER_LAND.remarks,PER_LAND.start_date,PER_LAND.used_per,PERSON[1].per_name,PER_LAND.valid,PER_LAND.version,WELL.well_location","sys.count":3,"sys.rowid":"PER_LAND","updateMode":"whereVersion"}}},"process":"/land2/infoManage/process/per_land_info/per_land_infoProcess"},{"accept":"application/json","action":"savePER_LANDAction","actionFlag":"__action_1__","activity":"per_land_infoActivity","contentType":"json","executeContext":"","executor":"","parameters":{"table":{"@type":"table","rows":[{"cost":{"changed":"1","originalValue":"110000.0000","value":"1100.00"},"item":{"value":"补交水费"},"item_bill":{},"item_money":{"value":"1100.00"},"land_location":{},"per_land_id":{"value":"CB00000091"},"rest":{"changed":"1","originalValue":"110000.0000","value":"1100.00"},"sum":{},"userdata":{"id":{"value":"6B36E175BD4548B29D33E75A837397FD"},"isModified":true,"recordState":"edit"}}],"userdata":{"idColumnDefine":"PER_LAND","idColumnName":"PER_LAND","idColumnType":"String","model":"/land2/infoManage/data","relationAlias":"cost,item,item_bill,item_money,land_location,per_land_id,rest,sum","relationTypes":"String,String,String,Decimal,String,String,String,String","relations":"EXPRESS,CHARGE_ITEM.item,CHARGE_BILL.item_bill,CHARGE_ITEM_DETAIL.item_money,PER_LAND.land_location,PER_LAND.per_land_id,EXPRESS,EXPRESS","updateMode":"whereVersion"}}},"process":"/land2/infoManage/process/per_land_info/per_land_infoProcess"}]}
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)
       

Shyloc

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 com.justep.micro.service.MicroServiceFilter.doFilter(Unknown Source)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        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: com.justep.exception.BusinessException: 编码: JUSTEP150164; 提示: 更新模式是WHERE_VERSION时, 必须有version
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.util.Utils.check(Unknown Source)
        at com.justep.system.data.impl.TableImpl.normalizeSaveInfo(Unknown Source)
        at com.justep.system.data.impl.TableImpl.save(Unknown Source)
        at com.justep.system.data.BizData.save(Unknown Source)
        at BizProcedure.save(BizProcedure.java:18)
        ... 30 more