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

 

 

Comments are closed.

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