查询返回树形数据

本文举了两种生成树形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<