pagehelper拦截器
时间: 2023-09-11 07:04:50 浏览: 51
PageHelper是一个用于分页查询的MyBatis插件。它提供了一种简单且强大的分页查询方式,可以方便地在MyBatis中实现分页功能。PageHelper的原理是通过MyBatis的拦截器机制,在执行SQL语句之前拦截并修改SQL,添加分页相关的查询条件和限制。具体来说,PageHelper会拦截Executor的query方法,在查询之前获取分页参数,然后修改SQL语句,添加LIMIT和OFFSET等关键字来实现分页查询。通过自动拦截并修改SQL语句,PageHelper能够在不修改原有Mapper接口的情况下,实现分页功能。<span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
- *1* *3* [Mybatis 系列:Pagehelper + 拦截器实现分页](https://blog.csdn.net/weixin_42036952/article/details/106064971)[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^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 50%"]
- *2* [吃透Mybatis源码-通过分析Pagehelper源码来理解Mybatis的拦截器(四)](https://blog.csdn.net/u014494148/article/details/122315991)[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^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 50%"]
[ .reference_list ]