easyUI.Tree后端工作

上次我们讲了关于easyUI的基本知识并做了一个简单的首页，但是菜单栏我们是一个固定的，并且点击没有界面，所以今天我们就来做一个连接数据库的菜单栏。

项目目录：

 

 

效果图：

数据库数据：

CREATE TABLE bs_permission
(
    id   number          DEFAULT NULL,
    pid  number          DEFAULT NULL,
    text varchar2(10) DEFAULT NULL,
    url  varchar2(255) DEFAULT NULL
);

create sequence seq_permission;

insert into bs_permission values(seq_permission.nextval,0,'会员管理','');
insert into bs_permission values(seq_permission.nextval,0,'商品管理','');
insert into bs_permission values(seq_permission.nextval,0,'订单管理','');
insert into bs_permission values(seq_permission.nextval,0,'数据报表','');
insert into bs_permission values(seq_permission.nextval,0,'系统管理','');

insert into bs_permission values(seq_permission.nextval,2,'会员卡充值','/manager/user/recharge.jsp');
insert into bs_permission values(seq_permission.nextval,2,'会员等级','/manager/user/level.jsp');
insert into bs_permission values(seq_permission.nextval,3,'状态管理','/manager/goods/state.jsp');
insert into bs_permission values(seq_permission.nextval,3,'类目管理','/manager/user/topic.jsp');
insert into bs_permission values(seq_permission.nextval,3,'评论管理','/manager/user/comment.jsp');

select * from bs_permission;

实现效果代码：

连接数据库（DBHrlper.java）

package com.zking.util;
/**
 * 
 * @author zjjt
 *
 */

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

import oracle.jdbc.OracleDriver;

public class DBHelper {
	//OracleDriver
	
	//加载驱动
	static {
		try {
			Class.forName("oracle.jdbc.driver.OracleDriver");
		}catch(Exception e) {
			e.printStackTrace();
		}
	}
	
	//定义连接字符串
	private static final String URL="jdbc:oracle:thin:@localhost:1521:orcl";
	
	//获得链接
	public static Connection getCon() {
		try {
			return DriverManager.getConnection(URL,"scott","123");
		} catch (Exception e) {
			e.printStackTrace();
		}
		return null;
	}
	
