权限管理 批量新增权限
dao层方法
void addRoleMenu(@Param("roleId") Integer roleId,@Param("menuIds") Integer[] menuIds);
mapper实现
<!-- 批量添加新增的权限-->
<insert id="addRoleMenu">
insert into role_menu values
<foreach collection="menuIds" item="menuId" separator=",">
(#{roleId},#{menuId})
</foreach>
</insert>
权限管理 批量删除多个用户权限
dao层方法
void delRoleByUserIds(@Param("ids") Integer[] ids);
mapper实现
<!-- 批量删除多个用户所有权限 -->
<delete id="delRoleByUserIds">
delete from user_role where user_id in
<foreach collection="ids" item="userid" open="(" close=")" separator=",">
#{userid}
</foreach>
</delete>