数据分组（使用stream流）

最新推荐文章于 2024-06-21 17:40:28 发布
最新推荐文章于 2024-06-21 17:40:28 发布
阅读量471 收藏 8
点赞数 10
分类专栏： java 文章标签： java 数据库 前端
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_45326523/article/details/136348381
版权

一、原数据查询格式

{
	"total": 27,
	"rows": [
		{
			"createBy": "Task",
			"createName": "Task",
			"createTime": "2024-02-28T08:55:38",
			"updateBy": "Task",
			"updateName": "Task",
			"updateTime": "2024-02-28T08:55:38",
			"id": 425,
			"pernr": "139000",
			"pnalt": "139000",
			"name": "陈sir",
			"gender": "男",
			"orgeh": "开发部",
			"rmark": "星期四",
			"bclb": "白班",
			"banciT": "江苏0830-1730",
			"pdate": "08:30-17:30",
			"ptime": "12:30-13:30",
			"btime": "07:56",
			"etime": "21:32",
			"znote": null,
			"zdkxq": "07:56,08:14,20:02,21:32",
			"zthsb": null,
			"fadate": "20240201",
			"wdate": "2024-02-04 04:31:55",
			"delFlag": "0"
		},
		{
			"createBy": "Task",
			"createName": "Task",
			"createTime": "2024-02-28T08:55:38",
			"updateBy": "Task",
			"updateName": "Task",
			"updateTime": "2024-02-28T08:55:38",
			"id": 1605,
			"pernr": "139000",
			"pnalt": "139000",
			"name": "陈sir",
			"gender": "男",
			"orgeh": "开发部",
			"rmark": "星期五",
			"bclb": "白班",
			"banciT": "江苏0830-1730",
			"pdate": "08:30-17:30",
			"ptime": "12:30-13:30",
			"btime": "08:15",
			"etime": "17:55",
			"znote": null,
			"zdkxq": "08:15,17:55",
			"zthsb": null,
			"fadate": "20240202",
			"wdate": "2024-02-05 04:31:52",
			"delFlag": "0"
		},
		{
			"createBy": "Task",
			"createName": "Task",
			"createTime": "2024-02-28T08:55:38",
			"updateBy": "Task",
			"updateName": "Task",
			"updateTime": "2024-02-28T08:55:38",
			"id": 2802,
			"pernr": "139000",
			"pnalt": "139000",
			"name": "陈sir",
			"gender": "男",
			"orgeh": "开发部",
			"rmark": "星期六",
			"bclb": "白班",
			"banciT": "江苏0830-1730",
			"pdate": "08:30-17:30",
			"ptime": "12:30-13:30",
			"btime": "07:51",
			"etime": "17:32",
			"znote": null,
			"zdkxq": "07:51,17:32",
			"zthsb": null,
			"fadate": "20240203",
			"wdate": "2024-02-06 04:31:42",
			"delFlag": "0"
		},
		{
			"createBy": "Task",
			"createName": "Task",
			"createTime": "2024-02-28T08:55:38",
			"updateBy": "Task",
			"updateName": "Task",
			"updateTime": "2024-02-28T08:55:38",
			"id": 3274,
			"pernr": "139000",
			"pnalt": "139000",
			"name": "陈sir",
			"gender": "男",
			"orgeh": "开发部",
			"rmark": "星期日",
			"bclb": "休息",
			"banciT": "江苏0830-1730假",
			"pdate": null,
			"ptime": "00:00-08:30,12:30-13:30,17:30-18:00",
			"btime": null,
			"etime": null,
			"znote": null,
			"zdkxq": null,
			"zthsb": null,
			"fadate": "20240204",
			"wdate": "2024-02-07 04:31:37",
			"delFlag": "0"
		},
		{
			"createBy": "Task",
			"createName": "Task",
			"createTime": "2024-02-28T08:55:38",
			"updateBy": "Task",
			"updateName": "Task",
			"updateTime": "2024-02-28T08:55:38",
			"id": 4156,
			"pernr": "139000",
			"pnalt": "139000",
			"name": "陈sir",
			"gender": "男",
			"orgeh": "开发部",
			"rmark": "星期一",
			"bclb": "白班",
			"banciT": "江苏0830-1730",
			"pdate": "08:30-17:30",
			"ptime": "12:30-13:30",
			"btime": "08:11",
			"etime": "18:58",
			"znote": null,
			"zdkxq": "08:11,18:58",
			"zthsb": null,
			"fadate": "20240205",
			"wdate": "2024-02-08 04:31:51",
			"delFlag": "0"
		},
		{
			"createBy": "Task",
			"createName": "Task",
			"createTime": "2024-02-28T08:55:38",
			"updateBy": "Task",
			"updateName": "Task",
			"updateTime": "2024-02-28T08:55:38",
			"id": 5219,
			"pernr": "139000",
			"pnalt": "139000",
			"name": "陈sir",
			"gender": "男",
			"orgeh": "开发部",
			"rmark": "星期二",
			"bclb": "白班",
			"banciT": "江苏0830-1730",
			"pdate": "08:30-17:30",
			"ptime": "12:30-13:30",
			"btime": "08:04",
			"etime": "17:31",
			"znote": null,
			"zdkxq": "08:04,08:24",
			"zthsb": "是",
			"fadate": "20240206",
			"wdate": "2024-02-09 04:31:53",
			"delFlag": "0"
		},
		{
			"createBy": "Task",
			"createName": "Task",
			"createTime": "2024-02-28T08:55:38",
			"updateBy": "Task",
			"updateName": "Task",
			"updateTime": "2024-02-28T08:55:38",
			"id": 6393,
			"pernr": "139000",
			"pnalt": "139000",
			"name": "陈sir",
			"gender": "男",
			"orgeh": "开发部",
			"rmark": "星期三",
			"bclb": "休息",
			"banciT": "江苏0830-1730假",
			"pdate": null,
			"ptime": "00:00-08:30,12:30-13:30,17:30-18:00",
			"btime": null,
			"etime": null,
			"znote": null,
			"zdkxq": null,
			"zthsb": null,
			"fadate": "20240207",
			"wdate": "2024-02-10 04:31:40",
			"delFlag": "0"
		},
		{
			"createBy": "Task",
			"createName": "Task",
			"createTime": "2024-02-28T08:55:38",
			"updateBy": "Task",
			"updateName": "Task",
			"updateTime": "2024-02-28T08:55:38",
			"id": 6789,
			"pernr": "139000",
			"pnalt": "139000",
			"name": "陈sir",
			"gender": "男",
			"orgeh": "开发部",
			"rmark": "星期四",
			"bclb": "休息",
			"banciT": "江苏0830-1730假",
			"pdate": null,
			"ptime": "00:00-08:30,12:30-13:30,17:30-18:00",
			"btime": null,
			"etime": null,
			"znote": null,
			"zdkxq": null,
			"zthsb": null,
			"fadate": "20240208",
			"wdate": "2024-02-11 04:31:33",
			"delFlag": "0"
		},
		{
			"createBy": "Task",
			"createName": "Task",
			"createTime": "2024-02-28T08:55:39",
			"updateBy": "Task",
			"updateName": "Task",
			"updateTime": "2024-02-28T08:55:39",
			"id": 7685,
			"pernr": "139000",
			"pnalt": "139000",
			"name": "陈sir",
			"gender": "男",
			"orgeh": "开发部",
			"rmark": "星期五",
			"bclb": "休息",
			"banciT": "江苏0830-1730假",
			"pdate": null,
			"ptime": "00:00-08:30,12:30-13:30,17:30-18:00",
			"btime": null,
			"etime": null,
			"znote": null,
			"zdkxq": null,
			"zthsb": null,
			"fadate": "20240209",
			"wdate": "2024-02-12 04:31:55",
			"delFlag": "0"
		},
		{
			"createBy": "Task",
			"createName": "Task",
			"createTime": "2024-02-28T08:55:39",
			"updateBy": "Task",
			"updateName": "Task",
			"updateTime": "2024-02-28T08:55:39",
			"id": 8407,
			"pernr": "139000",
			"pnalt": "139000",
			"name": "陈sir",
			"gender": "男",
			"orgeh": "开发部",
			"rmark": "星期六",
			"bclb": "休息",
			"banciT": "江苏0830-1730假",
			"pdate": null,
			"ptime": "00:00-08:30,12:30-13:30,17:30-18:00",
			"btime": null,
			"etime": null,
			"znote": null,
			"zdkxq": null,
			"zthsb": null,
			"fadate": "20240210",
			"wdate": "2024-02-13 04:31:34",
			"delFlag": "0"
		}
	],
	"code": 200,
	"msg": "查询成功"
}

