EasyUi 权限

最新推荐文章于 2021-02-23 23:23:32 发布

浪漫2020.

最新推荐文章于 2021-02-23 23:23:32 发布

阅读量95

点赞数

分类专栏：程序代码文章标签： EasyUi

本文链接：https://blog.csdn.net/weixin_43654482/article/details/97646844

版权

程序代码专栏收录该内容

17 篇文章 0 订阅

订阅专栏

权限目的：

是为了让不同的用户可以操作系统中不同资源

直接点说就是不同的用户可以看到左侧不同的菜单

实现思路:
① 菜单不同的原因在于，利用不同menuid进行查询，原本默认查询的是所有菜单，是通过-1去查的；
② menuid由来：是登录用户id查询中间表数据所得来的
③ 权限设计（用户权限多对多）

代码：

基于上节课的基础（工具类和jar包）

登录页面：login.jsp

<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>登录</title>
</head>
<body>

<form action="${pageContext.request.contextPath }/userAction.action?methodName=login" method="post">
uid:<input type="text" name="uid"><br>
upwd:<input type="text" name="upwd"><br>
<input type="submit" value="登录">

</form>
</body>
</html>

Dao方法 :UserDao

package com.xwt.dao;

import java.sql.SQLException;
import java.util.List;
import java.util.Map;

import com.xwt.uitl.JsonBaseDao;
import com.xwt.uitl.JsonUtils;
import com.xwt.uitl.PageBean;
import com.xwt.uitl.StringUtils;

public class UserDao extends JsonBaseDao {
	/**
	 * 用于查询用户分页列表所用
	 * 用于用户登录所用
	 * @param map
	 * @param pageBean
	 * @return
	 * @throws SQLException 
	 * @throws IllegalAccessException 
	 * @throws InstantiationException 
	 */
	public List<Map<String, Object>> list(Map<String, String[]> map,PageBean pageBean) throws InstantiationException, IllegalAccessException, SQLException{
		String sql="select * from t_easyui_user_version2 where true";
		String uid=JsonUtils.getParamVal(map, "uid");
		String upwd=JsonUtils.getParamVal(map, "upwd");
		if(StringUtils.isNotBlank(uid)) {
			sql+=" and uid="+uid;
		}
		if(StringUtils.isNotBlank(upwd)) {
			sql+=" and upwd="+upwd;
		}
		return super.executeQuery(sql, pageBean);
	}
	
	/**
	 * 通过用户登录的唯一账号  在用户父权限中间获取菜单id的集合
	 * @param map
	 * @param pageBean
	 * @return
	 * @throws InstantiationException
	 * @throws IllegalAccessException
	 * @throws SQLException
	 */
	public List<Map<String, Object>> getMenu(Map<String, String[]> map,PageBean pageBean) throws InstantiationException, IllegalAccessException, SQLException{
		String sql="select * from t_easyui_usermenu where true";
		String uid=JsonUtils.getParamVal(map, "uid");
		if(StringUtils.isNotBlank(uid)) {
			sql+=" and uid="+uid;
		}
		return super.executeQuery(sql, pageBean);
	}
}

MenuDao

package com.xwt.dao;

import java.sql.SQLException;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import com.xwt.entity.TreeNode;
import com.xwt.uitl.JsonBaseDao;
import com.xwt.uitl.JsonUtils;
import com.xwt.uitl.PageBean;
import com.xwt.uitl.StringUtils;
/**
 * 1、查询数据库所有数据用于easyui的tree树形展示（但是直接得来的数据格式easyui不识别）
 * 2、递归查询节点集合，形成子父节点关系，具备层次结构
 * 3、转格式
 * @author 婉婷宝贝
 *
 */
public class MenuDao extends JsonBaseDao {
	/**
	 * List<TreeNode>加上ObjectMapper可以转换成easyui的tree控件识别的json串
	 * @param map
	 * @param pageBean
	 * @return
	 * @throws SQLException 
	 * @throws IllegalAccessException 
	 * @throws InstantiationException 
	 */
	public List<TreeNode> listTreeNode(Map<String, String[]> map, PageBean pageBean) throws InstantiationException, IllegalAccessException, SQLException{
		List<Map<String, Object>> listMenu = this.listMenuAuth(map, pageBean);
		List<TreeNode> listTreeNode = new ArrayList<TreeNode>();
		this.listMapToListTreeNode(listMenu, listTreeNode);
		return listTreeNode;
	}
	
	/**
	 * 按照不同用戶登录能够访问不同的菜单
	 * @param map
	 * @param pageBean
	 * @return
	 * @throws InstantiationException
	 * @throws IllegalAccessException
	 * @throws SQLException
	 */
	public List<Map<String,Object>> listMenuAuth(Map<String, String[]> map, PageBean pageBean) throws InstantiationException, IllegalAccessException, SQLException{
		String sql = "select * from t_easyui_menu where true ";
		String id = JsonUtils.getParamVal(map, "Menuid");
		if(StringUtils.isNotBlank(id)) {
			sql += " and menuid in ("+id+") ";
		}else {
			sql += " and menuid=000";
		}
		return super.executeQuery(sql, pageBean);
	}
	
	/**
	 * List<Map<String,Object>>
	 * ->[{Menuid:001,Menuname:学生管理,children:[]}，{Menuid:001,Menuname:学生管理}]
	 * 	接下来需要递归查询子节点的集合存入当前节点
	 * 	
	 * @param map
	 * @param pageBean
	 * @return
	 * @throws InstantiationException
	 * @throws IllegalAccessException
	 * @throws SQLException
	 */
	public List<Map<String,Object>> listMenu(Map<String, String[]> map, PageBean pageBean) throws InstantiationException, IllegalAccessException, SQLException{
		String sql = "select * from t_easyui_menu where true ";
		String id = JsonUtils.getParamVal(map, "Menuid");
		if(StringUtils.isNotBlank(id)) {
        // 当前节点的ID当作子节点父ID进行查询
			sql += " and parentid="+id;
		}else {
			sql += " and parentid=-1";
		}
		return super.executeQuery(sql, pageBean);
	}
	
