Permalink
Fetching contributors…
Cannot retrieve contributors at this time
98 lines (67 sloc) 4.11 KB

MyBatis Pagination - PageHelper

Build Status Maven central Dependency Status

中文版文档

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.

New JavaDoc

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

Method API: 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

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

Read More...

Documentation

Spring integration sample

Submit BUG

Author Info

Web: http://www.mybatis.tk

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