+ -
当前位置:首页 → 问答吧 → XML关于sqlmap中的dynamic的两个时间参数问题

XML关于sqlmap中的dynamic的两个时间参数问题

时间:2011-03-17

来源:互联网

XML code
select
        B.PROV_DESC as "provDesp",
        SUM(CASE WHEN T.MONTH_ID='201012' THEN T.cdr_num  ELSE 0 END) as "cdrCount",
       SUM(CASE WHEN T.MONTH_ID='201101' THEN T.cdr_num  ELSE 0 END) as "cdrCount1",
       SUM(CASE WHEN T.MONTH_ID='201012' THEN T.bill_times     ELSE 0 END) "billTime",
       SUM(CASE WHEN T.MONTH_ID='201101' THEN T.bill_times     ELSE 0 END) "billTime1",   
       SUM(CASE WHEN T.MONTH_ID='201012' THEN T.USER_NUM  ELSE 0 END)"userCount",
       SUM(CASE WHEN T.MONTH_ID='201101' THEN T.USER_NUM ELSE 0 END)   "userCount1" ,        
       SUM(CASE WHEN T.MONTH_ID='201012' THEN T.LOACL_CDR_NUM  ELSE 0 END)"localCdrCount",
       SUM(CASE WHEN T.MONTH_ID='201101' THEN T.LOACL_CDR_NUM ELSE 0 END)  "localCdrCount1"  ,
       SUM(CASE WHEN T.MONTH_ID='201012' THEN T.loacl_bill_times   ELSE 0 END) "localBillTime",
       SUM(CASE WHEN T.MONTH_ID='201101' THEN T.loacl_bill_times    ELSE 0 END) "localBillTime1", 
       b.ord_id
    from
        LRT_TEMP_VALUE T,
        DIM_SRC.DIM_PROV B
    where
        T.PROV_ID=B.PROV_ID
       
       <dynamic>
            <isNotEqual property="po.provNo" compareValue="-1">
                 <isNotEmpty prepend="and" property="po.provNo">
                          B.prov_id = #po.provNo#
                 </isNotEmpty>
             </isNotEqual>
             <isNotEmpty prepend="and" property="po.monthId">
                  T.MONTH_ID = #po.monthId#
             </isNotEmpty> 
             <isNotEmpty prepend="and" property="po.monthId1">
                  T.MONTH_ID = #po.monthId1#
             </isNotEmpty> 
    </dynamic>



我想把T.MONTH_ID 的值改为dynamic中的po.monthId 和po.monthId1 请问如何写这个sql语句啊 使可以查询任何两个时间段的数据

作者: qepshujuku2010   发布时间: 2011-03-17

顶上去,没人理我??

作者: qepshujuku2010   发布时间: 2011-03-18