首先创建一个数据库表,如下图所示:
然后创建一个Spring Boot项目,pom.xml和配置如下:
<?xml version="1.0" encoding="UTF-8"?><project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://.kaven.mybatisplus.entity.User;import org.junit.Test;import org.junit.runner.RunWith;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.boot.test.context.SpringBootTest;import org.springframework.test.context.junit4.SpringRunner;import org.springframework.util.CollectionUtils;import org.springframework.util.StringUtils;import java.util.Arrays;import java.util.List;@RunWith(SpringRunner.class)@SpringBootTestpublic class UserMapperConditionTest { @Autowired private UserMapper userMapper; @Test public void selectList(){ String username = "k"; List<Integer> ageList = Arrays.asList(22 , 40 , 30); List<User> userList = userMapper.selectList(condition(username , ageList)); userList.forEach(System.out::println); } public QueryWrapper<User> condition(String username , List<Integer> ageList){ QueryWrapper<User> userQueryWrapper = new QueryWrapper<>();// if(!StringUtils.isEmpty(username)){// userQueryWrapper.like("username" , username);// }// if(!CollectionUtils.isEmpty(ageList)){// userQueryWrapper.in("age" , ageList);// } userQueryWrapper.like(!StringUtils.isEmpty(username) , "username" , username) .in(!CollectionUtils.isEmpty(ageList) , "age" , ageList); return userQueryWrapper; }}结果如下:
结果也是正确的。
到此这篇关于MyBatis-Plus条件构造器之condition参数的使用的文章就介绍到这了,更多相关MyBatis-Plus condition参数内容请搜索以前的文章或继续浏览下面的相关文章希望大家以后多多支持!