PROJECT REPORT

ON

Hospital Management System

Submitted in partial fulfilment of the requirements of

INFORMATICS PRACTICS (065) of

Senior Secondary Examination 2026

by

Arti Malik
ROLL NO. ________________________
2025-26

To

MR. SHRI KANT YADAV, (PGT, Info. Pract.)

FR. AGNEL SCHOOL, Greater Noida

Affiliated to
Central Board of Secondary Education, Delhi, Region – Noida
 DECLARATION FORM

I hereby declare that the Project work entitled HOSPITAL MANAGEMENT

SYSTEM submitted by me for the Informatics Practices during the
Senior Secondary Examination to Fr. Agnel School, Greater Noida
is my own original work and has not been submitted earlier either to FAS,
Greater Noida or to any other Institution for the fulfillment of the
requirement for any course of study. I also declare that no chapter of this
manuscript in whole or in part is lifted and incorporated in this report from
any earlier / other work done by me or others.

Place : Greater Noida

Date : _____/_____/______ Signature of Student

Name of Student: Arti Malik

Email ID::

Roll No. :5660279

 ACKNOWLEDGEMENT

This project report prepared by me is a result of several helping hands of

the Hospital Manage System. The knowledge of our Informatics
Practices is absolutely incomplete without its proper implementation and
application in diversified corporate world of today.

An understanding of the study like this is never an outcome of efforts put

in by single person; rather it imprints involvement of numbers of persons
who directly or indirectly helped me in completing the study.

First of all I would like to thank Mr. Mosam, Mr. Abhay & Mr. Ayub
khan saifi his knowledge has been a helping light during my project. I
offer a sincere thanks to Mr. Shri Kant Yadav (PGT Info. Pract.) for his
full-fledged cooperation, care and immense amount of help without which
it would have been really difficulty to complete this project.

Arti Malik

Roll No. 5660279

3|Page
 CERTIFICATE FOR ORIGENALITY

This is certify that project report entitled Hospital Management System

submitted to FR. AGNEL SCHOOL, GREATER NOIDA DISTT.
GAUTAMBUDH NAGAR (U.P.) in the partial fulfilment of the
requirement for the award of the “Senior Secondary Examination
2025-26” is an original work carried out by Ms. Arti Malik under my
guidance.

The matter embodied in this project is a genuine woke done by the

student and has not been submitted whether to this education society any
other university/ society for the fulfilment of the requirement of any
course of study.

Signature of Student Signature of

Guide

4|Page
 PREFACE

The only man who never makes mistakes is the man who never does
anything. Keeping above idea in one mind; me decided that I can do
anything, which we think.

Which it is known to us that we had to make a project, which is part

of my Senior Secondary Examination, Session 2023-24 curriculum.
We work concerned about our effective project that would field are value
to the user obviously, I was also excited when we had started to develop
this we were very thanks to our project Guide.

5|Page
 OBJECTIVE OF PROJECT

With the passage of time the value of money is increasing actually along
with cost of human resources. It is ultimately resulting in the price like of
each and everything but what become most causalities is “human
resource” and “human labor” because of the faster life in the cities,
people have everything excites so minutely observing, the main problem
seen to back of lock of time. Thus, the main objective of these projects is
to develop software and make it available to the concerned uses that may
help them in secluding their expenses and save their valuable time.

It a Hospital maintains etc. Management System details ink a note

book or a register them it becomes very difficult to answer to the queries
or to generate the reports, I bills, and payments quickly where equipped.
Thus in order to avoid all nuisances all the Hospital Management System
details can be maintained accurately and efficiently through a database.
Therefore, in this project we shall design a menu based program to
manage the processing system of a Hospital.

The objective of the projects are as following:-

1:- Retrieval of information regarding Doctor.
2:- Facility add new information in Doctor & Patients Information.
3:- Quick delivery of reports, bills and payments.
4:- Avoidance of any unnecessary and redundant data.
6:- Marking the system cost effective as well time effective.
7:- Making the systems more user – friendly and reducing paper work as
much as possible.
8: Keep the system running in advise condition too.
9:- Providing a taught system security.
10:- Making the systems flexible as possible.
11:- Providing a full – fledged back up.
12:- Making the systems useful for all levels of the management.

6|Page
 PROJECT CATEGORY

