Skip to content

Developed A simple Java JDBC-based Employee Management Application that demonstrates how to perform CRUD operations (Create, Read, Update, Delete) with a relational database (MySQL).

Notifications You must be signed in to change notification settings

RachitSham/Employee_Database_Application

Folders and files

NameName
Last commit message
Last commit date

Latest commit

Β 

History

5 Commits
Β 
Β 
Β 
Β 

Repository files navigation

Employee_Database_Application

🌟 Purpose:

πŸ”Ή Built a Console-based Employee CRUD using JDBC with MySQL

🌟 Code Flow:

πŸ”Ή Packages Division

βœ… com.app.model β†’ Employee class (represents a row in DB).

πŸ”Ή Encapsulates employee data.

πŸ”Ή toString() helps print employee nicely.

βœ… com.app.util β†’ DBUtil (JDBC connection helper).

πŸ”Ή Encapsulates employee data.

πŸ”Ή toString() helps print employee nicely.

βœ… com.app.dao β†’ EmployeeDAO (CRUD operations).

πŸ”Ή addEmployee() β†’ Insert new employee.

πŸ”Ή getAllEmployees() β†’ Fetch all employees.

πŸ”Ή updateEmployeeSalary() β†’ Modify salary by ID.

πŸ”Ή deleteEmployee() β†’ Remove employee.

πŸ”Ή Uses PreparedStatement (prevents SQL injection).

βœ… com.app.main β†’ Main class with menu-driven app.

πŸ”Ή Provides a simple menu-driven console app.

πŸ”Ή Calls DAO methods for CRUD operations.

πŸ”Ή Uses try-catch for DB exceptions.

πŸ“Œ References :-

πŸ”Ή I used ChatGPT to refine the grammar and structure of the key points explaining my code .

πŸ”Ή For Code Review and for exception came in the application I Used ChatGpt.

πŸ”Ή Additionally, I referred to GeeksforGeeks [https://www.geeksforgeeks.org] for conceptual guidance and coding references to ensure clarity and correctness in my implementation.

About

Developed A simple Java JDBC-based Employee Management Application that demonstrates how to perform CRUD operations (Create, Read, Update, Delete) with a relational database (MySQL).

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages