如何写KSQL语句？

hxqsys

有如下sql语句：
Select * from tbl_edu_cust t1,(Select fLinkManID , max(fContactTime) as fContactTime FROM tbl_educuststate group by fLinkManID) t2,
tbl_educuststate t3 where t1.fID = t2.fLinkManID  and t1.fID = t3.fLinkManID  and t2.fContactTime = t3.fContactTime
如何用KSQL写出来请老师帮忙指点下。

sue

写ksql是做报表么?如果做报表的话可以参考demo中的/UI/demo/report里面有各种报表格式

hxqsys

不是做报表，做增删改查功能。

sue

那就得参考API   KSQL语法了

zhaixin

Select * from tbl_edu_cust t1,
join tbl_educuststate t3
on t1.fID = t3.fLinkManID  
where t3.fContactTime = (Select max(fContactTime) FROM tbl_educuststate t2 where t2.fLinkManID=t1.fID )

hxqsys

zhaixin 发表于 2013-9-16 09:55
Select * from tbl_edu_cust t1,
join tbl_educuststate t3
on t1.fID = t3.fLinkManID  

查询出数据返回到 .w文件中的data组件中出错。现在需要通过这个语句查询到数据展现在grid中。或者有其他方法可以把其查询到的数据展现在grid中么？

zhaixin

是如何将数据返回到 .w文件中的data组件的，报什么错

hxqsys

data组件的reader方法指定为这个自定义的action  报错如下：
2013-09-16 14:56:52
javax.servlet.ServletException: java.lang.NullPointerException
        at com.justep.ui.servlet.MainServlet.service(Unknown Source)
        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: java.lang.NullPointerException
        at BizData.processData(BizData.java:335)
        at BizData.execute(BizData.java:55)
        at com.justep.xbl.runtime.TemplateEngine.computeJavaTemplate(Unknown Source)
        at com.justep.xbl.runtime.TemplateEngine.exeucte(Unknown Source)
        at com.justep.xbl.runtime.XBLEngine.parserBinding(Unknown Source)
        at com.justep.xbl.runtime.XBLEngine.parser(Unknown Source)
        at com.justep.xbl.runtime.XBLEngine.parser(Unknown Source)
        at com.justep.xbl.runtime.XBLEngine.parser(Unknown Source)
        at com.justep.xbl.runtime.XBLEngine.excute(Unknown Source)
        at com.justep.ui.util.UIUtils.xbl(Unknown Source)
        at com.justep.ui.WindowCompiler.compile(Unknown Source)
        at com.justep.ui.WindowServer.getWindow(Unknown Source)
        at com.justep.ui.WindowServer.service(Unknown Source)
        ... 14 more
2013-9-16 14:56:52 org.apache.catalina.core.StandardWrapperValve invoke
严重: Servlet.service() for servlet main-servlet threw exception
java.lang.NullPointerException
        at BizData.processData(BizData.java:335)
        at BizData.execute(BizData.java:55)
        at com.justep.xbl.runtime.TemplateEngine.computeJavaTemplate(Unknown Source)
        at com.justep.xbl.runtime.TemplateEngine.exeucte(Unknown Source)
        at com.justep.xbl.runtime.XBLEngine.parserBinding(Unknown Source)
        at com.justep.xbl.runtime.XBLEngine.parser(Unknown Source)
        at com.justep.xbl.runtime.XBLEngine.parser(Unknown Source)
        at com.justep.xbl.runtime.XBLEngine.parser(Unknown Source)
        at com.justep.xbl.runtime.XBLEngine.excute(Unknown Source)
        at com.justep.ui.util.UIUtils.xbl(Unknown Source)
        at com.justep.ui.WindowCompiler.compile(Unknown Source)
        at com.justep.ui.WindowServer.getWindow(Unknown Source)
        at com.justep.ui.WindowServer.service(Unknown Source)
        at com.justep.ui.servlet.MainServlet.service(Unknown Source)
        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)

zhaixin

上面的ksql放在queryAction里面可以执行，不需要自定义action

hxqsys

zhaixin 发表于 2013-9-16 15:15
上面的ksql放在queryAction里面可以执行，不需要自定义action

select *
    from Tbl_edu_cust t1
    join Tbl_educuststate t3 on t1.fID = t3.fLinkManID
    where t3.fContactTime = (
    select max(fContactTime)
    from Tbl_educuststate t2 where t2.fLinkManID=t1.fID )
放在KSQL中执行报错，
  ... 21 more
Caused by: com.justep.model.exception.ModelException: 执行ksql:select *
     from Tbl_edu_cust t1
     join Tbl_educuststate t3 on t1.fID = t3.fLinkManID
     where t3.fContactTime = (
      select max(fContactTime)
     from Tbl_educuststate t2 where t2.fLinkManID=t1.fID ) LIMIT 0, 50时出错！
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:15)
... 26 more
Caused by: com.justep.system.ksql.matcher.TokenMatchException: select ^^*
     from Tb 中未找到需要的token, 位置：7 需要下列之一：STRING, NUMBER, ONE_RELATION, IDENTIFER, VARIABLE
at com.justep.system.ksql.parser.AbstractParser.constExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.unaryExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.multiExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.addExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.selectColumn(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.selectListNode(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.selectSentenceNode(Unknown Source)
at com.justep.system.ksql.parser.QueryParser.start(Unknown Source)
at com.justep.system.ksql.parser.QueryParser.start(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.parse(Unknown Source)
... 31 more