Lambda表达实现类似SQL的group

Lambda表达数据group

SELECT wm_concat(cpbh) AS cpbhStr,sum(jsje) FROM jsclfymx GROUP BY jsdh;

1.主表jsclfymx ，有cpbh（VARCHAR）、jsje（NUMBER），jsdh（VARCHAR）主键不重复；
2.按jsdh合并，获得cpbh拼接、jsje汇总的结果；

注：jsdh（VARCHAR）主键不重复，重复或为空则lambda表达式会报key异常；

//创建4个对象
JsClfyMxVO vo1 = new JsClfyMxVO();
vo1.setJsdh("1");
vo1.setCpbh("0100");
vo1.setJsje(new BigDecimal(100.00));

JsClfyMxVO vo2 = new JsClfyMxVO();
vo2.setJsdh("2");
vo2.setCpbh("0200");
vo2.setJsje(new BigDecimal(200.00));

JsClfyMxVO vo3 = new JsClfyMxVO();
vo3.setJsdh("2");
vo3.setCpbh("0200");
vo3.setJsje(new BigDecimal(200.00))

JsClfyMxVO vo4 = new JsClfyMxVO();
vo4.setJsdh("1");
vo4.setCpbh("0200");
vo4.setJsje(new BigDecimal(150.00));
//放入list
List<JsClfyMxVO> a = Arrays.asList(vo1,vo2,vo3,vo4);

//按KEY（jsdh）分组
Map<String, List<JsClfyMxVO>> aMap a.stream().collect(Collectors.groupingBy(JsClfyMxVO::getJsdh));
List<JsClfyMxVO> r = aMap.values().stream().map((List<JsClfyMxVO> vo) -> {
            JsClfyMxVO as = new JsClfyMxVO();
            as.setCpbh(vo.stream().map(i -> i.getCpbh()).distinct().collect(Collectors.joining(",")));
            as.setJsje(vo.stream().map(i -> i.getJsje()).reduce(BigDecimal.ZERO,BigDecimal::add));
            return as;
}).collect(Collectors.toList());       

返回结果

[
 {
   "jsje": "250",
   "cpbh": "0100,0200"
 },
 {
   "jsje": "400",
   "cpbh": "0200"
 }
]