若依框架分页查询错误解决
时间: 2023-08-26 20:15:17 浏览: 73
若依框架分页查询错误的解决方法是对查询结果集进行二次操作时,会导致分页信息丢失。解决方案是将原本返回的List直接放到service层中,封装成分页对象后返回。这样可以避免分页信息丢失的问题。具体代码如下:
```java
// 在service层中进行分页查询
@Service
public class YourService {
@Autowired
private YourMapper yourMapper;
public PageInfo<YourEntity> getYourPageData(int pageNum, int pageSize) {
PageHelper.startPage(pageNum, pageSize);
List<YourEntity> yourList = yourMapper.getYourData();
return new PageInfo<>(yourList);
}
}
```
这样,在controller层调用service层的方法,就可以得到封装好的分页对象。使用这种方式可以避免使用PageHelper时可能出现的问题。<em>1</em><em>2</em><em>3</em>
#### 引用[.reference_title]
- *1* *3* [若依分离版——解决配置双数据源oracle,mysql分页错误问题](https://blog.csdn.net/zhaolulu916/article/details/131931766)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v92^chatsearchT0_1"}} ] [.reference_item]
- *2* [若依pageHelper分页导致total错误的问题](https://blog.csdn.net/m0_50707445/article/details/130771964)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v92^chatsearchT0_1"}} ] [.reference_item]
[ .reference_list ]