1 ,注册
package com.hmf.dao;
import java.util.List;
import com.hmf.entity.User;
import com.zking.util.BaseDao;
import com.zking.util.PageBean;public class UserDao extends BaseDao<User>{
public User login(User user) throws Exception {
String sql = "select * from t_easyui_user where name= '"+user.getName()+"' and pwd = '"+user.getPwd()+"'";
return super.executeQuery(sql, User.class, null).get(0);
}
public void add(User user) throws Exception {
String sql = "insert into t_easyui_user(name,pwd) values(?,?)";
super.executeUpdate(sql, user, new String[] {"name","pwd"});
}
}
子控制器
package com.hmf.web;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;import com.hmf.dao.UserDao;
import com.hmf.entity.User;
import com.zking.framework.ActionSupport;
import com.zking.framework.ModelDriver;public class UserAction extends ActionSupport implements ModelDriver<User>{
private User user=new User();
private UserDao userDao=new UserDao();
public User getModel() {
return user;
}
public String login(HttpServletRequest req, HttpServletResponse resp) {
try {
User u = userDao.login(user);
if(u == null) {
return "toLogin";
}
req.getSession().setAttribute("cuser", u);
} catch (Exception e) {
e.printStackTrace();
return "toLogin";
}
//数据库有这个用户 就直接跳转主界面
return "main";
}
public String register(HttpServletRequest req, HttpServletResponse resp) {
try {
userDao.add(user);
req.setAttribute("msg", "用户名和密码错误");
} catch (Exception e) {
e.printStackTrace();
return "toRegister";
}
//如果注册成功 直接跳转登录界面
return "toLogin";
}}
三个返回值
只有一个商家javaxl 其他都是买家
2,登录
注册成功跳登录
登录成功跳权限树形展示
3、权限树形展示
$(function(){
$("#bookMenus").tree({
url:$("#ctx").val()+"/permission.action?methodName=tree"
});
})
左侧数据没有显示
错误是我的js少了一个括号
结果
4, 实现权限登录
entity
PermissionDao:
package com.hmf.dao;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;import com.hmf.entity.Permission;
import com.zking.util.BaseDao;
import com.zking.util.BuildTree;
import com.zking.util.PageBean;
import com.zking.util.TreeVo;public class PermissionDao extends BaseDao<Permission>{
/**
* 变成easyui的tree控件所识别的json格式
* ①jackson引入进来
* ②拿到Permission的集合 先查询数据库
* ③list<Permission>转换list<TreeVo>
* ④工具类BuildTree将平级数据库转换成层级数据
*/
public List<Permission> list(Permission permission, PageBean pageBean) throws Exception {
String sql = "select * from t_easyui_permission where 1=1";
return super.executeQuery(sql, Permission.class, pageBean);
}
public List<Permission> listPlus(String ids) throws Exception {
String sql = "select * from t_easyui_permission where id in ("+ids+")";
return super.executeQuery(sql, Permission.class, null);
}
public List<TreeVo<Permission>> tree(Permission permission, PageBean pageBean) throws Exception {
List<Permission> listPermission = this.list(permission, pageBean);
List<TreeVo<Permission>> listVo=new ArrayList<TreeVo<Permission>>();
for (Permission p : listPermission) {
TreeVo<Permission> v =new TreeVo<Permission>();
v.setId(p.getId()+"");
v.setText(p.getName());
v.setParentId(p.getPid()+"");
Map<String, Object> map=new HashMap<String, Object>();
map.put("self", p);
v.setAttributes(map);
listVo.add(v);
}
return BuildTree.buildList(listVo, "0");
//return super.executeQuery(sql, Permission.class, pageBean);
}
public List<TreeVo<Permission>> treePlus(String ids) throws Exception {
List<Permission> listPermission = this.listPlus(ids);
List<TreeVo<Permission>> listVo=new ArrayList<TreeVo<Permission>>();
for (Permission p : listPermission) {
TreeVo<Permission> v =new TreeVo<Permission>();
v.setId(p.getId()+"");
v.setText(p.getName());
v.setParentId(p.getPid()+"");
Map<String, Object> map=new HashMap<String, Object>();
map.put("self", p);
v.setAttributes(map);
listVo.add(v);
}
return BuildTree.buildList(listVo, "0");
//return super.executeQuery(sql, Permission.class, pageBean);
}
}
PermissionAction:
package com.hmf.web;
import java.util.List;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;import com.hmf.dao.PermissionDao;
import com.hmf.dao.RolePermissionDao;
import com.hmf.dao.UserDao;
import com.hmf.entity.Permission;
import com.hmf.entity.RolePermission;
import com.hmf.entity.User;
import com.zking.framework.ActionSupport;
import com.zking.framework.ModelDriver;
import com.zking.util.BuildTree;
import com.zking.util.ResponseUtil;
import com.zking.util.TreeVo;public class PermissionAction extends ActionSupport implements ModelDriver<Permission>{
private Permission permission=new Permission();
private PermissionDao permissionDao=new PermissionDao();
private RolePermissionDao rolePermissionDao=new RolePermissionDao();
// private UserDao userDao=new UserDao();
public Permission getModel() {
return permission;
}
public String tree(HttpServletRequest req, HttpServletResponse resp) {
try {
User cuser = (User) req.getSession().getAttribute("cuser");
if(cuser == null) {
return "toLogin";
}
int type = cuser.getType();
List<RolePermission> findRolePermission = rolePermissionDao.findRolePermission(type);
StringBuffer sb=new StringBuffer();
for (RolePermission rp : findRolePermission) {
sb.append(",").append(rp.getPid());
}
// ids="1,2,3";
List<TreeVo<Permission>> treePlus = permissionDao.treePlus(sb.substring(1));
// List<TreeVo<Permission>> tree = permissionDao.tree(null, null);
System.out.println(treePlus);
ResponseUtil.writeJson(resp, treePlus);
} catch (Exception e) {
e.printStackTrace();
try {
ResponseUtil.writeJson(resp, "0");
} catch (Exception e1) {
e1.printStackTrace();
}
}
return null;
}
}
两种身份登录
这是买家
商家