4 0
Read Time:4 Minute, 41 Second

DIRECT DOWNLOAD FILES FROM OUR TELEGRAM GROUP

LEARN HOW TO MAKE THIS LIBRARY MANGEMENT PROJECT

Copy paste below given code into MS WORD to prepare your project file also edit your details like names , school name , class etc.

INDEX
 
 
1. CERTIFICATE
2. ACKNOWLEDGEMENT
3. MYSQL CODING
4. PYTHON CODING
5. SOFTWARE REQUIREMENTS
6. HARDWARE REQUIREMENTS

----------------------------------------------------------------------------------- 

SOFTWARE AND HARDWARE REQUIREMENTS

Software Requirements :

Mysql server : mysql server must be installed in computer. It will be used for accessing data of project. Tables will be made in server in which data will be stored.

Python idle : python idle must be installed in computer. It will be used for executing python scripts.
Mysql.connector : it will connect python idle with mysql server. To install it open cmd and write pip install mysql.connector
 
Hardware Requirements:
Computer must be of 500 gb hard-disk , intel i3 processor and 8 gb ram (minimum)

----------------------------------------------------------------------------------- 
CERTIFICATE
CLASS: 12TH C                                YEAR: 2021-2022


This is to certify that LIBRARY MANAGEMENT PROJECT is successfully completed by Rohit Saxena of Class: 12th C Roll no. 30 for the academic year 2021-2022 in the School Computer lab.


Head Teacher :
External Examiner :
Internal Examiner :
Date :


----------------------------------------------------------------------------------- 

 
Principal
 
Acknowledgement
I, Rohit Saxena of class 12th C would like to express our sincere gratitude to our computer science teacher Mr. Gaurav Garg, PGT COMPUTER SCIENCE, for her vital support, guidance and encouragement – without which
this project would not have come forth.
We would also like to express our gratitude to
our school ST. ANDREWS for letting us use the school laboratory.
 
 
 
 ----------------------------------------------------------------------------------

 
LIBRARY MANAGEMENT PROJECT
This project is made using two python scripts

First ( MYSQL ) : coding for making tables in mysql server.
We will write python code for making tables and database in mysql server. We will use python mysql connectivity for this. After writing the code we will execute this script only once. And after executing all the tables and database will be created in the server.
Second ( PYTHON IDLE ) : coding for using project interface.
Now we have made our database in mysql server using python idle. So now we will write the python code so that we can insert and access data from our database. We will create several functions for our interface of project. These functions will drive the working of our project / system.

----------------------------------------------------------------------------------- 

MYSQL [ passwd and user should be named according to your system ]

We will create a database “l1” and in that we will create 3 tables.

----------------------------------------------------------------------------------- 

import mysql.connector as a
con = a.connect(host="localhost",
              user="root",
              passwd="12345")
c = con.cursor()
sql1 = "create database l1"
c.execute(sql1)
sql2 = "use l1"
c.execute(sql2)
sql3 = "create table books (bname varchar(50),bcode varchar(10), total int, subject varchar(50))"
c.execute(sql3)
sql4 = "create table issue (sname varchar(50),regno varchar(10), bcode varchar(10), idate varchar(10))"
c.execute(sql4)
sql5 = "create table submit (sname varchar(50), regno varchar(10), bcode varchar(10), sdate varchar(10))"
c.execute(sql5)
con.commit()
 
----------------------------------------------------------------------------------- 

PYTHON IDLE

----------------------------------------------------------------------------------- 

import mysql.connector as a    
con = a.connect (host="localhost",user="root",passwd="12345",database="l1")
 
def addbook():
        bn = input("Enter  BOOK Name : ")
        c = input("Enter BOOK Code : ")
        t = input("Total Books : ")
        s = input("Enter Subject : ")
        data = (bn,c,t,s)
        sql = 'insert into books values(%s,%s,%s,%s)'
        c = con.cursor()
        c.execute(sql,data)
        con.commit()
        print(">----------------------------------------------------------------------------------------<")
        print("Data Entered Successfully")
        main()
   
def issueb():
        n = input("Enter Name : ")
        r = input("Enter Reg No : ")
        co = input("Enter Book Code : ")
        d = input("Enter Date : ")
        a = "insert into issue values(%s,%s,%s,%s)"
        data = (n,r,co,d)
        c = con.cursor()
        c.execute(a,data)
        con.commit()
        print(">--------------------------------------------------------------------------------------------<")
        print("Book issued to : ",n)
        bookup(co,-1)
   
def submitb():
        n = input("Enter Name : ")
        r = input("Enter Reg No : ")
        co = input("Enter Book Code : ")
        d = input("Enter Date : ")
        a = "insert into submit values(%s,%s,%s,%s)"
        data = (n,r,co,d)
        c = con.cursor()
        c.execute(a,data)
        con.commit()
        print(">--------------------------------------------------------------------------------------------<")
        print("Book Submitted from : ",n)
        bookup(co,1)
 
def bookup(co,u):
        a = "select TOTAL from books where BCODE = %s"
        data = (co,)
        c = con.cursor()
        c.execute(a,data)   # (10,)
        myresult = c.fetchone()
        t = myresult[0] + u
        sql = "update books set TOTAL = %s where BCODE = %s"
        d = (t,co)
        c.execute(sql,d)
        con.commit()
        main()
 
def rbook():
        ac = input("Enter Book Code : ")
        a = "delete from books where BCODE = %s"
        data = (ac,)
        c = con.cursor()
        c.execute(a,data)
        con.commit()
        main()
   
def dispbook():
        a = "select * from books"
        c = con.cursor()
        c.execute(a)
        myresult = c.fetchall()                    # [(1,2,3,4),(1,2,3,4)]
        for i in myresult:   
            print("Book Name : ",i[0])
            print("Book Code : ",i[1])
            print("Total : ",i[2])
            print("Subject : ",i[3])
            print(">--------------------------------<")
        main()
 
def ibooks():
        a = "select * from issue"
        c = con.cursor()
        c.execute(a)
        myresult = c.fetchall()                    # [(1,2,3,4),(1,2,3,4)]
        for i in myresult:   
            print("Student Name : ",i[0])
            print("Reg No : ",i[1])
            print("Book Code : ",i[2])
            print("Issue Date : ",i[3])
            print(">--------------------------------<")
        main()
       
def main():
    print("""
                                                       LIBRARY MANAGER
                                                      
                     1. ADD    2. ISSUE    3. SUBMIT   4. REMOVE   5. DISPLAY
    """)
    choice = input("Enter Task No : ")
    print(">--------------------------------------------------------------------------------------------<")
    if (choice == '1'):
        addbook()
    elif (choice=='2'):
        issueb()
    elif (choice=='3'):
        submitb()
    elif (choice=='4'):
        rbook()
    elif (choice=='5'):
        print("1. All   2. Issued")
        ch = input("Enter Task No. ")
        print(">--------------------------------------------------------------------------------------------<")
        if ch == '1':
                dispbook()
        else:
                ibooks()
    else :
        print(" Wrong choice..........")
        main()
        
def pswd():
        ps = input("Enter Password : ")
        if ps == "py143":
                main()
        else:
                print("Wrong Password")
                pswd()
pswd()
 
----------------------------------------------------------------------------------- 


 
See also  Inventory Management System Project Using Python
See also  Pharmacy Management System
Happy
Happy
33 %
Sad
Sad
33 %
Excited
Excited
%
Sleepy
Sleepy
%
Angry
Angry
%
Surprise
Surprise
33 %