mybatis批量处理

批量添加：参数以一个list 集合

<insert id="addRolePermission" parameterType="java.util.List">
        insert into MTB_ROLE_PERMISSION
        (
        Id,
        role_Id,
        permission_Id)
        values
        <foreach collection ="list" item="item" index= "index" separator =",">
        (#{item.Id,jdbcType=INTEGER},
        #{item.roleId,jdbcType=INTEGER},
        #{item.permissionId,jdbcType=INTEGER})
         </foreach >
    </insert>

修改：

<update id="updateBatchSortByPrimaryKey" parameterType="java.util.List">
        <foreach collection="list" item="cc" index="index" open="" close="" separator=";"> 
            update banner
            <set>
                sort=#{cc.sort,jdbcType=INTEGER},
            </set>
            where id = #{cc.id,jdbcType=INTEGER}
        </foreach>
    </update>

批量删除

<delete id="batchDeleteEmployee" parameterType="java.util.List">  
    DELETE FROM employee WHERE id IN  
    <foreach collection="list" index="index" item="item" open="(" separator="," close=")">   
        #{item.id}   
    </foreach>  
</delete>