Yam Code

New Paste Browse

from tkinter import *
from tkinter import ttk
import pymysql

class Database_01:
    def __init__(self,root):
            self.root = root
            self.root.title = ("The Father")
            self.root.geometry ("1350x900+0+0")

title = Label (self.root, text="The Father", relief=GROOVE, font=("Time New Roman", 40, "bold"), bg="#006643", fg="#FFF")
            title.pack(side = TOP, fill = X)

#======== Tong_hop_bien =================
            self.UID_var=StringVar()
            self.Password_var=StringVar()
            self.Authenticator_var=StringVar()
            self.Email_var=StringVar()
            self.Phan_loai_var=StringVar()

#======== Thanh_quan_ly =================
            Thanh_quan_ly = Frame(self.root, bd=4, bg="#E6E6E6", relief=RIDGE)
            Thanh_quan_ly.place(x=50, y=100, width=350)

a_title = Label(Thanh_quan_ly, text="Quản lý thông tin tài khoản",bg="#E6E6E6", fg="#006643", font=("Times New Roman", 25, "bold"))
            a_title.grid(row=0,columnspan=2,pady=20)

lb1_uid = Label(Thanh_quan_ly, text="UID", bg="#E6E6E6", fg="#006643", font=("Times New Roman", 14, "bold"))
            lb1_uid.grid(row=1,column=0,pady=10, padx=20, sticky="w")

txt_UID = Entry(Thanh_quan_ly,textvariable=self.UID_var, font=("Times New Roman", 14, "bold"), bd="1", relief= GROOVE)
            txt_UID.grid(row=1,column=1,pady=10, padx=20, sticky="w")

lb1_pass = Label(Thanh_quan_ly, text="Password", bg="#E6E6E6", fg="#006643", font=("Times New Roman", 14, "bold"))
            lb1_pass.grid(row=2,column=0,pady=10, padx=20, sticky="w")

txt_Pass = Entry(Thanh_quan_ly,textvariable=self.Password_var, font=("Times New Roman", 14, "bold"), bd="1", relief= GROOVE)
            txt_Pass.grid(row=2,column=1,pady=10, padx=20, sticky="w")

lb1_auth = Label(Thanh_quan_ly, text="Authenticator", bg="#E6E6E6", fg="#006643", font=("Times New Roman", 14, "bold"))
            lb1_auth.grid(row=3,column=0,pady=10, padx=20, sticky="w")

txt_Auth = Entry(Thanh_quan_ly,textvariable=self.Authenticator_var, font=("Times New Roman", 14, "bold"), bd="1", relief= GROOVE)
            txt_Auth.grid(row=3,column=1,pady=10, padx=20, sticky="w")

lb1_email = Label(Thanh_quan_ly, text="Email", bg="#E6E6E6", fg="#006643", font=("Times New Roman", 14, "bold"))
            lb1_email.grid(row=4,column=0,pady=10, padx=20, sticky="w")

txt_Email = Entry(Thanh_quan_ly,self.Email_var, font=("Times New Roman", 14, "bold"), bd="1", relief= GROOVE)
            txt_Email.grid(row=4,column=1,pady=10, padx=20, sticky="w")

lb1_phan_loai = Label(Thanh_quan_ly,textvariable=self.Phan_loai_var, text="Phân loại", bg="#E6E6E6", fg="#006643", font=("Times New Roman", 14, "bold"))
            lb1_phan_loai.grid(row=5,column=0,pady=10, padx=20, sticky="w")

combo_Phan_loai = ttk.Combobox(Thanh_quan_ly,textvariable=self.Phan_loai_var, font=("Times New Roman", 14), state='readonly')
            combo_Phan_loai['values']=("Via","Clone")
            combo_Phan_loai.grid(row=5,column=1,pady=10, padx=15, sticky="w")

lb1_note = Label(Thanh_quan_ly, text="Ghi chú", bg="#E6E6E6", fg="#006643", font=("Times New Roman", 14, "bold"))
            lb1_note.grid(row=7,column=0,pady=10, padx=20, sticky="w")

self.txt_Note = Text(Thanh_quan_ly, width=20, height=4, font=("Times News Roman", 12))
            self.txt_Note.grid(row=7,column=1,pady=10, padx=20, sticky="w")

#======== Button_Frame =================
            btn_Frame = Frame(self.root, relief=RIDGE)
            btn_Frame.place(x=40, y=550, width=350)

Addbtn = Button(btn_Frame, text="Tạo mới",command=self.add_database ,relief=GROOVE, font=("Time New Roman", 13, "bold"), bg="#FFF", fg="#006643").grid(row=0, column=0, padx=15)

Savebtn = Button(btn_Frame, text="Lưu lại", relief=GROOVE, font=("Time New Roman", 13, "bold"), fg="#006643", bg="#000").grid(row=0, column=1, padx=15)

Clearbtn = Button(btn_Frame, text="Xoá bỏ", relief=GROOVE, font=("Time New Roman", 13, "bold"), fg="#006643", bg="#000").grid(row=0, column=2, padx=15)
            
            Previewbtn = Button(btn_Frame, text="Preview", relief=GROOVE, font=("Time New Roman", 13, "bold"), fg="#006643", bg="#000").grid(row=0, column=3, padx=15)

#======== du_lieu =================
            du_lieu = Frame(self.root, bd=4, bg="#E6E6E6", relief=RIDGE)
            du_lieu.place(x=500,y=100,width=800,height=700)

lb1_search = Label(du_lieu, text="Tìm kiếm theo", bg="#E6E6E6", fg="#006643", font=("Times New Roman", 14, "bold"))
            lb1_search.grid(row=0,column=0,pady=20, padx=20, sticky="w")

combo_Search = ttk.Combobox(du_lieu, font=("Times New Roman", 14, "bold"), state='readonly')
            combo_Search['values']=("UID","Phân loại","Email","Authenticator")
            combo_Search.grid(row=0,column=1,pady=20, padx=10, sticky="w")
    
            txt_Search = Entry(du_lieu, font=("Times New Roman", 14), bd=2, relief=GROOVE)
            txt_Search.grid(row=0, column=2, pady=10, padx=10, sticky="w")

searchbtn = Button(du_lieu, text="Tìm kiếm", relief=GROOVE, font=("Time New Roman", 15, "bold"), fg="#006643", bg="#000").grid(row=0,column=3,padx=10,pady=10)

#======== thong_tin_du_lieu =================
            thong_tin_du_lieu = Frame(du_lieu, bd=4, relief=RIDGE, bg="#E6E6E6")     
            thong_tin_du_lieu.place(x=10,y=70,width=770,height=610)

Scroll_x = Scrollbar(thong_tin_du_lieu, orient=HORIZONTAL)
            Scroll_y = Scrollbar(thong_tin_du_lieu, orient=VERTICAL)
            acc_du_lieu = ttk.Treeview(thong_tin_du_lieu, columns=("UID","Password","Authenticator","Email","Phân loại","Ghi Chú"),xscrollcommand=Scroll_x.set, yscrollcommand=Scroll_y.set)

Scroll_x.pack(side=BOTTOM, fill=X)
            Scroll_y.pack(side=RIGHT, fill=Y)
            Scroll_x.config(command=acc_du_lieu.xview)
            Scroll_y.config(command=acc_du_lieu.yview)
            acc_du_lieu.heading("UID",text="UID")
            acc_du_lieu.heading("Password",text="Password")
            acc_du_lieu.heading("Authenticator", text="Authenticator")
            acc_du_lieu.heading("Email", text="Email")
            acc_du_lieu.heading("Phân loại", text="Phân loại")
            acc_du_lieu.heading("Ghi Chú", text="Ghi Chú")
            acc_du_lieu['show']='headings'
            
            acc_du_lieu.column("UID", width=200)
            acc_du_lieu.column("Password",width=200)
            acc_du_lieu.column("Authenticator", width=200)
            acc_du_lieu.column("Email", width=200)
            acc_du_lieu.column("Phân loại", width=100)
            acc_du_lieu.column("Ghi Chú", width=200)
            acc_du_lieu.pack(fill=BOTH,expand=1)

def add_database(self):
        con = pymysql.Connect(host="", user="root", password="", batabase="")
        cur = con.cursor()
        cur.execute("(%s,%s,%s,%s,%s,%s)",(
                                                            self.UID_var.get(),
                                                            self.Password_var.get(),
                                                            self.Authenticator_var.get(),
                                                            self.Email_var.get(),
                                                            self.Phan_loai_var.get(),
                                                            self.txt_Note.get(1.0, END),
            ))
        con.commit()
        con.close()

root = Tk()
ob = Database_01(root)
root.mainloop()

Paste Settings

Paste Title : [Optional]

Paste Folder : [Optional]

Syntax Highlighting : [Optional]

Paste Expiration : [Optional]

Paste Status : [Optional]

Password : [Optional]

Description: [Optional]

Tags: [Optional]

Encrypt Paste (?)

You are currently not logged in, this means you can not edit or delete anything you paste. Sign Up or Login

Paste Settings

Site Languages