ibatis 动态条件配置



<select id= "BCDAO.selectBCByQuery"  resultMap= "BaseResultMap" >
      select 

         process_key, 

         status
      from 
         bm_config
      where 
         status != -1
          <dynamic prepend= "" >
                <isNotNull prepend= "and"  property= "status" >
               status = #status#
             </isNotNull>          
             <isNotNull prepend= "and"  property= "gmtCreateStartString" >
               gmt_create &gt;= str_to_date(#gmtCreateStartString#, '%Y-%m-%d %H:%i:%s')
             </isNotNull>
             <isNotNull prepend= "and"  property= "gmtCreateEndString" >
               gmt_create &lt;= str_to_date(#gmtCreateEndString#, '%Y-%m-%d %H:%i:%s')
             </isNotNull>
          </dynamic>          
         order by gmt_create desc
         limit #pageFristItem#,#pageSize#
    </select>

转载于:https://www.cnblogs.com/68948/archive/2011/05/19/2051355.html