Skip to content

Latest commit

 

History

History
74 lines (53 loc) · 1.22 KB

File metadata and controls

74 lines (53 loc) · 1.22 KB

📌 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

Output1

Output 2

Output2


🧠 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