easyUI权限设置
1,Dao
/**
* 一星权限
* @param paramMap
* @param pageBean
* @return
* @throws InstantiationException
* @throws IllegalAccessException
* @throws SQLException
*/
public List<Map<String, Object>> userLista(Map<String, String[]> paramMap,PageBean pageBean) throws InstantiationException, IllegalAccessException, SQLException{
String uid = JsonUtil.getparamVal(paramMap, "uid");
String upwd = JsonUtil.getparamVal(paramMap, "upwd");
String sql=" select * from t_easyui_user_version1 where true ";
if(StringUtils.isNotBlank(uid)) {
sql+=" and uid="+uid;
}
if(StringUtils.isNotBlank(upwd)) {
sql+=" and upwd="+upwd;
}
return super.executeQuery(sql, pageBean);
}
/**
* 二星权限
* @param paramMap
* @param pageBean
* @return
* @throws InstantiationException
* @throws IllegalAccessException
* @throws SQLException
*/
public List<Map<String, Object>> userListb(Map<String, String[]> paramMap,PageBean pageBean) throws InstantiationException, IllegalAccessException, SQLException{
String uid = JsonUtil.getparamVal(paramMap, "uid");
String upwd = JsonUtil.getparamVal(paramMap, "upwd");
String sql=" select * from t_easyui_user_version2 where true ";
if(StringUtils.isNotBlank(uid)) {
sql+=" and uid="+uid;
}
if(StringUtils.isNotBlank(upwd)) {
sql+=" and upwd="+upwd;
}
return super.executeQuery(sql, pageBean);
}
/**
* 根据UID查询权限中间表
* @param paramMap
* @param pageBean
* @return
* @throws InstantiationException
* @throws IllegalAccessException
* @throws SQLException
*/
public List<Map<String, Object>> getMenuid(Map<String, String[]> paramMap,PageBean pageBean) throws InstantiationException, IllegalAccessException, SQLException{
String uid = JsonUtil.getparamVal(paramMap, "uid");
String sql=" select * from t_easyui_usermenu where true ";
if(StringUtils.isNotBlank(uid)) {
sql+=" and uid="+uid;
}
return super.executeQuery(sql, pageBean);
}
2,action
//一星权限
public String logina(HttpServletRequest req,HttpServletResponse resp) {
try {
List<Map<String, Object>> userList = ud.userLista(req.getParameterMap(), null);
Map<String, Object> userMap = userList.get(0);
if(userMap!=null) {
String menuID = (String) userMap.get("Menuid");
req.setAttribute("menuID", menuID);
}else {
return "tologin";
}
} catch (InstantiationException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IllegalAccessException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return "toindex";
}
//二星权限
public String loginb(HttpServletRequest req,HttpServletResponse resp) {
try {
List<Map<String, Object>> userList = ud.userListb(req.getParameterMap(), null);
Map<String, Object> userMap = userList.get(0);
if(userMap!=null) {
Map<String, String[]> paramMap=new HashMap<>();
paramMap.put("uid", new String[] {userMap.get("uid").toString()});
List<Map<String, Object>> menuids = ud.getMenuid(paramMap, null);
StringBuffer sb=new StringBuffer();
for (Map<String, Object> map : menuids) {
sb.append(",").append(map.get("menuId"));
}
req.setAttribute("menuID", sb.toString().substring(1));
}else {
return "tologin";
}
} catch (InstantiationException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IllegalAccessException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return "toindex";
}
3,js代码
$(function() {
var Url=$("#url").val();
var Menuid=$("#ID").val();
$('#menuTree').tree({
// url:Url+'/menuAction.action?methodName=menuTreeList', //请求全路径(树形菜单)
url:Url+'/menuAction.action?methodName=menuTreeList&&Menuid='+Menuid, //(权限)
onClick: function(node){ //点击事件
if($('#menuTab').tabs('exists',node.text)){ //如果已经存在
$('#menuTab').tabs('select',node.text) //就锁定
}else{
$('#menuTab').tabs('add',{ //否则就创建一个新的
title:node.text,
content:'<iframe scrolling="no" frameborder="0" src="'+node.attributes.menuURL+'" width="99%" height="99%"></iframe>',
closable:false
});
}
}
});
})
4,一星权限设计思路
5,二星权限设计思路
6,三星权限设计思路