easyui使用数据库数据展示导航标题：idea

客户端jsp网页：

<!-- 西部layout  -->
<div data-options="region:'west',split:true,title:'功能管理'" style="150px;">
 
    <!-- tree导航  -->
    <ul id="tt"></ul>
 
</div>

js部分：发送请求：

/**
     *   tree的设置
     *
     **/
 
    $("#tt").tree({
        url: "getTreeTitles",
        lines: true
 
 
    });

创建实体类，重要：理解

下面用pid表示层级之间的管理，默认是0，表示顶级，其次是子级（填写父级的id ）

然后，搜索pid，返回一个list集合，然后再返回json。

package com.domain;
 
import javax.persistence.*;
import java.io.Serializable;
 
 
@Table(name = "ooo_navigation")
@Entity
public class Navigation implements Serializable {
 
    private Integer id;
    private String text;
    private String state;
    private String iconCls;
    private String url;
    private Integer pid;
 
 
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Id
    public Integer getId() {
        return id;
    }
 
    public void setId(Integer id) {
        this.id = id;
    }
 
 
    @Column(nullable = true, length = 25)
    public String getText() {
        return text;
    }
 
    public void setText(String text) {
        this.text = text;
    }
 
    @Column(length = 25)
    public String getState() {
        return state;
    }
 
    public void setState(String state) {
        this.state = state;
    }
 
    public String getIconCls() {
        return iconCls;
    }
 
    public void setIconCls(String iconCls) {
        this.iconCls = iconCls;
    }
 
 
    @Column(length = 50)
    public String getUrl() {
        return url;
    }
 
    public void setUrl(String url) {
        this.url = url;
    }
 
    @Column(columnDefinition = "int default 0")
    public Integer getPid() {
        return pid;
    }
 
    public void setPid(Integer pid) {
        this.pid = pid;
    }
 
    public Navigation() {
    }
 
    public Navigation(Integer id, String text, String state, String iconCls, String url, Integer pid) {
        this.id = id;
        this.text = text;
        this.state = state;
        this.iconCls = iconCls;
        this.url = url;
        this.pid = pid;
    }
 
    @Override
    public String toString() {
        return "Navigation{" +
            "id=" + id +
            ", text='" + text + ''' +
            ", state='" + state + ''' +
            ", iconCls='" + iconCls + ''' +
            ", url='" + url + ''' +
            ", pid=" + pid +
            '}';
    }
}

用jpa生成数据库后，在数据库填写数据......closed表示父级显示+号，可以展开，展开的时候，tree就把子级的pid以“id”作为请求参数进行再次请求数据，表示请求该父级下的数据

请求方法，可以判断接收id值，默认为0，返回list，这里使用了json的jar包自动转换....

/**
     * 获取导航栏标题
     **/
    @ResponseBody
    @RequestMapping(value = "getTreeTitles", method = RequestMethod.POST)
    public List<Navigation> getTreeTitles(@RequestParam(value = "id", required = false, defaultValue = "0") Integer id) {
 
        List<Navigation> list = userTransaction.getTrees(id);
 
        System.out.println(list);
 
        return list;
    }

json的jar包：

springData的查询方法：

显示效果：

控制台语句：

Hibernate: 
    select
        navigation0_.id as id1_0_,
        navigation0_.iconCls as iconCls2_0_,
        navigation0_.pid as pid3_0_,
        navigation0_.state as state4_0_,
        navigation0_.text as text5_0_,
        navigation0_.url as url6_0_ 
    from
        ooo_navigation navigation0_ 
    where
        navigation0_.pid=?
[Navigation{id=1, text='数据库模块', state='closed', iconCls='null', url='null', pid=0}, Navigation{id=2, text='人员管理模块', state='closed', iconCls='null', url='null', pid=0}]

点击+号：

语句：

Hibernate: 
    select
        navigation0_.id as id1_0_,
        navigation0_.iconCls as iconCls2_0_,
        navigation0_.pid as pid3_0_,
        navigation0_.state as state4_0_,
        navigation0_.text as text5_0_,
        navigation0_.url as url6_0_ 
    from
        ooo_navigation navigation0_ 
    where
        navigation0_.pid=?
[Navigation{id=3, text='采购信息', state='open', iconCls='null', url='null', pid=1}, Navigation{id=4, text='学生成绩', state='open', iconCls='null', url='null', pid=1}]

来自为知笔记(Wiz)