Tag: jpa repository

Spring Boot Rest XML example – Web service with XML Response

bezkoder 3 Comments

In this Spring Boot tutorial, I will show you a Restful Web service example in that Spring REST Controller can receive/consume XML Request Body and return XML Response instead of JSON. We also use Spring Data JPA to interact with database (MySQL/PostgreSQL).

More Practice:
– Documentation: Spring Boot + Swagger 3 example (with OpenAPI 3)
– Caching: Spring Boot Redis Cache example
– Spring Boot Thymeleaf CRUD example
– Spring Boot, Spring Data JPA – Building Rest CRUD API example
– Spring Boot + GraphQL + MySQL example

Associations:
– Spring Boot One To One example with JPA, Hibernate
– Spring Boot One To Many example with JPA, Hibernate
– Spring Boot Many to Many example with JPA, Hibernate

Deployment:
– Deploy Spring Boot App on AWS – Elastic Beanstalk
– Docker Compose: Spring Boot and MySQL example

Read More

Spring Boot Pagination and Sorting example

bezkoder 5 Comments

We’ve known how to build Spring Boot Rest CRUD Apis with Spring Data JPA. In this tutorial, I will continue to make Pagination and Sorting example using Spring JPA and Pageable.

Related Post:
– Spring Boot Thymeleaf Pagination and Sorting example
– Spring Boot, Spring Data JPA – Rest CRUD API example
– Spring Boot Sort/Order by multiple Columns | Spring Data JPA
– Spring Boot @ControllerAdvice & @ExceptionHandler example
– Spring Boot Unit Test for JPA Repository
– Spring Boot Unit Test for Rest Controller
– Documentation: Spring Boot Swagger 3 example
– Caching: Spring Boot Redis Cache example
– Validation: Validate Request Body in Spring Boot

More Practice:
– Spring Boot Token based Authentication with Spring Security & JWT
– Deploy Spring Boot App on AWS – Elastic Beanstalk
– Docker Compose: Spring Boot and MySQL example
– Docker Compose: Spring Boot and Postgres example

Clients for this Server:
– React with Material-UI / React with react-table v7
– Angular 8 / Angular 10 / Angular 11 / Angular 12 / Angular 13 / Angular 14 / Angular 15
– Vue with Bootstrap / Vuetify

Read More

Spring Data JPA Sort/Order by multiple Columns | Spring Boot

bezkoder 5 Comments

In previous tutorial, we’ve known how to build Spring Boot Rest CRUD Apis with Spring Data JPA. Today I will show you how to sort/order result by multiple Columns in Spring Boot with Spring Data JPA. You also know way to apply sorting and paging together.

Related Posts:
– JPA – filter by multiple Columns
– Spring Boot, Spring Data JPA – Rest CRUD API example
– Spring Boot Pagination & Filter example | Spring JPA, Pageable
– Spring Boot @ControllerAdvice & @ExceptionHandler example

More Practice:
– Spring Boot Token based Authentication with Spring Security & JWT
– Spring Boot One To One example with JPA, Hibernate
– Spring Boot One To Many example with JPA, Hibernate
– Spring Boot Many to Many example with JPA, Hibernate
– Spring Boot Unit Test for JPA Repository
– Spring Boot Unit Test for Rest Controller
– Documentation: Spring Boot Swagger 3 example
– Caching: Spring Boot Redis Cache example
– Validation: Spring Boot Validate Request Body

Read More

Spring Boot Download CSV file from Database example

bezkoder 3 Comments

A CSV (comma-separated values) file is a plain text file that contains data which format is described in RFC4180. Each row has a number of fields, separated by commas. Each line should contain the same number of fields throughout the file. In this tutorial, I will show you how to build Spring Boot download CSV file Rest API example that exports data from MySQL Database table using & Apache Commons CSV.

Related Posts:
– Spring Boot: Upload & Read CSV file into MySQL Database | Multipart File
– Spring Boot Multipart File upload example
– How to upload multiple files in Java Spring Boot

Excel file instead: Spring Boot: Download Excel file example

Deployment:
– Deploy Spring Boot App on AWS – Elastic Beanstalk
– Docker Compose: Spring Boot and MySQL example

Read More

@DataJpaTest example for Spring Data Repository Unit Test

bezkoder 5 Comments

Nowadays Unit Test is so important in Software Development, and Spring Framework also provides @DataJpaTest annotation to make writing test for JPA Repository more simpler. In this tutorial, we’re gonna look at how to apply @DataJpaTest in our Spring Boot Project with TestEntityManager, then run with JUnit 5.

This tutorial gives you an additional unit test for the Post:
Spring Boot, Spring Data JPA: CRUD example

More Practice:
– Spring Boot – test Rest Controller with @WebMvcTest
– JPA Repository query example in Spring Boot
– Spring Boot Token based Authentication with Spring Security example
– Spring Boot @ControllerAdvice & @ExceptionHandler example
– Documentation: Spring Boot Swagger 3 example
– Caching: Spring Boot Redis Cache example
– Validation: Spring Boot Validate Request Body

Associations:
– Spring Boot One To One example with JPA, Hibernate
– Spring Boot One To Many example with JPA, Hibernate
– Spring Boot Many to Many example with JPA, Hibernate

Read More