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>