Scribd Logo
Upload

Welcome to Scribd!

  • 0 views

    ADAMAS WORLD SCHOOL

    Uploaded by

    podderbiswapriya717

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    ADAMAS WORLD SCHOOL

    Uploaded by

    podderbiswapriya717
    0 views5 pages

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    0 views5 pages

    ADAMAS WORLD SCHOOL

    Uploaded by

    podderbiswapriya717

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 5

    ADAMAS WORLD SCHOOL

    AFFILIATED TO CBSE, NEW DELHI (10+2)

    DEPARTMENT OF COMPUTER SCIENCE

    COMPUTER SCIENCE PROJECT

    AISSCE 2024 – 25

    TOPIC: Library Management System

    Name: BISWAPRIYA PODDER

    Class: XII SCIENCE

    Section: A

    Roll no.: 13

    Session: 2024 – 25
    SOURCE CODE
    import mysql.connector as ma

    def createdatabase(user, pas):


    condb = ma.connect(host="localhost", user=user, passwd=pas)
    sql = "create database if not exists library"
    c = condb.cursor()
    c.execute(sql)
    condb.close()
    print("Database Created...")
    condb = ma.connect(host="localhost", user=user, passwd=pas, database="library")
    c = condb.cursor()
    sql = "create table if not exists books(bname varchar(50),bcode varchar(10) primary key,total int(11),subject
    varchar(50))"
    c.execute(sql)
    sql = "create table if not exists issue(name varchar(50),regno varchar(10),bcode varchar(10),issue varchar(50))"
    c.execute(sql)
    sql = "create table if not exists submit(name varchar(50),regno varchar(10),bcode varchar(10),submit varchar(50))"
    c.execute(sql)
    condb.commit()
    condb.close()
    print("Database Created...")
    print("Table Books Created...")
    print("Table issue Created...")
    print("Table Submit Created...")

    def addbook(user, pas):


    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)"
    con = ma.connect(host="localhost", user=user, passwd=pas, database="library")
    c = con.cursor()
    c.execute(sql, data)
    con.commit()
    print(">=================================<")
    print("Data Entered Succesfully")
    main(user, pas)
    def issueb(user, pas):
    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)"
    con = ma.connect(host="localhost", user=user, passwd=pas, database="library")
    data = (n, r, co, d)
    c = con.cursor()
    c.execute(a, data)
    con.commit()
    print(">=================================<")
    Source Code
    print("Book issued to :", n)
    bookup(co, -1, user, pas)

    def submitb(user, pas):


    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)"
    con = ma.connect(host="localhost", user=user, passwd=pas, database="library")
    data = (n, r, co, d)
    c = con.cursor()
    c.execute(a, data)
    con.commit()
    print(">=================================<")
    print("Book submitted from :", n)
    bookup(co, 1, user, pas)

    def bookup(co, u, user, pas):


    a = "select TOTAL from books where BCODE=%s"
    con = ma.connect(host="localhost", user=user, passwd=pas, database="library")
    data = (co,)
    c = con.cursor()
    c.execute(a, data)
    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(user, pas)
    def dbook(user, pas):
    ac = input("Enter Book code:")
    a = "delete from books where BCODE=%s"
    con = ma.connect(host="localhost", user=user, passwd=pas, database="library")
    data = (ac,)
    c = con.cursor()
    c.execute(a, data)
    con.commit()
    print("Book deleted!!")
    main(user, pas)

    def dispbook(user, pas):


    sql = "select * from books"
    con = ma.connect(host="localhost", user=user, passwd=pas, database="library")
    c = con.cursor()
    c.execute(sql)
    myresult = c.fetchall()
    for i in myresult:
    print("Book Name:", i[0])
    print("Book Code:", i[1])
    print("Total:", i[2])
    print(">=================================<")
    main(user, pas)

    def main(user, pas):


    print("""LIBRARY MANAGER
    0. Create Database and Tables
    1. ADD BOOK
    2. ISSUE BOOK
    3. SUBMIT BOOK
    4. DELETE BOOK
    5. DISPLAY BOOKS """)
    choice = input("Enter Task no:")
    print(">=================================<")
    if choice == "0":
    createdatabase(user, pas)
    elif choice == "1":
    addbook(user, pas)
    elif choice == "2":
    issueb(user, pas)
    elif choice == "3":
    submitb(user, pas)
    elif choice == "4":
    dbook(user, pas)
    elif choice == "5":
    dispbook(user, pas)
    else:
    print("Wrong choice")
    ans = input("press Y to continue or press any key to terminate the pogram:")
    if ans == "Y" or ans == 'y':
    main(user, pas)
    else:
    pass
    while True:
    user = input("Enter User:")
    pas = input("Enter Pass:")
    if user != "" and pas != "":
    try:
    con = ma.connect(host="localhost", user=user, passwd=pas)
    except:
    break
    if con.is_connected():
    main(user, pas)
    else:
    break

    You might also like