📌 Student Management System (Java + MySQL)

📖 Description

A console-based Student Management System developed using Java and MySQL.
It allows users to add and view student records using a menu-driven interface.

---

🚀 Features

• Add student (name & email)
• View all students
• Data stored in MySQL database
• Uses DAO pattern for database operations

---

🧠 Concepts Used

• Object-Oriented Programming
• JDBC Connectivity
• DAO Pattern
• Database Operations

---

🛠️ Technologies Used

• Java
• MySQL
• JDBC
• OOP

---

▶️ How to Run

1. Create database studentdb

2. Create table: CREATE TABLE students ( id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(100), email VARCHAR(100) );

3. Update DBConnection.java credentials

4. Run Main.java

---

📷 Screenshots

Output 1

Output 2

---

🧠 Concepts Used

• Object-Oriented Programming
• JDBC Connectivity
• DAO Pattern
• Database Operations

---

💡 Future Improvements

• Add update and delete functionality
• Add search feature
• Build GUI using Swing

---

👩‍💻 Author

Mansi Khairnar