Skip to content

Creating my own Database, connects frontend with a backend, CRUD functionality for managing student records, deployed on Tomcat, Built with Jakarta Servlets, JSP, JDBC, and MySQL

Notifications You must be signed in to change notification settings

Jainil570/StudentManagement

Repository files navigation

Student Management System

A dynamic database project that seamlessly connects the front-end with the back-end to manage student records. This project demonstrates full CRUD (Create, Read, Update, Delete) functionality in a web environment and is built using modern Java technologies.

Overview

The Student Management System is a robust, full-stack application that:

  • Stores and manages student records (name, email, course, etc.).
  • Provides an interactive, responsive frontend (JSP) for data entry and display.
  • Leverages Servlets and JDBC for dynamic interaction with a MySQL database.
  • Runs on Apache Tomcat 11 and is developed with Jakarta EE standards.
  • Serves as a proof-of-concept for creating your own dynamic database-driven application connecting both frontend and backend seamlessly.

Note: A video demonstration of the working model is available in the repository!

Features

  • Dynamic Data Management:
    Create, update, delete, and list student records in real-time.
  • Robust Database Connectivity:
    Utilizes JDBC for secure, efficient communication with a MySQL database.
  • Clean, Modular Architecture:
    Well-structured code separating concerns between data access (DAO), business logic (Servlets), and presentation (JSP).
  • Responsive User Interface:
    Simple and intuitive forms with meaningful feedback for user actions.
  • Scalable Design:
    Easy to extend with additional features such as search, filtering, and role-based access.

Technologies Used

  • Frontend:
    • JSP, HTML, CSS
  • Backend:
    • Jakarta Servlets (using Tomcat 11)
    • JDBC
  • Database:
    • MySQL
  • Build Tools:
    • Maven (optional) / Eclipse IDE for Enterprise Java and Web Developers
  • Version Control:
    • Git & GitHub

Pros

  • Full-Stack Integration:
    • Demonstrates a complete end-to-end solution.
  • Modular Design:
    • Easy to maintain and extend.
  • Real-World Relevance:
    • Applicable to a variety of database-driven applications.

Cons

  • Basic UI:
    • The current design is simple and could be enhanced with modern UI frameworks.
  • Limited Features:
    • More advanced features (such as search or role-based access) can be added for a more comprehensive system.
  • Video Demonstration
    • A video of the working model is available in the repository. Please check the Video Demo for a detailed walkthrough of the system in action.

License

  • This project is licensed under the MIT License - see the LICENSE file for details.

About

Creating my own Database, connects frontend with a backend, CRUD functionality for managing student records, deployed on Tomcat, Built with Jakarta Servlets, JSP, JDBC, and MySQL

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages