Creating a CRUD REST API with Spring Boot and PostgreSQL: A Step-by-Step Guide 🪜

Hello Jhipsters (Java-hipsters) 👓

In this article we are returning to the basics. We'll be creating a Spring Boot application with a CRUD REST API for product management, using Java 17 and PostgreSQL.

We will use Java's Optional to handle potential null values, enhancing the clarity of our code (you can read more about Optionals in the previous article)

Prerequisites

• Jdk 17 installed

• PostgreSQL Database

• An IDE supporting Java and Gradle

• Basic knowledge of Java, Spring Boot, and REST APIs

Folder Structure

Our final folder structure will be something like this

ProductdemoApplication/
│
├── src/
│   ├── main/
│   │   ├── java/
│   │   │   └── net/
│   │   │       └── camelcodes/
│   │   │           ├── ProductdemoApplication.java 
│   │   │           ├── controller/
│   │   │           │   └── ProductController.java
│   │   │           ├── model/
│   │   │           │   └── Product.java
│   │   │           ├── repository/
│   │   │           │   └── ProductRepository.java
│   │   │           └── service/
│   │   │               └── ProductService.java
│   │   └── resources/
│   │       └── application.properties
│   └── test/
│
├── build.gradle
└── settings.gradle

Click here to read the full article on the new blog