Spring boot, Hibernate, MySQL REST API

A simple Spring boot application that demonstrates the usage of RESTful API using Spring boot, Hibernate and MySQL.

Tools and Technologies used

• Java 1.8
• Spring boot 2.1.1
• MySQL
• JPA
• Hibernate
• Maven
• Eclipse Oxygen

Steps to install

1. Clone the application

git clone https://github.com/scbushan05/spring-boot-hibernate-mysql-rest-api.git

2. Create MySQL database

CREATE DATABASE crudapi

3. Create table or Run the SQL script file

CREATE TABLE tbl_employee
(
	id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
    	name VARCHAR(255),
    	gender VARCHAR(255),
    	department VARCHAR(255),
    	dob DATE
)

4. Change MySQL Username and Password as per your MySQL Installation

• open src/main/resources/application.properties file.

• change spring.datasource.username and spring.datasource.password as per your installation

5. Run the app

You can run the spring boot app by typing the following command -

mvn spring-boot:run

You can also package the application in the form of a jar file and then run it like so -

mvn package
java -jar target/crudapi-0.0.1-SNAPSHOT.jar

The server will start on port 8080.

Explore Rest APIs

The app defines following CRUD APIs.

GET /api/employee

POST /api/employee

GET /api/employee/{id}

PUT /api/employee

DELETE /api/employee/{id}

You can test them using postman or any other rest client.

Learn more

You can find the video tutorial for this application on my youtube channel -

https://www.youtube.com/playlist?list=PLA7e3zmT6XQXIFcweUahWz2rQtmeI8dnl/

You can find the tutorial for this application on my blog -

http://bushansirgur.in/

You can subscribe to our Youtube channel -

https://www.youtube.com/b2tech/

You can join our free udemy courses also -

https://udemy.com/user/bushansirgur/