网上书城（登录、注册、树形菜单）

登录&注册

实体类

package com.luojun.entity;

public class User {
    private long id;
    private String name;
    private String pwd;
    private int type;
	public long getId() {
		return id;
	}
	public void setId(long id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public String getPwd() {
		return pwd;
	}
	public void setPwd(String pwd) {
		this.pwd = pwd;
	}
	public int getType() {
		return type;
	}
	public void setType(int type) {
		this.type = type;
	}
	@Override
	public String toString() {
		return "User [id=" + id + ", name=" + name + ", pwd=" + pwd + ", type=" + type + "]";
	}
	public User(long id, String name, String pwd, int type) {
		super();
		this.id = id;
		this.name = name;
		this.pwd = pwd;
		this.type = type;
	}
	public User() {
		super();
	}
    
    
}

dao方法

package com.luojun.dao;

import java.util.List;

import com.luojun.entity.User;
import com.luojun.utils.BaseDao;
import com.luojun.utils.StringUtils;


public class UserDao extends BaseDao<User> {
    //    登录
    public User login(User user) throws Exception {
    String name = user.getName();
    String pwd = user.getPwd();
    String sql = "select * from t_easyui_user where true ";
    if (StringUtils.isNotBlank(name)) {
        sql += " and name = '"+name+"'";
    }
    if (StringUtils.isNotBlank(pwd)) {
        sql += " and pwd = '"+pwd+"'";
    }
    List<User> list = super.executeQuery(sql, null, User.class);
    if (list.size() == 0) {
        return null;
    }
    return list.get(0);
 }

    //    注册
    public int add(User user) throws Exception {
        String sql = "insert into t_easyui_user(name,pwd) values(?,?) ";
        return super.executeUpdate(sql,user,new String[]{"name","pwd"});
    }

}

Action

package com.luojun.web;

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

import com.luojun.dao.UserDao;
import com.luojun.entity.User;
import com.luojun.framework.ActionSupport;
import com.luojun.framework.ModelDriven;


public class UserAction extends ActionSupport implements ModelDriven<User> {
    private User user = new User();
    private UserDao userDao = new UserDao();

    @Override
    public User getModel() {
        return user;
    }

    public String login(HttpServletRequest request, HttpServletResponse response){
        try {
            User current = this.userDao.login(user);
            if (current==null){
                return "mainTemp";
            }
            request.getSession().setAttribute("currentUser",current);
        } catch (Exception e) {
            e.printStackTrace();
            return "login";
        }
        return "mainTemp";
    }

