Spring Boot REST API

This is a project that shows you how to build Spring boot REST API that connects to MySQL databse using Spring JdcbTemplate.
Database used is called "university". All data in the database is for test purposes only.

Using "Postman" application to be able to use Post, Put, Delete operations. Ideally it is implemented such that React/Angular is used on client side instead.

Features

• Get all students
• Get single student by id
• Post students
• Update student by id
• Delete students by id

API Reference

Creation of a Student REST API, following are the rest end points

Get all students

  GET .../students

Sample Response

 [
  { 
    "name":"Zhang",
    "dept_name":"Comp. Sci.",
    "tot_cred":102,
    "id":128
  },
  {
    "name":"Shankar",
    "dept_name":"Comp. Sci.",
    "tot_cred":32,
    "id":12345
   },
   {
    "name":"Brandt",
    "dept_name":"History",
    "tot_cred":80,
    "id":19991
   },
   {
    "name":"Chavez",
    "dept_name":"Finance",
    "tot_cred":110,
    "id":23121
   },
   {
    "name":"Peltier",
    "dept_name":"Physics",
    "tot_cred":56,
    "id":44553
   },
   {
    "name":"Levy",
    "dept_name":"Physics",
    "tot_cred":46,
    "id":45678
   },
   {
    "name":"Williams",
    "dept_name":"Comp. Sci.",
    "tot_cred":54,
    "id":54321
   },
   {
    "name":"Sanchez",
    "dept_name":"Music",
    "tot_cred":38,
    "id":55739
   },
   {
    "name":"Snow",
    "dept_name":"Physics",
    "tot_cred":0,
    "id":70557
   },
   {
    "name":"Brown",
    "dept_name":"Comp. Sci.",
    "tot_cred":58,
    "id":76543
   },
   {
    "name":"Aoi",
    "dept_name":"Elec. Eng.",
    "tot_cred":60,
    "id":76653
   },
   {
    "name":"Bourikas",
    "dept_name":"Elec. Eng.",
    "tot_cred":98,
    "id":98765
   },
   {
    "name":"Tanaka",
    "dept_name":"Biology",
    "tot_cred":120,
    "id":98988
   }
  ]

Get single student

  GET .../students/{id}

Parameter	Type	Description
id	int	Required. Id of student to fetch

Sample Response

{
    "name": "Zhang",
    "dept_name": "Comp. Sci.",
    "tot_cred": "102",
    "id": "128"
}

Save student

  POST .../students

Parameter	Type	Description
student reference	Student	Required. Request body of student

Sample Request

{
    "name": "Kevin",
    "dept_name": "Comp. Sci.",
    "tot_cred": "133",
    "id": "13039"
}

Update student

  PUT .../students/{id}

Parameter	Type	Description
id	int	Required. Id of student to update
students reference	Student	Required. Request body of student

Sample Request

{
    "name": "Kevin",
    "dept_name": "History",
    "tot_cred": "136",
    "id": "13039"
}

Delete student

  DELETE .../students/{id}

Parameter	Type	Description
id	int	Required. Id of student to delete

Deleting student with id: 13039 from students"

Authors

• @kkemmere