easyui高级控件(一)

权限:就是相对应的人只能看到自己先对应的事，每一个都对应每一个事
这个是一星权限

二星权限

2、二星权限设计（用户权限多对多）
步骤
2.1执行数据库脚本
2.2修改原有的实体类
2.3建立实体类
2.4创建dao

先把原来的dao方法修改一下 (MenuDao)

package com.lj.dao;

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

import com.lj.entity.TreeNode;
import com.lj.util.JsonBaseDao;
import com.lj.util.JsonUtils;
import com.lj.util.PageBean;
import com.lj.util.StringUtils;

public class MenuDao extends JsonBaseDao {
	
	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;
	}
	

	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);
	}
	
	
	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);