2.0.4

Features

1. Supports databases: AliSQL, TDSQL, CynosDB, Presto, Citus, Raima, Tajo, Trafodion, YugabyteDB, Covenant, Sadas, Small, Yaacomo, Linter
2. Supports custom count column when pagination
3. Adapter pagehelper's orderby, countColumn

Bugs

1. #76 pagination fail in GBase
2. #77 a bug in sqlhelper-examples

Dependencies

1. upgrade langx-java to version 0.0.8
2. upgrade easyjson to version 2.0.5

2.0.3

Features

1. Supports CirroDB
2. Supports sql symbol mapper API
3. Supports Ansi SQL keywords
4. Refactor sql formatter
5. ProgramStyleOrderByBuilder
6. Adatper PageHelper perfect

2.0.2

Features

1. Supports Spring-Jdbc

Dependencies

1. langx-java to v0.0.4

2.0.1

Features

1. Supports Order By
2. Supports memory pagination
3. Supports HuaWei GaussDB （华为高斯数据库）

2.0.0

Features:

1. #38 supports rowbounds for mybatis
2. #39 supports orderby for mybatis

Enhancement

1. #31 when pageNo grate maxPageNo, return empty array in mybatis environment
2. #40 show supported dialects when startup

Bugs

1. #42 README version links is wrong

Dependency

1. #41 gson -> easyjson

1.2.3

Bugs

1. #31 when pageNo grate maxPageNo, return empty array in mybatis environment

1.2.1

supports mybatis nested query

1.2.0

1. supports 3 ORM framework：jfinal, ebean, mango
2. add two key features：batchinsert, urlparser

1.1.1

1. 简化依赖
2. 更新groupId, 从com.github.fangjinuo 更新为 com.github.fangjinuo.sqlhelper

JdbcUrlParser

mybatis pagination plugin

Key Features

1. Supported 90+ databases, you can find them here. Conatins almost all chinese database:

   • TiDB (北京平凯星辰科技))
   • Doris (Apache Doris，百度研发)
   • MaxCompute (阿里巴巴)
   • K-DB (浪潮)
   • GBase (南大通用)
   • DM (达梦)
   • OSCAR (神州通用)
   • HighGo (瀚高)
   • KingBase (金仓)
   • OpenBase (东软)
   • SequoiaDB (巨杉)

   If you want know all RDMBS ranking, you can find them in DB Engines.

2. Supports multiple databases in one application

3. Supports auto detect dialect, so the dialect option is optional

4. The performance is higher than Mybatis-PageHelper, because the limit、offset will be setted with PrepareStatement placeholder '?'

5. Supports plugin use Java SPI

6. Supports spring boot 1.x , 2.x

7. Supports mybatis 3.x

8. Supports JDK6+

<dependency>
    <groupId>com.github.fangjinuo.sqlhelper</groupId>
    <artifactId>sqlhelper-dialect</artifactId>
    <version>1.1.1</version>
</dependency>
<dependency>
    <groupId>com.github.fangjinuo.sqlhelper</groupId>
    <artifactId>sqlhelper-mybatis</artifactId>
    <version>1.1.1</version>
</dependency>
<dependency>
    <groupId>com.github.fangjinuo.sqlhelper</groupId>
    <artifactId>sqlhelper-mybatis-spring-boot-starter</artifactId>
    <version>1.1.1</version>
</dependency>
<dependency>
    <groupId>com.github.fangjinuo.sqlhelper</groupId>
    <artifactId>sqlhelper-mybatis-spring-boot-autoconfigure</artifactId>
    <version>1.1.1</version>
</dependency>
<dependency>
    <groupId>com.github.fangjinuo.sqlhelper</groupId>
    <artifactId>sqlhelper-mybatis-over-pagehelper</artifactId>
    <version>1.1.1</version>
</dependency>

1.1-RELEASE

1. Supports JDBC url parser
2. Support Doris Dialect (Apache Doris, power by BaiDu)