ibatis遍历备份

 1 <isEqual prepend="and" compareValue="0" property="STATUS">
 2              e.USERMCHSTATE not in ('C')
 3          </isEqual>
 4          <isEqual prepend="and" compareValue="M" property="STATUS">
 5              e.USERMCHSTATE = 'M'
 6          </isEqual>
 7          <isEqual prepend="and" compareValue="N" property="STATUS">
 8              e.USERMCHSTATE = 'N'
 9          </isEqual>
10          <isEqual prepend="and" compareValue="C" property="STATUS">
11              e.USERMCHSTATE = 'C'
12 
13 
14 to_char(ur.IDEFFECTIVEDATE,'yyyy-MM-dd') IDEFFECTIVEDATE,   
15 
16 
17 <isNotEmpty prepend="and" property="CREATEUSERSEQ"> e.CREATEUSERSEQ in 
18             <iterate  property="CREATEUSERSEQ" open="(" close=")" conjunction=",">  
19                      #CREATEUSERSEQ[]#  
20             </iterate> 
21             </isNotEmpty><!--创建人序号-->

posted on 2019-03-05 18:28 菜鸟01号阅读(180) 评论(0) 编辑收藏举报