Skip to content

Ashishjublsdet/spring-boot-mysql-example

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

14 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

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"
}'

About

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

Topics

Resources

Stars

Watchers

Forks

Packages

No packages published

Languages