pagehelper分页原理
时间: 2023-08-02 13:08:32 浏览: 52
回答: PageHelper是一个用于Mybatis的分页插件,它的原理是通过拦截器来实现分页功能。当在执行mapper查询之前调用PageHelper.startPage方法设置分页参数,PageHelper会拦截后续的查询语句,并根据设置的分页参数自动在查询语句中添加limit子句,从而实现分页查询。前端传递的pageNum和pageSize参数会被传递到后端,后端在调用接口时使用PageHelper.startPage方法设置分页参数,然后执行查询语句,返回的结果是一个继承自List的Page对象,其中包含了分页查询的结果数据。\[1\]\[2\]\[3\]
#### 引用[.reference_title]
- *1* [PageHelper 分页原理](https://blog.csdn.net/u012839871/article/details/125753953)[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^v91^insertT0,239^v3^insert_chatgpt"}} ] [.reference_item]
- *2* *3* [PageHelper 分页查询「原理篇」](https://blog.csdn.net/weixin_44471490/article/details/121969941)[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^v91^insertT0,239^v3^insert_chatgpt"}} ] [.reference_item]
[ .reference_list ]