Question: Hello I am working on a project using JavaFX I need help with this project I have some of it done and I have posted
Hello
I am working on a project using JavaFX I need help with this project I have some of it done and I have posted the dropbox link where you can find what I have done so far. I will really appreciate it if someone can help me with this and I would prefer if the files will be save through DropBox and only the link is share in the discussion board so it can be more clear and understandable.
Thank you in advance
JavaFX Project
The goal of this project is to create a database-backed application called Task Manager that tracks employee hours. You will use JavaFX for the user interface and either the h2 or sqlite3 database for storage.
Description
There are three basic entities in the system:
- Employees
- Managers
- Tasks
An employee is assigned tasks by the manager. When the manager assigns the task, the date of the assignment is recorded in the database. When the task is completed, the employee enters the hours that it took to complete the task and marks it as being complete. The system records the day and time that the task was marked as complete, and calculates the number of calendar days that it took to complete the task. In this way, the manager can see that a 2 hour task, for example, took 2 calendar days to complete (because, for example, the employee only worked an hour a day on that particular task).
Screens
The application must have the following screens:
- Manage Employees
- This screen should show a list of employees and allow the manager to add, remove, or update an employee.
- Manage Tasks
- This screen allows the manager to assign a task to an employee.
- Employee Task Screen
- This screen allows the employee to mark a task as complete and enter the hours worked on the task
- Employee Task Summary
- This screen allows the manager to look at the tasks for an employee and see how many hours and calendar days it took to complete.
Design
The schema should consist of three tables, one for each data type as listed above.
Each entity must have its own associated class (ex: Employee). The class should have fields for every column in the associated database table. In addition, each class should include the code to save, update, and delete itself in the database.
Each entity should also have a management class (ex: EmployeesHelper). These classes are responsible for retrieving a list of the elements from the database. Required fields:
- Manager
- id
- name
- department
- Employee
- id
- name
- FK_manager_id
- Task
- id
- name
- assigned_date
- completed_date
- hours_worked
- FK_employee_id
Database Access and Management
You must use the Flyway library to manage the database schema, and the commons- dbcp library as the implementation for the BasicDataSource class. The example project template in GitLab has both of these libraries already configured.
Using the Starter Project
A starter project for JavaFX can be found on the link provided below. The project URL is https://www.dropbox.com/sh/1sgqzkorvmmhey9/AADOIyh2VJWCTUZefPfooc6da?dl=0 The project is already configured for Maven and has the Flyway, h2, and datasource libraries included. When you first open the project in IntelliJ you will see a popup that asks you if you want to auto-configure Maven. Click that link and it should download the libraries for you.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
