Spring Boot Rest API using JDBC Core

In this story, we’ll learn how to implement a Spring Boot Rest API using Spring Boot JDBC core classes and PostgreSQL.

· Prerequisites
· Overview
∘ What is JDBC (Java Database Connectivity)?
∘ Core Classes and Interfaces for Spring JDBC
· Getting Started
∘ Define Data Model
∘ JDBC Repositories
∘ Spring Rest APIs Controller
· Test the application
· Conclusion
· References

Prerequisites

This is the list of all the prerequisites:

• Spring Boot 3+
• Maven 3.6.3
• Java 21
• PostgreSQL

Overview

What is JDBC (Java Database Connectivity)?

Java Database Connectivity (JDBC) is an application programming interface (API) for the Java programming language which defines how a client may access a database. It is a Java-based data access technology used for Java database connectivity. It is part of the Java Standard Edition platform, from Oracle Corporation. It provides methods…