LambdaQueryWrapper<User> wrapper = new LambdaQueryWrapper<>();
// 1.大于
//wrapper.gt(User::getAge,18);
// 2.介于...之间
//wrapper.between(User::getAge, 18, 28);
// 3.模糊匹配
//wrapper.like(User::getAge,2);
// 4.in
//wrapper.in(User::getAge,18,20);
//wrapper.in(User::getAge, Arrays.asList(18,20));
// 5.group
//wrapper.select(User::getAge);
//wrapper.groupBy(User::getAge);
// 6.order
// 升序
//wrapper.orderBy(true, true, User::getAge);
// 降序
wrapper.orderBy(true, false, User::getAge);
List<User> users = dao.selectList(wrapper);
log.info("user ===> {}", users.toString());
Mybatis Plus 常用的查询方式
最新推荐文章于 2023-06-12 15:00:03 发布