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 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+

Physical Paging

PageHelper supports the following databases:

1. Oracle
2. Mysql
3. MariaDB
4. SQLite
5. Hsqldb
6. PostgreSQL
7. DB2
8. SqlServer(2005,2008)
9. Informix
10. H2
11. SqlServer2012
12. Derby

Use QueryInterceptor spec

Installation

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.2</version>
</dependency>

If you are using Spring Boot, You can refer to pagehelper-spring-boot-starter

Read More...

Documentation

• How to use the PageHelper
• Changelog
• Important note

Spring integration sample

• Integration Spring 3.x
• Integration Spring 4.x
• Integration Spring Boot

Submit BUG

• Submit to github
• Submit to gitosc

Author Info

Web: http://www.mybatis.tk

Blog: http://blog.csdn.net/isea533

Email: abel533@gmail.com

QQ Group(recommend):

QQ Group(2000 full):

PageHelper on github:https://github.com/pagehelper/Mybatis-PageHelper

PageHelper on gitosc:http://git.oschina.net/free/Mybatis_PageHelper