QueryWrapper用法小记

QueryWrapper in

QueryWrapper<EventTagProcess> qw = new QueryWrapper<>();
qw.in("status", 0,1,3,4);

QueryWrapper or

QueryWrapper<EventTagProcess> qw = new QueryWrapper<>();
queryWrapper.or();
qw.and(Wrapper -> Wrapper.eq(PcmArticle::getAuState, "1").or().eq(PcmArticle::getAuState, "2"));

QueryWrapper eq

QueryWrapper<EventTagProcess> qw = new QueryWrapper<>();
qw.eq(SpSdmAllRules::getType, type)

QueryWrapper asc

QueryWrapper<EventTagProcess> qw = new QueryWrapper<>();
qw.select().orderByAsc(sort);

QueryWrapper desc

QueryWrapper<EventTagProcess> qw = new QueryWrapper<>();
qw.select().orderByDesc(sort);

QueryWrapper like

qw.lambda().like(SpSdmDisBle::getName, name);

QueryWrapper ge(大于等于)、 gt(大于)、 le(小于等于)、 lt(小于)

new LambdaQueryWrapper<UmpRedisEpEvent>().gt(UmpRedisEpEvent::getId, FlagNum)

QueryWrapper isNull、 isNotNull

new LambdaQueryWrapper<UmpRedisEpEvent>().isNotNull(UmpRedisEpEvent::getFlag)

QueryWrapper in+group

new QueryWrapper<SpSdmDbinfoTables>().in("id",tid.split(",")).groupBy("db_info_id")