testDeleteMapper.selectList(new LambdaQueryWrapper<TestDeletePO>()
.eq(TestDeletePO::getId, id)
.like(TestDeletePO::getName, name));or()查询
select * from dual where a=1 and (b=2 or b=3)
new LambdaQueryWrapper<InsPipeSegmentPO>()
.eq(InsPipeSegmentPO::getInsPlanId, patrolDateResVO.getPlanId())
.and(o -> o.eq(InsPipeSegmentPO::getPipeStatus, PlanStatusEnum.IN_EXECUTION.getCode())
.or().eq(InsPipeSegmentPO::getPipeStatus, PlanStatusEnum.NOT_BEGIN.getCode()));select * from dual where (a=1 or (a=2 and b=2))
new LambdaQueryWrapper<InsPipeSegmentPO>()
.and(o -> o.eq(EvaluationPO::getOverwritten, YesOrNoEnum.NO)
.or(m -> m.eq(EvaluationPO::getOverwritten, YesOrNoEnum.YES)
.eq(EvaluationPO::getActualType, EvaluationTypeEnum.ADD)))select
LambdaQueryWrapper<User> wrapper = new LambdaQueryWrapper<>();
wrapper.eq(User::getAge, 20)
.select(User::getId, User::getUserName, User::getAge);