This project can be viewed as a small RDBMS (Relational Database

Management System) since adding any information related to Medical
Agency Management involves a series of processing activity that requires
checking various parameters of the working system. These parameters
need to be constantly updating for the purpose of smooth execution of the
system.

The proposed system needs the perform following processing

activity:-

 Adding Doctor, Patients & Staff record.

 Modifying an underlying record.

 Deleting an existing record.

 Generation of reports.

 Generating sales bill.

The above stated processing activity clearly indicates that the proposed
project needs to be carefully handled by the systems database to optimize
the usage of organization’s resources.

7|Page
 TOOL/PLATFORM, LANGUAGES TO BE USED IN THE PROJECT

HARD WARE TOOLS

 Keyboard

 Monitor

 Mouse

 Ups

 Speaker

 Printer

SOFTWARE TOOLS

 Python 3.6.3 (For frontend)

 My SQL Server 5.1

 Windows 10/11

8|Page
 TOOL USED IN DATA COLLECTION

Review of written Document

Onside observation

Interview

Questionnaires

REVIEW OF LITERATURE
FROM MANUAL

INFORMATION ONSITE DATA

GETHERING OBSERVATION ORGANIZATION

QUESTIONAIRES
INTERVIEW

9|Page
 FRONT END USED IN THE PROJECT

In the client/ Server system, the backend is synonymous with the

Database engine that resides on the server on host, the database engine
or backend process SQL requests, stores and retrieves data in simple
word front-end means which appear in front of user.

The front end to be used in the project is Netbeans 7.0

Thus, Netbeans is also known as front-end tools. It has some unique

features, which are stated as follows.

 Netbeans uses the graphical interface of window which makes it

more interactive and easies to work on.
 Information such as sound, picture and documents created in other
applications can be used in Netbeans since it supports object
linking and embedding (OLE) feature for this purpose.
 Several Dynamic data exchange (DDE) functions provide support
for data exchange between windows application.
 Netbeans manage the file used for an application in an efficient
manner for it can group various kinds of files such as tables,
screens, queries, reports, labels and program.
 Netbeans can server both as a Clint as well as server, i.e. it can
receives as well as sent data to another application.
 Netbeans supports the ‘Object Oriented Programming’ and due to
this feature objects, class, inheritance, friend classes etc. are
included in it.

10 | P a g e
 BACKEND USED IN THE PROJECT

Backend is an application used by a client to access any database engine

or to present information to the user. In simple word backend means
which does not appear in front of the user. i.e. it simians hidden from the
user. The data is stored in some data base file like Ms Access and MySQL.

The backend to be used in the project is MySQL that is a Relational

Database Management System (RDBMS) which contains an organized
collection of enter related and update version of MYSQL 5.1.

RDBMS is a combination of hardware and software that can be used

to set up and monitor a database and can manage the updating and
retrieval of database that has been has been stared in it. Thus, RDBMS
acts, as intermediary between the user and the database and this is the
main reason for using it backend in the project.

11 | P a g e
 ABOUT THE PYTHON

The features unique to oracle for window are as follows.

 It supports object oriented programming because of that features of

objects, class, inheritance, polymorphism etc. includes in it.
 Neatbeans uses the graphical interface window software, which
makes it more interactive and easier to work on.
 Netbeans can serve both as a client as well as server i.e. it can
receive as well as sent data other applications.
 A unique feature is that information such as sound picture and
document creates in other application can be used in visual basic
since it supports object linking and embedding (OLE)’general’ data
type used for his purpose.
 Several Dynamic Data Exchange (DDE) function provide support for
data exchange between window application.
 The netbeans manages the file used for files used for an application
an efficient manner. It can group various kinds of such as table,
queries, report, tables and programs.

12 | P a g e
 ABOUT THE RDBMS

MySQL is a Relational Database Management System (RDBMS), which

contains an organized collections of interrelated & update version of
MySQL-5.1 there are several versions of the MySQLe available for use. It
can run under four different platform such as DOS, LINUX, MACINTOSH
and Windows (95 & 98) there are major different amongst these four
version of MySQL, because of different in their operating environment.

13 | P a g e
 PROBLEMS IN THE EXISTING SYSTEM

