MybatisPlus中的条件构造器

deleted作为逻辑删除的字段，所以查不到最后一个数据。

@Autowired
    private UserMapper userMapper;

    @Test
    public void test01(){
        //查询name不为空，email不为空和age>=19的数据
        QueryWrapper<User> wrapper = new QueryWrapper<>();

        wrapper.isNotNull("name").isNotNull("email").ge("age",19);

        List<User> users = userMapper.selectList(wrapper);

        users.forEach(System.out::println);


    }

JDBC Connection [com.mysql.jdbc.JDBC4Connection@1ac4ccad] will not be managed by Spring
==>  Preparing: SELECT id,name,age,email,version,create_time,update_time,deleted FROM user WHERE deleted=0 AND (name IS NOT NULL AND email IS NOT NULL AND age >= ?)
==> Parameters: 19(Integer)
<==    Columns: id, name, age, email, version, create_time, update_time, deleted
<==        Row: 2, Jack, 20, test2@baomidou.com, null, null, null, 0000
<==        Row: 3, Tom, 28, test3@baomidou.com, null, null, null, 0000
<==        Row: 4, Sandy, 21, test4@baomidou.com, null, null, null, 0000
<==        Row: 5, Billie, 24, test5@baomidou.com, null, null, null, 0000
<==      Total: 4
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@7fd8c559]
User(id=2, name=Jack, age=20, email=test2@baomidou.com, version=null, create_time=null, update_time=null, deleted=0)
User(id=3, name=Tom, age=28, email=test3@baomidou.com, version=null, create_time=null, update_time=null, deleted=0)
User(id=4, name=Sandy, age=21, email=test4@baomidou.com, version=null, create_time=null, update_time=null, deleted=0)
User(id=5, name=Billie, age=24, email=test5@baomidou.com, version=null, create_time=null, update_time=null, deleted=0)
2022-02-22 10:17:11.085  INFO 200012 --- [ionShutdownHook] com.alibaba.druid.pool.DruidDataSource   : {dataSource-1} closing ...
2022-02-22 10:17:11.089  INFO 200012 --- [ionShutdownHook] com.alibaba.druid.pool.DruidDataSource   : {dataSource-1} closed

区间查询

模糊查询

子查询：

排序：

更多的条件查询见mybatisPlus官网https://baomidou.com/