Github url


by pagehelper

pagehelper /Mybatis-PageHelper


9.4K Stars 2.7K Forks Last release: 8 months ago (v5.1.11) MIT License 514 Commits 57 Releases

Available items

No Items, yet!

The developer of this repository has not created any items for sale yet. Need a bug fixed? Help with integration? A different license? Create a request here:

MyBatis Pagination - PageHelper

Build StatusMaven central


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.

New JavaDoc\_PageHelper


新书《MyBatis 从入门到精通》

MyBatis 从入门到精通




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
  13. Phoenix
  14. 达梦数据库(dm)
  15. 阿里云PPAS数据库
  16. 神通数据库
  17. HerdDB

The database list here is not updated in time, see details here

Use QueryInterceptor spec


To use PageHelper, you just need to include the pagehelper-x.y.z.jarand 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



    <version>latest version</version>

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



Spring integration sample

Submit BUG

Thanks for free JetBrains Open Source license

Author Info



Email: [email protected]

PageHelper on github:

PageHelper on gitosc:\_PageHelper

We use cookies. If you continue to browse the site, you agree to the use of cookies. For more information on our use of cookies please see our Privacy Policy.