//批量插入
//mapper
public void insertUserRoleBatch(List<Map<String,String>> list);
//xml
<insert id="insertUserRoleBatch" parameterType="arraylist">
INSERT INTO sys_user_role (user_id,role_id)
VALUES
<foreach collection="list" item="item" index="index" separator="," >
(#{item.user_id},#{item.role_id})
</foreach>
</insert>
//批量更新
//mapper
public void udpateMenuRoleBatch(List<Map<String,String>> list);
//xml
<update id="udpateMenuRoleBatch" parameterType="arraylist">
<foreach collection="list" index="index" item="item" separator=";">
UPDATE sys_role_menu
<set>
permissions = #{item.permissions}
</set>
WHERE role_id = #{item.role_id} and menu_id = #{item.menu_id}
</foreach>
</update>
批量更新出现问题,请看这里:http://blog.csdn.net/goldenfish1919/article/details/50600053