How to insert data into MySQL database table in Python Tkinter using Object Oriented Programming Method (00P)

 

connection.py

import mysql.connector
import sys

def Connect():
    conn=None
    try:
        conn=mysql.connector.connect(
            host='localhost',
            username='root',
            password='',
            database='level4b'
        )

    except:
        print("Error", sys.exc_info())

    finally:

        return conn

libs.py

class Libs():
    def __init__(self, cid=0, name=None, dob=None, email=None, password=None):
        self.cid=cid
        self.name=name
        self.dob=dob
        self.email=email
        self.password=password

    #Getter
    def getCid(self):
        return self.cid

    def getName(self):
        return self.name

    def getDob(self):
        return self.dob

    def getEmail(self):
        return self.email

    def getPassword(self):
        return self.password

    #setter
    def setCid(self, cid):
        self.cid=cid

    def setName(self, name):
        self.name=name

    def setDob(self, dob):
        self.dob=dob

    def setEmail(self, email):
        self.email=email

    def setPassword(self, password):
        self.password=password

    def __str__(self):
        return ('{},{},{},{},{}'.format(self.cid, self.name, self.dob, self.email, self.password))

backend.py

from Hancie.connection import Connect
import mysql.connector
import sys

def insert_record(recordInfo):
    conn=None
    sql="""INSERT INTO customers VALUES (%s,%s,%s,%s,%s)"""
    values=(recordInfo.getCid(),
            recordInfo.getName(),
            recordInfo.getDob(),
            recordInfo.getEmail(),
            recordInfo.getPassword())
    result=False
    try:
        conn=Connect()
        cursor=conn.cursor()
        cursor.execute(sql, values)
        conn.commit()
        cursor.close()
        conn.close()
        result=True

    except:
        print("Error", sys.exc_info())

    finally:
        del values, sql, conn
        return result

gui.py

from tkinter import *
from tkcalendar import DateEntry
from tkinter import messagebox
from Hancie.backend import insert_record
from Hancie.libs import Libs


class Hancie():
    def __init__(self, main):
        self.main=main
        self.main.title("Hancie e-Learning Studio")
        self.main.geometry("500x400")

        myfont=('Tahoma',16)

        namelbl=Label(self.main, text="Name:", font=myfont)
        namelbl.place(x=20, y=50)

        nametxt=Entry(self.main, font=myfont)
        nametxt.place(x=120, y=50)

        doblbl=Label(self.main, text="DOB:", font=myfont)
        doblbl.place(x=20, y=100)

        dobtxt=DateEntry(self.main, font=myfont)
        dobtxt.place(x=120, y=100)

        emailbl = Label(self.main, text="Email:", font=myfont)
        emailbl.place(x=20, y=150)

        emailtxt = Entry(self.main, font=myfont)
        emailtxt.place(x=120, y=150)

        passwordlbl = Label(self.main, text="Password:", font=myfont)
        passwordlbl.place(x=20, y=200)

        passwordtxt = Entry(self.main, font=myfont)
        passwordtxt.place(x=120, y=200)

        def register():
            name=nametxt.get()
            dob=dobtxt.get()
            email=emailtxt.get()
            password=passwordtxt.get()

            customer=Libs(cid='', name=name, dob=dob, email=email, password=password)
            result=insert_record(customer)
            if result==True:
                messagebox.showinfo("Customer","The data is registered")
            else:
                messagebox.showerror("Customer","Error Occurred")


        savebtn = Button(self.main,command=register, font=myfont, text="Save")
        savebtn.place(x=120, y=250)






if __name__=='__main__':
    main=Tk()
    Hancie(main)
    main.mainloop()

Output