Library_book_management_system.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "02aa4a8d",
   "metadata": {},
   "source": [
    "## LIBRARY_BOOK_MANAGEMENT_SYSTEM USING CRUD"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "74291c6a",
   "metadata": {},
   "outputs": [],
   "source": [
    "from tkinter import *\n",
    "from tkinter import ttk\n",
    "from tkinter import messagebox\n",
    "from tkinter import font\n",
    "from PIL import Image\n",
    "from PIL import ImageTk\n",
    "import smtplib\n",
    "import sqlite3\n",
    "import time\n",
    "import datetime\n",
    "from datetime import datetime\n",
    "from datetime import timedelta\n",
    "from datetime import date\n",
    "\n",
    "db=sqlite3.connect('book.db')\n",
    "dbstore=sqlite3.connect('StoreBooks.db')\n",
    "dbstudents=sqlite3.connect('StudentsData.db')\n",
    "\n",
    "root = Tk()\n",
    "root.title(\"Library Management System\")\n",
    "root.iconbitmap('filename.ico')\n",
    "root.geometry(\"900x500+50+100\")\n",
    "root.resizable(0, 0)\n",
    "\n",
    "class main:\n",
    "    def login(self):\n",
    "        self.var1 = self.e1.get()\n",
    "        self.var2 = self.e2.get()\n",
    "        cursor=db.cursor()\n",
    "        cursor.execute(\"SELECT * FROM UserLogin WHERE UserID='\"+self.var1+\"' and Password='\"+self.var2+\"'\")\n",
    "        db.commit()\n",
    "        self.ab = cursor.fetchone()\n",
    "        \n",
    "        if self.ab!=None:\n",
    "            self.under_fm=Frame(root,height=500,width=900,bg='#fff')\n",
    "            self.under_fm.place(x=0,y=0)\n",
    "            \n",
    "            self.fm2=Frame(root,bg='#012727',height=80,width=900)\n",
    "            self.fm2.place(x=0,y=0)\n",
    "            \n",
    "            self.lbb=Label(self.fm2,bg='#012727')\n",
    "            self.lbb.place(x=15,y=5)\n",
    "            self.ig=PhotoImage(file='filename.png')\n",
    "            self.lbb.config(image=self.ig)\n",
    "            \n",
    "            self.lb3=Label(self.fm2,text='DASHBOARD',fg='White',bg='#012727',font=('times new roman',30,'bold'))\n",
    "            self.lb3.place(x=325,y=17)\n",
    "            \n",
    "            self.name=Label(root,text=\"Name : \",bg='#fff',fg=\"black\",font=('Calibri',12,'bold'))\n",
    "            self.name.place(x=5,y=83)\n",
    "            self.name1=Label(root,text=self.ab[0],fg='black',bg='#fff',font=('Calibri',12,'bold'))\n",
    "            self.name1.place(x=60,y=83)\n",
    "            \n",
    "            self.today=date.today()\n",
    "            self.dat=Label(root,text='Date : ',bg='#fff',fg='black',font=('Calibri',12,'bold'))\n",
    "            self.dat.place(x=750,y=83)\n",
    "            self.dat2 = Label(root, text=self.today, bg='#fff', fg='black', font=('Calibri', 12, 'bold'))\n",
    "            self.dat2.place(x=800, y=83)\n",
    "            \n",
    "            self.cur()\n",
    "        else:\n",
    "            messagebox.showerror('Library System', 'Your ID or Password is invalid!')\n",
    "            \n",
    "    def cur(self):\n",
    "        self.fm3=Frame(root,bg='#fff',width=900,height=390)\n",
    "        self.fm3.place(x=0,y=110)\n",
    "        \n",
    "        def clock():\n",
    "            h = str(time.strftime(\"%H\"))\n",
    "            m = str(time.strftime(\"%M\"))\n",
    "            s = str(time.strftime(\"%S\"))\n",
    "            \n",
    "            if int(h) >=12 and int(m) >=0:\n",
    "                self.lb7_hr.config(text=\"PM\")\n",
    "                \n",
    "            self.lb1_hr.config(text=h)\n",
    "            self.lb3_hr.config(text=m)\n",
    "            self.lb5_hr.config(text=s)\n",
    "    \n",
    "            self.lb1_hr.after(200, clock)\n",
    "        \n",
    "        self.lb1_hr = Label(self.fm3, text='12', font=('times new roman', 20, 'bold'), bg='#581845', fg='white')\n",
    "        self.lb1_hr.place(x=607, y=0, width=60, height=30)\n",
    "\n",
    "        self.lb3_hr = Label(self.fm3, text='05', font=('times new roman', 20, 'bold'), bg='#581845', fg='white')\n",
    "        self.lb3_hr.place(x=677, y=0, width=60, height=30)\n",
    "        \n",
    "        self.lb5_hr = Label(self.fm3, text='37', font=('times new roman', 20, 'bold'), bg='#581845', fg='white')\n",
    "        self.lb5_hr.place(x=747, y=0, width=60, height=30)\n",
    "        \n",
    "        self.lb7_hr = Label(self.fm3, text='AM', font=('times new roman', 17, 'bold'), bg='#581845', fg='white')\n",
    "        self.lb7_hr.place(x=817, y=0, width=60, height=30)\n",
    "        \n",
    "        clock()\n",
    "        self.canvas8 = Canvas(self.fm3, bg='black', width=400, height=300)\n",
    "        self.canvas8.place(x=475, y=40)\n",
    "        \n",
    "        self.photo9=PhotoImage(file=\"filename.png\")\n",
    "        self.canvas8.create_image(0,0,image=self.photo9,anchor=NW)\n",
    "        \n",
    "        self.bt1=Button(self.fm3,text='  Add Books',fg='#fff',bg='#581845',font=('Candara',15,'bold'),width=170,height=0,bd=7,relief='flat',command=self.addbook,cursor='hand2',activebackground='black',activeforeground='#581845')\n",
    "        self.bt1.place(x=40,y=40)\n",
    "        self.logo = PhotoImage(file='bt1.png')\n",
    "        self.bt1.config(image=self.logo, compound=LEFT)\n",
    "        self.small_logo = self.logo.subsample(1,1)\n",
    "        self.bt1.config(image=self.small_logo)\n",
    "        \n",
    "        \n",
    "        self.bt2 = Button(self.fm3, text='  Issue Books', fg='#fff', bg='#581845', font=('Candara', 15, 'bold'),width=170,height=0, bd=7,relief='flat',command=self.issuebook,cursor='hand2',activebackground='black',activeforeground='#581845')\n",
    "        self.bt2.place(x=250, y=40)\n",
    "        self.log = PhotoImage(file='bt2.png')\n",
    "        self.bt2.config(image=self.log, compound=LEFT)\n",
    "        self.small_log = self.log.subsample(1, 1)\n",
    "        self.bt2.config(image=self.small_log)\n",
    "            \n",
    "             \n",
    "        self.bt3 = Button(self.fm3, text='  Edit Books', fg='#fff', bg='#581845', font=('Candara', 15, 'bold'),width=170,height=0,bd=7,relief='flat',cursor='hand2',command=self.edit,activebackground='black',activeforeground='#581845')\n",
    "        self.bt3.place(x=40, y=120)\n",
    "        self.logb = PhotoImage(file='bt3.png')\n",
    "        self.bt3.config(image=self.logb, compound=LEFT)\n",
    "        self.small_logb = self.logb.subsample(1, 1)\n",
    "        self.bt3.config(image=self.small_logb)\n",
    "             \n",
    "             \n",
    "        self.bt4 = Button(self.fm3, text='  Return Books', fg='#fff', bg='#581845', font=('Candara', 15, 'bold'),width=170,height=0,bd=7,relief='flat',cursor='hand2',command=self.returnbook,activebackground='black',activeforeground='#581845')\n",
    "        self.bt4.place(x=250, y=120)\n",
    "        self.log4 = PhotoImage(file='bt4.png')\n",
    "        self.bt4.config(image=self.log4, compound=LEFT)\n",
    "        self.small_log4 = self.log4.subsample(1, 1)\n",
    "        self.bt4.config(image=self.small_log4)\n",
    "             \n",
    "             \n",
    "        self.bt5 = Button(self.fm3, text=' Delete Books', fg='#fff', bg='#581845', font=('Candara', 15, 'bold'),width=170,height=0,bd=7,relief='flat',cursor='hand2',command=self.delete,activebackground='black',activeforeground='#581845')\n",
    "        self.bt5.place(x=40, y=200)\n",
    "        self.log5 = PhotoImage(file='bt5.png')\n",
    "        self.bt5.config(image=self.log5, compound=LEFT)\n",
    "        self.small_log5 = self.log5.subsample(1, 1)\n",
    "        self.bt5.config(image=self.small_log5)\n",
    " \n",
    " \n",
    "        self.bt6 = Button(self.fm3, text=' Show Books', fg='#fff', bg='#581845', font=('Candara', 15, 'bold'),width=170,height=0,bd=7, relief='flat',cursor='hand2',command=self.show,activebackground='black',activeforeground='#581845')\n",
    "        self.bt6.place(x=40, y=280)\n",
    "        self.log6 = PhotoImage(file='bt6.png')\n",
    "        self.bt6.config(image=self.log6, compound=LEFT)\n",
    "        self.small_log6 = self.log6.subsample(1, 1)\n",
    "        self.bt6.config(image=self.small_log6)\n",
    "    \n",
    "        self.bt7 = Button(self.fm3, text='  Search Books', fg='#fff', bg='#581845', font=('Candara', 15, 'bold'),width=170,height=0,bd=7, relief='flat',cursor='hand2',command=self.search,activebackground='black',activeforeground='#581845')\n",
    "        self.bt7.place(x=250, y=200)\n",
    "        self.log7 = PhotoImage(file='bt7.png')\n",
    "        self.bt7.config(image=self.log7, compound=LEFT)\n",
    "        self.small_log7 = self.log7.subsample(1, 1)\n",
    "        self.bt7.config(image=self.small_log7)\n",
    "        \n",
    "        try:\n",
    "\n",
    "            self.bt8 = Button(self.fm3, text='  Log Out', fg='#fff', bg='#581845', font=('Candara', 15, 'bold'),width=170,height=0, bd=7, relief='flat',cursor='hand2',command=self.code,activebackground='black',activeforeground='#581845')\n",
    "            self.bt8.place(x=250, y=280)\n",
    "            self.log8 = PhotoImage(file='bt8.png')\n",
    "            self.bt8.config(image=self.log8, compound=LEFT)\n",
    "            self.small_log8 = self.log8.subsample(1, 1)\n",
    "            self.bt8.config(image=self.small_log8)\n",
    "\n",
    "        except:\n",
    "\n",
    "            self.bt9 = ttk.Button(self.fm3, text=\"Ram\", bg='#a40000', font=('Candara', 15, 'bold'), width=150,height=0)\n",
    "            self.bt9.place(x=40, y=350)\n",
    "            self.log9 = PhotoImage(file='bt8.png')\n",
    "            self.bt9.config(image=self.log9, compound=LEFT)\n",
    "            self.small_log9 = self.log9.subsample(3, 3)\n",
    "            self.bt9.config(image=self.small_log9)\n",
    "            \n",
    "    def search(self):\n",
    "        class demt(main):\n",
    "            def delmdata(self):\n",
    "\n",
    "                self.fc = Frame(root, bg='#ffe8ec', width=900, height=390)\n",
    "                self.fc.place(x=0, y=110)\n",
    "                self.fc1 = Frame(self.fc, bg='#ffe8ec', width=500, height=200, bd=5, relief='flat')\n",
    "                self.fc1.place(x=200, y=15)\n",
    "                self.edm = Frame(self.fc1, bg='#b76e79', bd=0, relief='flat', width=130, height=35)\n",
    "                self.edm.place(x=140, y=0)\n",
    "                self.lac = Label(self.edm, text='SEARCH BOOKS ', bg='#b76e79', fg='#fff', font=('Calibri', 12, 'bold'))\n",
    "                self.lac.place(x=8, y=5)\n",
    "                self.label8 = Label(self.fc1, text='Book ID', bg='#ffe8ec', fg='black', font=('Times New Roman', 11, 'bold'))\n",
    "                self.label8.place(x=85, y=65)\n",
    "                self.entryl= Entry(self.fc1, width=30, bd=4, relief='groove', font=('Calibri', 8, 'bold'))\n",
    "                self.entryl.place(x=188, y=65)\n",
    "                self.butto = Button(self.fc1, text='SEARCH', bg='#b76e79', fg='#fff', width=8,font=('Calibri', 12, 'bold'),command=self.srch,relief='flat',activebackground='black',activeforeground='#b76e79')\n",
    "                self.butto.place(x=85, y=120)\n",
    "\n",
    "                self.backbt = Button(self.fc,width=60, bg='#ffe8ec',activebackground='#ffe8ec',bd=0, relief='flat', command=self.cur)\n",
    "                self.backbt.place(x=0, y=0)\n",
    "                self.log = PhotoImage(file='filename.png')\n",
    "                self.backbt.config(image=self.log, compound=LEFT)\n",
    "                self.small_log = self.log.subsample(2, 2)\n",
    "                self.backbt.config(image=self.small_log)\n",
    "                \n",
    "            def srch(self):\n",
    "                self.emp=self.entryl.get()\n",
    "                cursor=dbstore.cursor()\n",
    "                cursor.execute(\"SELECT * FROM Books WHERE BookID='\"+self.emp+\"'\")\n",
    "                dbstore.commit()\n",
    "                self.srval=cursor.fetchone()\n",
    "                if self.srval!=None:\n",
    "                    self.top=Tk()\n",
    "                    self.top.title(\"Library System\")\n",
    "                    self.top.iconbitmap(\"filename.ico\")\n",
    "                    self.top.geometry(\"400x200+335+250\")\n",
    "                    self.top.resizable(0, 0)\n",
    "                    self.top.configure(bg='#ffe8ec')\n",
    "\n",
    "                    self.frm=Frame(self.top,bg='#b76e79',width=100,height=35)\n",
    "                    self.frm.place(x=100,y=10)\n",
    "\n",
    "                    self.mnlb=Label(self.frm,bg='#b76e79',fg='#fff',text=\"AVAILABLE\",font=('Calibri',12,'bold'))\n",
    "                    self.mnlb.place(x=9,y=5)\n",
    "\n",
    "                    self.lb1 = Label(self.top, text='Title: ', bg='#ffe8ec', fg='black', font=('Calibri', 12, 'bold'))\n",
    "                    self.lb1.place(x=85,y=70)\n",
    "                    self.lb2=Label(self.top,text=self.srval[1],bg='#ffe8ec', fg='black',font=('Calibri',12,'bold'))\n",
    "                    self.lb2.place(x=165,y=70)\n",
    "\n",
    "                    self.lb3 = Label(self.top, text='Author: ', bg='#ffe8ec', fg='black', font=('Calibri', 12, 'bold'))\n",
    "                    self.lb3.place(x=85, y=110)\n",
    "                    self.lb4 = Label(self.top, text=self.srval[2], bg='#ffe8ec', fg='black', font=('Calibri', 12, 'bold'))\n",
    "                    self.lb4.place(x=165, y=110)\n",
    "\n",
    "                    self.lb5 = Label(self.top, text='Edition: ',bg='#ffe8ec', fg='black', font=('Calibri', 12, 'bold'))\n",
    "                    self.lb5.place(x=85, y=150)\n",
    "                    self.lb6 = Label(self.top, text=self.srval[3], bg='#ffe8ec', fg='black', font=('Calibri', 12, 'bold'))\n",
    "                    self.lb6.place(x=165, y=150)\n",
    "                    self.entryl.delete(0,END)\n",
    "                \n",
    "                else:\n",
    "                    messagebox.showwarning('Invalid Data','This book does not exists!')\n",
    "                    self.entryl.delete(0,END)\n",
    "        object=demt()\n",
    "        object.delmdata()\n",
    "        \n",
    "    def show(self):\n",
    "        class test(main):\n",
    "            def __init__(self):\n",
    "                self.fc = Frame(root, bg='#ffe8ec', width=900, height=390)\n",
    "                self.fc.place(x=0, y=110)\n",
    "                self.popframe=Frame(self.fc,width=180,height=30,bg='#edb40d')\n",
    "                self.popframe.place(x=360,y=0)\n",
    "                self.lbn=Label(self.popframe,bg='#edb40d',text='BOOKS INFORMATION',fg='#fff',font=('Calibri',12,'bold'))\n",
    "                                                                                                \n",
    "                self.lbn.place(x=8,y=4)\n",
    "\n",
    "                self.backbt = Button(self.fc,width=30, bg='#ffe8ec',activebackground='#ffe8ec',bd=0, relief='flat', command=self.cur)\n",
    "                self.backbt.place(x=0, y=0)\n",
    "                self.log = PhotoImage(file='filename.png')\n",
    "                self.backbt.config(image=self.log, compound=LEFT)\n",
    "                self.small_log = self.log.subsample(3, 3)\n",
    "                self.backbt.config(image=self.small_log)\n",
    "\n",
    "                self.table_frame=Frame(self.fc,bg='#ffe8ec',bd=1,relief='flat')\n",
    "                self.table_frame.place(x=0,y=30,width=900,height=360)\n",
    "\n",
    "                self.scroll_x=Scrollbar(self.table_frame,orient=HORIZONTAL)\n",
    "                self.scroll_y=Scrollbar(self.table_frame,orient=VERTICAL)\n",
    "                self.book_table=ttk.Treeview(self.table_frame,columns=(\"Book ID\",\"Title\",\"Author\",\"Edition\",\"Price\"),xscrollcommand=self.scroll_x.set,yscrollcommand=self.scroll_y.set)\n",
    "                self.scroll_x.pack(side=BOTTOM,fill=X)\n",
    "                self.scroll_y.pack(side=RIGHT, fill=Y)\n",
    "                self.scroll_x.config(command=self.book_table.xview)\n",
    "                self.scroll_y.config(command=self.book_table.yview)\n",
    "                \n",
    "                self.book_table.heading(\"Book ID\",text=\"Book ID\")\n",
    "                self.book_table.heading(\"Title\", text=\"Title\")\n",
    "                self.book_table.heading(\"Author\", text=\"Author\")\n",
    "                self.book_table.heading(\"Edition\", text=\"Edition\")\n",
    "                self.book_table.heading(\"Price\", text=\"Price\")\n",
    "                self.book_table['show']='headings'\n",
    "                self.book_table.column(\"Book ID\",width=200)\n",
    "                self.book_table.column(\"Title\", width=200)\n",
    "                self.book_table.column(\"Author\", width=200)\n",
    "                self.book_table.column(\"Edition\", width=120)\n",
    "                self.book_table.column(\"Price\", width=110)\n",
    "                self.book_table.pack(fill=BOTH,expand=1)\n",
    "                self.fetch_data()\n",
    "            \n",
    "            def fetch_data(self):\n",
    "                cursor=dbstore.cursor()\n",
    "                cursor.execute(\"SELECT * FROM Books\")\n",
    "                self.rows=cursor.fetchall()\n",
    "                if len(self.rows)!=0:\n",
    "                        for self.row in self.rows:\n",
    "                                self.book_table.insert('',END,values=self.row)\n",
    "                dbstore.commit()\n",
    "                \n",
    "        oc=test()\n",
    "        \n",
    "    def mainclear(self):\n",
    "        self.e1.delete(0,END)\n",
    "        self.e2.delete(0,END)\n",
    "        \n",
    "        \n",
    "    def code(self):\n",
    "\n",
    "            self.fm=Frame(root,height=500,width=900,bg='white')\n",
    "            self.fm.place(x=0,y=0)\n",
    "\n",
    "            self.canvas=Canvas(self.fm,height=500,width=900,bg='#000000')\n",
    "            self.canvas.place(x=0,y=0)\n",
    "\n",
    "            self.photo=PhotoImage(file=r\"pathtoimage\\filename.png\")\n",
    "            self.canvas.create_image(0,0,image=self.photo,anchor=NW)\n",
    "\n",
    "            self.fm1=Frame(self.canvas,height=260,width=300,bg='#000000',bd=3,relief='sunken')\n",
    "            self.fm1.place(x=300,y=120)\n",
    "            \n",
    "            self.b1=Label(self.fm1,text='User ID',bg='black',font=('Arial',10,'bold'),fg='white')\n",
    "            self.b1.place(x=20,y=42)\n",
    "\n",
    "            self.e1=Entry(self.fm1,width=22,font=('arial',9,'bold'),bd=4,relief='groove')\n",
    "            self.e1.place(x=100,y=40)\n",
    "\n",
    "            self.lb2=Label(self.fm1,text='Password',bg='black',font=('Arial',10,'bold'),fg='white')\n",
    "            self.lb2.place(x=20,y=102)\n",
    "\n",
    "            self.e2=Entry(self.fm1,width=22,show='*',font=('arial',9,'bold'),bd=4,relief='groove')\n",
    "            self.e2.place(x=100,y=100)\n",
    "            \n",
    "            self.btn1=Button(self.fm1,text='  Login',fg='black',bg='yellow',width=100,font=('Arial',11,'bold'),activebackground='black',activeforeground='yellow',command=self.login,bd=3,relief='flat',cursor='hand2')\n",
    "            self.btn1.place(x=25,y=160)\n",
    "            self.logo = PhotoImage(file=r\"pathtoimage.png\")\n",
    "            self.btn1.config(image=self.logo, compound=LEFT)\n",
    "            self.small_logo = self.logo.subsample(1, 1)\n",
    "            self.btn1.config(image=self.small_logo)\n",
    "\n",
    "\n",
    "            self.btn2=Button(self.fm1,text='  Clear',fg='black',bg='yellow',width=100,font=('Arial',11,'bold'),activebackground='black',activeforeground='yellow',bd=3,relief='flat',cursor='hand2',command=self.mainclear)\n",
    "            self.btn2.place(x=155,y=160)\n",
    "            self.log = PhotoImage(file=r\"pathtoimage.png\")\n",
    "            self.btn2.config(image=self.log, compound=LEFT)\n",
    "            self.small_log = self.log.subsample(1, 1)\n",
    "            self.btn2.config(image=self.small_log)\n",
    "            \n",
    "            self.forgot=Label(self.fm1,text='Forgot Password?',fg='White',bg='#000000',activeforeground='black',font=('cursive',9,'bold'))\n",
    "            self.forgot.place(x=80,y=220)\n",
    "            self.forgot.bind(\"<Button>\",self.mouseClick)\n",
    "\n",
    "            root.mainloop()\n",
    "            \n",
    "    def mouseClick(self,event):\n",
    "        self.rog=Tk()\n",
    "        self.rog.title(\"Change password\")\n",
    "        self.rog.geometry(\"400x300+300+210\")\n",
    "        self.rog.iconbitmap(\"filename.ico\")\n",
    "        self.rog.resizable(0,0)\n",
    "        self.rog.configure(bg='#000')\n",
    "\n",
    "        self.framerog=Frame(self.rog,width=160,height=30,bg=\"#d6ed17\")\n",
    "        self.framerog.place(x=95,y=15)\n",
    "\n",
    "        self.label=Label(self.framerog,text=\"SET NEW PASSWORD\",bg='#d6ed17',fg='#606060',font=(\"Calibri\",12,'bold'))\n",
    "        self.label.place(x=5,y=4)\n",
    "\n",
    "        self.user=Label(self.rog,text='User ID',bg='#000',fg='white',font=(\"Times New Roman\",11,'bold'))\n",
    "        self.user.place(x=40,y=95)\n",
    "\n",
    "        self.user = Label(self.rog, text='New Password',bg='#000', fg='white', font=(\"Times New Roman\", 11, 'bold'))\n",
    "        self.user.place(x=40, y=170)\n",
    "\n",
    "        self.ef1 = Entry(self.rog, width=24, font=('Calibri', 8, 'bold'), bd=4, relief='groove')\n",
    "        self.ef1.place(x=170, y=95)\n",
    "\n",
    "        self.ef2 = Entry(self.rog, width=24, font=('Calibri', 8, 'bold'), bd=4, relief='groove')\n",
    "        self.ef2.place(x=170, y=170)\n",
    "\n",
    "        self.btn1 = Button(self.rog, text='SUBMIT', fg='#606060', bg='#d6ed17', width=8, font=('Calibri', 12, 'bold'),activebackground='black', activeforeground='#d6ed17',bd=3, relief='flat',cursor='hand2',command=self.chan_pas)\n",
    "        self.btn1.place(x=40, y=240)\n",
    "        \n",
    "    def chan_pas(self):\n",
    "        self.a=self.ef1.get()\n",
    "        self.b=self.ef2.get()\n",
    "        import sqlite3\n",
    "        conn=sqlite3.connect('book.db')\n",
    "        cursor=conn.cursor()\n",
    "        cursor.execute(\"SELECT * FROM UserLogin WHERE UserID='\"+self.a+\"'\")\n",
    "        conn.commit()\n",
    "        self.data=cursor.fetchone()\n",
    "\n",
    "        if self.data!=None:\n",
    "                cursor = conn.cursor()\n",
    "                cursor.execute(\"UPDATE UserLogin SET Password='\" + self.b + \"' WHERE UserID='\" + self.a + \"'\")\n",
    "                conn.commit()\n",
    "                messagebox.showinfo(\"SUCCESSFUL\",\"Your Password is changed\")\n",
    "                self.rog.destroy()\n",
    "        else:\n",
    "                messagebox.showerror(\"ERROR\", \"UserID doesn't exist\")\n",
    "                self.rog.destroy()\n",
    "                \n",
    "        self.rog.mainloop()\n",
    "                                                                                \n",
    "\n",
    "obj=main()\n",
    "obj.code()          \n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "fc275a09",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}