|
楼主 |
发表于 2014-5-7 15:01:12
|
显示全部楼层
jishuang 发表于 2014-5-7 14:09
参考http://bbs.justep.com/forum.php?mod=redirect&goto=findpost&ptid=33524&pid=165004035把sql语句打出 ...
2014-05-07 14:57:39
exec KSQL:
--> sql:SELECT count(*) FROM BT_HT BT_HT LEFT JOIN CT_CLDM CT_CLDM ON (BT_HT.HTLB = CT_CLDM.DM) AND (CT_CLDM.LB = ?) LEFT JOIN CT_ZYGS CT_ZYGS ON BT_HT.GSDM = CT_ZYGS.GSDM LEFT JOIN BT_CUSTOMER_MASTER BT_CUSTOMER_MASTER ON BT_HT.CUSTOMERID = BT_CUSTOMER_MASTER.CUSTOMERID LEFT JOIN BT_CUSTOMER_MASTER BT_CUSTOMER_MASTER_3 ON BT_HT.CARGOOWNERID = BT_CUSTOMER_MASTER_3.CUSTOMERID LEFT JOIN CT_CLDM CT_CLDM_4 ON (BT_HT.PACKINGID = CT_CLDM.DM) AND (CT_CLDM.LB = ?) LEFT JOIN CT_CLDM CT_CLDM_5 ON (BT_HT.CALFEETYPEID = CT_CLDM_5.DM) AND (CT_CLDM_5.LB = ?) LEFT JOIN CT_CLDM CT_CLDM_6 ON (BT_HT.CHECKOUTDATE = CT_CLDM.DM) AND (CT_CLDM.LB = ?) WHERE BT_HT.DAY <= TO_DATE(?, 'yyyy-mm-dd hh24:mi:ss')
--> binds:[合同类别, 包装, 计费依据, 结算期限, 2014-05-07]
2014-05-07 14:57:39
exec KSQL:
--> sql:SELECT count(*) FROM BT_HT BT_HT LEFT JOIN CT_CLDM CT_CLDM ON (BT_HT.HTLB = CT_CLDM.DM) AND (CT_CLDM.LB = ?) LEFT JOIN CT_ZYGS CT_ZYGS ON BT_HT.GSDM = CT_ZYGS.GSDM LEFT JOIN BT_CUSTOMER_MASTER BT_CUSTOMER_MASTER ON BT_HT.CUSTOMERID = BT_CUSTOMER_MASTER.CUSTOMERID LEFT JOIN BT_CUSTOMER_MASTER BT_CUSTOMER_MASTER_3 ON BT_HT.CARGOOWNERID = BT_CUSTOMER_MASTER_3.CUSTOMERID LEFT JOIN CT_CLDM CT_CLDM_4 ON (BT_HT.PACKINGID = CT_CLDM.DM) AND (CT_CLDM.LB = ?) LEFT JOIN CT_CLDM CT_CLDM_5 ON (BT_HT.CALFEETYPEID = CT_CLDM_5.DM) AND (CT_CLDM_5.LB = ?) LEFT JOIN CT_CLDM CT_CLDM_6 ON (BT_HT.CHECKOUTDATE = CT_CLDM.DM) AND (CT_CLDM.LB = ?) WHERE BT_HT.DAY <= TO_DATE(?, 'yyyy-mm-dd hh24:mi:ss')
--> binds:[合同类别, 包装, 计费依据, 结算期限, 2014-05-07]
2014-05-07 14:57:39 sql 执行时间:109ms
2014-05-07 14:57:39 sql 执行时间:109ms
这是加了日志后的控制台输出信息,我更晕乎了,为什么这个ksql语句和我们在biz层ontology文件里的queryAction里的ksql不一样啊? |
|