ibatis遍历备份

<isEqual prepend="and" compareValue="0" property="STATUS">
             e.USERMCHSTATE not in ('C')
         </isEqual>
         <isEqual prepend="and" compareValue="M" property="STATUS">
             e.USERMCHSTATE = 'M'
         </isEqual>
         <isEqual prepend="and" compareValue="N" property="STATUS">
             e.USERMCHSTATE = 'N'
         </isEqual>
         <isEqual prepend="and" compareValue="C" property="STATUS">
             e.USERMCHSTATE = 'C'


to_char(ur.IDEFFECTIVEDATE,'yyyy-MM-dd') IDEFFECTIVEDATE,   


<isNotEmpty prepend="and" property="CREATEUSERSEQ"> e.CREATEUSERSEQ in 
            <iterate  property="CREATEUSERSEQ" open="(" close=")" conjunction=",">  
                     #CREATEUSERSEQ[]#  
            </iterate> 
            </isNotEmpty><!--创建人序号-->