Student Management System

The Student Management System is a Java-based application designed to manage student records. The application uses JDBC (Java Database Connectivity) to interact with relational databases for storing, retrieving, and managing student data efficiently. This project demonstrates basic CRUD (Create, Read, Update, Delete) operations in a database through a console based interface.

Features

• Add a new Student : Insert new student records into the database.
• View all students : Fetch and display all student records.
• Search a student : Search for a student by ID
• Update student details : Manipulate the existing student information.
• Delete a student : Remove a student's record from the database.

Database Setup

• This project is done in MySQL. (I'll also add postgresql in near future)
• Create a database under any name (Ex: Student, StudentData etc) and name the schema as StudentTable.
• Under the schema, create a table and set the values for the table.
• Once the database is setup, you are ready to perform jdbc operations.

How to Run and Execute

• Clone the respository
• Inside StudentDAOImplement class, you need to enter your schema name, username and password.
• After entering the credentials, head over to driver class and run the application.