开源项目 > 数据库相关 > 数据库开发包 &

捐赠 Watch Star Fork

abel533 / Mybatis_PageHelperJavaMIT

Mybatis分页插件

432 Commits

Fetching Contributors

克隆/下载

# MyBatis Pagination - PageHelper

[![Build Status]()](/travis-cig/pagehelper/mybatis-pagehelper)
[![Maven central](/maven-badgesm/maven-central/com.github.pagehelper/pagehelper/badge.svg)](/maven-badgesm/maven-central/com.github.pagehelper/pagehelper)
[![Dependency Status](/versioneyem/user/projects/5932123f22f278003c5f851e/badge.svg-styleflat.html)](/versioneyem/user/projects/5932123f22f278003c5f851e)

[中文版文档](/githubm/pagehelper/mybatis-pagehelper/blob/master/readme_zh.md)

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**](/githubm/pagehelper/mybatis-pagehelper/blob/master/wikis/en/important.md).

Want to use PageHelper? 
Please see [**How to use PageHelper**](/githubm/pagehelper/mybatis-pagehelper/blob/master/wikis/en/howtouse.md).

## 新书《MyBatis 从入门到精通》

![MyBatis 从入门到精通]()

预售地址：[京东](/itemm/12103309.html)，[当当](/product/25098208.html)，[亚马逊](https://www.amazon.cn/MyBatis从入门到精通-刘增辉/dp/B072RC11DM/ref=sr_1_18?ie=UTF8&qid=1498007125&sr=8-18&keywords=mybatis)

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

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

## Support [MyBatis 3.1.0+](/githubm/mybatis/mybatis-3)
## 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`

## Use [QueryInterceptor spec](/githubm/pagehelper/mybatis-pagehelper/blob/master/src/main/java/com/github/pagehelper/queryinterceptor.java)

## Installation

To use PageHelper you just need to include the 
[pagehelper-x.x.x.jar](/repo1/maven2/com/github/pagehelper/pagehelper/) 
and [jsqlparser-0.9.5.jar](/repo1/maven2/com/github/jsqlparser/jsqlparser/0.9.5/) file in the classpath.

If you are using Maven just add the following dependency to your pom.xml:

```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 [pagehelper-spring-boot-starter](/githubm/pagehelper/pagehelper-spring-boot)

[Read More...](/githubm/pagehelper/mybatis-pagehelper/blob/master/wikis/en/howtouse.md)

## Documentation  
- [How to use the PageHelper](/githubm/pagehelper/mybatis-pagehelper/blob/master/wikis/en/howtouse.md)
- [Changelog](/githubm/pagehelper/mybatis-pagehelper/blob/master/wikis/en/changelog.md)
- [Important note](/githubm/pagehelper/mybatis-pagehelper/blob/master/wikis/en/important.md)

## Spring integration sample
- [Integration Spring 3.x](/githubm/abel533/mybatis-spring/tree/spring3.x)
- [Integration Spring 4.x](/githubm/abel533/mybatis-spring)
- [Integration Spring Boot](/githubm/abel533/mybatis-spring-boot)

## Submit BUG
- [Submit to github](/githubm/pagehelper/mybatis-pagehelper/issues/new)
- [Submit to gitosc](/git/free/mybatis_pagehelper/issues/new-issue5bassignee_id5dissue5bmilestone_id5d.html)

## Author Info
Web: http://www.mybatis.tk

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

Email: abel533@gmail.com

QQ Group: <a target="_blank" href="http://shang.qq.com/wpa/qunwpa?idkey=7c2f018e4cddc7d4aad04fc312b2d69361a0a896a4f59219a7914953a57bffc2"><img border="0" src="http://pub.idqqimg.com/wpa/images/group.png" alt="Mybatis工具群(2)" title="Mybatis工具群(2)"></a>

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

PageHelper on gitosc:http://git.fron.com.cn/free/Mybatis_PageHelper

一键复制原始数据按行查看历史

README.md 4.20 KB →

isea533 提交于 2017-07-31 20:38 . 增加 Phoenix 数据库的简单配置

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.

新书《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:

Oracle
Mysql
MariaDB
SQLite
Hsqldb
PostgreSQL
DB2
SqlServer(2005,2008)
Informix
H2
SqlServer2012
Derby
Phoenix

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>latest version</version>
</dependency>

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

Documentation

Spring integration sample

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:

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

PageHelper on gitosc:http://git.fron.com.cn/free/Mybatis_PageHelper

Float_left