Employee Management System

Overview

The Employee Management System is a desktop application that uses JavaFX for the frontend and Spring Boot for a RESTful backend. It helps organizations easily manage employee records—like viewing, adding, updating, and deleting—through a clean and simple user interface. The app connects to a MySQL database for storing data, and includes validations and error handling to make everything run smoothly. It’s a full-stack Java application from front to back.

Data Sources

• Database: MySQL (stores employee data: ID, name, etc.)
• API: Spring Boot REST endpoints (/api/employees)

Technologies Used

• Frontend: JavaFX (GUI, version tied to Java 23.0.2)
• Backend: Spring Boot (REST API), Java 23.0.2 (core language)
• Database: MySQL (relational storage)
• Build: Maven (dependency management)

Key Features

• View all employees in a dynamic table
• Add new employees with form input
• Update existing employee details
• Delete employees by ID
• Includes input validation and error handling
• Responsive JavaFX interface

Performance

• Response Time: Fast API responses (~100-200ms locally)
• Scalability: MySQL and Spring Boot support small-to-medium datasets; optimization needed for larger scale
• Reliability: Error handling catches invalid inputs and API failures

Challenges Overcome

• Integrated JavaFX frontend with Spring Boot backend via REST calls
• Managed MySQL schema and data consistency across CRUD operations
• Balanced desktop app usability with modern web tech (REST API)

Benefits

• Efficiency: Streamlines employee data management
• User-Friendly: Intuitive GUI for non-technical users
• Extensible: Modular design for future enhancements

Sample Operations

**View Employees:** Displays table with “John Doe, ID: 1, Dept: HR”
**Add Employee:** Input “Jane Smith, Dept: IT” → Added to table
**Update Employee:** Edit “John Doe” to “John Smith” → Reflected instantly
**Delete Employee:** Remove “Jane Smith” → Table updates
            

Future Improvements

• Add login system with authentication
• Implement role-based access (e.g., admin vs. viewer)
• Optimize database queries for larger datasets

Demo

Try It

Clone the repo, set up MySQL, and run the backend (mvn spring-boot:run) and frontend (mvn javafx:run)! See GitHub for setup.