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

 

##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 cbsepython

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.

One thought on “Hospital Management System Python Project Class 12”

Leave a Reply

Your email address will not be published. Required fields are marked *