Hospital Management System Python Project Class 12

 

Software requirements

Operating system : windows 10

Python 3 : for execution of program

Mysql : for storing data in the database

Python – mysql connector : for database connectivity

 




 

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
##hospital management software @cbsepython.in
##PRINTING WELCOME NOTE
while(True):
print("""
================================
WELCOME TO MYHOSPITAL
================================
""")
##creating database connectivity
import mysql.connector
passwd=str(input("ENTER THE DATABASE PASSWORD;"))
mysql=mysql.connector.connect(host="localhost",user="root",passwd="admin")
mycursor=mysql.cursor()
#creating database
mycursor.execute("create database if not exists my_hospitals")
mycursor.execute("use my_hospitals")
#creating the tables we need
mycursor.execute("create table if not exists patient_details(puid int(10) primary key,name varchar(30) not null,age int(3),address varchar(50),doctor_recommended varchar(30))")
mycursor.execute("create table if not exists doctor_details(name varchar(30) primary key,specialisation varchar(40),age int(2),address varchar(30),contact varchar(15),fees int(10),monthly_salary int(10))")
mycursor.execute("create table if not exists nurse_details(name varchar(30) primary key,age int(2),address varchar(30),contact varchar(15),monthly_salary int(10))")
mycursor.execute("create table if not exists other_workers_details(name varchar(30) primary key,age int(2),address varchar(30),contact varchar(15),monthly_salary int(10))")
#login or signup option
#creating table for storing the username and password of the user
mycursor.execute("create table if not exists user_data(username varchar(30) primary key,password varchar(30) default'000')")
#printing option
while(True):
print("""
1. SIGN IN (LOGIN)
2. SIGN UP (REGISTER)
""")
r=int(input("enter your choice:"))
#IF USER WANTS TO REGISTER
if r==2:
print("""
=======================================
!!!!!!!PLEASE REGISTER YOURSELF!!!!!!!!
=======================================
""")
u=input("ENTER YOUR PREFERRED USERNAME!!:")
p=input("ENTER YOUR PREFERRED PASSWORD (PASSWORD SHOULD BE STRONG!!!:")
#ENTERING THE ENTERED VALUE TO THE USER_DATA TABLE
mycursor.execute("insert into user_data values('"+u+"','"+p+"')")
mysql.commit()
print("""
=======================================
!!!!!!!!REGISTERED SUCCESSFULLY!!!!!!!!
=======================================
""")
x=input("enter any key to continue:")
#IF USER WANTS TO LOGIN
elif r==1:
#PRINTING THE SINGIN OPTION AGAIN TO THE USER AFTER REGISTRATION
print("""
==================================
!!!!!!!! {{SIGN IN }} !!!!!!!!!!
==================================
""")
un=input("ENTER THE USERNAME!!:")
ps=input("ENTER THE PASSWORD!!:")
mycursor.execute("select password from user_data where username='"+un+"'")
row=mycursor.fetchall()
for i in row:
a=list(i)
if a[0]==str(ps):
while(True):
##displaying the task you can perform
print("""
1.ADMINISTRATION
2.PATIENT (ADMISSION NAD DISCHARGE PROCESS)
3.SIGN OUT
""")
##asking for the task from user
a=int(input("ENTER YOUR CHOICE:"))
#if user wants to enter administration option
if a==1:
print("""
1. SHOW DETAILS
2. ADD NEW MEMBER
3. DELETE EXISTING ONE
4. EXIT
""")
b=int(input("ENTER YOUR CHOICE:"))
#showing the existing details
if b==1:
print("""
1. DOCTOR DETAILS
2. NURSE DETAILS
3. OTHER WORKERS
""")
#ASKING USER'S CHOICE
c=int(input("ENTER YOUR CHOICE:"))
#if user wants to see the details of doctors
if c==1:
mycursor.execute("select * from doctor_details")
row=mycursor.fetchall()
for i in row:
b=0
v=list(i)
k=["NAME","SPECIALISATION","AGE","ADDRESS","CONTACT","FEES","MONTHLY_SALARY"]
d=dict(zip(k,v))
print(d)
#if user wants to see the details of nurses
elif c==2:
mycursor.execute("select * from nurse_details")
row=mycursor.fetchall()
for i in row:
v=list(i)
k=["NAME","SPECIALISATION","AGE","ADDRESS","CONTACT","MONTHLY_SALARY"]
d=dict(zip(k,v))
print(d)
#if user wants to see the details of other_workers
elif c==3:
mycursor.execute("select * from other_workers_details")
row=mycursor.fetchall()
for i in row:
v=list(i)
k=["NAME","SPECIALISATION","AGE","ADDRESS","CONTACT","MONTHLY_SALARY"]
d=dict(zip(k,v))
print(d)
#IF USER WANTS TO ENTER DETAILS
elif b==2:
print("""
1. DOCTOR DETAILS
2. NURSE DETAILS
3. OTHER WORKERS
""")
c=int(input("ENTER YOUR CHOICE:"))
#FOR ENTERING DETAILS OF DOCTORS
if c==1:
#ASKING THE DETAILS
name=input("ENTER DR. NAME:")
spe=input("ENTER SPECIALISATION:")
age=input("ENTER AGE:")
add=input("ENTER ADDRESS:")
cont=input("ENTER CONTACT NO.:")
fees=input("ENTER FEES:")
ms=input("ENTER MONTHLY_SALARY:")
#INSERTING VALUES ENTERED INTO THE DOCTORS_TABLE
mycursor.execute("insert into doctor_details values('"+name+"','"+spe+"','"+age+"','"+add+"','"+cont+"','"+fees+"','"+ms+"')")
mysql.commit()
print("SUCCESSFULLY ADDED")
#for entering nurse details
elif c==2:
#ASKING THE DETAILS
name=input("ENTER NURSE NAME:")
age=input("ENTER AGE:")
add=input("ENTER ADDRESS:")
cont=input("ENTER CONTACT NO.:")
ms=int(input("ENTER MONTHLY_SALARY:"))
#INSERTING VALUES ENTERED TO THE TABLE
mycursor.execute("insert into nurse_details values('"+name+"','"+age+"','"+add+"','"+cont+"','"+str(ms)+"')")
mysql.commit()
print("SUCCESSFULLY ADDED")
#for entering workers details
elif c==3:
#ASKING THE DETAILS
name=input("ENTER WORKER NAME:")
age=input("ENTER AGE:")
add=input("ENTER ADDRESS:")
cont=input("ENTER CONTACT NO.:")
ms=input("ENTER MONTHLY_SALARY:")
#INSERTING VALUES ENTERED TO THE TABLE
mycursor.execute("insert into other_workers_details values('"+name+"','"+age+"','"+add+"','"+cont+"','"+ms+"')")
mysql.commit()
print("SUCCESSFULLY ADDED")
#if unser wants to delete data
elif b==3:
print("""
1. DOCTOR DETAILS
2. NURSE DETAILS
3. OTHER WORKERS
""")
c=int(input("ENTER YOUR CHOICE:"))
#deleting doctor's details
if c==1:
name=input("ENTER DOCTOR'S NAME:")
mycursor.execute("select * from doctor_details where name=='"+name+"'")
row=mycursor.fetchall()
print(row)
p=input("you really wanna delete this data? (y/n):")
if p=="y":
mycursor.execute("delete from doctor_details where name='"+name+"'")
mysql.commit()
print("SUCCESSFULLY DELETED!!")
else:
print("NOT DELETED")
#deleting nurse details
elif c==2:
name=input("ENTER NURSE NAME:")
mycursor.execute("select * nurse_details where name=='"+name+"'")
row=mycursor.fetchall()
print(row)
p=input("you really wanna delete this data? (y/n):")
if p=="y":
mycursor.execute("delete from nurse_details where name='"+name+"'")
mysql.commit()
print("SUCCESSFULLY DELETED!!")
else:
print("NOT DELETED")
#deleting other_workers details
elif c==3:
name=input("ENTER THE WORKER NAME:")
mycursor.execute("select * from workers_details where name=='"+name+"'")
row=mycursor.fetchall()
print(row)
p=input("you really wanna delete this data? (y/n):")
if p=="y":
mycursor.execute("delete from other_workers_details where name='"+name+"'")
mysql.commit()
print("SUCCESSFULLY DELETED!!")
else:
print("NOT DELETED")
elif b==4:
break
#entering the patient details table
elif a==2:
print("""
1. SHOW PATIENT DETAILS
2. ADD NEW PATIENT
3. DISCHARGE PATIENT
4. EXIT
""")
b=int(input("ENTER YOUR CHOICE:"))
#showing the existing details
#if user wants to see the details of PATIENT
if b==1:
mycursor.execute("select * from patient_details")
row=mycursor.fetchall()
for i in row:
b=0
v=list(i)
k=["NAME","SEX","AGE","ADDRESS","CONTACT"]
d=dict(zip(k,v))
print(d)
#adding new patient
elif b==2:
name=str(input("ENTER NAME: "))
sex=str(input("ENTER SEX: "))
age=str(input("ENTER AGE: "))
address=str(input("ADDRESS: "))
contact=str(input("CONTACT NUMBER: "))
mycursor.execute ("insert into patient_details values('"+str(name)+"','"+str(sex)+"','"+str(age)+"','"+str(address)+"','"+str(contact)+"')")
mysql.commit()
mycursor.execute("select * from patient_details")
for i in mycursor:
v=list(i)
k=['NAME','SEX','AGE','ADDRESS','CONTACT']
print(dict(zip(k,v)))
print("""
====================================
!!!!!!!REGISTERED SUCCESSFULLY!!!!!!
====================================
""")
#dischare process
elif b==3:
name=input("ENTER THE PATIENT NAME:")
mycursor.execute("select * from patient_details where name='"+name+"'")
row=mycursor.fetchall()
print(row)
bill=input("HAS HE PAID ALL THE BILLS ? (y/n):")
if bill=="y":
mycursor.execute("delete from patient_details where name='"+name+"'")
mysql.commit()
#if user wants to exit
elif b==4:
break
###SIGN OUT
elif a==3:
break
#IF THE USERNAME AND PASSWORD IS NOT IN THE DATABASE
else:
break
##hospital management software @cbsepython.in ##PRINTING WELCOME NOTE while(True): print(""" ================================ WELCOME TO MYHOSPITAL ================================ """) ##creating database connectivity import mysql.connector passwd=str(input("ENTER THE DATABASE PASSWORD;")) mysql=mysql.connector.connect(host="localhost",user="root",passwd="admin") mycursor=mysql.cursor() #creating database mycursor.execute("create database if not exists my_hospitals") mycursor.execute("use my_hospitals") #creating the tables we need mycursor.execute("create table if not exists patient_details(puid int(10) primary key,name varchar(30) not null,age int(3),address varchar(50),doctor_recommended varchar(30))") mycursor.execute("create table if not exists doctor_details(name varchar(30) primary key,specialisation varchar(40),age int(2),address varchar(30),contact varchar(15),fees int(10),monthly_salary int(10))") mycursor.execute("create table if not exists nurse_details(name varchar(30) primary key,age int(2),address varchar(30),contact varchar(15),monthly_salary int(10))") mycursor.execute("create table if not exists other_workers_details(name varchar(30) primary key,age int(2),address varchar(30),contact varchar(15),monthly_salary int(10))") #login or signup option #creating table for storing the username and password of the user mycursor.execute("create table if not exists user_data(username varchar(30) primary key,password varchar(30) default'000')") #printing option while(True): print(""" 1. SIGN IN (LOGIN) 2. SIGN UP (REGISTER) """) r=int(input("enter your choice:")) #IF USER WANTS TO REGISTER if r==2: print(""" ======================================= !!!!!!!PLEASE REGISTER YOURSELF!!!!!!!! ======================================= """) u=input("ENTER YOUR PREFERRED USERNAME!!:") p=input("ENTER YOUR PREFERRED PASSWORD (PASSWORD SHOULD BE STRONG!!!:") #ENTERING THE ENTERED VALUE TO THE USER_DATA TABLE mycursor.execute("insert into user_data values('"+u+"','"+p+"')") mysql.commit() print(""" ======================================= !!!!!!!!REGISTERED SUCCESSFULLY!!!!!!!! ======================================= """) x=input("enter any key to continue:") #IF USER WANTS TO LOGIN elif r==1: #PRINTING THE SINGIN OPTION AGAIN TO THE USER AFTER REGISTRATION print(""" ================================== !!!!!!!! {{SIGN IN }} !!!!!!!!!! ================================== """) un=input("ENTER THE USERNAME!!:") ps=input("ENTER THE PASSWORD!!:") mycursor.execute("select password from user_data where username='"+un+"'") row=mycursor.fetchall() for i in row: a=list(i) if a[0]==str(ps): while(True): ##displaying the task you can perform print(""" 1.ADMINISTRATION 2.PATIENT (ADMISSION NAD DISCHARGE PROCESS) 3.SIGN OUT """) ##asking for the task from user a=int(input("ENTER YOUR CHOICE:")) #if user wants to enter administration option if a==1: print(""" 1. SHOW DETAILS 2. ADD NEW MEMBER 3. DELETE EXISTING ONE 4. EXIT """) b=int(input("ENTER YOUR CHOICE:")) #showing the existing details if b==1: print(""" 1. DOCTOR DETAILS 2. NURSE DETAILS 3. OTHER WORKERS """) #ASKING USER'S CHOICE c=int(input("ENTER YOUR CHOICE:")) #if user wants to see the details of doctors if c==1: mycursor.execute("select * from doctor_details") row=mycursor.fetchall() for i in row: b=0 v=list(i) k=["NAME","SPECIALISATION","AGE","ADDRESS","CONTACT","FEES","MONTHLY_SALARY"] d=dict(zip(k,v)) print(d) #if user wants to see the details of nurses elif c==2: mycursor.execute("select * from nurse_details") row=mycursor.fetchall() for i in row: v=list(i) k=["NAME","SPECIALISATION","AGE","ADDRESS","CONTACT","MONTHLY_SALARY"] d=dict(zip(k,v)) print(d) #if user wants to see the details of other_workers elif c==3: mycursor.execute("select * from other_workers_details") row=mycursor.fetchall() for i in row: v=list(i) k=["NAME","SPECIALISATION","AGE","ADDRESS","CONTACT","MONTHLY_SALARY"] d=dict(zip(k,v)) print(d) #IF USER WANTS TO ENTER DETAILS elif b==2: print(""" 1. DOCTOR DETAILS 2. NURSE DETAILS 3. OTHER WORKERS """) c=int(input("ENTER YOUR CHOICE:")) #FOR ENTERING DETAILS OF DOCTORS if c==1: #ASKING THE DETAILS name=input("ENTER DR. NAME:") spe=input("ENTER SPECIALISATION:") age=input("ENTER AGE:") add=input("ENTER ADDRESS:") cont=input("ENTER CONTACT NO.:") fees=input("ENTER FEES:") ms=input("ENTER MONTHLY_SALARY:") #INSERTING VALUES ENTERED INTO THE DOCTORS_TABLE mycursor.execute("insert into doctor_details values('"+name+"','"+spe+"','"+age+"','"+add+"','"+cont+"','"+fees+"','"+ms+"')") mysql.commit() print("SUCCESSFULLY ADDED") #for entering nurse details elif c==2: #ASKING THE DETAILS name=input("ENTER NURSE NAME:") age=input("ENTER AGE:") add=input("ENTER ADDRESS:") cont=input("ENTER CONTACT NO.:") ms=int(input("ENTER MONTHLY_SALARY:")) #INSERTING VALUES ENTERED TO THE TABLE mycursor.execute("insert into nurse_details values('"+name+"','"+age+"','"+add+"','"+cont+"','"+str(ms)+"')") mysql.commit() print("SUCCESSFULLY ADDED") #for entering workers details elif c==3: #ASKING THE DETAILS name=input("ENTER WORKER NAME:") age=input("ENTER AGE:") add=input("ENTER ADDRESS:") cont=input("ENTER CONTACT NO.:") ms=input("ENTER MONTHLY_SALARY:") #INSERTING VALUES ENTERED TO THE TABLE mycursor.execute("insert into other_workers_details values('"+name+"','"+age+"','"+add+"','"+cont+"','"+ms+"')") mysql.commit() print("SUCCESSFULLY ADDED") #if unser wants to delete data elif b==3: print(""" 1. DOCTOR DETAILS 2. NURSE DETAILS 3. OTHER WORKERS """) c=int(input("ENTER YOUR CHOICE:")) #deleting doctor's details if c==1: name=input("ENTER DOCTOR'S NAME:") mycursor.execute("select * from doctor_details where name=='"+name+"'") row=mycursor.fetchall() print(row) p=input("you really wanna delete this data? (y/n):") if p=="y": mycursor.execute("delete from doctor_details where name='"+name+"'") mysql.commit() print("SUCCESSFULLY DELETED!!") else: print("NOT DELETED") #deleting nurse details elif c==2: name=input("ENTER NURSE NAME:") mycursor.execute("select * nurse_details where name=='"+name+"'") row=mycursor.fetchall() print(row) p=input("you really wanna delete this data? (y/n):") if p=="y": mycursor.execute("delete from nurse_details where name='"+name+"'") mysql.commit() print("SUCCESSFULLY DELETED!!") else: print("NOT DELETED") #deleting other_workers details elif c==3: name=input("ENTER THE WORKER NAME:") mycursor.execute("select * from workers_details where name=='"+name+"'") row=mycursor.fetchall() print(row) p=input("you really wanna delete this data? (y/n):") if p=="y": mycursor.execute("delete from other_workers_details where name='"+name+"'") mysql.commit() print("SUCCESSFULLY DELETED!!") else: print("NOT DELETED") elif b==4: break #entering the patient details table elif a==2: print(""" 1. SHOW PATIENT DETAILS 2. ADD NEW PATIENT 3. DISCHARGE PATIENT 4. EXIT """) b=int(input("ENTER YOUR CHOICE:")) #showing the existing details #if user wants to see the details of PATIENT if b==1: mycursor.execute("select * from patient_details") row=mycursor.fetchall() for i in row: b=0 v=list(i) k=["NAME","SEX","AGE","ADDRESS","CONTACT"] d=dict(zip(k,v)) print(d) #adding new patient elif b==2: name=str(input("ENTER NAME: ")) sex=str(input("ENTER SEX: ")) age=str(input("ENTER AGE: ")) address=str(input("ADDRESS: ")) contact=str(input("CONTACT NUMBER: ")) mycursor.execute ("insert into patient_details values('"+str(name)+"','"+str(sex)+"','"+str(age)+"','"+str(address)+"','"+str(contact)+"')") mysql.commit() mycursor.execute("select * from patient_details") for i in mycursor: v=list(i) k=['NAME','SEX','AGE','ADDRESS','CONTACT'] print(dict(zip(k,v))) print(""" ==================================== !!!!!!!REGISTERED SUCCESSFULLY!!!!!! ==================================== """) #dischare process elif b==3: name=input("ENTER THE PATIENT NAME:") mycursor.execute("select * from patient_details where name='"+name+"'") row=mycursor.fetchall() print(row) bill=input("HAS HE PAID ALL THE BILLS ? (y/n):") if bill=="y": mycursor.execute("delete from patient_details where name='"+name+"'") mysql.commit() #if user wants to exit elif b==4: break ###SIGN OUT elif a==3: break #IF THE USERNAME AND PASSWORD IS NOT IN THE DATABASE else: break
##hospital management software @cbsepython.in
##PRINTING WELCOME NOTE
while(True):
    print("""
            ================================
               WELCOME TO MYHOSPITAL
            ================================
    """)
    ##creating database connectivity
    import mysql.connector
    passwd=str(input("ENTER THE DATABASE PASSWORD;"))
    
    mysql=mysql.connector.connect(host="localhost",user="root",passwd="admin")
    mycursor=mysql.cursor()
    #creating database
    mycursor.execute("create database if not exists my_hospitals")
    mycursor.execute("use my_hospitals")
    #creating the tables we need
    mycursor.execute("create table if not exists patient_details(puid int(10) primary key,name varchar(30) not null,age int(3),address varchar(50),doctor_recommended varchar(30))")
    mycursor.execute("create table if not exists doctor_details(name varchar(30) primary key,specialisation varchar(40),age int(2),address varchar(30),contact varchar(15),fees int(10),monthly_salary int(10))")
    mycursor.execute("create table if not exists nurse_details(name varchar(30) primary key,age int(2),address varchar(30),contact varchar(15),monthly_salary int(10))")
    mycursor.execute("create table if not exists other_workers_details(name varchar(30) primary key,age int(2),address varchar(30),contact varchar(15),monthly_salary int(10))")
    #login or signup option
    #creating table for storing the username and password of the user
    mycursor.execute("create table if not exists user_data(username varchar(30) primary key,password varchar(30) default'000')")
    #printing option
    while(True):
        print("""
                        1. SIGN IN (LOGIN)
                        2. SIGN UP (REGISTER)
                                                            """)
    
        r=int(input("enter your choice:"))
    
    
    
        #IF USER WANTS TO REGISTER
        if r==2:
            print("""

                =======================================
                !!!!!!!PLEASE REGISTER YOURSELF!!!!!!!!
                =======================================
                                                    """)
            u=input("ENTER YOUR PREFERRED USERNAME!!:")
            p=input("ENTER YOUR PREFERRED PASSWORD (PASSWORD SHOULD BE STRONG!!!:")
            #ENTERING THE ENTERED VALUE TO THE USER_DATA TABLE
            mycursor.execute("insert into user_data values('"+u+"','"+p+"')")
            mysql.commit()
    
    
            print("""
                =======================================
                !!!!!!!!REGISTERED SUCCESSFULLY!!!!!!!!
                =======================================
                                                    """)
            x=input("enter any key to continue:")
        #IF USER WANTS TO LOGIN
        elif r==1:
        
        #PRINTING THE SINGIN OPTION AGAIN TO THE USER AFTER REGISTRATION

                print("""
                    ==================================
                    !!!!!!!!  {{SIGN IN }}  !!!!!!!!!!
                    ==================================
                                                        """)
                un=input("ENTER THE USERNAME!!:")
                ps=input("ENTER THE PASSWORD!!:")
                
                mycursor.execute("select password from user_data where username='"+un+"'")
                row=mycursor.fetchall()
                for i in row:
                    a=list(i)
                    if a[0]==str(ps):
                        while(True):
                            ##displaying the task you can perform
                            print("""
                                1.ADMINISTRATION
                                2.PATIENT (ADMISSION NAD DISCHARGE PROCESS)
                                3.SIGN OUT
                                                              
                                                            """)
    

                            ##asking for the task from user
                            a=int(input("ENTER YOUR CHOICE:"))
                            #if user wants to enter administration option
                            if a==1:
                                print("""
                                    1. SHOW DETAILS
                                    2. ADD NEW MEMBER
                                    3. DELETE EXISTING ONE
                                    4. EXIT
                                                             """)
                                b=int(input("ENTER YOUR CHOICE:"))
                                #showing the existing details
                                if b==1:
                                    print("""
                                        1. DOCTOR DETAILS
                                        2. NURSE DETAILS
                                        3. OTHER WORKERS
                                                         """)
                                    
                                    
                                    #ASKING USER'S CHOICE
                                    c=int(input("ENTER YOUR CHOICE:"))
                                    #if user wants to see the details of doctors 
                                    if c==1:
                                        mycursor.execute("select * from doctor_details")
                                        row=mycursor.fetchall()
                                        for i in row:
                                            b=0
                                            v=list(i)
                                            k=["NAME","SPECIALISATION","AGE","ADDRESS","CONTACT","FEES","MONTHLY_SALARY"]
                                            d=dict(zip(k,v))
                                            print(d)
                                    #if user wants to see the details of nurses    
                                    elif c==2:
                                        mycursor.execute("select * from nurse_details")
                                        row=mycursor.fetchall()
                                        for i in row:
                                            v=list(i)
                                            k=["NAME","SPECIALISATION","AGE","ADDRESS","CONTACT","MONTHLY_SALARY"]
                                            d=dict(zip(k,v))
                                            print(d)
                                    #if user wants to see the details of other_workers
                                    elif c==3:
                                        mycursor.execute("select * from other_workers_details")
                                        row=mycursor.fetchall()
                                        for i in row:
                                            v=list(i)
                                            k=["NAME","SPECIALISATION","AGE","ADDRESS","CONTACT","MONTHLY_SALARY"]
                                            d=dict(zip(k,v))
                                            print(d)
                                #IF USER WANTS TO ENTER DETAILS
                                elif b==2:
                                    print("""

                                        1. DOCTOR DETAILS
                                        2. NURSE DETAILS
                                        3. OTHER WORKERS
                                                                                    """)
                                    c=int(input("ENTER YOUR CHOICE:"))
                                    #FOR ENTERING DETAILS OF DOCTORS
                                    if c==1:
                                      #ASKING THE DETAILS
                                      name=input("ENTER DR. NAME:")
                                      spe=input("ENTER SPECIALISATION:")
                                      age=input("ENTER AGE:")
                                      add=input("ENTER ADDRESS:")
                                      cont=input("ENTER CONTACT NO.:")
                                      fees=input("ENTER FEES:")
                                      ms=input("ENTER MONTHLY_SALARY:")
                                      #INSERTING VALUES ENTERED INTO THE DOCTORS_TABLE
                                      mycursor.execute("insert into doctor_details values('"+name+"','"+spe+"','"+age+"','"+add+"','"+cont+"','"+fees+"','"+ms+"')")
                                      mysql.commit()
                                      print("SUCCESSFULLY ADDED")
                                    #for entering nurse details
                                    elif c==2:
                                      #ASKING THE DETAILS
                                      name=input("ENTER NURSE NAME:")
                                      age=input("ENTER AGE:")
                                      add=input("ENTER ADDRESS:")
                                      cont=input("ENTER CONTACT NO.:")
                                      ms=int(input("ENTER MONTHLY_SALARY:"))
                                      #INSERTING VALUES ENTERED TO THE TABLE
                                      mycursor.execute("insert into nurse_details values('"+name+"','"+age+"','"+add+"','"+cont+"','"+str(ms)+"')")
                                      mysql.commit()
                                      print("SUCCESSFULLY ADDED")
                                    #for entering workers details
                                    elif c==3:
                                  #ASKING THE DETAILS
                                      name=input("ENTER WORKER NAME:")
                                      age=input("ENTER AGE:")
                                      add=input("ENTER ADDRESS:")
                                      cont=input("ENTER CONTACT NO.:")
                                      ms=input("ENTER MONTHLY_SALARY:")
                                      #INSERTING VALUES ENTERED TO THE TABLE
                                      mycursor.execute("insert into other_workers_details values('"+name+"','"+age+"','"+add+"','"+cont+"','"+ms+"')")
                                      mysql.commit()
                                      print("SUCCESSFULLY ADDED")
                                #if unser wants to delete data
                                elif b==3:
                                   print("""
                                        1. DOCTOR DETAILS
                                        2. NURSE DETAILS
                                        3. OTHER WORKERS
                                                                                    """)
                                   c=int(input("ENTER YOUR CHOICE:"))
                                   #deleting doctor's details
                                   if c==1:
                                       name=input("ENTER DOCTOR'S NAME:")
                                       mycursor.execute("select * from doctor_details where name=='"+name+"'")
                                       row=mycursor.fetchall()
                                       print(row)
                                       p=input("you really wanna delete this data? (y/n):")
                                       if p=="y":
                                           mycursor.execute("delete from doctor_details where name='"+name+"'")
                                           mysql.commit()
                                           print("SUCCESSFULLY DELETED!!")
                                       else:
                                           print("NOT DELETED")
                                       
                                      
                                   #deleting nurse details
                                   elif c==2:
                                       name=input("ENTER NURSE NAME:")
                                       mycursor.execute("select * nurse_details where name=='"+name+"'")
                                       row=mycursor.fetchall()
                                       print(row)
                                       p=input("you really wanna delete this data? (y/n):")
                                       if p=="y":
                                           mycursor.execute("delete from nurse_details where name='"+name+"'")
                                           mysql.commit()
                                           print("SUCCESSFULLY DELETED!!")
                                       else:
                                           print("NOT DELETED")
                                   #deleting other_workers details
                                   elif c==3:
                                       name=input("ENTER THE WORKER NAME:")
                                       mycursor.execute("select * from workers_details where name=='"+name+"'")
                                       row=mycursor.fetchall()
                                       print(row)
                                       p=input("you really wanna delete this data? (y/n):")
                                       if p=="y":
                                           mycursor.execute("delete from other_workers_details where name='"+name+"'")
                                           mysql.commit()
                                           print("SUCCESSFULLY DELETED!!")
                                       else:
                                           print("NOT DELETED")
                                elif b==4:
                                    break
                               
                            #entering the patient details table
                            elif a==2:
                                
                                print("""
                                        1. SHOW  PATIENT DETAILS
                                        2. ADD  NEW PATIENT
                                        3. DISCHARGE PATIENT
                                        4. EXIT
                                                                          """)
                                b=int(input("ENTER YOUR CHOICE:"))
                                #showing the existing details
                                #if user wants to see the details of PATIENT
                                if b==1:
                                    mycursor.execute("select * from patient_details")
                                    row=mycursor.fetchall()
                                    for i in row:
                                        b=0
                                        v=list(i)
                                        k=["NAME","SEX","AGE","ADDRESS","CONTACT"]
                                        d=dict(zip(k,v))
                                        print(d)
                                    
                                #adding new patient
                                elif b==2:
                                    name=str(input("ENTER NAME: "))
                                    sex=str(input("ENTER SEX: "))
                                    age=str(input("ENTER AGE: "))
                                    address=str(input("ADDRESS: "))
                                    contact=str(input("CONTACT NUMBER: "))
                                    mycursor.execute ("insert into patient_details values('"+str(name)+"','"+str(sex)+"','"+str(age)+"','"+str(address)+"','"+str(contact)+"')")
                                    mysql.commit()
                                    mycursor.execute("select * from patient_details")
                                    for i in mycursor:
                                        v=list(i)
                                        k=['NAME','SEX','AGE','ADDRESS','CONTACT']
                                        print(dict(zip(k,v)))
                                        print("""
                                        ====================================
                                        !!!!!!!REGISTERED SUCCESSFULLY!!!!!!
                                        ====================================
                                                        """)
                                #dischare process
                                elif b==3:
                                    name=input("ENTER THE PATIENT NAME:")
                                    mycursor.execute("select * from patient_details where name='"+name+"'")
                                    row=mycursor.fetchall()
                                    print(row)
                                    bill=input("HAS HE PAID ALL THE BILLS ? (y/n):")
                                    if bill=="y":
                                        mycursor.execute("delete from patient_details where name='"+name+"'")
                                        mysql.commit()
                                #if user wants to exit
                                elif b==4:
                                    break
                            ###SIGN OUT
                            elif a==3:
                                break
                                    
                                
                   #IF THE USERNAME AND PASSWORD IS NOT IN THE DATABASE
                    else:
                        break

 

