MyBatisPlus条件构造器

五、条件构造器

package com.jx;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.jx.mapper.UserMapper;
import com.jx.pojo.User;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;

@SpringBootTest
public class WrapperTest {
    @Autowired
    private UserMapper userMapper;
    
    @Test
    void select(){
        QueryWrapper<User> wrapper = new QueryWrapper<>();
        wrapper.isNotNull("name")
                .isNull("email")
                .orderByAsc("id")
                .eq("name","jx");
        userMapper.selectList(wrapper);
    }
    
    //数值范围
    @Test
    void selectRange(){
        QueryWrapper<User> wrapper = new QueryWrapper<>();
        wrapper
        //.ge("age",15)//>=15
        //.gt("age",20);//<20
        //.le("age",17);//<=17
        //.lt("age",17);//<17
        .between("age",15,17);//15<=age<=17
        userMapper.selectList(wrapper);
    }
    
    //模糊查询
    @Test
    void selectLike(){
        QueryWrapper<User> wrapper = new QueryWrapper<>();
        wrapper.like("name","j")
                .notLike("email","3");
        userMapper.selectList(wrapper);
    }
    
    //嵌套查询in
    @Test
   void testInSql(){
        QueryWrapper<User> wrapper = new QueryWrapper<>();
        wrapper.ge("age",15)
                .inSql("id","select id from user where id<3");
        userMapper.selectList(wrapper);
    }
}