Covid-19-Management-Application

This application aims to deliver a system to manage the vaccination and testing related information. The application aims to provide a user-friendly and easy-to-use system that:

• Helps users manage their vaccination and testing related duties.
• Helps labs to manage the update of results and certificates for the user to access.

Technologies Used

• MySQL
• Java Swing
• JDBC

System Design

Screenshots of the application

Fig. 1. The main page

Fig. 2. The user login page

Fig. 3. The user Sign-up page

Fig. 4. Values entered during Sign-up

Fig. 5. The database gets updated

Fig. 6. The login page

Fig. 7. If the credentials are valid, Login is successful.

Fig. 8. If the credentials are invalid, Login is unsuccessful.

Fig. 9. If the login is successful, the user gets redirected to this page,

TESTING:

Fig. 10. Testing Booking Appointment Page

Fig. 11. Once the user selects the city they wish to be tested in, they will be prompted to search labs in that city, after which they can accordingly select the lab they wish to,

Fig. 12. Once all the details are valid and filled in, the test slot is booked

Fig. 13. The testing database gets updated accordingly as well.

Fig. 14. View Testing Appointment Page, the contents are uneditable.

Fig. 15. Change Appointment Page

Fig. 16. The date has been changed successfully.

Fig. 17. Cancel Appointment Page

Fig. 18. Appointment cancelled successfully

Fig. 19. Viewing the test result.

VACCINATION:

Fig. 20. Vaccination Booking Appointment Page.

Fig. 21. Vaccination appointment booked successfully.

Fig. 22. Once an appointment is booked, our database gets updated accordingly.

Fig. 23. View Vaccination Apoointment. All the contents are uneditable.

Fig. 24. Change Vaccination Appointment Page

Fig. 25. The date is updated in our database.

Fig. 26. On comparing this figure and Fig. 22, we can see that the date column has been updated to the date in Fig. 24.

Fig. 27. Get Vaccination Certificate Page

LABS:

Fig. 28. To prevent random users from making lab accounts, we have predefined some lab accounts based on the cities they are located in.

Fig. 29. Lab Login Page

Fig. 30. This page appears when a Lab logs in with the correct credentials

Fig. 31. Update Test Result Page. If the lab chooses to update the test results of patients that have been tested, they can do so from this page.

Fig. 32. Update Vaccination Result Page. If the lab chooses to update the vaccination results of patients who've been vaccinated, they can do so from this page.

Fig. 33. The lab needs to enter the phone number in the entry friend with the valid result and hit update to update the result.

Fig. 34. If the result has been updated successfully, this pop-up appears.

Fig. 35. Upon completion of updating, the name automatically disappears from the list.

Fig. 36. The database is updated successfully.