Skip to content

Latest commit

 

History

History
199 lines (135 loc) · 3.46 KB

README.md

File metadata and controls

199 lines (135 loc) · 3.46 KB
Raw

Files

  • StudentController.java
  • StudentRepository.java
  • StudentH2Service.java
  • StudentRowMapper.java
  • Student.java

And also given a database file school which contains a student table. The student table initially contains details of 20 students.

Student Table

Columns Type
studentId INTEGER
studentName TEXT
gender TEXT
standard INTEGER

Use only STUDENT as a table name in your code while writing queries.

Completion Instructions

  • Student.java: Student class should contain the following attributes.

    Attribute Type
    studentId int
    studentName String
    gender String
    standard int

  • StudentRepository.java: Create an interface containing required methods.

  • StudentH2Service.java: Update the service class with logic for managing student data.

  • StudentController.java: Create the controller class to handle HTTP requests.

  • StudentRowMapper.java: Create a class which implements the Rowmapper Interface.

Implement the following APIs.

API 1

Path: /students

Method: GET

Description:

Returns a list of all students in the school.

Response

[
    {
        "studentId": 1,
        "studentName": "John",
        "gender": "Male",
        "standard": 1
    },
   ...
]

API 2

Path: /students

Method: POST

Description:

Creates a new student in the student table. The studentId is auto-incremented. Also, returns the student details added.

Request

{
  "studentName": "Prince",
  "gender": "Male",
  "standard": 4
}

Response

{
    "studentId": 21,
    "studentName": "Prince",
    "gender": "Male",
    "standard": 4
}

API 3

Path: /students/bulk

Method: POST

Description:

Creates multiple students in the student table and returns a text containing the numbers of students added.

Request

For example, the below request object contains details of 4 students.

[
    {
        "studentName": "Jack",
        "gender": "Male",
        "standard": 8
    },
    ...
]

Response


Successfully added 4 students

The controller method that handles this API 3 consists of the parameter of type ArrayList<Student>.

API 4

Path: /students/{studentId}

Method: GET

Description:

Returns a student based on the studentId. If the given studentId is not found in the student table, raise ResponseStatusException with HttpStatus.NOT_FOUND.

Success Response

{
    "studentId": 13,
    "studentName": "Olivia",
    "gender": "Female",
    "standard": 3
}

API 5

Path: /students/{studentId}

Method: PUT

Description:

Updates the details of a student in the student table based on the studentId. Also, return the updated student details from the student table using the studentId.

Request

{
    "studentName": "Yuvi"
    "gender": "Male",
    "standard": 6
}

Success Response

{
    "studentId": 3,
    "studentName": "Yuvi",
    "gender": "Male",
    "standard": 6
}

API 6

Path: /students/{studentId}

Method: DELETE

Description:

Deletes a student from the student table based on the studentId.

Do not modify the code in SchoolApplication.java