	/**
	 * 需要将后台数据库查出来的数据格式转换成前台easyui所识别的数据
	 * @param map
	 * @param treeNode
	 * @throws SQLException 
	 * @throws IllegalAccessException 
	 * @throws InstantiationException 
	 */
	public void mapToTreeNode(Map<String,Object> map, TreeNode treeNode) throws InstantiationException, IllegalAccessException, SQLException {
		treeNode.setId(map.get("Menuid").toString());
		treeNode.setText(map.get("Menuname").toString());
		treeNode.setAttributes(map);
		
        // treeNode.setChildren(children);
		Map<String, String[]> childMap = new HashMap<String, String[]>();
		childMap.put("Menuid", new String[] {treeNode.getId()});
        // 查询出当前节点所拥有的子节点的集合
		List<Map<String, Object>> listMenu = this.listMenu(childMap, null);
		List<TreeNode> listTreeNode = new ArrayList<TreeNode>();
		this.listMapToListTreeNode(listMenu, listTreeNode);
		treeNode.setChildren(listTreeNode);
	}
	
	public void listMapToListTreeNode(List<Map<String, Object>> list, List<TreeNode> listTreeNode) throws InstantiationException, IllegalAccessException, SQLException {
		TreeNode treeNode = null;
		for (Map<String, Object> map : list) {
			treeNode = new TreeNode();
			this.mapToTreeNode(map, treeNode);
			listTreeNode.add(treeNode);
		}
	}
}

web层：UserAction

package com.xwt.web;

import java.sql.SQLException;
import java.util.List;
import java.util.Map;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.xwt.dao.UserDao;
import com.zking.framework.ActionSupport;

public class UserAction extends ActionSupport {
	
	private UserDao userDao=new UserDao();
	
	public String login(HttpServletRequest req,HttpServletResponse resp) {
		String code="index";
		//登录
		try {
			List<Map<String, Object>> list=this.userDao.list(req.getParameterMap(), null);
			if(list != null && list.size()==1) {
			//用户存在
				List<Map<String, Object>> menuList=this.userDao.getMenu(req.getParameterMap(), null);
				StringBuilder sb=new StringBuilder();
				for (Map<String, Object> map : menuList) {
					sb.append(","+map.get("menuId"));
				}
				req.setAttribute("menuIds", sb.substring(1));
			}else {
			//用户不存在
				req.setAttribute("msg", "用户不存在");
				code="login";
			}
		} catch (InstantiationException | IllegalAccessException | SQLException e) {
			e.printStackTrace();
			code="login";
		}
		return code;
	}
}

配置mvc.xml

<?xml version="1.0" encoding="UTF-8"?>
<config>
	<action path="/menuAction" type="com.xwt.web.MenuAction">
	</action>
	
	<action path="/userAction" type="com.xwt.web.UserAction">
	     <forward name="index" path="/index.jsp" redirect="false" />
	     <forward name="login" path="/login.jsp" redirect="false" />
	</action>
</config>

在index.jsp中接收从login.jsp中传过来的值:

<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<link rel="stylesheet" type="text/css"
	href="${pageContext.request.contextPath }/static/easyui/themes/default/easyui.css">
<link rel="stylesheet" type="text/css"
	href="${pageContext.request.contextPath }/static/easyui/themes/icon.css">
<script type="text/javascript"
	src="${pageContext.request.contextPath }/static/easyui/jquery.min.js"></script>
<script type="text/javascript"
	src="${pageContext.request.contextPath }/static/easyui/jquery.easyui.min.js"></script>
<script type="text/javascript"
    src="${pageContext.request.contextPath }/static/js/index.js"></script>
<title>后台管理主界面</title>
</head>
<body class="easyui-layout">

    <!-- 接收从login.jsp中传过来的值 -->
    <input type="hidden" id="menuIds" value="${menuIds }">
    
	<body class="easyui-layout">
	<div data-options="region:'north',border:false"
		style="height: 60px; background: #B3DFDA; padding: 10px">north
		region</div>
	<div data-options="region:'west',split:true,title:'West'"
		style="width: 150px; padding: 10px;">
		菜单栏
		<ul id="tt"></ul>  
	</div>
	<div
		data-options="region:'east',split:true,collapsed:true,title:'East'"
		style="width: 100px; padding: 10px;">east region
	</div>
	<div data-options="region:'south',border:false"
		style="height: 50px; background: #A9FACD; padding: 10px;">southregion
	</div>
	<div data-options="region:'center',title:'Center'">
		<div id="menuTab" class="easyui-tabs" style="height: 800px;">   
    <div title="首页" style="padding:20px;display:none;">   
                   欢迎你好   
    </div>   
    </div>  
	</div>
</body>
</html>

index.js

$(function(){
	$('#tt').tree({    
	    url:'menuAction.action?methodName=menuTree&&Menuid='+$("#menuIds").val(),
	    onClick: function(node){
			//alert(node.attributes.menuURL);  // 在用户点击的时候提示
	    	var content = '<iframe scrolling="no" frameborder="0" src="'+node.attributes.menuURL+'" width="99%" height="99%"></iframe>';
	    	if($("#menuTab").tabs('exists',node.text)){
	    		$("#menuTab").tabs('select',node.text)
	    	}else{
	    		$('#menuTab').tabs('add',{    
				    title:node.text,    
				    content:content,    
				    closable:true  
				}); 
	    	}
		}
	}); 
})

运行如下：

在这里插入图片描述