JarCastingspring-data-jdbcx
Spring-data-jdbcx is an extention for spring-jdbc-template. Spring-data-jdbcx makes it easy to connect with databases.
how to use
You can download from maven central, add dependency to your pom.xml
<dependency>
<groupId>net.turnbig</groupId>
<artifactId>spring-data-jdbcx</artifactId>
<version>2.0.6</version>
</dependency>
For more example, please check the unit tests.
To integrate with spring boot, add net.turnbig.jdbcx to auto scan package. And if you want to use the sql template feature, add configurations below:
# SQL template loading path
spring.jdbcx.sql.template-path = classpath:/sql-template
# SQL template encoding
spring.jdbcx.sql.template-encoding = UTF-8
# SQL auto refresh delay
spring.jdbcx.sql.update-delay = 0
Planed Features
abstract more friendly jdbc-template-API
- use Bean/Map as named-query parameter
- return Bean/Map for query directly
- pageable(order by included) support
hiding lesser-used jdbc-template-API
- you can still use the API by get original template
sql template support
- use freemarker as template engineer - (dynamic sql benifed from freemarker)
- use seperated xml to define sql templates
customer converter
- you can inject a customer converter service for the type not support by default
- PGobject to Map/List/Bean converter
why spring-data-jdbcx
For database tools, I think the most important parts are:
- full control of SQL (what sql will run, query/update/insert/delete/batch/etc)
- dynamic & clear & structed SQL seperated from code (SQL loaded from xml or somewhere, Mybatis do pretty good in this part)
- simply result-set mapping to JavaBean/Map/Integer/String/etc
- Pagination & dynamic Order inject support
There got many database tools, Hibernate, Mybatis, Jooq etc. Of course they are good, but spring-data-jdbcx will be more Smart. With spring-data-jdbcx, you will benifit from all spring-jdbc-template's adventage(low level api), you will got high level mapping too. You could pass JavaBean/Map as parameter, you could simply get Bean/map/primitive-type as result. It got pagination featurn which almost support all kind of select-sql and database. to be continue...