SpringBoot-Database

1. Project-1. Spring Boot REST API JDBC MySQL Gradle
   • Gradle project provides Spring Boot and JDBC (using Gradle)
2. Project-2. Spring Boot REST API JDBC MySQL Maven
   • Family Member small project provides Spring Boot and JDBC template (using MySQL) implementation. In case of, Spring Boot using Maven configuration, and DB (database) using JDBC (only template not JPA ).

Core data for Spring Boot with Database

This provides Database implementation in the Spring Boot. Indeed, We should breifly inform here concept of Spring, Spring Boot, JDBC, JPA, H2.

Spring

• The Spring Framework is an application framework and inversion of control container for the Java platform. Spring is HA (high avilability).

Spring Boot

• Most Spring Boot applications need minimal Spring configuration. Features. Create stand-alone Spring applications

JPA

• JPA (The Java Presistence API) = This module deals with enhanced support for JPA based data access layers.Indeed, the JPA is set of the rules to interfaces. JPA follows Object-Relation Mapping (ORM). It is a set of interfaces. It also provides a runtime EntityManager API for processing queries and transactions on the objects against the database. It uses a platform-independent object-oriented query language JPQL (Java Persistent Query Language).

Why should we use JPA? JPA is simpler, cleaner, and less labor-intensive than JDBC, SQL, and hand-written mapping. JPA is suitable for non-performance oriented complex applications.

API (Application programming interface) is a document that contains a description of all the features of a product or software. It represents classes and interfaces that software programs can follow to communicate with each other. An API can be created for applications, libraries, operating systems, etc.

JPA Implementations JPA is an open-source API. There is various enterprises vendor such as Eclipse, RedHat, Oracle, etc. that provides new products by adding the JPA in them. There are some popular JPA implementations frameworks such as Hibernate, EclipseLink, DataNucleus, etc. It is also known as Object-Relation Mapping (ORM) tool.

JDBC

• Java Database Connectivity (JDBC) is an application programming interface (API) for the programming language Java, which defines how a client may access a database.

Architecute of the Project Implementation

H2

• H2 is a relational database management system written in Java. It can be embedded in Java applications or run in client-server mode.