报表用in传参的问题

tyc2003

我在报表要为in传参数，如图

1. select AQ_NMGGL.*,SA_OPOrg.sName as sName
   
2.     from AQ_NMGGL AQ_NMGGL
   
3.      optional  join SA_OPOrg SA_OPOrg on AQ_NMGGL.fDWID = SA_OPOrg
   
4.     where AQ_NMGGL in (:p)

复制代码

查询其它帖子，要写JAVA，但都没有示例。

in中如果要传多个值就需要分多个参数，不能用一个参数，因为传过来的是字符串，就把多个值当作一个字符串处理了
或者自己在java中获取到传过来的参数的值，自己用,截取字符串判断一下，然后再给in的查询赋值

能给我一份完整的示例吗，论坛找不到。谢谢！

willydong

刚好正在想这个问题，帮顶。

jishuang

java中获取到字符串，截取字符串就是java标准的，可以到网上查找

tyc2003

是不是直接在生成的动作代码中操作

1. public class KSQLProcedure {
   
2. 
   
3.         public static Table query(String ksql, Map<String, Object> variables, String dataModel, String fnModel) {
   
4.                 Utils.check(Utils.isNotEmptyString(ksql) && Utils.isNotEmptyString(dataModel),
   
5.                                 CommonMessages.class, CommonMessages.PARAM_NULL1, "ksql, dataModel");
   
6.                 return KSQL.select(ksql, variables, dataModel, Utils.isEmptyString(fnModel) ? null : ModelUtils.getModel(fnModel));
   
7. 
   
8.         }
   
9. }
   

复制代码

直接使用并修改String ksql参数，就可以了？

jishuang

这样的最好是自己子定义一个action,然后action中直接定义参数，java中对方法的参数进行处理

tyc2003

我自己做了一个action ,还是不行，请各位大侠指点。

1. 
   
2.         public static Table reportAQ_NMG(String dx,String ksql,Map variables,String dataModel,String fnModel){
   
3.                
   
4. ///*               
   
5.                 String a[] = dx.split(",");
   
6.                 int i;
   
7.                 String xx="'";
   
8. 
   
9.                for( i = 0; i < a.length-1; i++) {  
   
10.                       
    
11.                    xx = xx +a[i]+"','";
    
12.                    
    
13. 
    
14.                 }  
    
15.                xx = xx + a[i] + "'";
    
16. //*/       
    
17.                 //String xx = "'"+"0E3E7CFBB43E4F209885C23870D631A7" +"','" + "130F2022840A4DA4BB969D0FC37A5119"+"'";
    
18.                 ksql = ksql + " in (" + xx + ")";
    
19. 
    
20. 
    
21.                 Utils.check(Utils.isNotEmptyString(ksql) && Utils.isNotEmptyString(dataModel),CommonMessages.class, CommonMessages.PARAM_NULL1, "ksql, dataModel");
    
22.                 return KSQL.select(ksql, variables, dataModel, Utils.isEmptyString(fnModel) ? null : ModelUtils.getModel(fnModel));
    
23. 
    
24.         }

复制代码

用中间注释的语句生成的ksql就可以执行成功，但是用前面循环语句生成的ksql就不能执行，请大侠指点。下面是不同语句生成ksql,一模一样啊，就是不行，郁闷死了。

1. select AQ_NMGGL.*,SA_OPOrg.sName as sName from AQ_NMGGL AQ_NMGGL  optional  join SA_OPOrg SA_OPOrg on AQ_NMGGL.fDWID = SA_OPOrg where AQ_NMGGL in ('0E3E7CFBB43E4F209885C23870D631A7','130F2022840A4DA4BB969D0FC37A5119')
   
2. 
   
3. select AQ_NMGGL.*,SA_OPOrg.sName as sName from AQ_NMGGL AQ_NMGGL  optional  join SA_OPOrg SA_OPOrg on AQ_NMGGL.fDWID = SA_OPOrg where AQ_NMGGL in ('0E3E7CFBB43E4F209885C23870D631A7','130F2022840A4DA4BB969D0FC37A5119')

复制代码

请指点.......

jishuang

参考

1.         public static void paramToin(String param){
   
2.                 String ksql = "select xb.* from AP_XSXB xb";
   
3.                 if(param.indexOf(",")>0){                       
   
4.                         String[] strArray = null;   
   
5.                         strArray = param.split(",");
   
6.                         String newalias =" in('";
   
7.                         for(int i=0 ;i<strArray.length;i++){
   
8.                                 if(i != strArray.length-1){
   
9.                                         newalias += strArray[i]+"','";
   
10.                                 }
    
11.                                 else
    
12.                                         newalias += strArray[i]+"'";
    
13.                         }   
    
14.                         System.out.println(newalias);
    
15.                         ksql += " where xb.fName"+newalias+")";
    
16.                 }
    
17.                 else
    
18.                         ksql +=" where xb.fName= '"+param+"'";
    
19.                 System.out.println(ksql);
    
20.                
    
21.                 Table table = KSQL.select(ksql, null, "/appdemo/test/data", null);
    
22.         }

复制代码

tyc2003

我已按上面的参考修改了action,但还是报错，请帮忙看看，错那里了。
        public static void reportAQ_NMGXX(String dx) {
                String ksql = "select AQ_NMGGL.*,SA_OPOrg.sName as sName from AQ_NMGGL AQ_NMGGL  optional  join SA_OPOrg SA_OPOrg on AQ_NMGGL.fDWID = SA_OPOrg ";
                if (dx.indexOf(",") > 0) {
                        String[] strArray = null;
                        strArray = dx.split(",");
                        String newalias = " in ('";
                        for (int i = 0; i < strArray.length; i++) {
                                if (i != strArray.length - 1) {
                                        newalias += strArray[i] + "','";
                                } else
                                        newalias += strArray[i] + "'";
                        }
                        System.out.println(newalias);
                        ksql += " where AQ_NMGGL" + newalias + ")";
                } else{
                        ksql += " where AQ_NMGGL = '" + dx + "'";
                }
                System.out.println(ksql);

                Table table = KSQL.select(ksql, null, "/aqgl/nmggl/data", null);
               
        }

tyc2003

错误信息如下：
2017-02-23 13:42:15 开始-中间文件生成缓存文件: /UI2/aqgl/nmggl/process/nmgxx/sgrybb.w
2017-02-23 13:42:16 结束-中间文件生成缓存文件: /UI2/aqgl/nmggl/process/nmgxx/sgrybb.w
in ('57C10407ECA8449D8DB8388508385F09','0E3E7CFBB43E4F209885C23870D631A7'
select AQ_NMGGL.*,SA_OPOrg.sName as sName from AQ_NMGGL AQ_NMGGL optional join SA_OPOrg SA_OPOrg on AQ_NMGGL.fDWID = SA_OPOrg where AQ_NMGGL in ('57C10407ECA8449D8DB8388508385F09','0E3E7CFBB43E4F209885C23870D631A7')
2017-02-23 13:42:16 action:<?xml version="1.0" encoding="UTF-8"?>
<action process="/aqgl/nmggl/process/nmgxx/nmgxxProcess" activity="mainActivity" action-flag="__action_0__" executor="" execute-context="" name="reportAQ_NMGXXAction"><parameters xmlns:xbiz="http://www.justep.com/xbiz#"></parameters></action>
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 Nmggl.reportAQ_NMGXX(Nmggl.java:37)
... 27 more
[ERROR] 2017-02-23 13:42:16,344 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
2017-02-23 13:42:16 action:<?xml version="1.0" encoding="UTF-8"?>
<action process="/aqgl/nmggl/process/nmgxx/nmgxxProcess" activity="mainActivity" action-flag="__action_0__" executor="" execute-context="" name="reportAQ_NMGXXAction"><parameters xmlns:xbiz="http://www.justep.com/xbiz#"></parameters></action>
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 Nmggl.reportAQ_NMGXX(Nmggl.java:37)
... 27 more
[ERROR] 2017-02-23 13:42:16,392 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

Nmggl.reportAQ_NMGXX(Nmggl.java:37)
java断点调试跟踪一下