Spring provides a nice abstraction on top of the JDBC API using JdbcTemplate and also provides great transaction management capabilities
using an annotation-based approach.

Test

A practical guide to using Spring's JdbcTemplate with Spring Boot. Covers the manual configuration approach (DataSource, TransactionManager, JdbcTemplate beans) versus Spring Boot's auto-configuration via spring-boot-starter-jdbc. Demonstrates CRUD operations with a UserRepository, schema/data SQL initialization, connecting to embedded (H2) and external databases (MySQL, PostgreSQL), and swapping connection pool implementations (Tomcat JDBC vs HikariCP).

SpringBoot : Working with JdbcTemplate