import pandas as pd import sqlite3 import tkinter as tk from tkinter import filedialog, messagebox, ttk DB = "accounts.db" def init_db(): conn = sqlite3.connect(DB) conn.execute(""" CREATE TABLE IF NOT EXISTS accounts ( id INTEGER PRIMARY KEY AUTOINCREMENT, website TEXT, username TEXT, password TEXT ) """) conn.commit() conn.close() def import_file(): path = filedialog.askopenfilename( filetypes=[ ("Excel", "*.xlsx"), ("CSV", "*.csv") ] ) if not path: return try: if path.endswith(".xlsx"): df = pd.read_excel(path) else: df = pd.read_csv(path) required = {"Website", "Username", "Password"} if not required.issubset(df.columns): messagebox.showerror( "Lỗi", "File cần có cột Website, Username, Password" ) return conn = sqlite3.connect(DB) for _, row in df.iterrows(): conn.execute(""" INSERT INTO accounts (website, username, password) VALUES (?, ?, ?) """, ( str(row["Website"]), str(row["Username"]), str(row["Password"]) )) conn.commit() conn.close() load_accounts() messagebox.showinfo( "Thành công", "Đã nhập danh sách tài khoản!" ) except Exception as e: messagebox.showerror("Lỗi", str(e)) def load_accounts(): for item in tree.get_children(): tree.delete(item) conn = sqlite3.connect(DB) rows = conn.execute(""" SELECT id, website, username FROM accounts """).fetchall() conn.close() for row in rows: tree.insert("", "end", values=row) def delete_account(): selected = tree.selection() if not selected: return account_id = tree.item(selected[0])["values"][0] conn = sqlite3.connect(DB) conn.execute( "DELETE FROM accounts WHERE id=?", (account_id,) ) conn.commit() conn.close() load_accounts() init_db() root = tk.Tk() root.title("Account Manager") root.geometry("800x500") title = tk.Label( root, text="ACCOUNT MANAGEMENT", font=("Arial", 18, "bold") ) title.pack(pady=15) toolbar = tk.Frame(root) toolbar.pack(pady=10) tk.Button( toolbar, text="Import Excel / CSV", command=import_file, width=20 ).pack(side=tk.LEFT, padx=5) tk.Button( toolbar, text="Xóa tài khoản", command=delete_account, width=15 ).pack(side=tk.LEFT, padx=5) columns = ("ID", "Website", "Username") tree = ttk.Treeview( root, columns=columns, show="headings" ) for col in columns: tree.heading(col, text=col) tree.column(col, width=220) tree.pack(fill=tk.BOTH, expand=True, padx=15, pady=15) load_accounts() root.mainloop()