本文举了两种生成树形json格式的数据,方法一循环模式是以键值对的形式去循环查询,另一种嵌套for循环模式见下面链接
https://blog.csdn.net/eeeeasy/article/details/80941452
控制层Controll
//方法一循环模式
@GetMapping("/tree1")
@ApiOperation(value = "部门树形结构", notes = "部门树形结构", httpMethod = "GET")
public RestObject<List<OrgTreeResponse>> fetchTreeOrgs1() {
return RestObject.newOk("", orgService.fetchTreeOrgs1());
}
//方法二递归模式
@GetMapping("/tree2")
@ApiOperation(value = "部门树形结构", notes = "部门树形结构", httpMethod = "GET")
public RestObject<List<OrgTreeResponse>> fetchTreeOrgs2() {
return RestObject.newOk("", orgService.fetchTreeOrgs2());
}
服务层接口Service
public List<OrgTreeResponse> fetchTreeOrgs1();
public List<OrgTreeResponse> fetchTreeOrgs2();
服务层实现类ServiceImpl
@Override
public List<OrgTreeResponse> fetchTreeOrgs1() {
String sql = "SELECT org_id AS orgId, org_name AS orgName, parent_id AS parentId FROM pub_org WHERE del_flag = '0' ORDER BY sort DESC";
Map<String, Object> paramMap = new HashMap<