README: |
A web-based application built using Java, JSP/Servlets, JDBC, and MySQL to manage student records and marks.
The system provides teacher authentication and allows CRUD operations (Create, Read, Update, Delete) on students and their marks.
- 🔑 Teacher Authentication – Only teachers can log in and manage data
- 👨🎓 Student Management – Add, view, update, and delete student details
- 📊 Marks Management – Enter and update marks for students
- 🗄 Database Integration – Persistent storage with MySQL
- 🌐 Web-based – Can be accessed from a browser
- Backend: Java, JSP, Servlets
- Database: MySQL (via JDBC)
- Frontend: HTML, CSS (basic JSP pages)
- Server: Apache Tomcat
-
Clone the repository
git clone https://github.com/PrajwalItnal/Student-Marks-Management.git
-
Import into IDE (Eclipse/IntelliJ) as a Java Web Project.
-
Set up MySQL Database
- Create a database (e.g.,
student_db) - Import the
marks.sqlfile (to be added indatabase/folder).
- Create a database (e.g.,
-
Update JDBC Configuration in DAO classes:
String url = "jdbc:mysql://localhost:3306/student_db"; String user = "root"; String pass = "your_password";
-
Deploy on Tomcat
- Run the project on Apache Tomcat server.
-
Access the App
- Go to http://localhost:8080/Student-Marks-Management
- Login using teacher credentials (default provided in database).
Student-Marks-Management/
│── src/
│ ├── controller/ # Servlets (handle requests)
│ ├── dao/ # JDBC database access
│ ├── model/ # JavaBeans (Student, Teacher, Marks)
│── WebContent/
│ ├── login.jsp # Teacher login page
│ ├── dashboard.jsp # Teacher dashboard
│ ├── addStudent.jsp # Add student form
│ ├── viewStudents.jsp # Display student list
│── database/marks.sql # Database schema
│── README.md # Documentation
- ❌ Passwords stored in plain text (not secure)
- ❌ Basic UI/UX (no responsive design, plain JSP pages)
- ❌ Limited error handling (no input validation for incorrect data)
- ❌ No role-based access beyond teacher (e.g., admin/student logins missing)
- 🔒 Add password hashing (BCrypt/Argon2)
- 🎨 Improve UI with Bootstrap or a modern framework
- ✅ Add validation & error handling for inputs
- 👥 Add multiple roles (Admin, Teacher, Student)
- 📑 Generate marksheets/reports in PDF or Excel
✅ Functional (CRUD + authentication working)