🎓 Student Management System

A full-featured Student Management System built using Spring MVC, JSP, JSTL, JDBC, and MySQL. This project allows administrators to add, view, update, and delete student records efficiently via a web interface.

🛠 Tech Stack

• Backend: Java, Spring MVC, JDBC
• Frontend: JSP, HTML, CSS, Bootstrap
• Database: MySQL
• Server: Apache Tomcat
• IDE: Eclipse

---

📌 Features

• ➕ Add new student
• 📄 View all students
• ✏️ Update student details
• ❌ Delete student
• 🔍 Search student by name or ID
• 🧹 Form validations and user feedback

---

📸 Screenshots

You can add images here like:

![Homepage](screenshots/homepage.png)
![Add Student](screenshots/add-student.png)

---

📃 Database Setup

Run the following SQL to create the database and table:

CREATE DATABASE studentdb;

USE studentdb;

CREATE TABLE students (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    email VARCHAR(100) NOT NULL,
    course VARCHAR(100) NOT NULL,
    country VARCHAR(50)
);

---

🚀 How to Run

1. Clone the repository

   git clone https://github.com/Ranjithkumarbandari/student-management-system.git

2. Import into Eclipse as an existing Maven or Dynamic Web Project.

3. Configure Tomcat server in Eclipse and add the project to the server.

4. Update database connection inside StudentDAO.java:

   private String jdbcURL = "jdbc:mysql://localhost:3306/studentdb";
   private String jdbcUsername = "root";
   private String jdbcPassword = "My_password";

5. Run the project on Tomcat and navigate to: http://localhost:8080/student-management-system/

---

📁 Project Structure

student-management-system/
├── src/
│   └── com.cg.SpringMVCProject/
│       ├── controller/
│       ├── service/
│       ├── serviceimpl/
│       ├── entity/
│       └── repository/
├── WebContent/
│   ├── WEB-INF/
│   │   └── web.xml
│   ├── views/
│   │   ├── list-students.jsp
│   │   ├── add-student.jsp
│   │   └── update-student.jsp
│   └── index.jsp

---

👨‍💼 Author

Ranjithkumar Bandari 📧 ranjithkumarbandari09@gmail.com 🔗 LinkedIn

---

⭐ Show your support

If you found this project helpful, please give it a ⭐ on GitHub!

---

📄 License

This project is licensed under the MIT License.