🎓 Student Management System – Backend

Project Overview

A RESTful Student Management System backend built using Spring Boot.
This application provides APIs to manage student records and persists data in a MySQL database using Spring Data JPA (Hibernate).

It serves as the backend for a React-based frontend application.

---

🔗 Frontend Repository:
👉 Student Management System – Frontend

---

🚀 Live Links

• Backend API Base URL: https://student-management-system-backend-jssl.onrender.com
• Students Endpoint: https://student-management-system-backend-jssl.onrender.com/students
• Frontend Live Demo: https://fullstack-studentdb-madhav.netlify.app/
• Note: The backend is hosted on a free instance, and may take ~1 minute to wake up on the first request.

---

✨ Features

🛠️ Core Functionality (CRUD APIs)

• Create: Add new student records
• Read: Fetch all students / fetch by Roll no
• Update: Update existing student details
• Delete: Remove student records from database

🔒 Technical Features

• RESTful API design
• Spring Data JPA with Hibernate ORM
• MySQL database integration
• CORS configuration for frontend communication
• Global exception handling
• Environment-based configuration (local & production)

---

🛠️ Tech Stack

• Backend Framework: Spring Boot
• Language: Java
• Database: MySQL
• ORM: Spring Data JPA (Hibernate)
• Build Tool: Maven
• Deployment: Render
• Frontend Hosting: Netlify

---

🏗️ System Architecture

• Client: React Frontend (Netlify)
• Server: Spring Boot REST API (Render)
• Database: MySQL (Railway)

---

⚡ API Endpoints

Method	Endpoint	Description	Request Body Example
GET	/	Displays welcome message	None
GET	/students	Get all students	None
GET	/students/{rollno}	Get student by rollno	{ "Roll no":12}
POST	/students	Add a new student	{ "name": "John", "Roll no":12, "Age":23, "Marks":99 }
PUT	/students/{rollno}	Update student by rollno	{ "name": "John", "Roll no":12, "Age":23, "Marks":76 }
DELETE	/students/{rollno}	Delete student by rollno	{ "Roll no":12}

---

🖼️ Screenshots

You can see the live frontend connected to this backend here:
Student Management System – Live Demo

Example Screenshots

---

☁️ Deployment on Render

1. Push your project to GitHub.
2. Connect the repo to Render.
3. Set environment variables for DB URL, username, and password.
4. Deploy to Render and use the generated live backend URL.

---

👤 Author

Madhav Agrawal

• Email: agrawalmad00@gmail.com

---

📄 License

This project is licensed under the MIT License.

---

📝 How it Works

1. React frontend sends HTTP requests to the backend.
2. Backend controllers handle the requests.
3. DAO layer executes SQL queries via JDBC.
4. Responses are sent back as JSON to the frontend.