ibaits 标签

<select id="wuliu_detail"   resultMap="wuliutongji_datail"   parameterClass="java.util.Map"  >
        select
      *
       from
       (
        select A.*,ROWNUM as rn from
        (select g.productno,g.name_all, b.orderid,b.orderno,u.username userid,to_char(b.create_dt,'yyyy-MM-dd hh24:mi:ss') createdate,t.tinyno,nvl(t.goods_amount,0.00) goods_amount,t.goods_num,to_char(tr.create_dt,'yyyy-MM-dd hh24:mi:ss') 
                      successdate,tr.track_info,tr.content from  d_bill_tiny t             
                      left join   d_bill b on  t.billid=b.orderid             
                      left join d_bill_track  tr on tr.billid=b.orderid  
                      left join d_goods g on g.id=t.goodsid    
                      left join userinfo u on u.userid=b.userid              
                      where tr.track_type=9   
     //  property 获取值不用加$$或者## 直接写key值              

      <isNotNull property="starttime">
                     <isNotNull property="endtime">
                        and   tr.create_dt    between  to_date('$starttime$','yyyy-MM-dd hh24:mi;ss')  
                        and  to_date('$endtime$','yyyy-MM-dd hh24:mi:ss')
                    </isNotNull>
                    </isNotNull>
                    <isNotNull property="productno">
     and g.productno    like  '%'||#productno#||'%'
       </isNotNull>
                  ) A    

                     // $pageInfo.page$  pageinfo 为map中的一个key值 也就是说获取到key值对应的对象以后再找属性   map放对象 ibtais获取方法
  <![CDATA[  where ROWNUM<= ($pageInfo.page$*$pageInfo.pageSize$)  ]]>
  <![CDATA[   ) where rn > ($pageInfo.page$ - 1) * $pageInfo.pageSize$]]>
     </select>