python图形用户页面交互患者登录信息查询界面代码

以下是一个简单的 Python 图形用户界面（GUI）程序，用于查询患者登录信息。该界面使用 Tkinter 库创建，并通过 SQLite 数据库存储和检索数据。

import tkinter as tk
import sqlite3

# 创建数据库
conn = sqlite3.connect('patient_data.db')
c = conn.cursor()

# 创建表格
c.execute('''CREATE TABLE IF NOT EXISTS patient_login (
            id INTEGER PRIMARY KEY,
            name TEXT,
            dob TEXT,
            email TEXT,
            phone TEXT,
            address TEXT,
            username TEXT,
            password TEXT)''')

# 添加示例数据
c.execute("INSERT INTO patient_login VALUES (1, 'John Doe', '01/01/1980', 'johndoe@email.com', '1234567890', '123 Main St', 'johndoe', 'password')")

# 保存更改
conn.commit()

# 创建 GUI 窗口
root = tk.Tk()
root.title("Patient Login Information")

# 创建标签和文本框
name_label = tk.Label(root, text="Name:")
name_label.grid(row=0, column=0)
name_entry = tk.Entry(root)
name_entry.grid(row=0, column=1)

dob_label = tk.Label(root, text="Date of Birth (MM/DD/YYYY):")
dob_label.grid(row=1, column=0)
dob_entry = tk.Entry(root)
dob_entry.grid(row=1, column=1)

email_label = tk.Label(root, text="Email:")
email_label.grid(row=2, column=0)
email_entry = tk.Entry(root)
email_entry.grid(row=2, column=1)

phone_label = tk.Label(root, text="Phone Number:")
phone_label.grid(row=3, column=0)
phone_entry = tk.Entry(root)
phone_entry.grid(row=3, column=1)

address_label = tk.Label(root, text="Address:")
address_label.grid(row=4, column=0)
address_entry = tk.Entry(root)
address_entry.grid(row=4, column=1)

username_label = tk.Label(root, text="Username:")
username_label.grid(row=5, column=0)
username_entry = tk.Entry(root)
username_entry.grid(row=5, column=1)

password_label = tk.Label(root, text="Password:")
password_label.grid(row=6, column=0)
password_entry = tk.Entry(root, show="*")
password_entry.grid(row=6, column=1)

# 创建查询按钮
def search():
    name = name_entry.get()
    dob = dob_entry.get()
    email = email_entry.get()
    phone = phone_entry.get()
    address = address_entry.get()
    username = username_entry.get()
    password = password_entry.get()
    
    # 查询数据库
    c.execute("SELECT * FROM patient_login WHERE name=? AND dob=? AND email=? AND phone=? AND address=? AND username=? AND password=?", (name, dob, email, phone, address, username, password))
    result = c.fetchone()
    
    # 显示结果
    if result:
        tk.messagebox.showinfo("Result", "Login information found!")
    else:
        tk.messagebox.showerror("Result", "Login information not found.")
        
search_button = tk.Button(root, text="Search", command=search)
search_button.grid(row=7, column=0, columnspan=2)

# 运行 GUI 程序
root.mainloop()

# 关闭数据库连接
conn.close()

请注意，这只是一个示例，您可能需要根据您的具体需求进行更改和定制。