layui之动态树

白未

已于 2022-07-18 11:01:50 修改

阅读量272

点赞数

文章标签： java

于 2022-07-18 08:44:23 首次发布

本文链接：https://blog.csdn.net/yzq102873/article/details/125840696

版权

一、获取数据库表中的所有菜单数据

1、实体类

package com.zking.entity;

public class Permission {
	private long id;
	private String name;//菜单
	private String description;//描述
	private String url;//点击菜单跳转页面
	private long pid;//付及菜单id
	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;
	}
	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();
	}
	@Override
	public String toString() {
		return "Permission [id=" + id + ", name=" + name + ", description=" + description + ", url=" + url + ", pid="
				+ pid + ", ismenu=" + ismenu + ", displayno=" + displayno + "]";
	}
	
}

2、dao方法

package com.zking.dao;

import java.util.ArrayList;
import java.util.List;

import com.zking.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>{

	//查询表中的数据
	public List<Permission> list(Permission permission,PageBean pageBean) throws Exception {
		String sql ="select * from t_oa_permission";
		return super.executeQuery(sql, Permission.class, pageBean);
	}
	

}

3、测试

package com.zking.dao;

import java.util.ArrayList;
import java.util.List;

import com.zking.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>{

	//查询表中的数据
	public List<Permission> list(Permission permission,PageBean pageBean) throws Exception {
		String sql ="select * from t_oa_permission";
		return super.executeQuery(sql, Permission.class, pageBean);
	}
	
}

运行如下

二、将菜单表中的数据在后头构建父子关系

1、工具类

BuildTree

package com.zking.util;

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

public class BuildTree {

	/**
	 * 默认-1为顶级节点
	 * @param nodes
	 * @param <T>
	 * @return
	 */
	public static <T> TreeVo<T> build(List&l