Skip to content

codefuser/student-management-system-java

Folders and files

NameName
Last commit message
Last commit date

Latest commit

Β 

History

8 Commits
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 

Repository files navigation

πŸŽ“ 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 πŸ”₯

About

A console-based Student Management System built using Java, JDBC, and MySQL with full CRUD operations and validation features.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors

Languages