For many project, I visited many Hospital of my city and keenly observed
their management system, accounting process. Record maintenance and
their full automation system. Though some of them had very impressive
automation system but some of them were incurring heavy losses. I very
minutely observed their management system and tried to fine out the
reasons due to which they were facing problems which are as follows:-

 Most of them handle their management by doing paper work and

since everything is on paper there is a possibility of getting it
misplace or torn out.

 Since all the entries are done manually on paper probability of

mistakes increases.

 It a person specialized for a particular ask is a absent for some

reason or the other the whole processing is blacked for no one can
perform his/ her task.

 Retrieval of records becomes very hectic process become one has

to go through a large number of records, which are stored in
different registers.

 Problem is understanding record’s level. Admin & Hospital Incharge

are searching a Doctor & Staff as well as Patients even it is out or
inside of hospital. There is no such arrangement to indicate the
records level of a record.

 Problem of employee attendance.

 Problem of finding records.

 Problem of patients before the In or Out of inventory.

 Calculation of bills, generally reports and payments manually is a

very notice and time- consuming process.

 The software they use is not sufficient enough to meet the

requirements of the management and is not able to cope up with
the difficulties he arise.

 No backup files are kept. In case the system crashes or the papers
are cost recovery of records becomes impossible.

14 | P a g e
  Misuse of given authority is done, even those who don’t have the
authority access the data which is an illegal act.

 Searching and answering queries is very long process due to

impropriety

15 | P a g e
 Validation & Testing

Validation can be described in many ways, but a simple definition is that

validation succeeds when software function in a manner that can be
reasonably expected by Hospital Incharge. Reasonable expectations are
defined in the software requirement specification.

Validation Test Criteria

Software validation is achieved through a series of back – box tests that

demonstrate conformity with the requirements. The function requirements
of the system are –

 Reports must be neatly presented.

 The application software must support GUI.

 Report should be produce instantly & must contain no errors are

ambiguity.

 Person having proper authority should be allowed modify, delete or

add records in the various data bases.

Software Testing is Important Because

Reviews & other ‘SQL’ activities can & do uncover errors, but they are not
sufficient. Every time the program is executed, the customer tests it.
Therefore, we has to execute the program before it gets to the customer
with the specific intent of finding & removing all errors. In order find the
highest possible numbers of errors, tests must be conducted system
erotically & tests must be designed using disciplined techniques.

16 | P a g e
 The steps in the Software Testing

Software is tested form two different perspective:-

 Internal program logic is exercised using “White – box” test case

design techniques.
 Software requirements are exercised using “black – Box” case
design technique in both case, the id intent to find the maximum
amount of affront & time.

Implementation of Validation & Testing

As discussed earlier the black box testing is implementation for complete

project, whether each module is working properly. White box testing us
implemented for internal functioning of module.

The various modules are tested independently in unit tests. All loops
which are used in the module are tested even the conditional statement
for all possible combinations of their values. All this is ester by data flow in
the module known as flow – chart method for testing function in the
module call other function internally are tested, & the4ri proper
declaration is also tested.

The report generated are tested their proper field definition to the
text box & proper placement of the field are required by the design of the
graph is displayed.

This software is tested all the modules basically tested is the

process of executing a program with intent of finding errors for each
module we have sample of data for test cases & each test output is
verified so we can say the good amount of alpha testing is performed.

17 | P a g e
 The fields, which are displayed in the search, are able to called
precise amount of data.

ANALYSIS

The analysis of function requirement of proposed system reveals the

following fact about the system:-

 The application must support “GUI”.

 Doctor/ Patient having valid Doc_ID should only be allowed to take

entry in Hospital.

 Doctor, Patients & Staff status should be maintained properly.

 Report should be produced in Stanley & must contain no errors or

ambiguity.

 Person having proper authority should be allowed to modify, delete

or add records in the various database.

18 | P a g e
 Scope of the Future Application

As this software application is designed for relatively small organization.

In order to deal with problems associated with a large scale organization,
where there are number of departments working the gather and
processing transactions are much complex we can modify the code and
extend capability of this software in order to scope up with increased
complexity. Since the software has been designed in Visual Basic
therefore using the capabilities of Visual Basic as a programming tool one
can implement a ‘LAN VERSION’ or a CLIENT/ SERVER VERSION of the
above application as desired by the user group.

19 | P a g e
 CONCLUSION

