sppringboot整合pagehelper
时间: 2023-12-19 13:31:53 浏览: 53
以下是Spring Boot整合PageHelper的步骤:
1. 添加PageHelper依赖
在pom.xml文件中添加PageHelper的依赖:
```xml
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper-spring-boot-starter</artifactId>
<version>1.2.5</version>
</dependency>
```
2. 配置PageHelper
在application.properties或application.yml文件中添加PageHelper的配置:
```properties
# 分页插件配置
pagehelper.helper-dialect=mysql
pagehelper.reasonable=true
pagehelper.support-methods-arguments=true
pagehelper.params=count=countSql
```
3. 使用PageHelper进行分页查询
在DAO层的方法中使用PageHelper进行分页查询,例如:
```java
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
@Service
public class UserServiceImpl implements UserService {
@Autowired
private UserMapper userMapper;
@Override
public PageInfo<User> getUsers(int pageNum, int pageSize) {
PageHelper.startPage(pageNum, pageSize);
List<User> userList = userMapper.getUsers();
return new PageInfo<>(userList);
}
}
```
4. 在Controller中使用分页查询结果
在Controller中调用Service层的方法获取分页查询结果,并将结果返回给前端页面,例如:
```java
@RestController
public class UserController {
@Autowired
private UserService userService;
@GetMapping("/users")
public PageInfo<User> getUsers(@RequestParam(defaultValue = "1") int pageNum,
@RequestParam(defaultValue = "10") int pageSize) {
return userService.getUsers(pageNum, pageSize);
}
}
```