Mysql CURD API using Spring Boot, MySQL, JPA, Hibernate Rest

Requirements

Install Mysql

brew install mysql

brew services start mysql

###Create project from https://start.spring.io

Add dependency :

Spring Boot DevTools DEVELOPER TOOLS, Spring Data JPA SQL, Spring Web WEB, MySQL Driver SQL, Spring Security SECURITY, jakarta validation

Steps to Setup

1. Clone the application

git clone 

2. Create Mysql database

create database yourdatabaseName

3. Change mysql username and password as per your installation

• open src/main/resources/application.properties

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

4. Build and run the app using maven

you can run the app without packaging it using -

mvn spring-boot:run

The app will start running at http://localhost:8080.

Rest APIs

GET API :

/users : Fetch all the users present in database

curl --location --request GET 'http://localhost:8080/users' \
--header 'Content-Type: application/json' \
--data-raw ''

Post API

/addMember : Create an user and stored in mysql


curl --location --request POST 'http://localhost:8080/addMember' \
--header 'Content-Type: application/json' \
--data-raw '{
"memberID": 5536,
"name": "ASHISH Singh",
"emailId": "Ashishsdet88@gmail.com"
}'