	//关闭资源
	public static void close(Connection con,PreparedStatement ps,ResultSet rs) {
		try {
			if(con!=null&&!con.isClosed()) {
				con.close();
			}
			if (ps!=null) {
				ps.close();
			}
			if(rs!=null) {
				rs.close();
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

}

TreeFactory.java

package com.zking.util;

import java.util.Arrays;
import java.util.List;
import java.util.Optional;
import java.util.stream.Collectors;

@SuppressWarnings("all")
public class TreeFactory {

    public static List<TreeNode> buildList(List<TreeNode> nodeList) {
        List<TreeNode> list = buildList(nodeList, "0");
        TreeNode root;
        if (!list.isEmpty()) {
            return list;
        } else {
            root = new TreeNode();
            root.setId("000");
            root.setParentId("-1");
            root.setHasParent(false);
            root.setHasChildren(true);
            root.setChecked(true);
            root.setChildren(list);
            root.setText("主菜单");
            root.setState("closed");
        }
        return Arrays.asList(root);
    }

    public static List<TreeNode> buildList(List<TreeNode> nodeList, String topMenuId) {
        return Optional.ofNullable(nodeList).map(list -> {
            list.forEach(item -> {
                list.stream().filter(i -> {
                    return i.getId().equals(item.getParentId());
                }).forEach(i -> {
                    i.setHasChildren(Boolean.TRUE);
                    i.getChildren().add(item);
                });
            });
            return list.stream().filter(i -> {
                return i.getParentId().equals(topMenuId);
            }).collect(Collectors.toList());
        }).get();
    }

}

TreeNode.java

package com.zking.util;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
import lombok.experimental.Accessors;

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

@SuppressWarnings("all")
@Data
@AllArgsConstructor
@NoArgsConstructor
@Accessors(chain = true)
public class TreeNode {

    private String id;
    private String text;
    private String state;
    private Boolean checked = false;
    private Map<String, Object> attributes=new HashMap<>();
    private List<TreeNode> children = new ArrayList<>();
    private String parentId;
    private Boolean hasParent = false;
    private Boolean hasChildren = false;
	public String getId() {
		return id;
	}
	public void setId(String id) {
		this.id = id;
	}
	public String getText() {
		return text;
	}
	public void setText(String text) {
		this.text = text;
	}
	public String getState() {
		return state;
	}
	public void setState(String state) {
		this.state = state;
	}
	public Boolean getChecked() {
		return checked;
	}
	public void setChecked(Boolean checked) {
		this.checked = checked;
	}
	public Map<String, Object> getAttributes() {
		return attributes;
	}
	public void setAttributes(Map<String, Object> attributes) {
		this.attributes = attributes;
	}
	public List<TreeNode> getChildren() {
		return children;
	}
	public void setChildren(List<TreeNode> children) {
		this.children = children;
	}
	public String getParentId() {
		return parentId;
	}
	public void setParentId(String parentId) {
		this.parentId = parentId;
	}
	public Boolean getHasParent() {
		return hasParent;
	}
	public void setHasParent(Boolean hasParent) {
		this.hasParent = hasParent;
	}
	public Boolean getHasChildren() {
		return hasChildren;
	}
	public void setHasChildren(Boolean hasChildren) {
		this.hasChildren = hasChildren;
	}
	public TreeNode() {
		super();
		// TODO Auto-generated constructor stub
	}
	public TreeNode(String id, String text, String state, Boolean checked, Map<String, Object> attributes,
			List<TreeNode> children, String parentId, Boolean hasParent, Boolean hasChildren) {
		super();
		this.id = id;
		this.text = text;
		this.state = state;
		this.checked = checked;
		this.attributes = attributes;
		this.children = children;
		this.parentId = parentId;
		this.hasParent = hasParent;
		this.hasChildren = hasChildren;
	}
    
    

}

实体类（Permission）

package com.zking.pojo;

public class Permission {
	
	private Integer id;
	private Integer pid;
	private String text;
	private String url;
	public Integer getId() {
		return id;
	}
	public void setId(Integer id) {
		this.id = id;
	}
	public Integer getPid() {
		return pid;
	}
	public void setPid(Integer pid) {
		this.pid = pid;
	}
	public String getText() {
		return text;
	}
	public void setText(String text) {
		this.text = text;
	}
	public String getUrl() {
		return url;
	}
	public void setUrl(String url) {
		this.url = url;
	}
	public Permission() {
		super();
	}
	public Permission(Integer id, Integer pid, String text, String url) {
		super();
		this.id = id;
		this.pid = pid;
		this.text = text;
		this.url = url;
	}
	
	

}

dao接口（IPermissionDao）

package com.zking.dao;

import java.util.List;

import com.zking.pojo.Permission;
import com.zking.util.TreeNode;

public interface IPermissionDao {
	
	List<Permission> list();
	
	List<TreeNode> listNodes();

}

dao接口实现（PermissionDaoImpl）

package com.zking.dao.impl;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;

import com.zking.dao.IPermissionDao;
import com.zking.pojo.Permission;
import com.zking.util.DBHelper;
import com.zking.util.TreeFactory;
import com.zking.util.TreeNode;

public class PermissionDaoImpl implements IPermissionDao{
	
	private Connection con;
    private PreparedStatement ps;
    private ResultSet rs;

    public List<Permission> list() {
        List<Permission> list = new ArrayList<Permission>();
        try {
            con = DBHelper.getCon();
            ps = con.prepareStatement("select * from bs_permission");
            rs = ps.executeQuery();
            while (rs.next()) {
                Permission permission = new Permission();
                permission.setId(rs.getInt(1));
                permission.setPid(rs.getInt(2));
                permission.setText(rs.getString(3));
                permission.setUrl(rs.getString(4));
                list.add(permission);
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            DBHelper.close(con, ps, rs);
        }
        return list;
    }

    public List<TreeNode> listNodes() {
        List<TreeNode> nodes = new ArrayList<TreeNode>();
        //数据库中
        List<Permission> list = list();
        //将permission封装成node
        for (Permission permission : list) {
            TreeNode node = new TreeNode();
            node.setId(String.valueOf(permission.getId()));
            node.setParentId(String.valueOf(permission.getPid()));
            node.setText(permission.getText());
            //把pid放到自定义属性中
            node.getAttributes().put("pid",permission.getPid());
            //把url放到自定义属性中
            node.getAttributes().put("url",permission.getUrl());
            nodes.add(node);
        }
        return TreeFactory.buildList(nodes, "0");
    }
	
	

}

biz接口（IPermissionBiz）

package com.zking.biz;

import java.util.List;

import com.zking.pojo.Permission;
import com.zking.util.TreeNode;

public interface IPermissionBiz {
	
	List<Permission> list();
	
	List<TreeNode> listNodes();

}

biz接口实现（PermissionBizImpl）

package com.zking.biz.impl;

import java.util.List;

import com.zking.biz.IPermissionBiz;
import com.zking.dao.IPermissionDao;
import com.zking.dao.impl.PermissionDaoImpl;
import com.zking.pojo.Permission;
import com.zking.util.TreeNode;

public class PermissionBizImpl implements IPermissionBiz{
	
	IPermissionDao ip=new PermissionDaoImpl();

	@Override
	public List<Permission> list() {
		return ip.list();
	}

	@Override
	public List<TreeNode> listNodes() {
		return ip.listNodes();
	}

}

功能实现类（PermissionServlet）

package com.zking.servlet;

import java.io.IOException;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.fasterxml.jackson.databind.ObjectMapper;
import com.zking.biz.IPermissionBiz;
import com.zking.biz.impl.PermissionBizImpl;

@WebServlet("/permission.do")
public class PermissionServlet extends HttpServlet{
	
	private IPermissionBiz p=new PermissionBizImpl();
	private ObjectMapper mapper=new ObjectMapper();
	
	@Override
	protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		doPost(req, resp);
	}
	
	@Override
	protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		//查询所有的菜单，将菜单写出去
		mapper.writeValue(resp.getOutputStream(), p.listNodes());
	}

}

首页（index.jsp）

<%@ page contentType="text/html;charset=UTF-8" %>
<html>
<head>
    <title>Title</title>
    <script src="easyui/jquery.min.js"></script>
    <script src="easyui/jquery.easyui.min.js"></script>
    <link rel="stylesheet" href="easyui/themes/default/easyui.css">
</head>
<body class="easyui-layout">
<div data-options="region:'north',title:'网站导航栏',collapsible:false" style="height:100px;"></div>
<div data-options="region:'west',title:'菜单',split:true" style="width:20%;">
    <ul id="asideMenu"></ul>
</div>
<div data-options="region:'center',collapsible:false,border:false" style="padding:5px;background:#eee;">
    <div id="mainTab" class="easyui-tabs" style="width:100%;height:100%;"></div>
</div>
<script>
    let mainTab = $('#mainTab')

    $('#asideMenu').tree({
        url: '${pageContext.request.contextPath}/permission.do', //远程数据的地址
        method: "POST",//访问方式
        lines: true, //显示虚线
        onClick(node) {
            //判断是否是父节点
            if (!node.attributes['pid']) {
                return
            }
            //判断是不是已经打开了
            if(mainTab.tabs('exists',node.text)){
                mainTab.tabs('select',node.text)
                return
            }
            mainTab.tabs('add', {
            	closable:true,
                id:node.id,
                title: node.text,
                content:"<iframe src='"+node.attributes['url']+"'></iframe>"
                //href:node.attributes['url']
            });
        }
    });
</script>
</body>
</html>

有点小bug，点击菜单栏 界面可能出不来