MyBatis-Plus一个下拉框参数支持多种条件查询

「爱情、让人受尽委屈。」 2023-10-01 22:14 11阅读 0赞

## MyBatis-Plus一个下拉框参数支持多种条件查询 ##

#### 1.MyBatis-Plus中实现方式 ####

Page<AlgorithmFactory> algorithmFactoryPage = new Page<>();
           algorithmFactoryPage.setCurrent(algorithmListDTO.getPageIndex()).setSize(algorithmListDTO.getPageSize());
            LambdaQueryWrapper<AlgorithmFactory> queryWrapper = Wrappers.<AlgorithmFactory>lambdaQuery();
            queryWrapper.eq(AlgorithmFactory::getIsDeleted, DeleteEnum.NO_DELETE.getCode());
            if (StringUtils.isNotBlank(algorithmListDTO.getAlgorithmNameAndProviderName())) {
        
                queryWrapper.and(wrapper -> wrapper.like(AlgorithmFactory::getAlgorithmName, algorithmListDTO.getAlgorithmNameAndProviderName())
                        .or()
                        .like(AlgorithmFactory::getProviderName, algorithmListDTO.getAlgorithmNameAndProviderName()));
            }
            queryWrapper.orderByDesc(AlgorithmFactory::getUpdateTime);
            Page<AlgorithmFactory> page = this.page(algorithmFactoryPage, queryWrapper);

![image-20220624153728994][]

#### 实际完成的SQL ####

SELECT id,algorithm_name,algorithm_desc,provider_name,interface_address,version,status,detection_type,is_deleted,create_time,update_time,is_test_status,ai_code,config_status FROM algorithm_factory WHERE (is_deleted = 0 AND (algorithm_name LIKE '%玩手机%' OR provider_name LIKE '%玩手机%')) ORDER BY update_time DESC LIMIT 0,10

#### 2.Mybatis中可以用concat标签 ####

<select id="selectAll" resultType="com.test.pojo.user">
            SELECT *
            FROM user
      		<where>
              <if test="key!='' and key!=null">
                  and CONCAT(username,nickname) like CONCAT ('%', #{key}, '%')          </if> 
            </where>
    </select>

[image-20220624153728994]: https://img-blog.csdnimg.cn/img_convert/7fdc4eedcf4aad3560cc1dab84df6bba.png