当前位置:网站首页>如何将List<Map>进行分组数值计算合并排序
如何将List<Map>进行分组数值计算合并排序
2022-08-09 14:51:00 【学弟不想努力了】
import java.util.*;
import java.util.stream.Collectors;
public class Test {
public static void main(String[] args) {
//list模拟数据
Map map1 = new HashMap();
map1.put("shopId",1);
map1.put("salesmanId",2);
map1.put("money", 20);
Map map2 = new HashMap();
map2.put("shopId",2);
map2.put("salesmanId",2);
map2.put("money", 100);
Map map5 = new HashMap();
map5.put("shopId",2);
map5.put("salesmanId",2);
map5.put("money", 50);
List<Map> list1 = new ArrayList<>();
list1.add(map1);
list1.add(map2);
list1.add(map5);
// System.out.println(list1);
// [{salesmanId=2, money=20, shopId=1}, {salesmanId=2, money=100, shopId=2}, {salesmanId=2, money=50, shopId=2}]
//list<Map>分组,按超市分组
Map<String, List<Map>> mapGroup = list1.stream().collect(Collectors.groupingBy(o -> o.get("shopId") + ""));
// System.out.println(mapGroup);
// {1=[{salesmanId=2, money=20, shopId=1}], 2=[{salesmanId=2, money=100, shopId=2}, {salesmanId=2, money=50, shopId=2}]}
List<Map> listReturn = new ArrayList<>();
for (String str : mapGroup.keySet()) {
List<Map> task1 = mapGroup.get(str);
int money = 0;
for (Map mm: task1) {
money = money + Integer.valueOf(String.valueOf(mm.get("money")));
}
Map<String, Object> mapReturn = new HashMap();
mapReturn.put("shopId", task1.get(0).get("shopId"));
mapReturn.put("salesmanId", task1.get(0).get("salesmanId"));
mapReturn.put("money", money);
listReturn.add(mapReturn);
}
// System.out.println(listReturn);
// [{salesmanId=2, money=20, shopId=1}, {salesmanId=2, money=150, shopId=2}]
//根据money 倒叙排序
Collections.sort(listReturn, (o2, o1) -> {
Integer shop1 = Integer.valueOf(o1.get("shopId").toString());
Integer shop2 = Integer.valueOf(o2.get("shopId").toString());
return shop1.compareTo(shop2);
});
// System.out.println(listReturn);
// [{salesmanId=2, money=150, shopId=2}, {salesmanId=2, money=20, shopId=1}]
}
}
边栏推荐
猜你喜欢
随机推荐
技术分享 | 接口自动化测试如何处理 Header cookie
Mysql两个引擎对比
VMWare does not use easy install, install ISO manual manually
易基因|作物育种:DNA甲基化在大豆优良品种培育中的作用研究成果
【LeetCode】15. 三数之和
【LeetCode】1898. 可移除字符的最大数目
道路标识信息 (RSI)
第五讲 测试技术与用例设计
6大论坛,30+技术干货议题,2022首届阿里巴巴开源开放周来了!
.NET现代应用的产品设计 - DDD实践
经典面试题 之 JVM调优
Swift中的Error处理
二维数组实现八皇后问题
Hudi Spark-Shell 实战
【LeetCode】1413. 逐步求和得到正数的最小值
基于FPGA的FIR滤波器的实现(3)—采用Filter Design & Analysis设计
Mysql two engines comparison
[DevOps] jekins configuration (2)
C语言程序设计笔记(浙大翁恺版) 第十周:字符串
My MySQL database was attacked and deleted for ransom, forcing me to use all my might to recover data