In the end, I wish to say that computers should be put to such use where
not only capabilities are fully exploited but, what is more important, serve
the society by raising the standard of living of people, thereby making the
ward better place to live and work in.

I sincerely fell that the compulsion to do a project as part of “Senior

Secondary Examination 2024-25 ” course of FR. AGNEL SCHOOL, GR.
NOIDA is very much justified but not only just use full and helpful for
student. It also gives the felling of achievement and satisfaction to those
who work with full dedication and concentration on it.

20 | P a g e
 DATABASE STRUCTURE

DOCTOR TABLES

S.R. FIELD NAME TYPE

1. Doc_Name varchar (30)

2. Doc_ID varchar (5)

3. Doc_Address varchar (30)

4. Doc_Phone_Number varchar(10)

5. Doc_Qualification varchar (25)

6. Doc_Department varchar (25)

7. Doc_Fee int (5)

8. Doc_Fee_validity int (3)

9. Doc_Join date

10. Doc_Cabin_Number varchar(3)

PATIENT TABLE

S.R. FIELD NAME TYPE

1. Pat_Name varchar (30)

2. Pat_ID varchar (5)

3. Pat_Address varchar (30)

4. Pat_Phone_Number varchar (10)

5. Pat_Doctor_Incharge_ID varchar (25)

6. Pat_Date_Admission date

7. Pat_Date_discharge date

8. Pat_Amounte int (5)

9. Pat_Disease varchar (20)

10. Pat_Room_Number varchar(3)

21 | P a g e
SALE RECORD TABLE

S.R. FIELD NAME TYPE

1. Staff_Name varchar (30)

2. Staff_ID varchar (5)

3. Staff_Address varchar (30)

4. Staff_Phone_Number varchar (10)

5. Staff_Qualification varchar (25)

6. Staff_Department varchar (25)

7. Staff_Salary int (5)

8. Staff_Date_Join date

22 | P a g e
 AUTHORIZED
PERSON

DATA ENTRY
AND
VERIFICATION

Doctor’s Details Patient’s Details Staff’s Details

Patient’s
ABOUT THE HOSPITAL
HOSPITAL
MANAGEMENT
SYSTEM DEPT. OF HOSPITALS

TREATMENT

PAYMENT

REPORT

STAFF OF THE HOSPITAL

EXPENSES OF HOSPITAL

