Skip to content

README.md

Latest commit

 

History

History
434 lines (302 loc) · 6.45 KB

README.md

File metadata and controls

434 lines (302 loc) · 6.45 KB
Raw

🎓 Student Management System

A console-based Student Management System developed using Java, JDBC, and MySQL. This project demonstrates CRUD operations, database connectivity, Object-Oriented Programming (OOP), and the DAO (Data Access Object) design pattern.

📌 Overview

This application allows users to manage student records from a console interface. It follows a modular architecture by separating database access, business logic, and user interaction into different packages.

The project was built to strengthen practical knowledge of:

  • Java Programming
  • JDBC Connectivity
  • MySQL Database
  • Object-Oriented Programming
  • DAO Design Pattern
  • CRUD Operations
  • Input Validation
  • Exception Handling
  • Git & GitHub

✨ Features

Feature Status
Add Student ✅
View Students ✅
Search Student ✅
Update Student ✅
Delete Student ✅
Email Validation ✅
Phone Validation ✅
Duplicate Email Prevention ✅
PreparedStatement ✅
Exception Handling ✅

🚀 Tech Stack

Technology Purpose
Java Programming Language
JDBC Database Connectivity
MySQL Database
Git Version Control
GitHub Repository Hosting
VS Code IDE

🏗️ Project Architecture

                +------------------+
                |    Console UI    |
                +---------+--------+
                          |
                          v
                +------------------+
                | Student Service  |
                +---------+--------+
                          |
                          v
                +------------------+
                |   Student DAO    |
                +---------+--------+
                          |
                          v
                +------------------+
                | JDBC Connection  |
                +---------+--------+
                          |
                          v
                +------------------+
                |     MySQL DB     |
                +------------------+

🔄 Application Flow

User

↓

Main Menu

↓

Choose Operation

↓

Input Validation

↓

DAO Layer

↓

PreparedStatement

↓

MySQL Database

↓

Success / Failure

↓

Console Output

📂 Project Structure

StudentManagementSystem
│
├── lib
│   └── mysql-connector-j.jar
│
├── screenshots
│
├── src
│   ├── dao
│   │    └── StudentDAO.java
│   │
│   ├── db
│   │    └── DBConnection.java
│   │
│   ├── model
│   │    └── Student.java
│   │
│   ├── ui
│   │    └── MainMenu.java
│   │
│   └── App.java
│
├── README.md
└── .gitignore

📦 Package Description

Package Responsibility
dao Performs CRUD operations
db Manages database connection
model Student entity class
ui Console interface
App.java Entry point of application

🗄️ Database

Database Name

student_management_system

Table

students

Database Schema

CREATE TABLE students (

id INT PRIMARY KEY AUTO_INCREMENT,

name VARCHAR(100) NOT NULL,

email VARCHAR(100) UNIQUE NOT NULL,

phone VARCHAR(15),

department VARCHAR(100)

);

ER Diagram

+------------------------------------------------+
|                 STUDENTS TABLE                 |
+------------------------------------------------+
| id (PK)                                       |
| name                                          |
| email                                         |
| phone                                         |
| department                                    |
+------------------------------------------------+

📚 Concepts Demonstrated

  • Object-Oriented Programming
  • DAO Design Pattern
  • JDBC Connectivity
  • CRUD Operations
  • SQL
  • PreparedStatement
  • ResultSet
  • Exception Handling
  • Input Validation
  • Package Organization

⚙️ Installation

Clone Repository

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

Open project inside VS Code.

Compile

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

Run

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

📸 Screenshots

Main Menu

screenshots/main-menu.png

Add Student

screenshots/add-student.png

View Students

screenshots/view-students.png

Search Student

screenshots/search-student.png

Update Student

screenshots/update-student.png

Delete Student

screenshots/delete-student.png

Database

screenshots/mysql-table.png

💡 Project Highlights

  • Built using Java, JDBC, and MySQL.
  • Implements complete CRUD functionality.
  • Uses DAO Design Pattern.
  • Uses PreparedStatement to execute SQL queries.
  • Prevents duplicate email entries.
  • Performs input validation.
  • Organized using modular package structure.
  • Easy to extend and maintain.

📖 Learning Outcomes

Through this project, I gained practical experience in:

  • Java Programming
  • Object-Oriented Programming
  • JDBC API
  • MySQL Integration
  • SQL Queries
  • CRUD Operations
  • DAO Design Pattern
  • Exception Handling
  • Validation Techniques
  • Git & GitHub Workflow

🔮 Future Improvements

  • Spring Boot REST API
  • JavaFX User Interface
  • User Authentication
  • Admin Dashboard
  • Role-Based Access
  • Export to CSV
  • Docker Support
  • Maven Project Structure
  • Unit Testing with JUnit
  • Logging Framework

🧪 Sample Workflow

Start

↓

Display Menu

↓

User selects option

↓

Validate Input

↓

DAO Method Called

↓

Execute SQL Query

↓

Receive Result

↓

Display Response

↓

Repeat Until Exit

🛡️ Best Practices Used

  • Layered Project Structure
  • Reusable Database Connection
  • PreparedStatement
  • Input Validation
  • Exception Handling
  • Modular Code Organization

📈 Skills Demonstrated

  • Core Java
  • JDBC
  • SQL
  • MySQL
  • OOP
  • DAO Pattern
  • CRUD Operations
  • Git
  • GitHub

📄 License

This project is created for learning and educational purposes.

👨‍💻 Author

Joseph

⭐ If you found this project useful, consider giving it a Star on GitHub.