Skip to content

Latest commit

 

History

History
312 lines (198 loc) · 5.6 KB

File metadata and controls

312 lines (198 loc) · 5.6 KB

🎓 Student Management System

Java + JDBC + MySQL CRUD Application 🚀




🚀 About Project

A professional console-based Student Management System built using:

✅ Java
✅ JDBC
✅ MySQL
✅ Object-Oriented Programming
✅ DAO Design Pattern

This project performs complete CRUD operations with validation and database integration.


✨ Features

Feature Status
Add Student
View Students
Search Student
Update Student
Delete Student
Email Validation
Phone Validation
Duplicate Email Prevention
Loop Menu System
JDBC Connectivity

🎞️ Tech Stack


📂 Project Structure

StudentManagementSystem
│
├── lib
├── src
│   ├── dao
│   ├── db
│   ├── model
│   ├── ui
│   └── App.java
│
├── screenshots
├── README.md
└── .gitignore

🗄️ Database Configuration

Database Name

student_management_system

Table Name

students

⚡ How To Run

1️⃣ Clone Repository

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

2️⃣ Open Project

Open project in VS Code.


3️⃣ Compile Project

javac -cp ".;../lib/mysql-connector-j-9.7.0.jar" App.java

4️⃣ Run Project

java -cp ".;../lib/mysql-connector-j-9.7.0.jar" App

📸 Project Screenshots


🖥️ Main Menu


➕ Add Student


📋 View Students


🔍 Search Student


✏️ Update Student


❌ Delete Student


🗄️ MySQL Database


📚 Concepts Used

Concept Used
OOP Concepts
DAO Pattern
JDBC Connectivity
PreparedStatement
ResultSet
CRUD Operations
Validation Logic
Exception Handling

🌟 Support This Project


❤️ Give Support


🌐 Connect With Me


🚀 Future Improvements

🔹 Swing GUI
🔹 JavaFX UI
🔹 Login System
🔹 Admin Dashboard
🔹 CSV Export
🔹 File Handling
🔹 Authentication System


👨‍💻 Author

Joseph


🔥 Thank You For Visiting My Project 🔥