Covid-19-Management-Application

The COVID-19 pandemic has affected people in a severe manner, Testing and vaccination have become an important part of the current world, be it air travel or visiting elderly relatives getting tested and vaccinated has become a top priority. With the increase in testing and vaccinations, it has become significant to have a system to manage these procedures and keep a record.

Our 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:

• JDBC
• Window Builder
• rs2xml
• Swing

System Design

Screenshots Of The Application

Fig. 1. The main page:

Fig. 2. The user Sign-up page:

Fig. 3. Values entered during Sign-up:

Fig. 4. The database gets updated:

Fig. 5. The login page:

Fig. 6. If the credentials are valid, Login is successful:

Fig. 7. If the credentials are invalid, Login is unsuccessful:

Fig. 8. If the login is successful, the user gets redirected to this page where they can choose whichever option they wish to:

Fig. 9. Testing Booking Appointment Page:

Fig. 10. 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. 11. Once all the details are valid and filled in, the test slot is booked:

Fig. 12. The testing database gets updated accordingly as well:

Fig. 13. View Appointment Page Here, the contents are uneditable:

Fig. 14. Change Appointment Page. The user is prompted to change the date of their appointment:

Fig. 15. The date has been changed successfully:

Fig. 16. If the user clicks on confirm cancellation. Their appointment gets deleted from our database:

Fig. 17. Appointment cancelled successfully:

Fig. 18. Viewing the test result:

Fig. 19. Book vaccination appointment Page:

Fig. 20. Vaccination appointment booked successfully:

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

Fig. 22. In case the user wishes to view his appointment details again, they can do so by clicking on the View appointment option. Here, all the contents are uneditable:

Fig. 23. Changing the vaccination date, if the user wishes to:

Fig. 24. The date is updated in our database:

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

Fig. 26. Here, the user receives his certificate once the lab has updated it:

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

Fig. 28. Lab Login Page:

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

Fig. 31. 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. 32. The lab needs to choose the person from the table and enter their phone number in the entry friend with the valid result and hit update to update the result:

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

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

Fig. 35. The database is updated successfully:

Fig. 30. 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: