点击按钮弹出report报表页面

fpj

hzs0224 发表于 2014-9-1 01:51
输入各个信息后点击查询时，可以进行操作，但是执行打开导出界面时，查询时语句不对我的SQL语句如下：
se ...

关于 KSQL或者 SQL是否正确，你将他们输出一下，放到数据库执行一下，一看便知；

KSQL 或者 SQL的输出需要修改配置文件，修改方法，见下贴 7楼
http://bbs.justep.com/thread-33524-1-1.html

hzs0224

yinlun 发表于 2014-9-1 09:25
单个可以的话，多个道理也一样啊，如果有问题，最好报错信息附上

你能帮我远程看看嘛？

hzs0224

yinlun 发表于 2014-9-1 09:25
单个可以的话，多个道理也一样啊，如果有问题，最好报错信息附上

错误信息：
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: select DSS_BASIS_EQUIPMENT.*,rownum as XH from DSS_BASIS_EQUIPMENT DSS_BASIS_EQUIPMENT where DSS_BASIS_EQUIPMENT.EQUIP_NO LIKE :ZCH AND DSS_BASIS_EQUIPMENT.EQUIP_NAME LIKE :SBMC AND DSS_BASIS_EQUIPMENT.DEPT_NAME LIKE :SYBM AND DSS_BASIS_EQUIPMENT.APPLY_PEOPLE LIKE :SYRY and  DSS_BASIS_EQUIPMENT.EQUIP_TYPE = :TYPE
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
        at com.justep.system.data.KSQL.select(Unknown Source)
        at KSQLProcedure.query(KSQLProcedure.java:17)
        ... 26 more
Caused by: java.lang.NullPointerException
        at com.justep.system.ksql.visitor.QueryVisitor.createInfo(Unknown Source)
        at com.justep.system.ksql.visitor.QueryVisitor.visit(Unknown Source)
        at com.justep.system.ksql.node.SelectListNode.accept(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visit(Unknown Source)
        at com.justep.system.ksql.node.SelectSentenceNode.accept(Unknown Source)
        at com.justep.system.ksql.visitor.SQLVisitor.visitChildren(Unknown Source)
        at com.justep.system.ksql.visitor.QueryVisitor.visit(Unknown Source)
        at com.justep.system.ksql.node.QuerySentence.accept(Unknown Source)
        ... 31 more
[ERROR] 2014-09-01 11:33:16,143 com.justep.report.controller.DataController - 报表数据获取失败
执行KSQL出错, KSQL: select DSS_BASIS_EQUIPMENT.*,rownum as XH from DSS_BASIS_EQUIPMENT DSS_BASIS_EQUIPMENT where DSS_BASIS_EQUIPMENT.EQUIP_NO LIKE :ZCH AND DSS_BASIS_EQUIPMENT.EQUIP_NAME LIKE :SBMC AND DSS_BASIS_EQUIPMENT.DEPT_NAME LIKE :SYBM AND DSS_BASIS_EQUIPMENT.APPLY_PEOPLE LIKE :SYRY and  DSS_BASIS_EQUIPMENT.EQUIP_TYPE = :TYPE
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:637)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        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:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:595)
Caused by: com.justep.report.exception.ReportServerException: 执行KSQL出错, KSQL: select DSS_BASIS_EQUIPMENT.*,rownum as XH from DSS_BASIS_EQUIPMENT DSS_BASIS_EQUIPMENT where DSS_BASIS_EQUIPMENT.EQUIP_NO LIKE :ZCH AND DSS_BASIS_EQUIPMENT.EQUIP_NAME LIKE :SBMC AND DSS_BASIS_EQUIPMENT.DEPT_NAME LIKE :SYBM AND DSS_BASIS_EQUIPMENT.APPLY_PEOPLE LIKE :SYRY and  DSS_BASIS_EQUIPMENT.EQUIP_TYPE = :TYPE
        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

yinlun

hzs0224 发表于 2014-9-1 11:35
错误信息：
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出 ...

你的KSQL写的有问题，LIKE 还需要%，concat('%',:ZCH,'%')
如果你不清楚KSQL的语法，参考API里KSQL语法、函数的用法

hzs0224

yinlun 发表于 2014-9-1 12:54
你的KSQL写的有问题，LIKE 还需要%，concat('%',:ZCH,'%')
如果你不清楚KSQL的语法，参考API里KSQL语法、 ...

我的写法改成：
select DSS_BASIS_EQUIPMENT.*, rownum as XH
  from DSS_BASIS_EQUIPMENT DSS_BASIS_EQUIPMENT
where DSS_BASIS_EQUIPMENT.EQUIP_NO LIKE concat('%', :ZCH, '%')
   AND DSS_BASIS_EQUIPMENT.EQUIP_NAME LIKE concat('%', :SBMC, '%')
   AND DSS_BASIS_EQUIPMENT.DEPT_NAME LIKE concat('%', :SYBM, '%')
   AND DSS_BASIS_EQUIPMENT.APPLY_PEOPLE LIKE concat('%', :SYRY, '%')
   AND DSS_BASIS_EQUIPMENT.EQUIP_TYPE = :TYPE
也不行，还是报错啊！
[ERROR] 2014-09-01 13:06:28,690 com.justep.report.controller.DataController - 报表数据获取失败
执行KSQL出错, KSQL: select DSS_BASIS_EQUIPMENT.*,rownum as XH from DSS_BASIS_EQUIPMENT DSS_BASIS_EQUIPMENT where DSS_BASIS_EQUIPMENT.EQUIP_NO LIKE concat('%', :ZCH, '%') AND DSS_BASIS_EQUIPMENT.EQUIP_NAME LIKE concat('%', :SBMC, '%') AND DSS_BASIS_EQUIPMENT.DEPT_NAME LIKE concat('%', :SYBM, '%') AND DSS_BASIS_EQUIPMENT.APPLY_PEOPLE LIKE concat('%', :SYRY, '%') AND DSS_BASIS_EQUIPMENT.EQUIP_TYPE = :TYPE
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:637)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        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:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:595)
Caused by: com.justep.report.exception.ReportServerException: 执行KSQL出错, KSQL: select DSS_BASIS_EQUIPMENT.*,rownum as XH from DSS_BASIS_EQUIPMENT DSS_BASIS_EQUIPMENT where DSS_BASIS_EQUIPMENT.EQUIP_NO LIKE concat('%', :ZCH, '%') AND DSS_BASIS_EQUIPMENT.EQUIP_NAME LIKE concat('%', :SBMC, '%') AND DSS_BASIS_EQUIPMENT.DEPT_NAME LIKE concat('%', :SYBM, '%') AND DSS_BASIS_EQUIPMENT.APPLY_PEOPLE LIKE concat('%', :SYRY, '%') AND DSS_BASIS_EQUIPMENT.EQUIP_TYPE = :TYPE
        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

yinlun

hzs0224 发表于 2014-9-1 13:09
我的写法改成：
select DSS_BASIS_EQUIPMENT.*, rownum as XH
  from DSS_BASIS_EQUIPMENT DSS_BASIS_EQU ...

看下你的KSQL是怎么写的？

hzs0224

yinlun 发表于 2014-9-1 13:15
看下你的KSQL是怎么写的？

select DSS_BASIS_EQUIPMENT.*, rownum as XH
  from DSS_BASIS_EQUIPMENT DSS_BASIS_EQUIPMENT
where DSS_BASIS_EQUIPMENT.EQUIP_NO LIKE concat('%', :ZCH, '%')
   AND DSS_BASIS_EQUIPMENT.EQUIP_NAME LIKE concat('%', :SBMC, '%')
   AND DSS_BASIS_EQUIPMENT.DEPT_NAME LIKE concat('%', :SYBM, '%')
   AND DSS_BASIS_EQUIPMENT.APPLY_PEOPLE LIKE concat('%', :SYRY, '%')
   AND DSS_BASIS_EQUIPMENT.EQUIP_TYPE = :TYPE

jishuang

KSQL中没有rownum，

yinlun

hzs0224 发表于 2014-9-1 13:33
select DSS_BASIS_EQUIPMENT.*, rownum as XH
  from DSS_BASIS_EQUIPMENT DSS_BASIS_EQUIPMENT
where D ...

不是这个，是java代码里的KSQL是怎么写的？
比如String ksql = "select *　"

hzs0224

yinlun 发表于 2014-9-1 13:46
不是这个，是java代码里的KSQL是怎么写的？
比如String ksql = "select *　"

select DSS_BASIS_EQUIPMENT.*
    from DSS_BASIS_EQUIPMENT DSS_BASIS_EQUIPMENT
    where ( DSS_BASIS_EQUIPMENT.EQUIP_NO LIKE concat('%', :ZCH, '%') OR DSS_BASIS_EQUIPMENT.EQUIP_NO is null ) AND ( DSS_BASIS_EQUIPMENT.EQUIP_NAME LIKE concat('%', :SBMC, '%') OR DSS_BASIS_EQUIPMENT.EQUIP_NAME is null ) AND ( DSS_BASIS_EQUIPMENT.DEPT_NAME LIKE concat('%', :SYBM, '%') OR DSS_BASIS_EQUIPMENT.DEPT_NAME is null ) AND DSS_BASIS_EQUIPMENT.EQUIP_TYPE = :TYPE
这个就是在java里的代码！