【ibatis】ibatis动态操作sql数据

//简单的判断时候为空

<select id="selectProductAll" parameterClass="Batch" resultClass="Batch">
  select t.proid as proid from t_hx_product_info t where 1=1
  <isNotEmpty property="proviAccountid" >//如果传入过来的proviAccountid不为空
             <isNotEqual prepend="and" property="proviAccountid" compareValue="0">//传入过来的proviAccountid不等于0
               t.procompanyid=#proviAccountid#//如果以上的条件都满足，则根据传入过来的proviAccountid进行操作。
             </isNotEqual>
  </isNotEmpty>
  
 </select>

//迭代条件查询

<select id="selectProxyByProvi" parameterClass="java.util.List" resultClass="Batch">	
	select  from t_hx_person_safe_info ti,  (
	select t.accountid,t.CITYRLATION  from t_hx_user t where 1=1 and
		<iterate conjunction="," open="CITYRLATION in (" close=")">
			#list[].cityAccountid#
		</iterate>) ta//迭代条件
	where ti.seller = ta.accountid and  DATE_FORMAT(ti.signdate ,'%Y-%m-%d') between #list[0].satrtTime# and #list[0].endTime#		
</select>

<!-- 根据操作人用户名，匹配全部子用户，like操作批量删除， 传入List<accountid>数组，匹配多个 -->
<statement id="delPermissionByParentnames" parameterClass="java.util.List">
	DELETE FROM t_hx_permissions
	<iterate prepend="WHERE"  open="(" close=")" conjunction="OR">
	accountid like CONCAT('%',#[]#,'%')    //因为参数是一个list结合。#[]#表示循环中的实体
	</iterate>
</statement>