23 | P a g e
24 | P a g e
private void jButton1ActionPerformed([Link] evt) {

new Main().setVisible(true);

dispose();

25 | P a g e
LOGIN BUTTON

private void jButton1ActionPerformed([Link] evt) {

String username=[Link]();

String password=new String([Link]());

if([Link]("netbeans")&&[Link]("mysql"))
{

[Link](null,"Congratulations!! You are

successfully logged in." + "\n" + "\n" + "Welcome to Hospital
Management System."+"\n"+"Please click OK to proceed."," Result
",JOptionPane.NO_OPTION);

new Main().setVisible(true);

dispose();

} else{

26 | P a g e
 [Link](null," Either username or
password is incorrect! Sorry, please try again. "," Result
",JOptionPane.ERROR_MESSAGE);

[Link](null);

[Link](null);

CANCLE BUTTON

private void jButton2ActionPerformed([Link] evt) {

// TODO add your handling code here:

dispose();

27 | P a g e
ADD NEW RECORD BUTTON

private void jButton1ActionPerformed([Link] evt) {

// TODO add your handling code here:

new Add().setVisible(true);

REMOVE EXISTING RECORD BUTTON

private void jButton4ActionPerformed([Link] evt) {

// TODO add your handling code here:

new Remove().setVisible(true);

VIEW RECORD BUTTON

private void jButton3ActionPerformed([Link] evt) {

// TODO add your handling code here:

new Record().setVisible(true);

SEARCH RECORD BUTTON

private void jButton2ActionPerformed([Link] evt) {

// TODO add your handling code here:

new Search().setVisible(true);

GET APPOINTMENT BUTTON

private void jButton5ActionPerformed([Link] evt) {

28 | P a g e
 // TODO add your handling code here:

new Appointment().setVisible(true);

ABOUT BUTTON

private void jButton6ActionPerformed([Link] evt) {

// TODO add your handling code here:

new About().setVisible(true);

LOGOUT BUTTON

private void jButton7ActionPerformed([Link] evt) {

// TODO add your handling code here:

new Login().setVisible(true);

dispose();

EXIT BUTTON

private void jButton8ActionPerformed([Link] evt) {

// TODO add your handling code here:

[Link](0);

29 | P a g e
ADD DOCTOR BUTTON

private void jButton1ActionPerformed([Link] evt) {

// TODO add your handling code here:

new Add_Doctor().setVisible(true);

ADD PATIENT BUTTON

private void jButton2ActionPerformed([Link] evt) {

// TODO add your handling code here:

new Add_Patient().setVisible(true);

ADD PATIENT BUTTON

private void jButton3ActionPerformed([Link] evt) {

// TODO add your handling code here:

new Add_Staff().setVisible(true);

30 | P a g e
CLOSE BUTTON

private void jButton8ActionPerformed([Link] evt) {

// TODO add your handling code here:

Dispose();

SUBMIT BUTTON

private void jButton1ActionPerformed([Link] evt) {

// TODO add your handling code here:

try{

[Link]("[Link]");
31 | P a g e
 String S="insert into doctor values('"+[Link]()
+"','"+[Link]()+"','"+[Link]()+"','"+[Link]()
+"','"+[Link]()+"','"+[Link]()+"','"+[Link]()
+"','"+[Link]()+"','"+[Link]()+"','"+[Link]()+"');";

//[Link](S);

[Link](S);

[Link](null,"Record Successfully
Inserted");

[Link]();

catch(ClassNotFoundException | SQLException | HeadlessException e)

{[Link](null, "Error in Connectivity");}

CLEAR BUTTON

private void jButton2ActionPerformed([Link] evt) {

// TODO add your handling code here:

[Link](null);

[Link](null);

[Link](null);

[Link](null);

[Link](null);

[Link](null);

[Link](null);

[Link](null);

[Link](null);

[Link](null);

}
32 | P a g e
CLOSE BUTTON

private void jButton8ActionPerformed([Link] evt) {

// TODO add your handling code here:

Dispose();

SUBMIT BUTTON

private void jButton1ActionPerformed([Link] evt) {

// TODO add your handling code here:

try{

33 | P a g e
 [Link]("[Link]");

String S="insert into patient values('"+[Link]()

+"','"+[Link]()+"','"+[Link]()+"','"+[Link]()
+"','"+[Link]()+"','"+[Link]()+"','"+[Link]()
+"','"+[Link]()+"','"+[Link]()+"','"+[Link]()+"');";

[Link](S);

[Link](S);

[Link](null,"Record Successfully
Inserted");

[Link]();

catch(ClassNotFoundException | SQLException | HeadlessException

e){[Link](null, "Error in Connectivity");}

CLEAR BUTTON

private void jButton2ActionPerformed([Link] evt) {

// TODO add your handling code here:

[Link](null);

[Link](null);

[Link](null);

[Link](null);

[Link](null);

[Link](null);

[Link](null);

[Link](null);

[Link](null);

[Link](null);
34 | P a g e
CLOSE BUTTON

private void jButton8ActionPerformed([Link] evt) {

// TODO add your handling code here:

Dispose();

SUBMIT BUTTON

35 | P a g e
private void jButton1ActionPerformed([Link] evt) {

// TODO add your handling code here:

try{

[Link]("[Link]");

String S = "insert into staff values('"+[Link]()

+"','"+[Link]()+"','"+[Link]()+"','"+[Link]()
+"','"+[Link]()+"','"+[Link]()+"','"+[Link]()
+"','"+[Link]()+"');";

[Link](S);

[Link](null,"Record Successfully
Inserted");

[Link]();

catch(ClassNotFoundException | SQLException | HeadlessException

e){[Link](null, "Error in Connectivity");}

CLEAR BUTTON

private void jButton2ActionPerformed([Link] evt) {

// TODO add your handling code here:

[Link](null);

[Link](null);

[Link](null);

[Link](null);

[Link](null);

[Link](null);

[Link](null);
36 | P a g e
 [Link](null);

CLOSE BUTTON

private void jButton8ActionPerformed([Link] evt) {

// TODO add your handling code here:

Dispose();

REMOVE DOCTOR BUTTON

private void jButton1ActionPerformed([Link] evt) {

// TODO add your handling code here:

new Remove_Doctor().setVisible(true);

REMOVE PATIENT BUTTON

private void jButton1ActionPerformed([Link] evt) {

37 | P a g e
 // TODO add your handling code here:

new Remove_Patient ().setVisible(true);

REMOVE PATIENT BUTTON

private void jButton1ActionPerformed([Link] evt) {

new Remove_Staff ().setVisible(true);

38 | P a g e
REMOVE BUTTON

private void jButton1ActionPerformed([Link] evt) {

// TODO add your handling code here:

[Link](null,"Please confirm before you

remove as data once lost cannot be retrieved again.");

try{

[Link]("[Link]");

String s="delete from doctor where Doc_ID='"+[Link]()+"';";

[Link](s);

[Link](null,"Successfully Removed!!");

[Link]();

catch(ClassNotFoundException | SQLException | HeadlessException

e){[Link](null, "Error in Removal");}

CLEAR BUTTON

private void jButton2ActionPerformed([Link] evt) {

// TODO add your handling code here:

[Link]("");

[Link]("");

[Link]("");

39 | P a g e
REMOVE BUTTON

40 | P a g e
 private void TF1CaretUpdate([Link] evt) {

// TODO add your handling code here:

[Link]("");

[Link]("");

try{

[Link]("[Link]");

String a="select Pat_Name,Pat_Phone_Number from patient where

Pat_ID='"+[Link]()+"';";

rs=[Link](a);

while([Link]())

String Name=[Link]("Pat_Name");

String Number=[Link]("Pat_Phone_Number");

[Link](""+Name);

[Link](""+Number);

catch(ClassNotFoundException | SQLException e)
{[Link](null, "Error in Connectivity");}

CLEAR BUTTON

private void jButton2ActionPerformed([Link] evt) {

// TODO add your handling code here:

41 | P a g e
 [Link]("");

[Link]("");

[Link]("");

REMOVE BUTTON

private void jButton1ActionPerformed([Link] evt) {

// TODO add your handling code here:

42 | P a g e
 [Link](null,"Please confirm before you
remove as data once lost cannot be retrieved again.");

try{

[Link]("[Link]");

String s="delete from staff where Staff_ID='"+[Link]()+"';";

[Link](s);

[Link](null,"Successfully Removed!!");

[Link]();

catch(ClassNotFoundException | SQLException | HeadlessException

e){[Link](null, "Error in Removal");}

CLEAR BUTTON

private void jButton2ActionPerformed([Link] evt) {

// TODO add your handling code here:

[Link]("");

[Link]("");

[Link]("");

43 | P a g e
CHECK DOCTORS’ RECORD BUTTON

private void jButton1ActionPerformed([Link] evt) {

// TODO add your handling code here:

new Record_Doctor().setVisible(true);

CHECK PATIENTS’ RECORD BUTTON

private void jButton1ActionPerformed([Link] evt) {

// TODO add your handling code here:

new Record_ Patient ().setVisible(true);

CHECK STAFFS’ RECORD BUTTON

private void jButton1ActionPerformed([Link] evt) {

44 | P a g e
 // TODO add your handling code here:

new Record_ Staff ().setVisible(true);

FETCH BUTTON

private void jButton1ActionPerformed([Link] evt) {

// TODO add your handling code here:

[Link]();

DefaultTableModel model=(DefaultTableModel)[Link]();

try{

[Link]("[Link]");

String querry="select * from doctor;";

rs=[Link](querry);

while([Link]())

45 | P a g e
 {

String Name=[Link]("Doc_Name");

String ID=[Link]("Doc_ID");

String Address=[Link]("Doc_Address");

String Phone=[Link]("Doc_Phone_Number");

String Qualification=[Link]("Doc_Qualification");

String Depart=[Link]("Doc_Department");

int Fee=[Link]("Doc_Fee");

int Validity=[Link]("Doc_Fee_Validity");

Date Join=[Link]("Doc_Join");

String Cabin=[Link]("Doc_Cabin_Number");

[Link](new Object[]
{Name,ID,Address,Phone,Qualification,Depart,Fee,Validity,Join,Cabin});

CLEAR BUTTON

private void jButton2ActionPerformed([Link] evt) {

// TODO add your handling code here:

DefaultTableModel model=(DefaultTableModel)[Link]();

int rows=[Link]();

if(rows > 0)

for(int i=0; i<rows; i++)

[Link](0);

46 | P a g e
 }

FETCH BUTTON

private void jButton1ActionPerformed([Link] evt) {

// TODO add your handling code here:

[Link]();

DefaultTableModel model=(DefaultTableModel)[Link]();

try{

[Link]("[Link]");

String querry="select * from patient;";

rs=[Link](querry);

while([Link]())

47 | P a g e
 {

String Name=[Link]("Pat_Name");

String ID=[Link]("Pat_ID");

String Address=[Link]("Pat_Address");

String Phone=[Link]("Pat_Phone_Number");

String Incharge=[Link]("Pat_Doctor_Incharge_ID");

Date Admission=[Link]("Pat_Date_Admission");

Date Discharge=[Link]("Pat_Date_Discharge");

int Amount=[Link]("Pat_Amounte");

String Trouble=[Link]("Pat_Disease");

String Room=[Link]("Pat_Room_Number");

[Link](new Object[]
{Name,ID,Address,Phone,Incharge,Admission,Discharge,Amount,Trouble,R
oom});

[Link]();

[Link]();

[Link]();

catch(ClassNotFoundException | SQLException e)
{[Link](null, "Error in Connectivity");}

CLEAR BUTTON

private void jButton2ActionPerformed([Link] evt) {

// TODO add your handling code here:

48 | P a g e
 DefaultTableModel model=(DefaultTableModel)[Link]();

int rows=[Link]();

if(rows > 0)

for(int i=0; i<rows; i++)

[Link](0);

CLEAR BUTTON

private void jButton3ActionPerformed([Link] evt) {

// TODO add your handling code here:

dispose();

49 | P a g e
FETCH BUTTON

private void jButton1ActionPerformed([Link] evt) {

// TODO add your handling code here:

[Link]();

DefaultTableModel model=(DefaultTableModel)[Link]();

try{

[Link]("[Link]");

String querry="select * from staff;";

rs=[Link](querry);

50 | P a g e
 while([Link]())

String Name=[Link]("Staff_Name");

String ID=[Link]("Staff_ID");

String Address=[Link]("Staff_Address");

String Phone=[Link]("Staff_Phone_Number");

String Qualification=[Link]("Staff_Qualification");

String Depart=[Link]("Staff_Department");

int Salary=[Link]("Staff_Salary");

Date Join=[Link]("Staff_Date_Join");

[Link](new Object[]
{Name,ID,Address,Phone,Qualification,Depart,Salary,Join});

[Link]();

[Link]();

[Link]();

catch(ClassNotFoundException | SQLException e)
{[Link](null, "Error in Connectivity");}

CLEAR BUTTON

private void jButton2ActionPerformed([Link] evt) {

// TODO add your handling code here:

DefaultTableModel model=(DefaultTableModel)[Link]();

int rows=[Link]();

if(rows > 0)
51 | P a g e
 {

for(int i=0; i<rows; i++)

[Link](0);

CLOSE BUTTON

private void jButton3ActionPerformed([Link] evt) {

// TODO add your handling code here:

dispose();

52 | P a g e
SEARCH DOCTORS’ RECORD BUTTON

private void jButton1ActionPerformed([Link] evt) {

// TODO add your handling code here:

new Search_Doctor().setVisible(true);

SEARCH PATIENTS’ RECORD BUTTON

private void jButton1ActionPerformed([Link] evt) {

// TODO add your handling code here:

new Search_ Patient ().setVisible(true);

SEARCH STAFFS’ RECORD BUTTON

private void jButton1ActionPerformed([Link] evt) {

// TODO add your handling code here:

new Search_ Staff ().setVisible(true);

53 | P a g e
SEARCH BUTTON

private void jButton1ActionPerformed([Link] evt) {

// TODO add your handling code here:

[Link]();

String filter="";

if([Link]())//==true)

filter="Doc_ID='"+[Link]()+"';";

else if([Link]())//==true)

filter="Doc_Name="+[Link]()+";";

[Link](filter);
54 | P a g e
 }

DefaultTableModel model=(DefaultTableModel)[Link]();

try{

[Link]("[Link]");

String querry="select * from doctor where "+filter;

[Link](querry);

rs=[Link](querry);

while([Link]()) {

String Name=[Link]("Doc_Name");

String Address=[Link]("Doc_Address");

String Phone=[Link]("Doc_Phone_Number");

[Link](new Object[] {Name,Address,Phone});

[Link]();

[Link]();

[Link]();

} catch(ClassNotFoundException | SQLException e)
{[Link](null, "Error in Connectivity");}

CLEAR TABLE BUTTON

private void jButton2ActionPerformed([Link] evt) {

// TODO add your handling code here:

DefaultTableModel model=(DefaultTableModel)[Link]();

55 | P a g e
 int rows=[Link]();

if(rows > 0) {

for(int i=0; i<rows; i++) {

[Link](0);

CLOSE BUTTON

private void jButton3ActionPerformed([Link] evt) {

// TODO add your handling code here:

dispose();

56 | P a g e
SEARCH BUTTON

private void jButton1ActionPerformed([Link] evt) {

// TODO add your handling code here:

[Link]();

String filter="";

if([Link]())//==true)

filter="Pat_ID ='"+[Link]()+"';";

else if([Link]())//==true)

57 | P a g e
 {

filter="Pat_Name="+[Link]()+";";

DefaultTableModel model=(DefaultTableModel)[Link]();

try{

[Link]("[Link]");

String querry="select * from patient where "+filter;

rs=[Link](querry);

while([Link]()) {

String Name=[Link]("Pat_Name");

String Address=[Link]("Pat_Address");

String Phone=[Link]("Pat_Phone_Number");

[Link](new Object[] {Name,Address,Phone});

[Link]();

[Link]();

[Link]();

} catch(ClassNotFoundException | SQLException e)
{[Link](null, "Error in Connectivity");}

CLEAR TABLE BUTTON

private void jButton2ActionPerformed([Link] evt) {

// TODO add your handling code here:

58 | P a g e
 DefaultTableModel model=(DefaultTableModel)[Link]();

int rows=[Link]();

if(rows > 0) {

for(int i=0; i<rows; i++) {

[Link](0);

CLOSE BUTTON

private void jButton3ActionPerformed([Link] evt) {

// TODO add your handling code here:

dispose();

59 | P a g e
SEARCH BUTTON

private void jButton1ActionPerformed([Link] evt) {

// TODO add your handling code here:

[Link]();

String filter="";

if([Link]()==true)

filter="Staff_ID='"+[Link]()+"';";

else if([Link]()==true)

60 | P a g e
 {

filter="Staff_Name="+[Link]()+";";

DefaultTableModel model=(DefaultTableModel)[Link]();

try{

[Link]("[Link]");

String querry="select * from staff where "+filter;

rs=[Link](querry);

while([Link]()) {

String Name=[Link]("Staff_Name");

String Address=[Link]("Staff_Address");

String Phone=[Link]("Staff_Phone_Number");

[Link](new Object[] {Name,Address,Phone});

[Link]();

[Link]();

[Link]();

} catch(ClassNotFoundException | SQLException e)
{[Link](null, "Error in Connectivity");}

CLEAR TABLE BUTTON

private void jButton2ActionPerformed([Link] evt) {

// TODO add your handling code here:

61 | P a g e
 DefaultTableModel model=(DefaultTableModel)[Link]();

int rows=[Link]();

if(rows > 0) {

for(int i=0; i<rows; i++) {

[Link](0);

CLOSE BUTTON

private void jButton3ActionPerformed([Link] evt) {

// TODO add your handling code here:

dispose();

62 | P a g e
GET APPOINTMENT BUTTON

private void jButton1ActionPerformed([Link] evt) {

// TODO add your handling code here:

String DoctorName = [Link]();

String Depart=[Link]();

String DateTime=[Link]();
63 | P a g e
 [Link](null, "You have an appointment
with Doctor " + DoctorName + " of department: " + Depart + " at: " +
DateTime + " . Kindly be on time.");

CLEARBUTTON

private void jButton3ActionPerformed([Link] evt) {

// TODO add your handling code here:

[Link](null);

[Link](null);

[Link](null);

[Link](null);

CLOSE BUTTON

private void jButton2ActionPerformed([Link] evt) {

// TODO add your handling code here:

dispose();

64 | P a g e
 THANKYOU
THANK YOU

65 | P a g e