Tuition Classes Management API

This Spring Boot application manages tuition classes, students, and subjects. It supports CRUD operations and searching for students by name, subjects by name, and classes by student or subject. Using a MySQL database and Spring Data JPA, this API provides a robust backend for organizing tuition classes effectively.

Features

• Subjects Management:

  • Add, retrieve all, retrieve by ID, retrieve by name, delete subjects.

• Students Management:

  • Add, retrieve all, retrieve by ID, retrieve by name, delete students.

• Classes Management:

  • Add, retrieve all, retrieve by ID, retrieve by subject, retrieve by student, delete classes.

Tools Used

• Spring Boot: Java framework for building the API.
• Spring Data JPA: Simplifies data access using ORM.
• MySQL: Database management system for data persistence.
• Maven: Dependency management and build tool.
• Java: Programming langauge

Endpoints

Subjects

• Create Subject

  POST /tuition/subjects/add

• Get All Subjects

  GET /tuition/subjects/all

• Get Subject by ID

  GET /tuition/subjects/id/{id}

• Get Subjects by Name

  GET /tuition/subjects/name/{name}

• Delete Subject

  DELETE /tuition/subjects/{id}

Students

• Create Student

  POST /tuition/students/add

• Get All Students

  GET /tuition/students/all

• Get Student by ID

  GET /tuition/students/id/{id}

• Get Students by Name

  GET /tuition/students/name/{name}

• Delete Student

  DELETE /tuition/students/{id}

Classes

• Create Class

  POST /tuition/classes/add

• Get All Classes

  GET /tuition/classes/all

• Get Class by ID

  GET /tuition/classes/id/{id}

• Get Classes by Subject

  GET /tuition/classes/subject/{subjectId}

• Get Classes by Student

  GET /tuition/classes/student/{studentId}

• Delete Class

  DELETE /tuition/classes/{id}

Contact Information

• Developer: Shiv Prakash Verma
• Email: shivprakashlps@gmail.com
• College: IIT Ropar