Open links in new tab
    • Work Report
    • Email
    • Rewrite
    • Speech
    • Title Generator
    • Smart Reply
    • Poem
    • Essay
    • Joke
    • Instagram Post
    • X Post
    • Facebook Post
    • Story
    • Cover Letter
    • Resume
    • Job Description
    • Recommendation Letter
    • Resignation Letter
    • Invitation Letter
    • Greeting Message
    • Try more templates
    Feedback
  1. 123

    Below is a Python implementation of a Library Management System using the Tkinter library for GUI and SQLite3 for database management. This system allows users to manage books, register members, issue/return books, and view records.

    import sqlite3
    from tkinter import *
    import tkinter.ttk as ttk
    import tkinter.messagebox as mb

    # Database Connection
    connector = sqlite3.connect('library.db')
    cursor = connector.cursor()
    connector.execute('''
    CREATE TABLE IF NOT EXISTS Library (
    BK_NAME TEXT,
    BK_ID TEXT PRIMARY KEY NOT NULL,
    AUTHOR_NAME TEXT,
    BK_STATUS TEXT,
    CARD_ID TEXT
    )
    ''')

    # Functions
    def add_record():
    if bk_status.get() == 'Issued':
    card_id.set(mb.askstring('Issuer Card ID', 'Enter Issuer Card ID:'))
    else:
    card_id.set('N/A')
    try:
    connector.execute(
    'INSERT INTO Library (BK_NAME, BK_ID, AUTHOR_NAME, BK_STATUS, CARD_ID) VALUES (?, ?, ?, ?, ?)',
    (bk_name.get(), bk_id.get(), author_name.get(), bk_status.get(), card_id.get())
    )
    connector.commit()
    display_records()
    mb.showinfo('Success', 'Record added successfully!')
    except sqlite3.IntegrityError:
    mb.showerror('Error', 'Book ID already exists!')

    def display_records():
    tree.delete(*tree.get_children())
    for row in connector.execute('SELECT * FROM Library'):
    tree.insert('', END, values=row)

    def delete_record():
    selected_item = tree.focus()
    if not selected_item:
    mb.showerror('Error', 'Select a record to delete!')
    return
    values = tree.item(selected_item)['values']
    connector.execute('DELETE FROM Library WHERE BK_ID=?', (values[1],))
    connector.commit()
    display_records()

    # GUI Setup
    root = Tk()
    root.title('Library Management System')
    root.geometry('800x500')

    # Variables
    bk_name = StringVar()
    bk_id = StringVar()
    author_name = StringVar()
    bk_status = StringVar(value='Available')
    card_id = StringVar()

    # Frames
    left_frame = Frame(root)
    left_frame.pack(side=LEFT, fill=Y)
    right_frame = Frame(root)
    right_frame.pack(side=RIGHT, fill=BOTH, expand=True)

    # Left Frame Widgets
    Label(left_frame, text='Book Name').pack(pady=5)
    Entry(left_frame, textvariable=bk_name).pack(pady=5)
    Label(left_frame, text='Book ID').pack(pady=5)
    Entry(left_frame, textvariable=bk_id).pack(pady=5)
    Label(left_frame, text='Author Name').pack(pady=5)
    Entry(left_frame, textvariable=author_name).pack(pady=5)
    Label(left_frame, text='Status').pack(pady=5)
    OptionMenu(left_frame, bk_status, 'Available', 'Issued').pack(pady=5)
    Button(left_frame, text='Add Record', command=add_record).pack(pady=10)

    # Right Frame Widgets
    tree = ttk.Treeview(right_frame, columns=('Book Name', 'Book ID', 'Author', 'Status', 'Card ID'), show='headings')
    tree.heading('Book Name', text='Book Name')
    tree.heading('Book ID', text='Book ID')
    tree.heading('Author', text='Author')
    tree.heading('Status', text='Status')
    tree.heading('Card ID', text='Card ID')
    tree.pack(fill=BOTH, expand=True)

    Button(right_frame, text='Delete Record', command=delete_record).pack(pady=10)

    # Initialize Records Display
    display_records()

    root.mainloop()
    Copied!
    Feedback
  2. Python Geeks
    https://pythongeeks.org › python-library

    Library Management System Project in Python with Source Code

    In this Python project, we will build a GUI-based Library Management System project using the Tkinter library, SQLite3 API, and messagebox modules of Tkinter. It is an inte…
    About Library Management Systems

    Library Management Systems are used to manage information about contents in a library. They are used to manage information relating to books, their names, codes, author names, whether they have been issued or not and if so, who has issu…

    About The Python Library Management System Project

    The objective of this is to create a GUI based Library Management System. To build this, you will need intermediate understanding of the SQLite API and its commands, intermediate understanding of Tkinter library, Ttk module’s Treeview, an…

    Python Library Management Project Prerequisites

    To build this project, we will need the following Python libraries: 1. Tkinter – To create the GUI a. messagebox – To display boxes showing information or error or asking yes or no. b. Ttk.Treeview – To display all the information in the GUI wind…

  3. CodeWithCurious
    https://codewithcurious.com › projects › library...

    Library Management System Using Python with Source …

    By building this Python-based Library Management System with Tkinter, we’re giving libraries a digital helping hand. Whether it’s a small local library or a big …

  4. GeeksForGeeks
    https://www.geeksforgeeks.org › python › library...

    Library Management System using Python - GeeksforGeeks

    Jul 15, 2025 · Library Management System is a project developed using Object-Oriented Programming (OOP) in Python. The goal of this project is to simulate the operations of a real-world library, including …

  5. Itsourcecode.com
    https://itsourcecode.com › free-projects › python...

    Library Management System Project In Python with Source Code

    • Reviews: 19
    • Language/s Used: Python Tkinter GUI Library
    • Database: MySQL
    • Project Name: library Management System Project in Python
      1. Login Page. The code given below is the login page of the system which can log in to the …
      2. Main Module. The main module of the Library Management System Project In Python and MySQL …
      3. Student Information. This module is for the student information that can be searched and you can …
      4. Book Information. This module is for the book information that can be searched and you can …
      5. Add New Student. In this module, you can add the information of the student. from tkinter import * …
      See full list on itsourcecode.com
  6. Github
    https://github.com › ... › Library-Management-System

    Library Management System with Python and MySQL …

    Note: This description provides an overview of the Library Management System project and its features. Depending on the project's scope and requirements, …

  8. Source Code Examples
    https://www.sourcecodeexamples.net › library...

    Library Management System Project in Python with Source Code

    Library management systems are crucial in organizing and maintaining the records of books, members, and transactions in a library. In this blog post, we'll create a simple library management system using …

  9. Genial Code
    https://genial-code.com › library-management-system...

    Library Management System Project in Python with …

    Here, we will delve into the process of creating a Library Management System Project in Python, exploring its key components, and design considerations, and …

  10. Project Gurukul
    https://projectgurukul.org › python-li

    Python Library Management System [project with …

    In this article, we are going to build an advanced python project Library Management System using MySQL database and Tkinter for GUI (Graphical User …

  11. shiva0909122.github.io
    https://shiva0909122.github.io › Library-Management-System

    Library-Management-System | A python project to streamline library ...

    Library-Management-System | A python project to streamline library management processes. A simple Library Management System built with Python and Tkinter, using SQLite for database management.

  12. codenova.in
    https://www.codenova.in › advanced-library-management-system.html

    Advanced Library Management System with Source Code

    Jun 25, 2025 · We’ve built an Advanced Library Management System in Python that can manage books, members, borrowing, returning, fines, and reports. You’ve got the complete source code, step-by-step …

  13. Deep dive into Library Management System in Python with Source Code

Content was generated with AI. Learn more