    public String add(HttpServletRequest request, HttpServletResponse response){
        try {
            this.userDao.add(user);
        } catch (Exception e) {
            e.printStackTrace();
            return "register";
        }
        return "login";
    }
}

树形菜单

实体类

package com.luojun.entity;


public class Permission {
    private long id;
    private String name;
    private String description;
    private String url;
    private long pid;
    private int ismenu;
    private long displayno;
	public long getId() {
		return id;
	}
	public void setId(long id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public String getDescription() {
		return description;
	}
	public void setDescription(String description) {
		this.description = description;
	}
	public String getUrl() {
		return url;
	}
	public void setUrl(String url) {
		this.url = url;
	}
	public long getPid() {
		return pid;
	}
	public void setPid(long pid) {
		this.pid = pid;
	}
	public int getIsmenu() {
		return ismenu;
	}
	public void setIsmenu(int ismenu) {
		this.ismenu = ismenu;
	}
	public long getDisplayno() {
		return displayno;
	}
	public void setDisplayno(long displayno) {
		this.displayno = displayno;
	}
	@Override
	public String toString() {
		return "Permission [id=" + id + ", name=" + name + ", description=" + description + ", url=" + url + ", pid="
				+ pid + ", ismenu=" + ismenu + ", displayno=" + displayno + "]";
	}
	public Permission(long id, String name, String description, String url, long pid, int ismenu, long displayno) {
		super();
		this.id = id;
		this.name = name;
		this.description = description;
		this.url = url;
		this.pid = pid;
		this.ismenu = ismenu;
		this.displayno = displayno;
	}
	public Permission() {
		super();
	}
    
}

dao方法

package com.luojun.dao;

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

import com.luojun.entity.Permission;
import com.luojun.entity.RolePermission;
import com.luojun.utils.BaseDao;
import com.luojun.utils.BuildTree;
import com.luojun.vo.TreeVo;


public class PermissionDao extends BaseDao<Permission> {

//    树形菜单加载
    public List<Permission> menuTree() throws Exception {
        String sql = "select * from t_easyui_permission where true ";
        return super.executeQuery(sql, null, Permission.class);
    }

//    通过ids查出ids指定的树形菜单
    public List<Permission> menuTree(String ids) throws Exception {
        String sql = "select * from t_easyui_permission where id in ("+ids+") ";
        return super.executeQuery(sql, null, Permission.class);
    }

//    树形菜单加载
    public List<TreeVo<Permission>> menuTreeHandler() throws Exception {
        List<Permission> permissions = this.menuTree();
        List<TreeVo<Permission>> nodes = new ArrayList<>();
        TreeVo<Permission> node;
        for (Permission permission : permissions) {
            node = new TreeVo<>();
            node.setId(String.valueOf(permission.getId()));
            node.setText(permission.getName());
//            node.setAttributes();
            node.setParentId(String.valueOf(permission.getPid()));
            Map map = new HashMap();
            map.put("self",permission);
            node.setAttributes(map);
            nodes.add(node);
        }
//        BuildTree.
        return BuildTree.buildList(nodes,"0");
    }

    public List<TreeVo<Permission>> menuTreeHandler(String pids) throws Exception {
        List<Permission> permissions = this.menuTree(pids);
        List<TreeVo<Permission>> nodes = new ArrayList<>();
        TreeVo<Permission> node;
        for (Permission permission : permissions) {
            node = new TreeVo<>();
            node.setId(String.valueOf(permission.getId()));
            node.setText(permission.getName());
//            node.setAttributes();
            node.setParentId(String.valueOf(permission.getPid()));
            Map map = new HashMap();
            map.put("self",permission);
            node.setAttributes(map);
            nodes.add(node);
        }
//        BuildTree.
        return BuildTree.buildList(nodes,"0");
    }

}

Action

package com.luojun.web;



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

import com.fasterxml.jackson.databind.ObjectMapper;
import com.luojun.dao.PermissionDao;
import com.luojun.dao.RolePermissionDao;
import com.luojun.entity.Permission;
import com.luojun.entity.RolePermission;
import com.luojun.entity.User;
import com.luojun.framework.ActionSupport;
import com.luojun.framework.ModelDriven;
import com.luojun.utils.ResponseUtil;
import com.luojun.vo.TreeVo;

import java.util.List;

public class PermissionAction extends ActionSupport implements ModelDriven<Permission> {
    private Permission permission = new Permission();
    private PermissionDao permissionDao = new PermissionDao();
    private RolePermissionDao rolePermissionDao = new RolePermissionDao();

    public String menuTree(HttpServletRequest request, HttpServletResponse response){
        ObjectMapper om = new ObjectMapper();
        try {
            User currentUser = (User) request.getSession().getAttribute("currentUser");
            List<RolePermission> pids = rolePermissionDao.getPids(currentUser.getType());
            StringBuilder sb = new StringBuilder();
            for (RolePermission pid : pids) {
                sb.append(",").append(pid.getPid());
            }

            List<TreeVo<Permission>> treeVos = this.permissionDao.menuTreeHandler(sb.substring(1));
            String json = om.writeValueAsString(treeVos);
            ResponseUtil.write(response,json);
        } catch (Exception e) {
            e.printStackTrace();
        }
        return null;
    }

    @Override
    public Permission getModel() {
        return permission;
    }
}

效果图