尚筹网：Admin分配Role角色

刺骨的言语ヽ痛彻心扉 2023-06-28 08:53 21阅读 0赞

# 权限验证 #

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poaXpoZW5nZ3Vhbg_size_16_color_FFFFFF_t_70]![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poaXpoZW5nZ3Vhbg_size_16_color_FFFFFF_t_70 1]

# 给Admin分配Role #

## 创建中间表 ##

CREATE TABLE inner_admin_role (
    	id INT (11) NOT NULL auto_increment,
    	admin_id INT (11),
    	role_id INT (11),
    	PRIMARY KEY (id)
    );

※说明：不做逆向工程，直接使用SQL操作。

## 思路 ##

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poaXpoZW5nZ3Vhbg_size_16_color_FFFFFF_t_70 2]

## 调整"分配"按钮 ##

所在工程：atcrowdfunding-admin-1-webui  
所在文件：admin-page.jsp  
修改前：

修改后：

## 创建AssignHandler【后端】 ##

所在工程：atcrowdfunding-admin-2-component  
所在包：com.atguigu.crowd.funding.handler

@Controller
    public class AssignHandler {
        
    	
    	@Autowired
    	private RoleService roleService;
    	
    	@RequestMapping("/assign/to/assign/role/page")
    	public String toAssignRolePage(@RequestParam("adminId") Integer adminId, Model model) {
        
    		
    		// 1.查询已分配角色
    		List<Role> assignedRoleList = roleService.getAssignedRoleList(adminId);
    		
    		// 2.查询未分配角色
    		List<Role> unAssignedRoleList = roleService.getUnAssignedRoleList(adminId);
    		
    		// 3.存入模型
    		model.addAttribute("assignedRoleList", assignedRoleList);
    		model.addAttribute("unAssignedRoleList", unAssignedRoleList);
    		
    		return "assign-role";
    	}
    
    }

## 查询已分配、未分配角色的SQL【后端】 ##

/atcrowdfunding-admin-1-webui/src/main/resources/mybatis/mapper/RoleMapper.xml

<select id="selectAssignedRoleList" resultMap="BaseResultMap">
    	SELECT
    		r.id,
    		r.`name`
    	FROM
    		t_role r
    	LEFT JOIN inner_admin_role ar ON r.id = ar.role_id
    	WHERE
    		ar.admin_id = #{adminId}
    </select>
    <select id="selectUnAssignedRoleList" resultMap="BaseResultMap">
    	SELECT
    		id,
    		`name`
    	FROM
    		t_role
    	WHERE
    		id NOT IN (
    			SELECT
    				role_id
    			FROM
    				inner_admin_role
    			WHERE
    				admin_id = #{adminId}
    		)
    </select>

/atcrowdfunding-admin-2-component/src/main/java/com/atguigu/crowd/funding/mapper/RoleMapper.java

List<Role> selectUnAssignedRoleList(Integer adminId);
        List<Role> selectAssignedRoleList(Integer adminId);

/atcrowdfunding-admin-2-component/src/main/java/com/atguigu/crowd/funding/service/impl/RoleServiceImpl.java

@Override
    	public List<Role> getAssignedRoleList(Integer adminId) {
        
    		return roleMapper.selectAssignedRoleList(adminId);
    	}
    
    	@Override
    	public List<Role> getUnAssignedRoleList(Integer adminId) {
        
    		return roleMapper.selectUnAssignedRoleList(adminId);
    	}

## 创建assign-role ##

/atcrowdfunding-admin-1-webui/src/main/webapp/WEB-INF/assign-role.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    	pageEncoding="UTF-8"%>
    <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
    <!DOCTYPE html>
    <html lang="UTF-8">
    <%@ include file="/WEB-INF/include-head.jsp"%>
    <script type="text/javascript">
    	$(function(){
        
    		$("#rightBtn").click(function(){
        
    			$("#leftSelect>option:selected").appendTo("#rightSelect");
    		});
    		$("#leftBtn").click(function(){
        
    			$("#rightSelect>option:selected").appendTo("#leftSelect");
    		});
    		$("#submitBtn").click(function(){
        
    			
    			$("#rightSelect>option").prop("selected","selected");
    			
    		});
    	});
    </script>
    <body>
    
    	<%@ include file="/WEB-INF/include-nav.jsp"%>
    	<div class="container-fluid">
    		<div class="row">
    			<%@ include file="/WEB-INF/include-sidebar.jsp"%>
    			<div class="col-sm-9 col-sm-offset-3 col-md-10 col-md-offset-2 main">
    				
    				<ol class="breadcrumb">
    					<li><a href="#">首页</a></li>
    					<li><a href="#">数据列表</a></li>
    					<li class="active">分配角色</li>
    				</ol>
    				<div class="panel panel-default">
    					<div class="panel-body">
    						<form action="assign/role.html" method="post" role="form"
    							class="form-inline">
    
    							<input type="hidden" name="adminId" value="${param.adminId }" />
    							<input type="hidden" name="pageNum" value="${param.pageNum }" />
    							<div class="form-group">
    								<label for="exampleInputPassword1">未分配角色列表</label><br>
    								<select
    									id="leftSelect" class="form-control" multiple size="10"
    									style="width: 100px; overflow-y: auto;">
    
    									<c:forEach items="${requestScope.unAssignedRoleList }" var="role">
    										<option value="${role.id }">${
        role.name }</option>
    									</c:forEach>
    								</select>
    							</div>
    							<div class="form-group">
    								<ul>
    									<li id="rightBtn"
    										class="btn btn-default glyphicon glyphicon-chevron-right"></li>
    									<br>
    									<li id="leftBtn"
    										class="btn btn-default glyphicon glyphicon-chevron-left"
    										style="margin-top: 20px;"></li>
    								</ul>
    							</div>
    							<div class="form-group" style="margin-left: 40px;">
    								<label for="exampleInputPassword1">已分配角色列表</label><br>
    								<select
    									id="rightSelect" name="roleIdList" class="form-control"
    									multiple size="10" style="width: 100px; overflow-y: auto;">
    									
    									<c:forEach items="${requestScope.assignedRoleList }" var="role">
    										<option value="${role.id }">${
        role.name }</option>
    									</c:forEach>
    
    								</select>
    							</div>
    							<button id="submitBtn" type="submit" style="width: 200px;"
    								class="btn btn-success btn-lg btn-block">分配</button>
    						</form>
    					</div>
    				</div>
    
    			</div>
    		</div>
    	</div>
    
    </body>
    </html>

## 执行分配的handler方法【后端】 ##

/atcrowdfunding-admin-2-component/src/main/java/com/atguigu/crowd/funding/handler/RoleHandler.java  
![在这里插入图片描述][20200108145547331.png]

@RequestMapping("/assign/role")
    public String doAssignRole(
    		// roleIdList不一定每一次都能够提供，没有提供我们也接受
    		@RequestParam(value="roleIdList", required=false) List<Integer> roleIdList, 
    		@RequestParam("adminId") Integer adminId,
    		@RequestParam("pageNum") String pageNum) {
        
    	
    	roleService.updateRelationship(adminId, roleIdList);
    	
    	return "redirect:/admin/query/for/search.html?pageNum="+pageNum;
    }

注意：当有@ResponseBody注解时，重定向会无效，会返回一个字符串redirect:/admin/query/for/search.html?pageNum=xx

## 执行分配的service方法 ##

/atcrowdfunding-admin-2-component/src/main/java/com/atguigu/crowd/funding/service/impl/RoleServiceImpl.java

@Override
    public void updateRelationship(Integer adminId, List<Integer> roleIdList) {
        
    	
    	// 1.删除全部旧数据
    	roleMapper.deleteOldAdminRelationship(adminId);
    	
    	// 2.保存全部新数据
    	if(CrowdFundingUtils.collectionEffective(roleIdList)) {
        
    		roleMapper.insertNewAdminRelationship(adminId, roleIdList);
    	}
    	
    }

## 执行分配的sql语句 ##

<delete id="deleteOldAdminRelationship">
    	delete from inner_admin_role where admin_id=#{adminId}
    </delete>
    <insert id="insertNewAdminRelationship">
    	insert into inner_admin_role(admin_id,role_id)
    	values
    	<foreach collection="roleIdList" item="roleId" separator=",">(#{adminId},#{roleId})</foreach>
    </insert>

注意/atcrowdfunding-admin-2-component/src/main/java/com/atguigu/crowd/funding/mapper/RoleMapper.java的@Param注解，否则报错org.apache.ibatis.binding.BindingException: Parameter ‘xxxxx’ not found.  
![在这里插入图片描述][20200108151102568.png]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poaXpoZW5nZ3Vhbg_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20200108140736293.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poaXpoZW5nZ3Vhbg==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poaXpoZW5nZ3Vhbg_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20200108140741279.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poaXpoZW5nZ3Vhbg==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poaXpoZW5nZ3Vhbg_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/202001081414338.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poaXpoZW5nZ3Vhbg==,size_16,color_FFFFFF,t_70
[20200108145547331.png]: https://img-blog.csdnimg.cn/20200108145547331.png
[20200108151102568.png]: https://img-blog.csdnimg.cn/20200108151102568.png