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.
Support MyBatis 3.1.0+
PageHelper supports the following databases:
Oracle
Mysql
MariaDB
SQLite
Hsqldb
PostgreSQL
DB2
SqlServer(2005,2008)
Informix
H2
SqlServer2012
Derby
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>5.0.0</version>
</dependency>
If you are using Spring Boot, You can refer to 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