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()