Pagination_KeyFeatures

1. Higher Performance than Mybatis-PageHelper

Mybatis-PageHelper's pagination sql use java hard code, examples :
assume has an original sql like this:

select * 
from user
where age > 10

Use Mybatis-PageHelper, the pagination sql will be:

select * 
from user
where age > 10
limit 11, 20

If you use our sqlhelper, the sql will be:

select *
from user
where age > 10
limit ?, ?

that is, use sqlhelper the limit、offset parameters will be setted with PrepareStatement placeholder '?'

2. Multiple Databases in a application

Use sqlhelper, you can use multiple database in the same application, and you don't have to be able to distinguish them. Because of the dialect will be automatic detected without any configuration.

3. Zero config

Assume you are working in a spring boot application, so if you want use sqlhelper, you will configure nothing

4. Supports Spring Boot 1.x, 2.x

5. Supports MyBatis 3.x

6. Supports almost all RDBMS

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.
  

7. Run with JDK6+

8. Supports jFinal