两个list合并，并根据某个字段进行数据合并

两个list合并，并根据某个字段进行数据合并

方法一：sql返回对象为对象时

	//list 有 amount、zmr_user_id、zmr_user_name、nurse_sum
        List<StatisticsVo> list = zmrManicureRecordsMapper.rankingBeauticianPlus(params);
	//list1 有 amount_sum、zmr_user_id、zmr_user_name
        List<StatisticsVo> list1 = zmrManicureRecordsMapper.rankingBeauticianAmount(params);
        list.addAll(list1);
        //替换后的数据
        List<StatisticsVo> lists = new ArrayList<>(list.stream().collect(
                Collectors.toMap(StatisticsVo::getZmrUserId, a -> a, (o1, o2) -> {
                //判断userId是否相同，相同则将2的值赋给1
                    if (o1.getZmrUserId().equals(o2.getZmrUserId())) {
                        o1.setAmountSum(o2.getAmountSum());
                    }
                    return o1;
                })
        ).values());

方法一：sql返回为List<Map<String,Object>>

        Map<String,Object> one = new HashMap<>();
        one.put("id","001");
        one.put("name","曹操");
        one.put("sex","mail");
        Map<String,Object> one2 = new HashMap<>();
        one2.put("id","002");
        one2.put("name","孙权");
        one2.put("sex","mail");
        Map<String,Object> one3 = new HashMap<>();
        one3.put("id","003");
        one3.put("name","刘备");
        one3.put("sex","mail");
        List<Map<String,Object>> listA = new ArrayList<>();
        listA.add(one);
        listA.add(one2);
        listA.add(one3);

        Map<String,Object> two = new HashMap<>();
        two.put("id","001");
        two.put("age",30);
        Map<String,Object> two2 = new HashMap<>();
        two2.put("id","002");
        two2.put("age",31);
        Map<String,Object> two3 = new HashMap<>();
        two3.put("id","003");
        two3.put("age",32);
        List<Map<String,Object>> listB = new ArrayList<>();
        listB.add(two);
        listB.add(two2);
        listB.add(two3);

        // 合并
        listB.addAll(listA);
        //去重
        List<Map<String,Object>> result = listB.stream()
                .collect(Collectors.groupingBy(group -> group.get("id").toString()))//根据map中id的value值进行分组, 这一步的返回结果Map<String,List<Map<String, Object>>>
                .entrySet()//得到Set<Map.Entry<String, List<Map<String, Object>>>
                .stream()
                .map(map -> {
                    Map<String,Object> collect = map.getValue().stream()//m.getValue()的结果是 List<Map<String, Object>>
                            .flatMap(o -> o.entrySet().stream())//o.entrySet() 的结果是 Set<Map.Entry<String, Object>>
                            .collect(Collectors.toMap(Map.Entry::getKey,Map.Entry::getValue,(m1,m2) -> m2));//(m1, m2) -> m2 的意思是如果 m1 == m2 则使用m2
                    return collect;
                })
                .collect(Collectors.toList());
        System.out.println(result);