It's a Desktop Application used by Attendant to book patient's appointment instead of maintaining paper-based databases.
The basic idea behind the project is, it lets attendant book patient's appointment for a particular doctor visiting hospital and backend does the necessary checking for slots and making entries in database.
This Project is made using Java, more specifically, Swing, JDBC and MySQL.
- Very fast to find a specific record.
- Can be used to analyse the data.
- Can easily update or amend a record.
- Records are stored safely, they are available when needed.
- The database can be kept secure by use of passwords and many more....
Consider each doctor can treat a maximum of 5 patients per day at a particular hospital and there are no appointments booked currently.
- Select required medical field.
- After selecting required field, say Cardiology, select the required doctor.
-
After selecting the required doctor, the backend will check for the availability of slot in that doctor’s table in database.
-
Condition - If the no. of entries of the current date is less than 5 then attendant will enter the required information and appointment will be booked successfully.
- Database table:
- If no. of entries of the current date becomes equal to 5 then appointment is not booked.
- Database table: