SQL Tools ( Dialect, Pagination, UrlParser, SqlStatementParser, WallFilter, BatchExecutor for Test) based Java
sqlhelper-dialect : the core
sqlhelper-mybatis : the mybatis tools (MyBatis Pagination Plugin)
sqlhelper-mybatis-spring-boot: spring boot autoconfigure, starter for sqlhelper in mybatis environment
sqlhelper-mybatis-over-pagehelper: migrate your application from mybatis-pagehelper
sqlhelper-jfinal: use it in jFinal application environment
sqlhelper-ebean: use it in Ebean application environment
sqlhelper-examples: some examples for there tools
-
Supports MyBatis, JFinal, EBean, Mango
-
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.
-
Supports multiple databases in one application
-
Supports auto detect dialect, so the dialect option is optional (current supports this mode in mybatis environment)
-
The performance is higher than Mybatis-PageHelper, because the limit、offset will be setted with PrepareStatement placeholder '?'
-
Supports plugin use Java SPI
-
Supports spring boot 1.x , 2.x
-
Supports mybatis 3.x
-
Supports JDK6+
| metric | mybatis-pagehelper | sqlhelper |
|---|---|---|
| databases | 13 | 90+ |
| 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 | √ （参见上述列表） |