Output:

================================
WELCOME TO MYHOSPITAL
================================

ENTER THE DATABASE PASSWORD;"admin"

1. SIGN IN (LOGIN)
2. SIGN UP (REGISTER)





enter your choice:2

=======================================
!!!!!!!PLEASE REGISTER YOURSELF!!!!!!!!
=======================================

ENTER YOUR PREFERRED USERNAME!!:"cbse"
ENTER YOUR PREFERRED PASSWORD (PASSWORD SHOULD BE STRONG!!!:"cbse@123"

=======================================
!!!!!!!!REGISTERED SUCCESSFULLY!!!!!!!!
=======================================

enter any key to continue:

1. SIGN IN (LOGIN)
2. SIGN UP (REGISTER)

enter your choice:1

==================================
!!!!!!!! {{SIGN IN }} !!!!!!!!!!
==================================

ENTER THE USERNAME!!:"cbse"
ENTER THE PASSWORD!!:"cbse@123"

1.ADMINISTRATION
2.PATIENT (ADMISSION NAD DISCHARGE PROCESS)
3.SIGN OUT


ENTER YOUR CHOICE:1

1. SHOW DETAILS
2. ADD NEW MEMBER
3. DELETE EXISTING ONE
4. EXIT



ENTER YOUR CHOICE:2


1. DOCTOR DETAILS
2. NURSE DETAILS
3. OTHER WORKERS

ENTER YOUR CHOICE:1
ENTER DR. NAME:"Dr. Rohit Sharma"
ENTER SPECIALISATION:"Physician"
ENTER AGE:34
ENTER ADDRESS:"Mumbai"
ENTER CONTACT NO.:1234512345
ENTER FEES:450
ENTER MONTHLY_SALARY:550000
SUCCESSFULLY ADDED

1.ADMINISTRATION
2.PATIENT (ADMISSION NAD DISCHARGE PROCESS)
3.SIGN OUT


ENTER YOUR CHOICE:1

1. SHOW DETAILS
2. ADD NEW MEMBER
3. DELETE EXISTING ONE
4. EXIT

ENTER YOUR CHOICE:1

1. DOCTOR DETAILS
2. NURSE DETAILS
3. OTHER WORKERS

ENTER YOUR CHOICE:1
{'NAME': '"Dr. Rohit Sharma"', 'SPECIALISATION': '"Physician"', 'AGE': 34, 'ADDRESS': '"Mumbai"', 'CONTACT': '1234512345', 'FEES': 450, 'MONTHLY_SALARY': 550000}
{'NAME': 'rajkumar', 'SPECIALISATION': 'eye', 'AGE': 27, 'ADDRESS': 'new delhi', 'CONTACT': '1231231224', 'FEES': 1000, 'MONTHLY_SALARY': 24000}

1.ADMINISTRATION
2.PATIENT (ADMISSION NAD DISCHARGE PROCESS)
3.SIGN OUT


ENTER YOUR CHOICE:

 

Hospital Management System Python Project Class 12

Screenshots:

Hospital Management System Python Project Class 12

 

class 12 project cs

 

HM3

 

class 12 project cs

 

class 12 project cs

 

 

 

More Projects for Computer Science/ IP in Python

 

 

By Jitendra Singh

A complete solution for the students of class 9 to 12 having subject Information Technology (402), Computer Science (083). Explore our website for all the useful content as Topic wise notes, Solved QNA, MCQs, Projects and Quiz related to the latest syllabus.

Comments are closed.

Copywrite © 2020-2025, CBSE Python,
All Rights Reserved
error: Content is protected !!