Skip to content

๐Ÿ“– MyPages is a java based, open source pagination plugin for MyBatis that simplifies database paging queries. Many databases, one plugin.

License

Notifications You must be signed in to change notification settings

yihleego/mypages

Folders and files

NameName
Last commit message
Last commit date

Latest commit

ย 

History

44 Commits
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 

Repository files navigation

MyPages

MyPages is a java based, open source pagination plugin for MyBatis that simplifies database paging queries. Many databases, one plugin.

Installation

Please make sure the Java version is 1.8 or above.

$ git clone https://github.com/yihleego/mypages.git
$ cd mypages
$ mvn clean install

Dependency

Maven

<dependency>
    <groupId>io.leego</groupId>
    <artifactId>mypages</artifactId>
    <version>2.2.1</version>
</dependency>

Gradle

implementation 'io.leego:mypages:2.2.1'

Supported

Database
PostgreSQL PostgreSQL
MySQL MySQL
Oracle Oracle
Microsoft SQL Server Microsoft SQL Server
SQLite SQLite
DB2 DB2
H2 H2
MariaDB MariaDB
HSQLDB HSQLDB
Apache Phoenix Apache Phoenix
Apache Derby Apache Derby
Apache Hive Apache Hive
Informix Informix

ANTLR

ANTLR (ANother Tool for Language Recognition) is a powerful parser generator for reading, processing, executing, or translating structured text or binary files. It's widely used to build languages, tools, and frameworks. From a grammar, ANTLR generates a parser that can build and walk parse trees.

Original SQL

select * from t where k = v

Query Statement Tree

Generated SQL

select count(*) from t where k = v

Count Statement Tree

Documentation

Chinese Document ไธญๆ–‡็‰ˆ

Contact

License

MyPages is under the MIT license. See the LICENSE file for details.