LayUI之动态树

目录

一，后台搭建

1.实体类

2.dao层

3.tag层

4.util层

5.web层

二，前台演示

---

一，后台搭建

如图所示

需要搭建以下层面

1.实体类

属性的数据类型必须与数据库的数据类型保持一致

bigint在实体类中用long

<代码演示>

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() {
		// TODO Auto-generated constructor stub
	}
	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(String name, String description, String url, long pid, int ismenu, long displayno) {
		super();
		this.name = name;
		this.description = description;
		this.url = url;
		this.pid = pid;
		this.ismenu = ismenu;
		this.displayno = displayno;
	}
	@Override
	public String toString() {
		return "Permission [id=" + id + ", name=" + name + ", description=" + description + ", url=" + url + ", pid="
				+ pid + ", ismenu=" + ismenu + ", displayno=" + displayno + "]";
	}
	
	
	
	
	
	
}

 

2.dao层

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);
	}
	
	public List<TreeVo<Permission>> menus(Permission permission, PageBean pageBean) throws Exception {
		ArrayList<TreeVo<Permission>> trees = new ArrayList<TreeVo<Permission>>();
		//从数据库拿到的菜单数据，此时数据是平级的，不具备父子关系
		List<Permission> list = this.list(permission, pageBean);
		for (Permission p : list) {
			TreeVo<Permission> vo = new TreeVo<>();
			vo.setId(p.getId()+"");
			vo.setText(p.getName());//节点的名称
			vo.setParentId(p.getPid()+"");
			trees.add(vo);
		}
		return BuildTree.buildList(trees, "-1");
	}
	
	
	
	
}

dao方法测试类

《代码演示》

package com.zking.dao;

import static org.junit.Assert.*;

import java.util.List;

import org.junit.After;
import org.junit.Before;
import org.junit.Test;

import com.fasterxml.jackson.databind.ObjectMapper;
import com.zking.entity.Permission;
import com.zking.util.TreeVo;

public class PermissionDaoTest {
	
	private PermissionDao md = new PermissionDao();

	@Before
	public void setUp() throws Exception {
	}

	@After
	public void tearDown() throws Exception {
	}

	@Test
	public void testList() {
		try {
			List<Permission> list = md.list(null, null);
			for (Permission permission : list) {
				System.out.println(permission);
			}
			ObjectMapper obj = new ObjectMapper();
			System.out.println(obj);
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
	
	
	@Test
	public void testmenu