public int setPrivilegeForUser(Integer[] privIds, Integer userId) {
Map<String, Object> map = new HashMap<>();
map.put("privIds", privIds);
map.put("userId", userId);
return this.privilegeMapper.setPrivilegeForUser(map);
}
批量新增的处理
<insert id="setPrivilegeForUser" parameterType="map">
insert into user_privilege(user_id, privilege_id) values
<foreach collection="privIds" index="index" item="item" separator=",">
( #{userId}, #{item} )
</foreach>
</insert>
批量删除多个的处理
<delete id="deleteByIds" parameterType="java.util.List">
delete from user_privilege where id in
<foreach collection="list" index="index" item="item" open="(" separator="," close=")">
#{item}
</foreach>
</delete>
批量插入传入对象List的例子
<insert id="batchInsertStudent" parameterType="java.util.List">
insert into student (id,name,sex,tel,address) values
<foreach collection="list" item="item" index="index" separator="," >
(#{item.id},#{item.name},#{item.sex},#{item.tel},#{item.address})
</foreach>
</insert>