Spring Boot Tutorial
Creating Project
Project Components
Tool Suite
- hello-world-example
- project-deployment-using-tomcat
Spring Boot AOP
Spring Boot Database
Spring Boot View
- sb-thymeleaf-view
SB Caching
Spring Boot Misc
Spring Boot - RESTful
Spring Tutorial
- spring-tutorial
Spring Cloud
- spring-cloud-tutorial
Spring Microservices
- spring-microservices-tutorial
Interview Questions
- spring-interview

Updating GET Methods on User Resource to Use JPA

In this topic, we will create a service that retrieves all the users.

Still, we are using the UserResource, which talks to the in-memory. Now we will create a new UserResource that will talk to the embedded database. Let's create a new user resource.

Step 1: Copy the UserResource.java file and paste it in the user package. Rename it with UserJPAResource.

Step 2: Now, we have two URIs with the same name that create conflict. To remove this conflict, we will add /jpa in UserJPAResource.java file.

UserJPAResource.java

     package com.w3cschoool.server.main.user;
import static org.springframework.hateoas.mvc.ControllerLinkBuilder.*;
import java.net.URI;
import java.util.List;
import javax.validation.Valid;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.hateoas.Resource;
import org.springframework.hateoas.mvc.ControllerLinkBuilder;
import org.springframework.http.ResponseEntity;
import org.springframework.web.bind.annotation.DeleteMapping;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RestController;
import org.springframework.web.servlet.support.ServletUriComponentsBuilder;
@RestController
public class UserJPAResource 
{
@Autowired
private UserDaoService service;
@GetMapping("/jpa/users")
public List<User> retriveAllUsers()
{
return service.findAll();
}
@GetMapping("/jpa/users/{id}")
public Resource<User> retriveUser(@PathVariable int id)
{
User user= service.findOne(id);
if(user==null)
//runtime exception
throw new UserNotFoundException("id: "+ id);
//"all-users", SERVER_PATH + "/users"
//retrieveAllUsers
Resource<User> resource=new Resource<User>(user);	//constructor of Resource class
//add link to retrieve all the users
ControllerLinkBuilder linkTo=linkTo(methodOn(this.getClass()).retriveAllUsers());
resource.add(linkTo.withRel("all-users"));
return resource;
}
//method that delete a user resource
@DeleteMapping("/jpa/users/{id}")
public void deleteUser(@PathVariable int id)
{
User user= service.deleteById(id);
if(user==null)
//runtime exception
throw new UserNotFoundException("id: "+ id);
}
//method that posts a new user detail and returns the status of the user resource
@PostMapping("/jpa/users")
public ResponseEntity<Object> createUser(@Valid @RequestBody User user)	
{
User sevedUser=service.save(user);	
URI location=ServletUriComponentsBuilder.fromCurrentRequest().path("/{id}").buildAndExpand(sevedUser.getId()).toUri();
return ResponseEntity.created(location).build();
}
}

    

But it is not really talking to the database. We need to create a spring data repository.

Step 3: Create an interface with the name UserRepository that extends JpaRepository. Specify the entity that has to be managed. We have specified User and Integer. Now we have the UserRepository ready.

UserRepository.java

     package com.w3cschoool.server.main.user;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.stereotype.Repository;
@Repository
public interface UserRepository extends JpaRepository<User, Integer>
{

}

    

Step 4: Create the use of UserResource. We have autowired the UserRepository interface in the UserJPAResource class.

     @Autowired
private UserRepository userRepository;

Step 5: Return the userRepository.findAll() in the retriveAllUsers() method.

     @GetMapping("/jpa/users")
public List<User> retriveAllUsers()
{
return userRepository.findAll();
}

    

The retriveAllUsers() is the only method that retrieve data form the embedded database, all the other methods retrieve data from the static array list.

Step 6: Open the Postman. Type the URI http://localhost:8080/jpa/users and send a GET request. It shows all the data that is fetched from the embedded database.

Updating GET Methods on User Resource to Use JPA

Again send a GET request with the URL http://localhost:8080/jpa/users/1. It returns the specified user id, i.e. 1, but it picks up data from memory.

But we are required to fetch data from the embedded database. We need to change the following services in the UserJPAResource.java.

     @GetMapping("/jpa/users")
public List<User> retriveAllUsers()
{
return userRepository.findAll();
}

    

In the following service, the findById() returns the Option of User whether user is null or not null. Whenever we use findById(), there is two possibilities: id exist or not exist. When it does not exist it comes with a proper object. We will check the user exist or not by the statement if(!user.isPresent()). If the user is not present it throws an exception.

     @GetMapping("/jpa/users/{id}")
public Resource<User> retriveUser(@PathVariable int id)
{
Optional<User> user= userRepository.findById(id);
if(user.isPresent())
//runtime exception
throw new UserNotFoundException("id: "+ id);
//"all-users", SERVER_PATH + "/users"
//retrieveAllUsers
Resource<User> resource=new Resource<User>(user.get());	//constructor of Resource class
//add link to retrieve all the users
ControllerLinkBuilder linkTo=linkTo(methodOn(this.getClass()).retriveAllUsers());
resource.add(linkTo.withRel("all-users"));
return resource;
}

    

Again send a GET request with the URL http://localhost:8080/jpa/users/1. It returns a specified user and the link to /jpa/users.

     {
"name": "John",
"dob": "2019-10-01"T0726:52.596+0000",
"_links": {
"all-users": {
"href": "http://localhost:8080/jpa/users"
}
}
}

    

Next TopicUpdating POST and DELETE methods on UserResource to use JPA

← prev next →

Hot Tutorials

HTML/CSS

JavaScript

Backend language

Development Framework

Database

Mobile development

Development tools

Big Data

XML Tutorial

Contact US

Email:jjw.quan@gmail.com

Spring Boot Tutorial

Creating Project

Project Components

Tool Suite

Spring Boot AOP

Spring Boot Database

Spring Boot View

SB Caching

Spring Boot Misc

Spring Boot - RESTful

Spring Tutorial

Spring Cloud

Spring Microservices

Interview Questions

Updating GET Methods on User Resource to Use JPA

Hot Tutorials

Python tutorial

Vue.js Tutorial

HTML Tutorial

Java Tutorial

PHP Tutorial

Spring Tutorial

JavaScript Tutorial

CSS Tutorial

jQuery Tutorial

SQL Tutorial

C Tutorial

HTML/CSS

HTML Tutorial

HTML5 Tutorial

CSS Tutorial

Bootstrap Tutorial

JavaScript

JavaScript Tutorial

Vue.js Tutorial

ReactJS Tutorial

jQuery Tutorial

Node.js Tutorial

TypeScript Tutorial

AngularJS Tutorial

JSON Tutorial

Ajax Tutorial

ES6 Tutorial

Angular 7 Tutorial

jQuery UI Tutorial

Backend language

Python tutorial

Java Tutorial

Node.js Tutorial

PHP Tutorial

Go Tutorial

C Tutorial

C++ Tutorial

C# Tutorial

Ruby Tutorial

JSP Tutorial

JSTL Tutorial

ASP.NET Tutorial

Perl Tutorial

Scala Tutorial

VBA Tutorial

Development Framework

Spring Tutorial

Spring Boot Tutorial

Django Tutorial

Servlet Tutorial

Struts 2 Tutorial

Hibernate Tutorial

Solr Tutorial

Database

SQL Tutorial

MySQL Tutorial

Oracle Tutorial

SQL Server Tutorial

PostgreSQL Tutorial

DB2 Tutorial

Redis Tutorial

SQLite Tutorial

MongoDB Tutorial

Memcached Tutorial