This is the example that shows you how to build spring boot REST API that connects to MySQL database using Spring JdbcTemplate
This is the example project that shows you how to build Spring boot REST API that connects to MySQL databse using Spring JdcbTemplate.
We will create a Employee REST API, following are the rest end points
GET /api/v1/employees
[
{
"id": 1,
"name": "Bushan",
"location": "India",
"department": "IT"
},
{
"id": 2,
"name": "Bharath",
"location": "India",
"department": "Sales"
},
{
"id": 3,
"name": "Chaitra",
"location": "India",
"department": "IT"
}
]
GET /api/v1/employees/${id}
Parameter | Type | Description |
---|---|---|
id |
int |
Required. Id of employee to fetch |
{
"id": 2,
"name": "Bharath",
"location": "India",
"department": "Sales"
}
POST /api/v1/employees
Parameter | Type | Description |
---|---|---|
employee reference |
Employee |
Required. Request body of employee |
{
"name": "Bharath",
"location": "India",
"department": "Sales"
}
PUT /api/v1/employees/${id}
Parameter | Type | Description |
---|---|---|
id |
int |
Required. Id of employee to update |
employee reference |
Employee |
Required. Request body of employee |
{
"name": "Bharath",
"location": "India",
"department": "Sales"
}
DELETE /api/v1/employees/${id}
Parameter | Type | Description |
---|---|---|
id |
int |
Required. Id of employee to delete |
Download the project and import it to any IDE.
Open the class SpringbootjdbcApplication.java
and run as Java application.
Insert gif or link to demo
Here are some related projects