EasyJDBC: Spring JdbcTemplate Wrapper with JPA Annotation Support and Multi‑Database Compatibility

EasyJDBC is a library built on top of Spring's JdbcTemplate that adds partial JPA annotation support, allowing annotated entities to be used for CRUD operations similar to Hibernate/JPA.

Key features include support for common JPA annotations, simplified batch and pagination operations, a flexible chainable query API with SQL builder and annotations, dynamic entity property mapping, and compatibility with multiple databases such as MySQL, MariaDB, Oracle, SQL Server, PostgreSQL, DB2, SQLite, HSQLDB, Derby, Phoenix, DM, PPAS, Oscar, and HerdDB.

Maven coordinates for the core library are:

<dependency>
    <groupId>cn.xphsc</groupId>
    <artifactId>easyjdbc</artifactId>
    <version>2.1.0</version>
</dependency>

For Spring Boot integration, use the starter:

<dependency>
    <groupId>cn.xphsc.boot</groupId>
    <artifactId>easyjdbc-spring-boot-starter</artifactId>
    <version>2.1.0</version>
</dependency>

Changelog

Changes in version 2.1.0

Added support for registering EasyJDBC DAO interfaces via @DaoScan annotation.

Renamed the default EasyJDBC DAO annotation from @EasyDao to @Dao.

By default, DAO interfaces can be annotated with @Dao or Spring’s @Repository.

Added support for JDK 8 date‑time types: Instant, OffsetDateTime, OffsetTime, Year.

Extended database support to include Derby, Phoenix, DM, PPAS, Oscar, and HerdDB.