Mybatis_plus条件构造器(Wrapper)

使用查询条件构造器

//测试条件CRUD(Wrapper)
    @Test
    public void testSelect(){
        //QueryWrapper用于构造查询条件
        QueryWrapper<User> wrapper=new QueryWrapper<>();
        wrapper
                .isNotNull("name")
                .isNotNull("age")
                .ge("age",12);

        //参数是一个条件构造器
        List<User> list=userMapper.selectList(wrapper);
        list.forEach(System.out::println);
    }

查询一个区间内的

    //查询一个区间内的
    @Test
    public void test2() {
        QueryWrapper<User> wrapper = new QueryWrapper<>();
        wrapper.between("age", 17, 19);//区间内的
        userMapper.selectCount(wrapper);
    }

模糊查询

//模糊查询
    @Test
    public void test3() {
        QueryWrapper<User> wrapper = new QueryWrapper<>();
        //name中包含e的
        //左和右  %e%
        wrapper
                .like("name", "e")
                .likeLeft("email", "@gem.com");//email以@gem.com结尾
        List<Map<String,Object>> map = userMapper.selectMaps(wrapper);
        map.forEach(System.out::println);
    }

内联查询

//内联查询
    @Test
    public void test4() {
        QueryWrapper<User> wrapper = new QueryWrapper<>();
        wrapper.inSql("name","select id from user where id=1");
        List<Object> list=userMapper.selectObjs(wrapper);
        list.forEach(System.out::println);
    }

降序查询

//降序查询
    @Test
    public void test6(){
        QueryWrapper<User> wrapper = new QueryWrapper<>();
        //通过id排序
        wrapper.orderByDesc("id");
        List<User> list =userMapper.selectList(wrapper);
        list.forEach(System.out::println);
    }

更多：条件构造器 | MyBatis-Plus (baomidou.com)https://baomidou.com/guides/wrapper/