Student Management System (Java + MySQL)

Project Overview

The Student Management System is a console-based Java application developed to manage student records, courses, and results.
It performs CRUD operations using JDBC and stores data in a MySQL relational database.

This project demonstrates database connectivity, input handling, and structured application design using the DAO pattern.

---

Technologies Used

• Java (JDK 8+)
• MySQL 8.0
• JDBC (MySQL Connector/J)
• VS Code

---

Features

• Add, view, update, and delete student records
• Manage courses and student results
• Uses PreparedStatement for secure database operations
• Implements foreign key relationships for data integrity
• Menu-driven console interface

---

Database Schema

student

• student_id (Primary Key)
• name
• date_of_birth
• department
• email
• phone_number

courses

• course_id (Primary Key)
• course_name
• credits

results

• result_id (Primary Key, Auto Increment)
• student_id (Foreign Key)
• course_id (Foreign Key)
• marks

---

Project Structure