Need help with Mybatis-PageHelper?
Click the “chat” button below for chat support from the developer who created it, or find similar developers for support.

About the developer

pagehelper
10.3K Stars 2.9K Forks MIT License 543 Commits 167 Opened issues

Description

Mybatis通用分页插件

Services available

!
?

Need anything else?

Contributors list

# 1,328
Java
mybatis...
Shell
SQL
490 commits
# 63,935
Java
mybatis...
4 commits
# 48,550
tuntap
mybatis...
jvm-lan...
Groovy
4 commits
# 73,696
Java
mybatis...
3 commits
# 17,263
Java
mybatis...
TypeScr...
alibaba
2 commits
# 91,265
Java
mybatis...
2 commits
# 90,569
Java
mybatis...
server-...
gRPC
2 commits
# 91,272
Java
mybatis...
2 commits
# 126,257
Java
mybatis...
1 commit
# 119,441
mybatis...
Groovy
Shell
HTML
1 commit
# 43,628
Java
mybatis...
Applica...
tracing
1 commit
# 126,252
Java
mybatis...
1 commit
# 120,192
Java
mybatis...
1 commit
# 126,234
Java
mybatis...
1 commit
# 125,988
Java
mybatis...
1 commit
# 126,216
Java
mybatis...
1 commit
# 126,246
Java
mybatis...
1 commit
# 119,639
mybatis...
CSS
HTML
Node.js
1 commit
# 101,989
React
HTML
CSS
floatin...
1 commit
# 126,258
Java
mybatis...
1 commit

MyBatis Pagination - PageHelper

MyBatis Pagination - PageHelper

Build Status Maven 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

https://apidoc.gitee.com/free/Mybatis_PageHelper

APIs: https://apidoc.gitee.com/free/Mybatis_PageHelper/com/github/pagehelper/page/PageMethod.html

新书《MyBatis 从入门到精通》

MyBatis 从入门到精通

预售地址:京东当当亚马逊

CSDN博客:http://blog.csdn.net/isea533/article/details/73555400

GitHub项目:https://github.com/mybatis-book/book

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 PageAutoDialect.java#L58.

Use QueryInterceptor spec

Installation

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

pom.xml
:
    com.github.pagehelper
    pagehelper
    latest version

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

More...

Documentation

Spring integration sample

Submit BUG

Thanks for free JetBrains Open Source license

Author Info

Web: https://mybatis.io

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

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.