table合并数据

chenweibinx

现在有多个条件查询同一个表，循环查询获取，问题是，怎么把这些循环获取的数据合并到同一个table中呢？像下面这样操作会报错java.lang.reflect.InvocationTargetException，报错table2.appendRow(row1);这一行有问题，请问是哪里我写错了，还是有其他什么方便的方法可以用吗？
Table table = getPrintMain(startDate, endDate, JCDH, YPBH, JCXM);
                Iterator<Row> rows = table.iterator();
                String fApplyNo = "";
                String fSampleNo = "";
                String fItemNo = "";
                Table table2=null;
                while (rows.hasNext()) {
                        fApplyNo = "";
                        fSampleNo = "";
                        fItemNo = "";
                        Row row = rows.next();
                        fApplyNo += row.getValue("fApplyNo");
                        fSampleNo += row.getValue("fSampleNo");
                        fItemNo += row.getValue("fItemNo");
                        String sql = "select * from QC_JCDetailSub where fApplyNo='" + fApplyNo + "' and fSampleNo='" + fSampleNo + "' and fItemNo='" + fItemNo + "'";
                        HashMap<String, String> sqlmap = new HashMap<String, String>();
                        sqlmap.put(SQL.DEFAULT_DB_NAME, sql);
                        Table table1 = SQL.select(sqlmap, null, "/HTTQC/QCTestRecord/data");
                        Iterator<Row> rows1 = table1.iterator();
                        while (rows1.hasNext()) {
                                Row row1 = rows1.next();
                                table2.appendRow(row1);
                        }
                }
                return table2;

jishuang

有问题具体什么问题？

chenweibinx

jishuang 发表于 2019-10-8 09:43
有问题具体什么问题？

这句话报错table2.appendRow(row1);
报错内容如下
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.NullPointerException
        at QCTestRecord.getPrintDetailSub(QCTestRecord.java:3338)
        ... 27 more
[ERROR] 2019-10-08 09:42:05,960 com.justep.report.controller.DataController - 报表数据获取失败
null
com.justep.report.exception.ReportServerException: 报表数据获取失败
        at com.justep.report.controller.DataController.execute(Unknown Source)
        at com.justep.report.controller.GenericControllerChain.execute(Unknown Source)
        at com.justep.report.controller.InitController.execute(Unknown Source)
        at com.justep.report.controller.GenericControllerChain.execute(Unknown Source)
        at com.justep.report.Servlet.a(Unknown Source)
        at com.justep.report.Servlet.doPost(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:643)
        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: com.justep.report.exception.ReportServerException: null
        at com.justep.report.controller.DataController.a(Unknown Source)
        at com.justep.report.controller.DataController.a(Unknown Source)
        ... 20 more
Caused by: java.lang.Exception
        ... 22 more

jishuang

确认row存在吗？报的是空指针异常

chenweibinx

jishuang 发表于 2019-10-8 10:15
确认row存在吗？报的是空指针异常

输出row1.toString()的内容为
<RowImpl state=NONE
[<column name=fID, state=0, oldValue=null, newValue=04518EDDF81044EDB9C5892E73726119>, <column name=fTestTime, state=0, oldValue=null, newValue=null>, <column name=fBZZJYC, state=0, oldValue=null, newValue=变色≥4; 沾色≥4;>, <column name=fRecno, state=0, oldValue=null, newValue=L0058>, <column name=fSampleNo, state=0, oldValue=null, newValue=190802686A>, <column name=fItemName, state=0, oldValue=null, newValue=WI026耐水洗色牢度(级)>, <column name=fHandlers, state=0, oldValue=null, newValue=null>, <column name=fmID, state=0, oldValue=null, newValue=F539C8E740C44097BB47CCA7BDDBDF2D>, <column name=fCreateDate, state=0, oldValue=null, newValue=2019-08-27 16:51:12.547>, <column name=fResult10, state=0, oldValue=null, newValue=null>, <column name=fResult11, state=0, oldValue=null, newValue=null>, <column name=fResult12, state=0, oldValue=null, newValue=null>, <column name=fApplyNo, state=0, oldValue=null, newValue=190802686>, <column name=fItemNo, state=0, oldValue=null, newValue=L0058>, <column name=fCreateName, state=0, oldValue=null, newValue=B01>, <column name=fResult6, state=0, oldValue=null, newValue=合格>, <column name=fResult5, state=0, oldValue=null, newValue=4.31/4-5>, <column name=fResult4, state=0, oldValue=null, newValue=≥4>, <column name=fResult3, state=0, oldValue=null, newValue=A>, <column name=version, state=0, oldValue=null, newValue=1>, <column name=fResult9, state=0, oldValue=null, newValue=null>, <column name=fResult8, state=0, oldValue=null, newValue=4.31>, <column name=fResult7, state=0, oldValue=null, newValue=null>, <column name=fResult2, state=0, oldValue=null, newValue=415>, <column name=fResult1, state=0, oldValue=null, newValue=7>, <column name=fdID, state=0, oldValue=null, newValue=null>, <column name=fWorkTime1, state=0, oldValue=null, newValue=null>]
>

jishuang

Table table2=null;不能这样写，要new Table
如果是多个table合并就直接用已有的一个直接添加行就可以

chenweibinx

jishuang 发表于 2019-10-8 11:54
Table table2=null;不能这样写，要new Table
如果是多个table合并就直接用已有的一个直接添加行就可以 ...

如图，这样写会报错，请问怎么写new Table,直接用已有的一个直接添加行这个怎么写呢？

jishuang

如果是多个table合并就直接用已有的一个直接添加行就可以

new Table是需要参数的