Application Title: Scheduler v1.0

Purpose: The purpose of this application is to provide advanced customers and appointment management. Notable features include: ability to connect to MySQL database and enables user to import and export data directly from the scheduler app; Three simple reports to view appointments and staff schedules; alert functionality that alerts the user if there are any upcoming appointments within 15 minutes. 

Author: Kyung Jun Lee 
Contact Info: [email protected]
Application Version 1.0
Date: 3/8/2022

Development Environment:
IntelliJ Community 2021.2.2, Java 17.0.2 LTS, Java TM SE Runtime Environment 17+35-LTS-2724, Java HotSpot 64-Bit server VM, JavaFx-SDK-17.0.2

Direction for use: Launch the application. Enter your username and password. Login_activity.txt file will be created upon user’s first login. This file can be reviewed for every login attempt. Upon successful login, you should be taken to the menu screen with alert display box that will list any upcoming appointments the user has in the next 15 minutes. 

Click Manage Customers Records to perform customer management. You can see any customers already created in the database and customer details. Customer can be created, edited, or deleted using the 3 buttons on the bottom of the customer table. All input fields are required fields. If a customer is already booked with an appointment, the appointment must be deleted first before you can delete the customer.

Click View and Manage Appointments to make new appointments, edit existing appointments, or cancel any existing appointments. Functionality is similar to Customer screen. User has the ability to filter and see only the appointments in the current month or week. Customers cannot be booked for an overlapping appointments.

Reports menu shows three reports you can run. Choose the desired report.  My custom report shows the total number of customer appointments by country and month.

MySQL Connector driver version number: mysql-connector-java-8.0.28