👥 Employee Management System

Java Console Application for Managing Employee Records with Database Integration

Overview

The Employee Management System is a Java console application designed to perform CRUD (Create, Read, Update, Delete) operations on employee data stored in an Oracle database.
It demonstrates JDBC database connectivity, SQL operations, and object-oriented design to manage employee records efficiently.

🚀 Features

• Add new employee records with ID, name, salary, and department
• Update employee salary by employee ID
• Delete employee records
• Retrieve single or all employee details
• Console-based interactive menu system
• JDBC connection to Oracle database

🧠 Concepts Demonstrated

• JDBC API for database connection and SQL execution
• SQL queries for insertion, selection, update, and deletion
• Exception handling and resource management with try-with-resources
• Object-oriented principles via Employee model and service interfaces
• Console input handling with Java Scanner

🏗️ Project Structure

com.employee_management_system/ │
├── model/
│ └── Employee.java # Employee data model class
├── service/
│ ├── EmployeeService.java # Service interface for employee operations
│ └── impl/
│ └── EmployeeServiceImpl.java # Implementation of service using JDBC
├── utility/
│ └── DBConnection.java # Utility class for Oracle DB connection
└── Main.java # Application entry point with interactive menu

🧩 How It Works

1. The user interacts with a command-line menu to select operations.
2. Operations invoke service methods that execute SQL queries on the Oracle database via JDBC.
3. Results are fetched, updated, or deleted with real-time console feedback.
4. Database connection is handled centrally in DBConnection utility class.

🖥️ Example Console Menu

Employee Management System

1. Add Employee
2. Delete Employee
3. Update Employee's Salary
4. Get Employee Detail
5. Get All Employee Details
6. Exit Application
   Which operation do you want to perform ( enter number between 1 to 6 )

⚙️ How to Run

1. Configure your Oracle database with the required employee table.

2. Update database credentials in DBConnection.java.

3. Compile the project with: javac com/employee_management_system/**/*.java

4. Run the application: java com.employee_management_system.Main

Make sure Oracle JDBC driver is included in the classpath and you have JDK 17+ installed.

🧑‍💻 Author

Avinash S.
Java Developer | Full‑Stack Enthusiast

📬 LinkedIn • GitHub