MybatisPlus特殊查询的实现介绍

@Test
void testGetAll07(){
    LambdaQueryWrapper<Users> lqw = new LambdaQueryWrapper<Users>();
    lqw.select(Users::getId,Users::getName,Users::getAge);
    List<Users> userList = userDao.selectList(lqw);
    System.out.println(userList);
}

@SpringBootTest
class mybatisplus{
    @Autowired
    private UserDao userDao;
    @Test
    void testGetAll(){
        QueryWrapper<User> lqw = new QueryWrapper<User>();
        //lqw.select("count(*) as count");
        //SELECT count(*) as count FROM user
        //lqw.select("max(age) as maxAge");
        //SELECT max(age) as maxAge FROM user
        //lqw.select("min(age) as minAge");
        //SELECT min(age) as minAge FROM user
        //lqw.select("sum(age) as sumAge");
        //SELECT sum(age) as sumAge FROM user
        lqw.select("avg(age) as avgAge");
        //SELECT avg(age) as avgAge FROM user
        List<Map<String, Object>> userList = userDao.selectMaps(lqw);
        System.out.println(userList);
    }
}

@springBootTest
class Mybatisplus{
    @Autowired
    private UserDao userDao;
    @Test
    void testGetAll09(){
        QueryWrapper<Users> lqw = new QueryWrapper<Users>();
        lqw.select("count(*) as count,age");
        lqw.groupBy("age");
        List<Map<String, Object>> list = userDao.selectMaps(lqw);
        System.out.println(list);
    }
}

@SpringBootTest
class Mybatisplus{
    @Autowired
    private UserDao userDao;
    @Test
    void testGetAll13(){
        LambdaQueryWrapper<Users> lqw = new LambdaQueryWrapper<Users>();
        lqw.eq(Users::getName, "懒羊羊").eq(Users::getPassword, "123456");
        Users users = userDao.selectOne(lqw);
        System.out.println(users);
    }
}

@SpringBootTest
class Mybatisplus{
    @Autowired
    private UserDao userDao;
    @Test
    void testGetAll12(){
        LambdaQueryWrapper<Users> lqw = new LambdaQueryWrapper<Users>();
        lqw.between(Users::getAge, 10, 30);
        List<Users> userList = userDao.selectList(lqw);
        System.out.println(userList);
    }
}

@SpringBootTest
class Mybatisplus {
    @Autowired
    private UserDao userDao;
    @Test
    void testGetAll10(){
        LambdaQueryWrapper<Users> lqw = new LambdaQueryWrapper<Users>();
        lqw.like(Users::getName, "美");
        List<Users> userList = userDao.selectList(lqw);
        System.out.println(userList);
    }
}

@SpringBootTest
class Mybatisplus{
    @Autowired
    private UserDao userDao;
    @Test
    void testGetAll11(){
        LambdaQueryWrapper<Users> lwq = new LambdaQueryWrapper<>();
        lwq.orderBy(true,true, Users::getId);
        List<Users> users = userDao.selectList(lwq);
        System.out.println(users);
    }
}