文章目录
常用
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、记录的一些构造器使用
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;
}