语法笔记

语法笔记"/>

语法笔记

ibaits 联合主键批量删除

DAO 定义：public void batchDelete(List<SysSource> list);

<delete id="batchDelete" parameterClass="java.util.List">DELETE 	FROM SYS_SOURCE 	/*  */WHERE<iterate open="(" close=")" conjunction="OR" >DATA_SOURCE = #list[].dataSource#		/* 数据库类型 */AND DB_NAME = #list[].dbName#		/* 数据库名 */AND SYS_ID = #list[].sysId#		/* 系统编号 */</iterate></delete>

mybatis 

 <collection property="subList" column="menu_id" ofType="SysMenu"select="searchSubMenu" javaType="ArrayList"/>

<select id="searchSubMenu" resultMap="sysMenuMap" parameterType="String">SELECT*FROM sys_right sWHEREs.parent_id = #{menu_id}</select>