🏢 Employee Management System

A Java Console-Based Employee Management System developed using Java, JDBC, and MySQL.

🚀 Features

✅ Add Employee

✅ View Employees

✅ Search Employee

✅ Update Employee

✅ Delete Employee

✅ Attendance Management

✅ MySQL Database Integration

✅ JDBC Connectivity

---

🛠 Technologies Used

• Java
• JDBC
• MySQL
• Eclipse IDE

---

📂 Project Structure

EmployeeManagementSystem/

├── src/

│ ├── model/

│ │ └── Employee.java

│ ├── dao/

│ │ ├── EmployeeDAO.java

│ │ └── AttendanceDAO.java

│ ├── util/

│ │ └── DBConnection.java

│ ├── service/

│ │ └── EmployeeService.java

│ └── main/

│ └── Main.java

├── database/

│ └── employee_db.sql

└── README.md

---

🗄 Database Setup

1. Open MySQL Workbench.
2. Execute employee_db.sql.
3. Create database and tables.
4. Update DBConnection.java credentials.

Example:

private static final String USER = "root";
private static final String PASSWORD = "root";

---

▶ Run Project

1. Import project into Eclipse.
2. Add MySQL Connector JAR.
3. Configure database.
4. Run Main.java.

---

🎯 Learning Outcomes

• Object Oriented Programming
• JDBC Connectivity
• CRUD Operations
• MySQL Database Design
• Exception Handling
• DAO Design Pattern

---

👨‍💻 Author

Aravindh D

Fresher

Java | SQL | JDBC | MySQL