目录
一、数据分析
我们可以知道一级菜单都是放在ul下面的li标签中的a标签,我们是不是可以放在同一级别进行遍历,而子级菜单都是为dd标签中,所以我们可以放在一起进行遍历。
数据格式:
[
{name:会议管理,children:[
{name:发布会议},
{name:我的会议},
{name:会议通知},
{name:历史会议}
]},
{name:menu group2},
{name:click menu item},
{name:the links}
]
二、获取数据库中的所有菜单数据
表格数据:
首先,先建立一个实体类名为Permission
package com.zking.entity;
/**
* 数据库中t_oa_Permission表对应的实体类
* @author Administrator
*
*/
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() {
// TODO Auto-generated constructor stub
}
@Override
public String toString() {
return "Permission [id=" + id + ", name=" + name + ", description=" + description + ", url=" + url + ", pid="
+ pid + ", ismenu=" + ismenu + ", displayno=" + displayno + "]";
}
}
写一个dao方法:MenuDao
package com.zking.dao;
import java.util.List;
import com.zking.entity.Permission;
import com.zking.util.BaseDao;
import com.zking.util.PageBean;
public class MenuDao extends BaseDao<Permission>{
//查询t_oa_permission表中的数据
public List<Permission> executeQuery(Permission permission, PageBean pageBean) throws Exception {
String sql="SELECT * from t_oa_permission";
return super.executeQuery(sql, Permission.class, pageBean);
}
}
运行结果:
三、将菜单表中的数据在后台构建父子关系
将数据转为Json格式
package com.zking.dao;
import static org.junit.Assert.*;
import java.util.List;
import org.junit.Test;
import com.fasterxml.jackson.databind.ObjectMapper;
import com.zking.entity.Permission;
public class PermissionDaoTest {
private PermissionDao pd = new PermissionDao();
@Test
public void testList() {
try {
List<Permission> list = pd.list(null,null);
for (Permission permission : list) {
//System.out.println(permission);
}
ObjectMapper om = new ObjectMapper();
System.out.println(om.writeValueAsString(list));
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
得到Json数据 :
[{
"id": 10,
"name": "会议管理",
"description": null,
"url": null,
"pid": -1,
"ismenu": 1,
"displayno": 1
}, {
"id": 11,
"name": "投票管理",
"description": null,
"url":