MyBatis Pagination - PageHelper
If you are using MyBatis, it is recommended to try this pagination plugin. This must be the MOST CONVENIENT pagination plugin.
PageHelper supports any complex single-table, multi-table queries. As to some special cases, please refer to the Important note.
Want to use PageHelper? Please check out How to use PageHelper.
New JavaDoc
https://apidoc.gitee.com/free/Mybatis_PageHelper
APIs: https://apidoc.gitee.com/free/Mybatis_PageHelper/com/github/pagehelper/page/PageMethod.html
新书《MyBatis 从入门到精通》
CSDN博客:http://blog.csdn.net/isea533/article/details/73555400
GitHub项目:https://github.com/mybatis-book/book
MyBatis 3.1.0+
SupportPhysical Paging
PageHelper supports the following databases:
Oracle
Mysql
MariaDB
SQLite
Hsqldb
PostgreSQL
DB2
SqlServer(2005,2008)
Informix
H2
SqlServer2012
Derby
Phoenix
- 达梦数据库(dm)
- 阿里云PPAS数据库
- 神通数据库
- HerdDB
The database list here is not updated in time, see details here PageAutoDialect.java#L58.
QueryInterceptor spec
UseInstallation
To use PageHelper, you just need to include the pagehelper-x.y.z.jar and jsqlparser-x.y.z.jar file in the classpath.
For version matching relation, please refer to the dependent version in pom.
If you are using Maven, you could just add the following dependency to your pom.xml
:
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper</artifactId>
<version>latest version</version>
</dependency>
If you are using Spring Boot, You can refer to the pagehelper-spring-boot-starter
Documentation
Spring integration sample
Submit BUG
Thanks for free JetBrains Open Source license
Author Info
Web: https://mybatis.io
Blog: http://blog.csdn.net/isea533
Email: abel533@gmail.com
PageHelper on github:https://github.com/pagehelper/Mybatis-PageHelper
PageHelper on gitosc:http://git.oschina.net/free/Mybatis_PageHelper