Why JPA matters for database access in Spring Boot - See It in Action

Why JPA Matters for Database Access

📖 Scenario: You are building a simple Spring Boot application to manage a list of books in a library. You want to store book information in a database and access it easily without writing complex SQL queries.

🎯 Goal: Build a Spring Boot project that uses JPA to map a Book entity to a database table and retrieve all books using a repository interface.

📋 What You'll Learn

Create a Book entity class with fields id, title, and author

Create a Spring Data JPA repository interface called BookRepository

Use the repository to fetch all books from the database

Configure the application to use an in-memory H2 database

💡 Why This Matters

🌍 Real World

Many applications need to store and retrieve data from databases. JPA helps developers work with databases using Java objects instead of SQL queries.

💼 Career

Understanding JPA and Spring Data JPA is essential for Java backend developers working with databases in enterprise applications.

1

Create the Book entity class

Create a Java class called Book in the package com.example.library. Add private fields Long id, String title, and String author. Annotate the class with @Entity and the id field with @Id and @GeneratedValue.

Spring Boot

// Your code here to create the Book entity class with @Entity, @Id, and @GeneratedValue annotations

Need a hint?

Use @Entity on the class and @Id with @GeneratedValue on the id field to let JPA know this is a database entity.

2

Create the BookRepository interface

Create an interface called BookRepository in the package com.example.library. Make it extend JpaRepository<Book, Long> to enable basic CRUD operations.

Spring Boot

package com.example.library;

// Your code here to create BookRepository interface extending JpaRepository

Need a hint?

Extend JpaRepository with the entity Book and primary key type Long to get database methods automatically.

3

Fetch all books using the repository

In a Spring Boot @Service class called LibraryService in package com.example.library, inject BookRepository and create a method getAllBooks() that returns List<Book> by calling bookRepository.findAll().

Spring Boot

package com.example.library;

import org.springframework.stereotype.Service;
import java.util.List;

// Your code here to create LibraryService with getAllBooks() method

Need a hint?

Use constructor injection for BookRepository and call findAll() inside getAllBooks().

4

Configure Spring Boot to use H2 database

Add the following properties to src/main/resources/application.properties: spring.datasource.url=jdbc:h2:mem:testdb, spring.datasource.driverClassName=org.h2.Driver, spring.jpa.database-platform=org.hibernate.dialect.H2Dialect, and spring.h2.console.enabled=true.

Spring Boot

# Your code here to add H2 database configuration properties in application.properties

Need a hint?

These properties configure Spring Boot to use an in-memory H2 database and enable the H2 console for easy access.