easyui 中 的同步树（2）

在上一篇文章中我写的那个同步树，我是使用了三张表。这次我是把三张表合成一张表，表名是t_academy，实体类名是TAcademy。

1.先看下这个表结构

这个表只有三列，id不用解释，text是节点的名称，pid是父节点的id。其中id是自动增长的。

2.看下实体类TAcademy

@Entity
@Table(name = "t_academy", catalog = "xiaonei")
public class TAcademy implements java.io.Serializable {
    // Fields
    private Integer id;
    private String text;
    private String pid;
    private List<TAcademy> children;

    // Constructors
    /** default constructor */
    public TAcademy() {
    }

    @Column(name = "pid")
    public String getPid() {
        return pid;
    }

    public void setPid(String pid) {
        this.pid = pid;
    }

    @Transient
    public List<TAcademy> getChildren() {
        return children;
    }

    public void setChildren(List<TAcademy> children) {
        this.children = children;
    }


    /** full constructor */
    public TAcademy(String text) {
        this.text = text;
    }

    // Property accessors
    @Id
    @GeneratedValue(strategy = IDENTITY)
    @Column(name = "id", unique = true, nullable = false)
    public Integer getId() {
        return this.id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    @Column(name = "text", length = 36)
    public String getText() {
        return this.text;
    }

    public void setText(String text) {
        this.text = text;
    }

}
//注意：children字段是不和数据库对应的！！！，是用来存放它的子节点的！

3.看下controller

/*
     * 这种方法也是不行的，因为这种方法只能在专业树的中间部分添加节点，
     * 这样写着个专业树就是一个死树， 所以再进行改进，需要用到递归了！！！
     * */
    @RequestMapping("/_getAllTree")
    public String _getAllTree(HttpServletRequest request,HttpServletResponse response) throws Exception{
        //获取一级目录academy
        List academyList_1 = treeService.getAllTree(0);

        //遍历一级目录，并获取二级目录
        Iterator academyIt_1 = academyList_1.iterator();
        while(academyIt_1.hasNext()){
            TAcademy academy_1 = (TAcademy) academyIt_1.next();
            List academyList_2 = treeService.getAllTree(academy_1.getId());

            //遍历二级目录，并获取三级目录
            Iterator academyIt_2 = academyList_2.iterator();
            List addAcademyList_2 = new ArrayList();
            while(academyIt_2.hasNext()){
                TAcademy academy_2 = (TAcademy) academyIt_2.next();
                addAcademyList_2.add(academy_2);
                List academyList_3 = treeService.getAllTree(academy_2.getId());
                Iterator academyIt_3 = academyList_3.iterator();
                List addAcademy_3 = new ArrayList();
                while(academyIt_3.hasNext()){
                    TAcademy academy_3 = (TAcademy) academyIt_3.next();
                    addAcademy_3.add(academy_3);
                }
                academy_2.setChildren(addAcademy_3);
            }
            academy_1.setChildren(addAcademyList_2);
        }
        JSONArray jn = JSONArray.fromObject(academyList_1);
        response.setContentType("text/html;charset=utf-8");
        response.getWriter().println(jn.toString());
        return null;
    }

4.效果图

注意：前台代码是和上一篇中的一样的。