sharlenlxm / sqlhelper

SQL Tools ( Dialect, Pagination, DDL dump, UrlParser, SqlStatementParser, WallFilter, BatchExecutor for Test) based Java

sqlhelper

SQL Tools ( Dialect, Pagination, DDL Dump, UrlParser, SqlStatementParser, WallFilter, BatchExecutor for Test) based Java

modules

module	sqlhelper version	JDK	Description
sqlhelper-dialect	1.0+	1.6+	the core
sqlhelper-mybatis	1.0+	1.6+	the mybatis tools (MyBatis Pagination Plugin)
sqlhelper-mybatis-spring-boot	1.0+	1.6+	spring boot autoconfigure, starter for sqlhelper-mybatis
sqlhelper-mybatis-over-pagehelper	1.0+	1.6+	migrate your application from mybatis-pagehelper
sqlhelper-jfinal	1.2+	1.6+	supports jfinal
sqlhelper-ebean	1.2+	1.6+	supports ebean
sqlhelper-hibernate	1.2+	1.6+	supports hibernate
sqlhelper-mango	1.2+	1.6+	supports mango
sqlhelper-batchinsert	1.2+	1.6+	Batch insert data to database, use it for performance
sqlhelper-springjdbc	2.0.2+	1.6+	supports spring-jdbc
sqlhelper-springjdbc-spring-boot	2.0.2+	1.8+	spring boot autoconfigure, starter for sqlhelper-springjdbc
sqlhelper-mybatisplus	2.0.7+	1.6+	supports mybatis-plus
sqlhelper-mybatisplus-spring-boot	2.0.7+	1.8+	supports mybatis-plus in spring boot application
sqlhelper-dbutils	2.2.0	1.6+	supports Apache Commons-DBUtils
sqlhelper-examples	1.0+	1.8+	some examples for there tools

tools usage

pagination plugin

Key Features

1. Supports MyBatis, MyBatis-Plus, SpringJdbc, Apache Commons-DBUtils, JFinal, EBean, Mango, Hibernate
2. Supported 110+ databases, you can find them here. Conatins almost all chinese database:

• AliSQL (阿里 MySQL)

• AntDB (亚信)

• CirroDB (东方国信 行云)

• CynosDB (腾讯云数据库)

• Doris (Apache Doris，百度研发)

• DM (达梦)

• EsgynDB (易鲸捷)

• GaussDB (华为 高斯)

• GBase (南大通用)

• GoldenDB (中兴)

• HHDB (恒辉数据库)

• HighGo (瀚高)

• HybridDB (阿里巴巴 分布式PostgreSQL)

• K-DB (浪潮)

• KingBase (金仓)

• MaxCompute (阿里巴巴)

• OBase (上海丛云信息科技)

• OceanBase (阿里巴巴/蚂蚁金服 兼容mysql)

• OSCAR (神州通用)

• OpenBase (东软)

• RadonDB (青云)

• SequoiaDB (巨杉)

• SinoDB (星瑞格)

• TDSQL (腾讯 分布式MySQL)

• TiDB (北京平凯星辰科技))

• Trafodion (易鲸捷 EsgynDB的开源版)

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

3. Supports multiple databases in one application
4. Supports auto detect dialect, so the dialect option is optional (current supports this mode in mybatis environment)
5. The performance is higher than Mybatis-PageHelper, because the limit、offset will be setted with PrepareStatement placeholder '?'
6. Supports plugin use Java SPI
7. Supports spring boot 1.x , 2.x
8. Supports mybatis 3.x
9. Supports mybatis-plus
10. Supports JDK6+
11. Supports Memory Pagination
12. Supports SqlSymbolMapper, use it you can mapping any symbol to SQL symbol
13. Supports Dump DDL

sqlhelper vs mybatis-pagehelper

metric	mybatis-pagehelper	sqlhelper
databases	13	100+
multiple databases in runtime	√	√
auto detect dialect	√	√
plugin	√	√
PrepareStatement with '?'	X	√
mybatis	3.x	3.x
spring boot	1.x, 2.x	1.x, 2.x
JDK	1.6+	1.6+
jFinal	X	√
Mango	X	√
EBean	X	√
国产数据库	X	√ （参见上述列表）
Spring JDBC	X	2.x,3.x,4.x,5.x
SqlSymbol Mapping	X	√
MyBatis-Plus	X	√
Apache Commons-DBUtils	X	√

Pagination

• Quick Start
  • MyBatis application
    • Installation
    • How To
    • Migrate from mybatis-pagehelper application
  • SpringJDBC application
    • Installation
    • How To
  • jFinal application
    • Installation
    • How To
  • MyBatis-Plus application
  • EBean application
• Advanced Usage

UrlParser

Parse jdbc url.

usage:

String url = "jdbc:mysql://${localhost}:${port}....";
DatabaseInfo dbinfo = new JdbcUrlParser().parse(url)
...

Batch Insert Tool

If you want to optimize SQL performance, it is essential to create a large amount of sample data. This tool can meet your needs.

FAQ

Contact

QQ Group: 750929088