JAVA级联结构是什么_mybatis级联查询树形结构（如菜单）

1、查询指定ID下所有的子节点(从顶层到底层--多层结构)

id为0 查询所有节点

import java.util.List;

/**

*/

public class TreeVO {

private Integer id;

private String name;

private Integer pid;

private Listlist;

public Integer getId() {

return id;

}

public void setId(Integer id) {

this.id = id;

}

public String getName() {

return name;

}

public void setName(String name) {

this.name = name;

}

public Integer getPid() {

return pid;

}

public void setPid(Integer pid) {

this.pid = pid;

}

public ListgetList() {

return list;

}

public void setList(Listlist) {

this.list = list;

}

}

select * from t_tree where pid = 0

select * from t_tree where pid = #{id}

数据库数据结构如下：

查询出来后，json格式化：

2、根据指定ID 查询其所有父级(从底层到顶层--多层结构)

import java.util.List;

/**

*/

public class TreeVO {

private Integer id;

private String name;

private Integer pid;

private Listlist;

public Integer getId() {

return id;

}

public void setId(Integer id) {

this.id = id;

}

public String getName() {

return name;

}

public void setName(String name) {

this.name = name;

}

public Integer getPid() {

return pid;

}

public void setPid(Integer pid) {

this.pid = pid;

}

public ListgetList() {

return list;

}

public void setList(Listlist) {

this.list = list;

}

}

@Mapper

public interface TreeVOMapper {

ListselectAllTree() ;

ListselectAllParentTreeBySubId(Integer id) ;

}

http://localhost:8080/tree2?id=12