MyBatis-Plus QueryWrapper常用方法

背景

新公司用QueryWrapper 话说好久没用啦 就整理啦一下 ，大家可以收藏一下，现在每个公司的组件都不一样，还是很看个人能力的

 1 queryWrapper.lt();                            // 小于
 2 queryWrapper.le();                            // 小于等于
 3 queryWrapper.gt();                            // 大于
 4 queryWrapper.ge();                            // 大于等于
 5 queryWrapper.eq();                            // 等于    
 6 queryWrapper.ne();                            // 不等于
 7 queryWrapper.betweeen("age”,10,20);            // age在值10到20之间
 8 queryWrapper.notBetweeen("age”,10,20);        // age不在值10到20之间
 9 queryWrapper.like("属性","值");            // 模糊查询匹配值
10 queryWrapper.notLike("属性","值");            // 模糊查询不匹配值
11 queryWrapper.likeLeft("属性","值");        // 模糊查询匹配最后一位值
12 queryWrapper.likeRight("属性","值");        // 模糊查询匹配第一位值‘值%’
13 queryWrapper.isNull();                        // 值为空或null
14 queryWrapper.isNotNull();                    // 值不为空或null
15 queryWrapper.in("属性"，条件，条件);            // 符合多个条件的值
16 queryWrapper.notIn("属性"，条件，条件);            // 不符合多个条件的值
17 queryWrapper.or();                            // 或者
18 queryWrapper.and();                            // 和
19 queryWrapper.groupBy("实体类::查询字段");    //分组
20 queryWrapper.orderByAsc(“属性”);                // 根据属性升序排序
21 queryWrapper.orderByDesc(“属性”);                // 根据属性降序排序
22 queryWrapper.inSql(“sql语句”);                // 符合sql语句的值
23 queryWrapper.notSql(“sql语句”);                // 不符合SQL语句的值
24 queryWrapper.esists(“SQL语句”);                // 查询符合SQL语句的值
25 queryWrapper.notEsists(“SQL语句”);            // 查询不符合SQL语句的值
26 queryWrapper.select("字段1"，"字段2"，"字段3");    // 设置查询字段

例子

public Page<CarSurvey> pageList(Page<CarSurvey> page, CarSurveyRequest request) {
    LambdaQueryWrapper<CarSurvey> queryWrapper = new LambdaQueryWrapper<>();
    
    // 根据请求参数构造查询条件
    if (request.getId() != null) {
        queryWrapper.eq(CarSurvey::getId, request.getId());
    }
    if (request.getBrandId() != null) {
        queryWrapper.eq(CarSurvey::getBrandId, request.getBrandId());
    }
    if (request.getSeriesId() != null) {
        queryWrapper.eq(CarSurvey::getSeriesId, request.getSeriesId());
    }
    if (request.getSpecId() != null) {
        queryWrapper.eq(CarSurvey::getSpecId, request.getSpecId());
    }
    if (request.getCountryId() != null) {
        queryWrapper.eq(CarSurvey::getCountryId, request.getCountryId());
    }
    if (org.springframework.util.StringUtils.hasText(request.getMasterBrandName())) {
        queryWrapper.like(CarSurvey::getMasterBrandName, request.getMasterBrandName());
    }
    if (org.springframework.util.StringUtils.hasText(request.getBrandName())) {
        queryWrapper.like(CarSurvey::getBrandName, request.getBrandName());
    }
    if (org.springframework.util.StringUtils.hasText(request.getSeriesName())) {
        queryWrapper.like(CarSurvey::getSeriesName, request.getSeriesName());
    }
    if (org.springframework.util.StringUtils.hasText(request.getSpecName())) {
        queryWrapper.like(CarSurvey::getSpecName, request.getSpecName());
    }
    if (org.springframework.util.StringUtils.hasText(request.getCountryName())) {
        queryWrapper.like(CarSurvey::getCountryName, request.getCountryName());
    }
    if (org.springframework.util.StringUtils.hasText(request.getLanguages())) {
        queryWrapper.eq(CarSurvey::getLanguages, request.getLanguages());
    }
    if (org.springframework.util.StringUtils.hasText(request.getSurveyType())) {
        queryWrapper.eq(CarSurvey::getSurveyType, request.getSurveyType());
    }
    if (org.springframework.util.StringUtils.hasText(request.getSurveyTitle())) {
        queryWrapper.like(CarSurvey::getSurveyTitle, request.getSurveyTitle());
    }
    if (org.springframework.util.StringUtils.hasText(request.getSurveyContent())) {
        queryWrapper.like(CarSurvey::getSurveyContent, request.getSurveyContent());
    }
    if (org.springframework.util.StringUtils.hasText(request.getSurveyDate())) {
        queryWrapper.eq(CarSurvey::getSurveyDate, request.getSurveyDate());
    }
    if (org.springframework.util.StringUtils.hasText(request.getDataSource())) {
        queryWrapper.eq(CarSurvey::getDataSource, request.getDataSource());
    }

    queryWrapper.orderByDesc(CarSurvey::getCreateTime);
    
    return this.page(page, queryWrapper);
}