原数据格式为每条显示，但数据中有很多重复的信息 需要分组显示如下列格式：

{
	"total": 1,
	"rows": [
		{
			"pnalt": "139000",
			"name": "陈sir",
			"gender": "男",
			"orgeh": "开发部",
			"rmark": null,
			"bclb": null,
			"btime": null,
			"etime": null,
			"fadate": null,
			"info": [
				{
					"20240201": {
						"btime": "07:56",
						"rmark": "星期四",
						"etime": "21:32",
						"bclb": "白班"
					}
				},
				{
					"20240202": {
						"btime": "08:15",
						"rmark": "星期五",
						"etime": "17:55",
						"bclb": "白班"
					}
				},
				{
					"20240203": {
						"btime": "07:51",
						"rmark": "星期六",
						"etime": "17:32",
						"bclb": "白班"
					}
				},
				{
					"20240204": {
						"btime": "null",
						"rmark": "星期日",
						"etime": "null",
						"bclb": "休息"
					}
				},
				{
					"20240205": {
						"btime": "08:11",
						"rmark": "星期一",
						"etime": "18:58",
						"bclb": "白班"
					}
				},
				{
					"20240206": {
						"btime": "08:04",
						"rmark": "星期二",
						"etime": "17:31",
						"bclb": "白班"
					}
				},
				{
					"20240207": {
						"btime": "null",
						"rmark": "星期三",
						"etime": "null",
						"bclb": "休息"
					}
				},
				{
					"20240208": {
						"btime": "null",
						"rmark": "星期四",
						"etime": "null",
						"bclb": "休息"
					}
				},
				{
					"20240209": {
						"btime": "null",
						"rmark": "星期五",
						"etime": "null",
						"bclb": "休息"
					}
				},
				{
					"20240210": {
						"btime": "null",
						"rmark": "星期六",
						"etime": "null",
						"bclb": "休息"
					}
				},
				{
					"20240211": {
						"btime": "null",
						"rmark": "星期日",
						"etime": "null",
						"bclb": "休息"
					}
				},
				{
					"20240212": {
						"btime": "null",
						"rmark": "星期一",
						"etime": "null",
						"bclb": "休息"
					}
				},
				{
					"20240213": {
						"btime": "null",
						"rmark": "星期二",
						"etime": "null",
						"bclb": "休息"
					}
				},
				{
					"20240214": {
						"btime": "null",
						"rmark": "星期三",
						"etime": "null",
						"bclb": "休息"
					}
				},
				{
					"20240215": {
						"btime": "null",
						"rmark": "星期四",
						"etime": "null",
						"bclb": "休息"
					}
				},
				{
					"20240216": {
						"btime": "null",
						"rmark": "星期五",
						"etime": "null",
						"bclb": "休息"
					}
				},
				{
					"20240217": {
						"btime": "null",
						"rmark": "星期六",
						"etime": "null",
						"bclb": "休息"
					}
				},
				{
					"20240218": {
						"btime": "null",
						"rmark": "星期日",
						"etime": "null",
						"bclb": "白班"
					}
				},
				{
					"20240219": {
						"btime": "null",
						"rmark": "星期一",
						"etime": "null",
						"bclb": "白班"
					}
				},
				{
					"20240220": {
						"btime": "08:29",
						"rmark": "星期二",
						"etime": "20:00",
						"bclb": "白班"
					}
				},
				{
					"20240221": {
						"btime": "08:25",
						"rmark": "星期三",
						"etime": "20:08",
						"bclb": "白班"
					}
				},
				{
					"20240222": {
						"btime": "08:12",
						"rmark": "星期四",
						"etime": "20:27",
						"bclb": "白班"
					}
				},
				{
					"20240223": {
						"btime": "08:13",
						"rmark": "星期五",
						"etime": "20:13",
						"bclb": "白班"
					}
				},
				{
					"20240224": {
						"btime": "08:19",
						"rmark": "星期六",
						"etime": "18:05",
						"bclb": "休息"
					}
				},
				{
					"20240225": {
						"btime": "null",
						"rmark": "星期日",
						"etime": "null",
						"bclb": "休息"
					}
				},
				{
					"20240226": {
						"btime": "08:11",
						"rmark": "星期一",
						"etime": "20:06",
						"bclb": "白班"
					}
				},
				{
					"20240227": {
						"btime": "08:00",
						"rmark": "星期二",
						"etime": "20:05",
						"bclb": "白班"
					}
				}
			]
		}
	],
	"code": 200,
	"msg": "查询成功"
}

