Creating REST API with Java Spring Boot + Oracle Database + JBoss Server #Part2 — Learning Java

INTRODUCTION

After the previous article where we set up the project and configured the Spring Boot connection with the JBoss Server, now we move on to creating a simple REST API using Spring Boot.

PROJECT STRUCTURE

As usual, I will create a project structure based on the DAO, Service, and Controller layers. Briefly, this article will only discuss these three main layers.

Project Structure

DAO Layer

This layer is used to access queries from Spring Boot to Oracle/Database. As briefly explained in the previous article, in the DAO Class, we use the PreparedStatement function to execute queries. In the insert method, the executeUpdate function is commonly used to execute Insert or Update queries. The resultSet function is usually used for Select queries to extract rows of query results.

Interface Dao Class