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.
https://apidoc.gitee.com/free/Mybatis_PageHelper
APIs: https://apidoc.gitee.com/free/Mybatis_PageHelper/com/github/pagehelper/page/PageMethod.html
CSDN博客：http://blog.csdn.net/isea533/article/details/73555400
GitHub项目：https://github.com/mybatis-book/book
Support MyBatis 3.1.0+
PageHelper supports the following databases:
OracleMysqlMariaDBSQLiteHsqldbPostgreSQLDB2SqlServer(2005,2008)InformixH2SqlServer2012DerbyPhoenix- 达梦数据库(dm)
- 阿里云PPAS数据库
- 神通数据库
- HerdDB
The database list here is not updated in time, see details here PageAutoDialect.java#L58.
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
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