二、实体类

@Data
@AllArgsConstructor
@NoArgsConstructor
public class AttendanceStructureVo {

    
    private String pnalt;

   
    private String name;

    private String gender;

    private String orgeh;

    private String rmark;

    private String bclb;

    private String btime;
  
    private String etime;

    private String fadate;

    private List<Map<String, Map<String, String>>> info;

    public AttendanceStructureVo(String pnalt, String name, String gender, String orgeh, List<Map<String, Map<String, String>>> info) {
        this.pnalt = pnalt;
        this.name = name;
        this.gender = gender;
        this.orgeh = orgeh;
        this.info = info;
    }

}

三、代码展示

 @Override
    public TableDataInfo<AttendanceStructureVo> selectAttendanceGrouping(AttendanceBo bo, PageQuery pageQuery) {
        List<AttendanceStructureVo> entityList = bAttendanceMapper.selectAttendanceGrouping(bo);
        List<AttendanceStructureVo> result = new ArrayList<>();
        if (entityList.size() > 0) {
            result = entityList.stream()
                    .collect(Collectors.groupingBy(AttendanceStructureVo::getPnalt)) // 先按工号分组
                    .entrySet().stream()
                    .map(entry -> {
                        String pnalt = entry.getKey();
                        List<Map<String, Map<String, String>>> info = entry.getValue().stream()
                                .collect(Collectors.groupingBy(AttendanceStructureVo::getFadate, LinkedHashMap::new, Collectors.toCollection(LinkedHashSet::new)))
                                .entrySet().stream()
                                .map(dateEntry -> {
                                    Map<String, String> mapValue = new HashMap<>();
                                    mapValue.put("bclb", dateEntry.getValue().stream().map(AttendanceStructureVo::getBclb).collect(Collectors.joining(",")));
                                    mapValue.put("rmark", dateEntry.getValue().stream().map(AttendanceStructureVo::getRmark).collect(Collectors.joining(",")));
                                    mapValue.put("btime", dateEntry.getValue().stream().map(AttendanceStructureVo::getBtime).collect(Collectors.joining(",")));
                                    mapValue.put("etime", dateEntry.getValue().stream().map(AttendanceStructureVo::getEtime).collect(Collectors.joining(",")));

                                    Map<String, Map<String, String>> dateInfo = new TreeMap<>();
                                    dateInfo.put(dateEntry.getKey(), mapValue);
                                    return dateInfo;
                                })
                                .collect(Collectors.toList());

                        return new AttendanceStructureVo(pnalt, entry.getValue().get(0).getName(), entry.getValue().get(0).getGender(), entry.getValue().get(0).getOrgeh(), info);
                    })
                    .collect(Collectors.toList());
        }

        Page<AttendanceStructureVo> page = new Page<>();
        if (pageQuery.getPageNum() != null && pageQuery.getPageSize() != null) {
            page.setCurrent(pageQuery.getPageNum());
            page.setSize(pageQuery.getPageSize());

            // 手动分页，获取当前页的数据列表
            int startIndex = (int) ((page.getCurrent() - 1) * page.getSize());
            int endIndex = (int) Math.min(startIndex + page.getSize(), result.size());
            List<AttendanceStructureVo> currentList = result.subList(startIndex, endIndex);

            // 设置总记录数和当前页数据列表
            page.setTotal(result.size());
            page.setRecords(currentList);
        } else {
            page.setRecords(result);
            page.setTotal(result.size());
        }
        return TableDataInfo.build(page);
    }

