<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN""http://mybatis.org/dtd/mybatis-3-mapper.dtd"><mapper namespace="com.zhongruan.dao.RoleDao"><select id="findRoleIdByUserId" parameterType="int" resultType="int">
select roleId from user_role where userId=#{userId}</select><select id="findRoleByUserId" parameterType="int" resultType="role">
SELECT * FROM tb_role WHERE id NOT IN (SELECT roleId FROM user_role WHERE userId=#{id})</select></mapper>
function addRoles(){
var roleList=newArray();
$("input[name='roleId']:checked").each(
function (){
roleList.push($(this).val())});
var userId=$("input[name=userId]").val();alert(roleList);/*alert(userId);*/
$.ajax({
type:"post",
url:"${pageContext.request.contextPath}/user/addRole.do",
data:{roleList:roleList.toString(),userId:userId},
success:function (){alert("添加角色成功");
location.href="${pageContext.request.contextPath}/user/findAll.do";},
error:function (){alert("添加角色失败");}});