Skip to content

This is an employee management system developed using Java Swing. It allows users to add, delete, update, and display employee information using a JTable. It is connected to a MySQL database using JDBC and contains classes for database operations and employee data storage. This is my first JDBC project.

License

Notifications You must be signed in to change notification settings

PrathameshDhande22/Employee-Management-System

Repository files navigation

Employee Management System In Java Swing

GitHub repo size   IDE   Language   GitHub

This is a Java Swing application for managing employee information. This project was created using JDK 17 and Eclipse 2022-12.

It has the following functionalities:

Add employee: Allows you to add a new employee to the system by entering their personal and employment details.
Delete employee: Allows you to delete an existing employee from the system.
Update employee: Allows you to update the personal and employment details of an existing employee.
Display employee: Shows a list of all employees in a JTable, with their personal and employment details.

Classes :

The application consists of the following classes:

CreateConnection: This class is responsible for establishing a connection with a database using JDBC. Edit the CreateConnection.java file to provide your database details.
Operations: This class contains methods for inserting, deleting, and updating employee records in the database.
Query: This class contains methods for retrieving employee records from the database.
Windows: This is the main GUI class, which handles user interactions and displays the employee information in a JTable.
Employee: This class stores the personal and employment details of a single employee.

Prerequisites

MySQL database: The application uses a MySQL database to store employee records. The employee.sql file contains the SQL query to create the necessary database and tables.

MySQL Connector library: Add the mysql-connector-java-8.0.22.jar file to your classpath. This library is required to establish a connection with the MySQL database using JDBC.

How to run the application :

  1. Clone the repository to your local machine.
  2. Open the project in an IDE such as Eclipse or IntelliJ.
  3. Build and run the project run window.java file.
  4. The application will open in a new window. Follow the prompts to add, delete, update, or display employees.

Demo :

Demo Of this Project is Uploaded on Youtube.
Click Here 👉 Youtube Link

Note :

This application is just a basic example of how to build an employee management system using Java Swing. You can modify and expand upon the code to add additional features and functionality as needed.

Author : Prathamesh Dhande

About

This is an employee management system developed using Java Swing. It allows users to add, delete, update, and display employee information using a JTable. It is connected to a MySQL database using JDBC and contains classes for database operations and employee data storage. This is my first JDBC project.

Topics

Resources

License

Stars

Watchers

Forks

Languages