Java8 Stream和MyBatis Plus 常用Lambda表达式 -- 记录

对白丶

已于 2022-05-13 11:24:58 修改

阅读量3.8k

点赞数 2

分类专栏：再学Java 文章标签： java 开发语言

于 2021-05-24 19:09:24 首次发布

本文链接：https://blog.csdn.net/dzc18296226695/article/details/115552438

版权

再学Java 专栏收录该内容

19 篇文章 0 订阅

订阅专栏

文章目录

常用

常用

1、QueryWrapper 判空

官方文档

2、LambdaQueryWrapper 查询

LambdaQueryWrapper<TbTicketCodePO> queryWrapper = new QueryWrapper<TbTicketCodePO>()
                .lambda()
                .eq(TbTicketCodePO::getIsDelete, IFDeleteEnum.NO_DELETE.getCode())
                .select(TbTicketCodePO::getTicketCode,TbTicketCodePO::getCredType);

TbMarketTicketCode ticketCode = ticketCodeService.getOne(new LambdaQueryWrapper<TbMarketTicketCode>()
                .eq(TbMarketTicketCode::getTicketId, ticketId)
                .eq(TbMarketTicketCode::getTicketCode, code));
        Optional.ofNullable(ticketCode).orElseThrow(() -> new CeException("无此票券详情"));

3、UpdateWrapper 更新

// 同时更新 ticketCodeStatus 的状态
                ticketCodeService.update(new UpdateWrapper<TbMarketTicketCode>().lambda()
                        .set(TbMarketTicketCode::getStatus, TicketCodeStatusEnum.EXPIRED.getValue())
                        .eq(TbMarketTicketCode::getTicketCodeId, ticketCode.getTicketCodeId()));

4、Map的join构建

public Map<String, String> getHallNameMapByActIds(List<String> activityIds, Integer language) {
        List<TbActivityHall> activityHalls = activityHallService.getActHallByIds(activityIds, language);
        // 通过活动id 返回一个分组 拼接好的 展馆 string 串
        return activityHalls.stream()
                .distinct()
                .collect(
                        Collectors.groupingBy(TbActivityHall::getActivityId,
                                Collectors.mapping(TbActivityHall::getHallName,
                                        Collectors.joining("、")))
                );
    }

5、flatmap的应用

合并多条流，easyExcel导出

public void analysisExport(QuestionnaireAnalysisPageVO pageVO, HttpServletResponse response) throws IOException {
        pageVO.setPage(1L);
        pageVO.setLimit(500L);
        CePageResult<QuestionnaireAnalysisListDTO> qaResult = getQuestionnaireAnalysisList(pageVO);
        List<QuestionnaireAnalysisListDTO> resources = qaResult.getData().getList();

        List<List<QuestionnaireAnalysisListDTO.QuestAnalysisExport>> qeList = new ArrayList<>();
        for (QuestionnaireAnalysisListDTO r : resources) {
            List<TbQuestionStatistics> detailList = r.getStatList();
            List<QuestionnaireAnalysisListDTO.QuestAnalysisExport> questAnalysisExports = BeanCopierUtil.copyList(detailList, QuestionnaireAnalysisListDTO.QuestAnalysisExport.class);
            questAnalysisExports.forEach(
                    q -> {
                        q.setFinalTitle("【" + r.getShowQuestionType() + "】" + r.getTitle());
                    }
            );
            qeList.add(questAnalysisExports);
            log.info("questAnalysisExports,{}", questAnalysisExports);
        }
        log.info("qeList,{}", qeList);

        List<QuestionnaireAnalysisListDTO.QuestAnalysisExport> reportDetails = qeList.stream()
                .flatMap(Collection::stream)
                .collect(Collectors.toList());

        //需要合并的列
        int[] mergeColumnIndex = {0};
        // 从那一列开始合并
        int mergeRowIndex = 0;

        response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;charset=utf-8");
        String fileName = URLEncoder.encode("问卷数据收集分析表.xlsx", "UTF-8");
        response.setHeader("Content-Disposition", "attachment;filename=" + fileName);
        EasyExcel.write(response.getOutputStream(), QuestionnaireAnalysisListDTO.QuestAnalysisExport.class)
                .sheet("问卷数据收集分析")
                //设置合并单元格策略
                .registerWriteHandler(new ExcelFillCellMergeStrategy(mergeRowIndex, mergeColumnIndex))
                .doWrite(reportDetails);
    }

在这里插入图片描述

6、记录的一些构造器使用

来源：mp入门教程推荐，
案例

6.1、多条件包含

在这里插入图片描述

6.2、nested

注意：nested 其实就是不拼接and或者or的括号。用于优先级判定
在这里插入图片描述
select * from user where (age<40 or email is not null) and name like ‘王%’

6.3、排除指定列

在这里插入图片描述

6.4、返回构造出的Map，用于排除不需要的列

在这里插入图片描述

6.5、LambdaQueryChainWrapper链式调用

需要传入一个 mapper，然后在最后可以直接调用方法，一步到位。
在这里插入图片描述

7、stream 去重的妙用

https://blog.csdn.net/ianly123/article/details/82658622

// 根据name去重
List<Person> unique = persons.stream().collect(
            Collectors.collectingAndThen(
                    Collectors.toCollection(() -> new TreeSet<>(Comparator.comparing(Person::getName))), ArrayList::new)
);

8、归并映射

private AlarmDetailVO getAlarmDetailVO(PageParam<AssetPortrayDetail> detail, String assetIp) {
        // 根据设备ip查询告警漏洞的id集合，再复用一下远程调用接口
        Map<String, List<String>> operEventIdMap = new LambdaQueryChainWrapper<>(this.baseMapper)
                .select(AlarmVuln::getOper, AlarmVuln::getBsEventId)
                .eq(AlarmVuln::getDstIp, assetIp)
                .groupBy(Arrays.asList(AlarmVuln::getOper, AlarmVuln::getBsEventId))
                .list()
                .stream()
                .collect(Collectors.groupingBy(AlarmVuln::getOper, Collectors.mapping(AlarmVuln::getBsEventId, Collectors.toList())));

        Map<String, String> typeStrMap = new HashMap<>(16);
        operEventIdMap.keySet().forEach(oper -> {
            List<String> eventIds = operEventIdMap.get(oper);
            typeStrMap.put(oper, StringUtils.join(eventIds.toArray(), ","));
        });

        AlarmDetailVO vulnAlarmVo = new AlarmDetailVO();
        for (AlarmTypeAlarm value : AlarmTypeAlarm.values()) {
            getVulnAlarms(detail.getPageNum(), detail.getPageSize(), vulnAlarmVo, typeStrMap.get(value.getValue()), value.getValue());
        }
        return vulnAlarmVo;
    }