mybatisplus group by 归组

最新推荐文章于 2024-04-16 21:04:27 发布

阿舒带你学编程

最新推荐文章于 2024-04-16 21:04:27 发布

阅读量1.2k

点赞数

分类专栏：前端 html 文章标签： java 开发语言

本文链接：https://blog.csdn.net/m0_55613022/article/details/123424383

版权

前端同时被 2 个专栏收录

52 篇文章 6 订阅

订阅专栏

html

52 篇文章 0 订阅

订阅专栏

 QueryWrapper<MetaItem> wrapper = new QueryWrapper<MetaItem>()
                .select("set_id,count(0) as field_count")
                .in("set_id",setids)
                .groupBy("set_id");

        List<Map<String,Object>> list = itemService.listMaps(wrapper);

注意要用 listMaps ，返回的是 Map<String,Object>

示例：

public Result<?> queryPageList(MetaSet metaSet,
								   @RequestParam(name="pageNo", defaultValue="1") Integer pageNo,
								   @RequestParam(name="pageSize", defaultValue="10") Integer pageSize,
								   HttpServletRequest req) {
		QueryWrapper<MetaSet> queryWrapper = QueryGenerator.initQueryWrapper(metaSet, req.getParameterMap());
		Page<MetaSet> page = new Page<MetaSet>(pageNo, pageSize);
		IPage<MetaSet> pageList = metaSetService.page(page, queryWrapper);

        List<MetaSet> records = pageList.getRecords();
        List<String> setids = records.stream().map(f -> f.getId()).collect(Collectors.toList());

        QueryWrapper<MetaItem> wrapper = new QueryWrapper<MetaItem>()
                .select("set_id,count(0) as field_count")
                .in("set_id",setids)
                .groupBy("set_id");

        List<Map<String,Object>> list = itemService.listMaps(wrapper);

        records.forEach(f->{
            Map<String, Object> set_id = list.stream().filter(l -> l.get("set_id").toString().equals(f.getId())).findFirst().orElse(null);
            if(set_id!=null){
                f.setFieldCount(Integer.valueOf(set_id.get("field_count").toString()));
            }
        });
        pageList.setRecords(records);

        return Result.OK(pageList);
	}