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

树形查询 递归实现 Springboot Mybatis-plus

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

树形查询 递归实现 Springboot Mybatis-plus

项目需求:上级代理商可以看到自己和下级代理商 方案:利用树形查询,递归实现 数据库表:

每一行都有id和推荐人id,实现输入name查询本身与下级

Service层的实现

@Override
    public List treeList(int id) {
        List menuList = list();
        List result = menuList.stream()
                .filter(menu -> menu.getRefereeId().equals(id))
                .map(menu -> covertMenuNode(menu, menuList)).collect(Collectors.toList());
        return result;
    }

    @Override
    public List treeList() {
        List menuList = list();
        List result = menuList.stream()
                .filter(menu -> menu.getRefereeId().equals(0))
                .map(menu -> covertMenuNode(menu, menuList)).collect(Collectors.toList());
        return result;
    }

    

    @Override
    public DlsUserTreePO covertMenuNode(DlsUserPO menu, List menuList) {
        DlsUserTreePO node = new DlsUserTreePO();
        BeanUtils.copyProperties(menu, node);
        List children = menuList.stream()
                .filter(subMenu -> subMenu.getRefereeId().equals(menu.getId()))
                .map(subMenu -> covertMenuNode(subMenu, menuList)).collect(Collectors.toList());
        node.setChildUser(children);
        return node;
    }

实体类

public class DlsUserTreePO extends DlsUserPO {
    private List childUser;
}

Controller层

    @RequestMapping("/treeQuery/{name}")
    @ApiOperation(value = "树形查询推荐人",httpMethod = "POST")
    public R treeQuery(@PathVariable("name") String name){
        int id=dlsUserMapper.selectByName(name);
        DlsUserTreePO dlsUserTreePO=dlsUserService.itself(id);
        List dlsUserTreePOS=dlsUserService.treeList(id);
        dlsUserTreePO.setChildUser(dlsUserTreePOS);
        return R.ok(dlsUserTreePO,"查询成功");
    }

    @RequestMapping("/treeQuery")
    @ApiOperation(value = "生成树形",httpMethod = "POST")
    public R treeQuery(){
        List dlsUserTreePOS=dlsUserService.treeList();
        return R.ok(dlsUserTreePOS,"查询成功");
    }
   

返回的结果:

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

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

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