Spring Boot, Hibernate, MySQL example: CRUD app

This content originally appeared on DEV Community and was authored by Tien Nguyen

In this tutorial, we're gonna build a Spring Boot, Hibernate, MySQL CRUD example that interacts with MySQL database. You'll know:

How to configure Spring Data JPA, Hibernate to work with MySQL Database
How to define Data Models and Repository interfaces
Way to create Spring Rest Controller to process HTTP requests
Way to use Spring Data JPA to interact with MySQL Database

Full Article: Spring Boot, Hibernate, MySQL example: Build CRUD app

Overview of Spring Boot, Hibernate, MySQL example

We will build a Spring Boot + MySQL CRUD example for a Tutorial application in that:

Each Tutotial has id, title, description, published status.
Apis help to create, retrieve, update, delete Tutorials.
Apis also support custom finder methods such as find by published status or by title.

These are APIs that we need to provide:

Methods	Urls	Actions
POST	/api/tutorials	create new Tutorial
GET	/api/tutorials	retrieve all Tutorials
GET	/api/tutorials/:id	retrieve a Tutorial by `:id`
PUT	/api/tutorials/:id	update a Tutorial by `:id`
DELETE	/api/tutorials/:id	delete a Tutorial by `:id`
DELETE	/api/tutorials	delete all Tutorials
GET	/api/tutorials/published	find all published Tutorials
GET	/api/tutorials?title=[keyword]	find all Tutorials which title contains `keyword`

We make CRUD operations & finder methods with Spring Data JPA's JpaRepository.
The database could be PostgreSQL or MySQL depending on the way we configure project dependency & datasource.

Technology

Java 8
Spring Boot 2 (with Spring Web MVC, Spring Data JPA)
MySQL
Maven

Project Structure

Let me explain it briefly.

– Tutorial data model class corresponds to entity and table tutorials.
– TutorialRepository is an interface that extends JpaRepository for CRUD methods and custom finder methods. It will be autowired in TutorialController.
– TutorialController is a RestController which has request mapping methods for RESTful requests such as: getAllTutorials, createTutorial, updateTutorial, deleteTutorial, findByPublished...
– Configuration for Spring Datasource, JPA & Hibernate in application.properties.
– pom.xml contains dependencies for Spring Boot and MySQL/PostgreSQL.

Video

This is demo video and brief instruction of Spring Boot Rest Apis with Hibernate, MySQL example using Spring Data JPA:

Source Code

For step by step instruction and Github, please visit:
Spring Boot, Hibernate, MySQL example: Build CRUD app

Overview of Spring Boot, Hibernate, MySQL example

Technology

Project Structure

Video

Source Code

Further Reading

Related Posts