栏目分类:
子分类:
返回
名师互学网用户登录
快速导航关闭
当前搜索
当前分类
子分类
实用工具
热门搜索
名师互学网 > IT > 软件开发 > 后端开发 > Java

【JAVA】查询树形结构的数据

Java 更新时间: 发布时间: IT归档 最新发布 模块sitemap 名妆网 法律咨询 聚返吧 英语巴士网 伯小乐 网商动力

【JAVA】查询树形结构的数据

1.数据结构:

data: [
	{
	  id: 1,
	  date: '2016-05-02',
	  name: '王小虎1',
	  address: '上海市普陀区金沙江路 1518 弄'
	  children: [{
		  id: 21,
		  date: '2016-05-06',
		  name: '王小虎4',
		  address: '上海市普陀区金沙江路 1519 弄'
		}, {
		  id: 22,
		  date: '2016-05-07',
		  name: '王小虎5',
		  address: '上海市普陀区金沙江路 1519 弄'
	  }]
	}, {
	  id: 2,
	  date: '2016-05-04',
	  name: '王小虎2',
	  address: '上海市普陀区金沙江路 1517 弄'
	  children: [{
		  id: 23,
		  date: '2016-05-08',
		  name: '王小虎6',
		  address: '上海市普陀区金沙江路 1519 弄'
		}, {
		  id: 24,
		  date: '2016-05-09',
		  name: '王小虎7',
		  address: '上海市普陀区金沙江路 1519 弄'
	  }]
	}, {
	  id: 3,
	  date: '2016-05-05',
	  name: '王小虎3',
	  address: '上海市普陀区金沙江路 1519 弄',
	  children: [{
		  id: 25,
		  date: '2016-05-10',
		  name: '王小虎8',
		  address: '上海市普陀区金沙江路 1519 弄'
		}, {
		  id: 26,
		  date: '2016-05-11',
		  name: '王小虎9',
		  address: '上海市普陀区金沙江路 1519 弄'
	  }]
	}
]

2.实现方法

1.引入fastjson的依赖



    com.alibaba
    fastjson
    1.2.83
@Override
    public StandardResponse getMenu(GetMenuRequest menuRequest) {
        // 1.查询系统信息,先查询目录然后递归查询目录下面的数据
        LambdaQueryWrapper wrapper = new QueryWrapper().lambda()
                .eq(SysMenuEntity::getDelFlg, Constants.ONE)
                .eq(SysMenuEntity::getMenuType, Constants.MENU_TYPE)
                .like(StringUtils.hasLength(menuRequest.getMenuStatus()), SysMenuEntity::getMenuStatus, menuRequest.getMenuStatus())
                .like(StringUtils.hasLength(menuRequest.getMenuName()), SysMenuEntity::getMenuName, menuRequest.getMenuName());
        List menuList = getBaseMapper().selectList(wrapper);
        // 2.递归查询目录下面的数据
        JSONArray jsonArray = JSON.parseArray(JSON.toJSONString(menuList, SerializerFeature.WriteMapNullValue));
        treeList(jsonArray,menuRequest);
        return StandardResponse.build(Result.QUERY_SUCCESS).setData(jsonArray);
    }

    
    public void treeList(JSONArray jsonArray,GetMenuRequest menuRequest) {
        for (Object ob : jsonArray) {
            JSONObject jo = (JSONObject)ob;
            LambdaQueryWrapper queryWrapper = new QueryWrapper().lambda()
                    .eq(SysMenuEntity::getDelFlg, Constants.ONE)
                    .eq(SysMenuEntity::getParentId, jo.get("id"))
                    .like(StringUtils.hasLength(menuRequest.getMenuStatus()), SysMenuEntity::getMenuStatus, menuRequest.getMenuStatus())
                    .like(StringUtils.hasLength(menuRequest.getMenuName()), SysMenuEntity::getMenuName, menuRequest.getMenuName())
                    ;
            List childList = getBaseMapper().selectList(queryWrapper);
            if (CollectionUtils.isEmpty(childList)) {
                continue;
            }
            JSONArray childArray = JSON.parseArray(JSON.toJSONString(childList, SerializerFeature.WriteMapNullValue));
            jo.put("children", childArray);
            treeList(childArray,menuRequest);
        }
    }

转载请注明:文章转载自 www.mshxw.com
本文地址:https://www.mshxw.com/it/959651.html
我们一直用心在做
关于我们 文章归档 网站地图 联系我们

版权所有 (c)2021-2022 MSHXW.COM

ICP备案号:晋ICP备2021003244-6号