If you are using MyBatis, it is recommended to try this pagination plugin. This must be the Most Convenient pagination plugin.
PageHelper support any complex single-table, multi-table queries. Some special cases please see the Important note.
Want to use PageHelper? Please see How to use PageHelper.
https://apidoc.gitee.com/free/Mybatis_PageHelper
Method API: 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:
Oracle
Mysql
MariaDB
SQLite
Hsqldb
PostgreSQL
DB2
SqlServer(2005,2008)
Informix
H2
SqlServer2012
Derby
Phoenix
To use PageHelper you just need to include the pagehelper-x.x.x.jar and jsqlparser-0.9.5.jar file in the classpath.
If you are using Maven 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 pagehelper-spring-boot-starter
Blog: http://blog.csdn.net/isea533
Email: [email protected]
PageHelper on github:https://github.com/pagehelper/Mybatis-PageHelper
PageHelper on gitosc:http://git.oschina.net/free/Mybatis_PageHelper