java用根据月份、类型汇总求和并修改

wshhcsdn

于 2024-11-21 17:45:58 发布

阅读量441

点赞数 3

文章标签： java 前端数据库

本文链接：https://blog.youkuaiyun.com/wshhcsdn/article/details/143951281

版权

public int sumByList(){
    List<EnergyNaturalGas> list = energyNaturalGasMapper.selectEnergyNaturalGasList2();
     Map<String, Map<String, BigDecimal>> groupByResult = list.stream()
            .collect(
                    Collectors.groupingBy(
                            EnergyNaturalGas::getTime,
                            Collectors.groupingBy(
                                    EnergyNaturalGas::getProvideType,
                                    Collectors.reducing(
                                            BigDecimal.ZERO,
                                            EnergyNaturalGas::getEnergyNumber,
                                            BigDecimal::add
                                    )
                            )
                    )
            );

    groupByResult.forEach((time, provideTypeMap) -> {
            provideTypeMap.forEach((provideType, sumTotal) -> {
                EnergyNaturalGas provider = new EnergyNaturalGas();
                provider.setTime(time);
                provider.setProvideType(provideType);
                provider.setMonthlySummary(sumTotal);
                energyNaturalGasMapper.updateEnergyNaturalGasByParm(provider);
            });
        });
    return 1;
}