Student Management System in Java

A desktop application for managing student records with a graphical user interface built using Java Swing and MySQL database. This system allows users to perform CRUD (Create, Read, Update, Delete) operations on student data including ID, name, major, phone, GPA, and date of birth.

Features

• 📝 Add, update, and delete student records
• 📊 View all student data in a table format
• 🔍 Search and filter student information
• 🗄️ MySQL database backend for persistent storage
• 🖥️ Simple and intuitive GUI using Java Swing

Requirements

• Java 8 or higher
• MySQL Server
• MySQL Connector/J (already included in lib/)

Setup

1. Clone this repository.
2. Import student_data.sql into your MySQL server to create the database and table.
3. Edit db.properties with your MySQL credentials.
4. Compile and run:

cd Student-Management-System-in-Java-main
javac -cp "lib/mysql-connector-j-8.0.33.jar" -d out src/*.java
java -cp "out;lib/mysql-connector-j-8.0.33.jar" Main

Project Structure

• src/ - Java source files
• lib/ - MySQL JDBC driver
• student_data.sql - SQL script to create the database
• db.properties - Database configuration (not committed)

Database Schema

The students table includes the following columns:

Column	Type	Description
Student_ID	INT	Unique identifier for each student
first_name	VARCHAR	Student's first name
last_name	VARCHAR	Student's last name
major	VARCHAR	Student's field of study
Phone	VARCHAR	Contact phone number
GPA	DECIMAL	Grade point average
DOB	DATE	Date of birth

Technologies Used

• Java - Core programming language
• Java Swing - GUI framework
• MySQL - Database management system
• JDBC - Database connectivity

Contributing

Contributions are welcome! Please feel free to submit a Pull Request.

License

This project is open source and available under the MIT License.