mybatis plus 使用函数

MyBatis Plus 提供了许多函数来方便开发者处理数据，以下是一些常见的函数：

1. eq：等于

QueryWrapper<User> queryWrapper = new QueryWrapper<>();
queryWrapper.eq("name", "Tom");

2. ne：不等于

QueryWrapper<User> queryWrapper = new QueryWrapper<>();
queryWrapper.ne("name", "Tom");

3. gt：大于

QueryWrapper<User> queryWrapper = new QueryWrapper<>();
queryWrapper.gt("age", 18);

4. lt：小于

QueryWrapper<User> queryWrapper = new QueryWrapper<>();
queryWrapper.lt("age", 18);

5. ge：大于等于

QueryWrapper<User> queryWrapper = new QueryWrapper<>();
queryWrapper.ge("age", 18);

6. le：小于等于

QueryWrapper<User> queryWrapper = new QueryWrapper<>();
queryWrapper.le("age", 18);

7. like：模糊查询

QueryWrapper<User> queryWrapper = new QueryWrapper<>();
queryWrapper.like("name", "Tom");

8. notLike：不包含

QueryWrapper<User> queryWrapper = new QueryWrapper<>();
queryWrapper.notLike("name", "Tom");

9. in：包含

QueryWrapper<User> queryWrapper = new QueryWrapper<>();
List<Integer> ids = Arrays.asList(1, 2, 3);
queryWrapper.in("id", ids);

10. notIn：不包含

QueryWrapper<User> queryWrapper = new QueryWrapper<>();
List<Integer> ids = Arrays.asList(1, 2, 3);
queryWrapper.notIn("id", ids);

11. between：区间查询

QueryWrapper<User> queryWrapper = new QueryWrapper<>();
queryWrapper.between("age", 18, 30);

12. isNull：为空

QueryWrapper<User> queryWrapper = new QueryWrapper<>();
queryWrapper.isNull("address");

13. isNotNull：不为空

QueryWrapper<User> queryWrapper = new QueryWrapper<>();
queryWrapper.isNotNull("address");

14. orderBy：排序

QueryWrapper<User> queryWrapper = new QueryWrapper<>();
queryWrapper.orderByDesc("age");

15. groupBy：分组

QueryWrapper<User> queryWrapper = new QueryWrapper<>();
queryWrapper.groupBy("age");

以上是 MyBatis Plus 中常用的函数，开发者可以根据自己的需求使用不同的函数来处理数据