MybatisPlus条件查询
时间: 2024-01-11 15:45:50 浏览: 33
MybatisPlus是Mybatis的增强版,提供了更加便捷的条件查询方式。
1. 简单的条件查询
```java
QueryWrapper<User> queryWrapper = new QueryWrapper<>();
queryWrapper.eq("name", "张三");
List<User> userList = userMapper.selectList(queryWrapper);
```
2. 多条件查询
```java
QueryWrapper<User> queryWrapper = new QueryWrapper<>();
queryWrapper.eq("name", "张三")
.eq("age", 18);
List<User> userList = userMapper.selectList(queryWrapper);
```
3. 模糊查询
```java
QueryWrapper<User> queryWrapper = new QueryWrapper<>();
queryWrapper.like("name", "张");
List<User> userList = userMapper.selectList(queryWrapper);
```
4. 区间查询
```java
QueryWrapper<User> queryWrapper = new QueryWrapper<>();
queryWrapper.between("age", 18, 30);
List<User> userList = userMapper.selectList(queryWrapper);
```
5. 集合查询
```java
List<Integer> ageList = new ArrayList<>();
ageList.add(18);
ageList.add(20);
QueryWrapper<User> queryWrapper = new QueryWrapper<>();
queryWrapper.in("age", ageList);
List<User> userList = userMapper.selectList(queryWrapper);
```
6. 排序查询
```java
QueryWrapper<User> queryWrapper = new QueryWrapper<>();
queryWrapper.orderByDesc("age");
List<User> userList = userMapper.selectList(queryWrapper);
```
7. 分页查询
```java
Page<User> page = new Page<>(1, 10);
QueryWrapper<User> queryWrapper = new QueryWrapper<>();
queryWrapper.between("age", 18, 30);
IPage<User> userIPage = userMapper.selectPage(page, queryWrapper);
List<User> userList = userIPage.getRecords();
```
以上就是MybatisPlus的常见条件查询方式。