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. 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:
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, 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
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