Project 1 - English Dictionary App & Library Book Management System
2. Library Book Management System
**************************************************************
from tkinter import *
import sqlite3
import tkinter.ttk as ttk
import tkinter.messagebox as tkmessagebox
**************************************************************
root=Tk()
root.title('Library management system')
**************************************************************
def Database():
global con, cursor
con=sqlite3.connect('library.db')
cur=con.cursor
cursor.execute('CREATE TABLE IF NOT EXISTS books(booktitle TEXT, author TEXT, year TEXT, isbn TEXT)')
def Create():
if BOOKTITLE.get()=="" or AUTHOR.get()=="" or YEAR.get()=="" or ISBN.get()=="":
txt_result.config(text='enter the all fiels:',fd="red")
else:
Database()
cursor.execute('INSERT INTO books(booktitle,author,year, isbn) VALUES(?,?,?,?)',str(BOOKTITLE.get()),str(AUTHOR.get()),str(YEAR.get()),str(ISBN.get()))
conn.commit()
BOOKTITLE.set(" ")
AUTHOR.set(" ")
YAER.set(" ")
ISBN.set(" ")
cursor.close()
conn.close()
txt_result.config(text='Records inserted:',fd="green")
def Read():
tree.delete(*tree.get_children)
Database()
cursor.execute('SELECT * FROM books ORDER BY last ASE')
fetch=cursor.fetchall()
for data in fetch:
tree.insert('',values=(data[1],data[2],data[3],data[4]))
cursor.close()
txt_result.config(text='Data fetched succesfull:',fg="black")
def Exit():
result=tkMessageBox.askquestion('Do you want to exit?(y/n)',icon='warning')
if result=='yes':
root.destroy()
exit()
**************************************************************
BOOKTITLE = StringVar()
AUTHOR = StringVar()
YEAR = StringVar()
ISBN = StringVar()
**************************************************************
Top=Frame(root, width=900, height=50, bd=8, relief='raise')
Top.pack(side=TOP)
Left=Frame(root, width=300, height=500, bd=8, relief='raise')
Left.pack(side=LEFT)
Right=Frame(root, width=600, height=500, bd=8, relief='raise')
Right.pack(side=RIGHT)
Forms=Frame(Left,width=300, height=450)
Forms.pack(side=TOP)
Buttons=Frame(Left,width=300, height=150,bd=8, relief='raise')
Buttons.pack(side=BOTTOM)
RadioGroup=Frame(Forms)
Name=Radiobutton(RadioGroup,text='name',variable=AUTHOR,value='Name').pack(side=LEFT)
**************************************************************
txt_title=Label(Top,width=900,text='Library management system')
txt_title.pack()
txt_booktitle=Label(Forms,text="Booktitle: ",font=('arial',16),bd=15)
txt_booktitle.grid(row=0,stick="e")
txt_author=Label(Forms,text="Author: ",font=('arial',16),bd=15)
txt_author.grid(row=1,stick="e")
txt_year=Label(Forms,text="Year: ",font=('arial',16),bd=15)
txt_year.grid(row=2,stick="e")
txt_isbn=Label(Forms,text="ISBN: ",font=('arial',16),bd=15)
txt_isbn.grid(row=3,stick="e")
text_result=Label(Buttons)
text_result.pack(side=TOP)
**************************************************************
booktitle=Entry(Forms,textvariable=BOOKTITLE,width=30)
booktitle.grid(row=0,column=1)
author=Entry(Forms,textvariable=AUTHOR,width=30)
author.grid(row=1,column=1)
RadioGroup.grid(row=2,column=1)
year=Entry(Forms,textvariable= YEAR ,width=30)
year.grid(row=3,column=1)
isbn=Entry(Forms,textvariable=ISBN,width=30)
isbn.grid(row=4,column=1)
**************************************************************
btn_display =Button(Buttons,width=10,text="Display",command=display)
btn_display.pack(side=LEFT)
btn_search =Button(Buttons,width=10,text="Search",command=search)
btn_search.pack(side=LEFT)
#btn_add =Button(Buttons,width=10,text="Add",command=add)
#btn_add.pack(side=LEFT)
btn_read=Button(Buttons,width=10,text="Read",command=Read)
btn_read.pack(side=LEFT)
#btn_update=Button(Buttons,width=10,text="Update",command=DISABLED)
#btn_upate.pack(side=LEFT)
#btn_delete=Button(Buttons,width=10,text="Read",command=DISABLED)
#btn_delete.pack(side=LEFT)
btn_exit=Button(Buttons,width=10,text="Exit",command=Exit)
btn_exit.pack(side=LEFT)
**************************************************************
scrollbary=Scrollbar(Right, orient=VERTICAL)
scrollbarX=Scrollbar(Right, orient=HORIZONTAL)
tree=ttk.Treeview("Booktitle","Author","Year","Isbn")
scrollbary.config(command=tree.yview)
scrollbary.pack(side=RIGHT,fill=Y)
scrollbarx.config(command=tree.xview)
scrollbarx.pack(side=RIGHT,fill=X)
tree.heading('Booktitle',text='Booktitle',anchor=W)
tree.heading('Author',text='Author',anchor=W)
tree.heading('Year',text='Year',anchor=W)
tree.heading('Isbn',text='Isbn',anchor=W)
tree.column('#0',stretch=NO,minwidth=0,width=0)
tree.column('#1',stretch=NO,minwidth=0,width=80)
tree.column('#2',stretch=NO,minwidth=0,width=120)
tree.column('#3',stretch=NO,minwidth=0,width=80)
tree.column('#4',stretch=NO,minwidth=0,width=120)
tree.pack()
**************************************************************
if __name__=='__main__':
root.mainloop()
**************************************************************