Creating a JDBC Starter Project

Learn about creating a JDBC starter project, connect to the H2 database, create a table, and add data to the table.

We'll cover the following

Spring Boot JDBC
In-memory database
Using Spring Boot Initializer

Spring JDBC makes talking to databases easy by eliminating the need for establishing a connection, handling expectations, and closing connections. Spring provides a template class called JdbcTemplate to interact with databases which offers a wide array of methods to perform storage and retrieval of data. The JdbcTemplate class hides all the boilerplate code for connection management and error handling whereby the developer can focus on the SQL query.

Using the Spring JdbcTemplate, a Java application can store and retrieve objects of a class to a table in the database.

Level up your interview prep. Join Educative to access 80+ hands-on prep courses.

Introduction

Spring Basics

Spring In-depth

Spring Boot

Spring JDBC

Spring Data JPA

Spring REST Fundamentals

Spring REST Advanced Operations and Error Management

Database Relationships in Spring

Spring Aspect Orientated Programming (AOP)

Configuring a Basic Enterprise Web Application

Spring MVC Fundamentals

Spring MVC Advanced Concepts

Unit Testing in Spring

Interview Questions

Epilogue

Creating a JDBC Starter Project