骑着蜗牛打天下
关注
  • 10
    点赞
  • 踩
  • 8
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
Stream流对数据进行分组
m0_57125666的博客
08-25 2887
public static void main(String[] args) { /** * 先对名字进行分组，然后按照年龄进行分组 */ Map<String, Map<Object, List<Person>>> map = Stream.of( new Person("张三", 18, 175), new Person("李四", 22
Java Stream 流的使用过程解析
08-25
Stream 流提供了丰富的数据处理功能，可以对数据进行筛选、映射、聚合、分组等操作。下面我们将详细介绍 Java Stream 流的使用过程解析。 筛选和切片 Java Stream 流提供了多种筛选和切片方法，包括 filter、...
stream流——分组
weixin_48293596的博客
01-03 1万+
stream流——分组
Stream流分组
啥也没有
03-24 3万+
java Stream流分组案例
Java8使用Stream流实现List列表查询、统计、排序、分组、合并
最新发布
12程序猿的博客
06-21 2416
Java8使用Stream流实现List列表查询、统计、排序、分组、合并
Stream流之groupingBy分组详解 (java1.8 新特性)
weixin_46887062的博客
09-13 7456
(使用java8 stream groupingBy操作, 基于city 和name 实现多次分组)/*** 自定义重复key 规则* @return*/super T,?;});希望对大家有帮助 下期再见呦~Java8 Stream 之groupingBy 分组讲解_在奋斗的大道的博客-CSDN博客。
Java stream 多情况分组、统计、取最值
醉逸鎏年的博客
05-29 1万+
Java stream 多情况分组、统计、取最值
Stream流-分组操作
热门推荐
你的博客
07-11 4万+
Stream流-分组操作 文章目录Stream流-分组操作方法1，`groupingBy(Function)`方法2，`groupingBy(Function,Collector)`方法3：`groupingBy(Function,Supplier,Collector)` Collectors.groupingBy()3个方法的使用示例 /**员工 * @author Yang * @create 2020-07-09 19:57 */ public class Employee {
Java Stream 流实现合并操作示例
08-19
在实际开发中，我们经常需要将多个 Stream 流合并成一个流，以便进行后续的数据处理。今天，我们将详细介绍 Java Stream 流实现合并操作的原理、方法和注意事项。 Stream 流的合并 Stream 流的合并是指将两个或多...
Java-IO流/Stream流总结
07-12
下面将详细阐述这两个流的分类、转换、异常处理以及Stream流的使用。 1. **IO流分类** - **字节流**：字节流处理的是原始的字节数据，包括`InputStream`和`OutputStream`两大类。`FileInputStream`和`...
stream流操作demo
01-14
在`StreamTest.java`中，可能会包含各种Stream API的使用示例，如过滤特定条件的元素、转换数据类型、分组、排序等。`Person.java`可能定义了一个表示人的类，包含姓名、年龄等属性，然后在`StreamTest.java`中对`...
java1.8 中 stream 的 groupingBy 最大值、最小值分组
05-20
主要是介绍在 JDK8中使用 stream 流的 groupingBy 方法源进行最大值分组、最小值分组、平均值分组、统计分组
Java Stream流对集合进行分组操作
kkwyting的博客
09-30 1221
Java Stream流对集合进行分组操作
Java8 stream流之分组 groupingBy 的使用
suge大帝的博客
06-10 4万+
使用stream流可以让我们的代码看上去很简洁，本文举例了 按照班级分组、分组再过滤、统计分组后人数、嵌套分组、分组排序...
java8中stream流集合的筛选，规约，分组，聚合
极客鼠之家
06-14 4411
简要介绍一下streamStream 将要处理的元素集合看作一种流，在流过程中，借助stream api对流中的元素进行操作，比如筛选，排序，聚合等。
Java8 stream流操作: 去重,排序,筛选,分组,聚合计算
翊墨的博客
04-13 2399
Java8流操作: 去重,排序,筛选,分组,聚合计算流是从支持数据处理操作的源生成的元素序列，源可以是数组、文件、集合、函数。流不是集合元素，它不是数据结构并不保存数据，它的主要目的在于计算。
Java-Stream流规约、分组、分区
byteRun的博客
02-24 1901
问题引入 如果你在做一些汇总操作，比如 1、对一个交易列表按货币分组，获取每种货币的和（Map<Cruuency,Integer>） 2、将交易分成贵的、不贵的（Map<Boolean,List<Transaction>>） 3、多级分组，按城市分组，再按贵和不贵分组 如果是传统的写法，使用外部迭代即可，会有很多for+if组合，类似： private static void groupImperatively() { Map<Cu.
Java Stream流 Map 分组方式汇总
m0_74246367的博客
03-21 7705
Java Stream流 Map 分组方式汇总
stream流 分组
08-25
stream流的分组可以通过不同的方法实现下面是一些常见的方式： 1. 固定大小分组：将流数据按照固定的进行分组。例如，每个分组含固定数量的元素或字节。种方法简单直观，但可能会导致最后一个分组不满一组。 2. 定界符分组：使用特定的定界符将流数据分成不同的分组。可以在数据流中插入特殊标记作为分组边界，当遇到该标记时，就将数据分为一个新的分组。这种方法可以灵活地处理不同大小和类型的数据。 3. 时间窗口分组：按照时间间隔将流数据分组。例如，每秒钟或每分钟生成一个新的分组。这种方法主要适用于实时流处理场景，可以根据时间戳来确定数据属于哪个时间窗口。 4. 条件分组：根据特定的条件将流数据进行分组。例如，根据某个字段的值或某种规则来决定数据属于哪个分组。可以使用过滤器或规则引擎来定义条件，并根据条件将数据分类到相应的分组。 这些是常见的流分组方法，具体选择哪种方法取决于应用场景和需求。在实际应用中，可能需要结合多种方法来实现更复杂的分组逻辑。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值