MyBatis-Plus-wrapper(条件查询)

复杂条件查询

@SpringBootTest
public class wrapper {

    @Autowired
    private UserMapper userMapper;

    //条件查询
    @Test
    void contextLoads() {
        QueryWrapper<User> wrapper = new QueryWrapper<>();
        wrapper
                .isNotNull("name")
                .isNotNull("email")//不为空
                .ge("age",19);//大于
        List<User> users = userMapper.selectList(wrapper);
        users.forEach(System.out::println);

    }
    @Test
    void t1(){
        QueryWrapper<User> wrapper = new QueryWrapper<>();
        wrapper
                .eq("name","大饼"); //相当
        userMapper.selectOne(wrapper);
    }


    @Test
    void t2(){
        QueryWrapper<User> wrapper = new QueryWrapper<>();
        wrapper.between("age",20,30);//区间
        userMapper.selectCount(wrapper);
    }

    @Test
    void t3(){
        QueryWrapper<User> wrapper = new QueryWrapper<>();
        wrapper
                .notLike("name","奶") //不包含
                .likeRight("email","t");//右边含有百分号 => t%
        List<Map<String, Object>> maps = userMapper.selectMaps(wrapper);
    }

    @Test
    void t4(){
        QueryWrapper<User> wrapper = new QueryWrapper<>();
        wrapper.inSql("id","select id from user where id<3");//拼接sql 嵌套查询
        List<Object> objects = userMapper.selectObjs(wrapper);
        objects.forEach(System.out::println);

    }



    @Test
    void t5(){
        QueryWrapper<User> wrapper = new QueryWrapper<>();
        wrapper.orderByDesc("id");//按照降序排列
        List<User> users = userMapper.selectList(wrapper);
        users.forEach(System.out::println);


    }
}