目录
前言
与之前的LayUI之动态树一样,需要有三层架构,这里只是将表换了而已
表如下:此表为一个三级菜单表,从表中可以看到id为15的对应的pid为-1,是一个父级菜单
一,实体类
package com.zking.entity;
public class Easyui_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;
}
public Easyui_Permission() {
// TODO Auto-generated constructor stub
}
public Easyui_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 Easyui_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 "easyui_permission [id=" + id + ", name=" + name + ", description=" + description + ", url=" + url
+ ", pid=" + pid + ", ismenu=" + ismenu + ", displayno=" + displayno + "]";
}
}
二,dao层
package com.zking.dao;
import java.util.ArrayList;
import java.util.List;
import com.zking.entity.Easyui_Permission;
import com.zking.util.BaseDao;
import com.zking.util.BuildTree;
import com.zking.util.PageBean;
import com.zking.util.StringUtils;
import com.zking.util.TreeVo;
public class Easyui_PermissionDao extends BaseDao<Easyui_Permission>{
//查询t_easyui_permission表中的数据
public List<Easyui_Permission> list(Easyui_Permission easyui_permission, PageBean pageBean) throws Exception{
String sql = "select * from t_easyui_permission";
return super.executeQuery(sql,Easyui_Permission.class,pageBean);
}
//二级目录
public List<TreeVo<Easyui_Permission>> permission(Easyui_Permission easyui_permission, PageBean pageBean) throws Exception {
List<TreeVo<Easyui_Permission>> tree = new ArrayList<TreeVo<Easyui_Permission>>();
//从数据库中拿到的菜单数据,此时数据是平级的ÿ