python编写一个管理系统,包括UI界面和数据库.
时间: 2024-06-10 16:10:26 浏览: 9
作为AI语言模型,我无法编写UI界面和数据库。但我可以为您提供一个基本的Python代码框架,以帮助您构建一个管理系统。
# 导入必要的模块
import sqlite3
import tkinter as tk
from tkinter import messagebox
# 连接数据库
conn = sqlite3.connect('mydatabase.db')
# 创建表格
conn.execute('''CREATE TABLE IF NOT EXISTS users
(ID INTEGER PRIMARY KEY AUTOINCREMENT,
NAME TEXT NOT NULL,
EMAIL TEXT NOT NULL);''')
# 定义主界面
class MainUI:
def __init__(self, master):
self.master = master
self.master.title("用户管理系统")
self.master.geometry("300x300")
# 添加按钮
self.add_button = tk.Button(self.master, text="添加用户", command=self.add_user)
self.add_button.pack(pady=10)
# 删除按钮
self.delete_button = tk.Button(self.master, text="删除用户", command=self.delete_user)
self.delete_button.pack(pady=10)
# 显示所有用户
self.show_all_button = tk.Button(self.master, text="显示所有用户", command=self.show_all_user)
self.show_all_button.pack(pady=10)
# 关闭按钮
self.close_button = tk.Button(self.master, text="关闭", command=self.master.quit)
self.close_button.pack(pady=10)
# 添加用户
def add_user(self):
add_window = tk.Toplevel(self.master)
add_window.title("添加用户")
add_window.geometry("300x300")
# 用户名标签和文本框
name_label = tk.Label(add_window, text="用户名:")
name_label.pack(pady=10)
name_entry = tk.Entry(add_window)
name_entry.pack(pady=10)
# 邮箱标签和文本框
email_label = tk.Label(add_window, text="邮箱:")
email_label.pack(pady=10)
email_entry = tk.Entry(add_window)
email_entry.pack(pady=10)
# 添加按钮
add_button = tk.Button(add_window, text="添加", command=lambda: self.add_user_db(name_entry.get(), email_entry.get(), add_window))
add_button.pack(pady=10)
# 添加用户到数据库
def add_user_db(self, name, email, add_window):
if name == '' or email == '':
messagebox.showerror("错误", "用户名和邮箱不能为空")
else:
conn.execute("INSERT INTO users (NAME, EMAIL) VALUES (?, ?)", (name, email))
conn.commit()
messagebox.showinfo("成功", "用户添加成功")
add_window.destroy()
# 删除用户
def delete_user(self):
delete_window = tk.Toplevel(self.master)
delete_window.title("删除用户")
delete_window.geometry("300x300")
# 用户名标签和文本框
name_label = tk.Label(delete_window, text="用户名:")
name_label.pack(pady=10)
name_entry = tk.Entry(delete_window)
name_entry.pack(pady=10)
# 删除按钮
delete_button = tk.Button(delete_window, text="删除", command=lambda: self.delete_user_db(name_entry.get(), delete_window))
delete_button.pack(pady=10)
# 从数据库中删除用户
def delete_user_db(self, name, delete_window):
if name == '':
messagebox.showerror("错误", "用户名不能为空")
else:
conn.execute("DELETE FROM users WHERE NAME=?", (name,))
conn.commit()
messagebox.showinfo("成功", "用户删除成功")
delete_window.destroy()
# 显示所有用户
def show_all_user(self):
show_window = tk.Toplevel(self.master)
show_window.title("所有用户")
show_window.geometry("300x300")
# 获取所有用户
cursor = conn.execute("SELECT ID, NAME, EMAIL from users")
# 显示用户
for row in cursor:
id_label = tk.Label(show_window, text="ID: "+str(row[0]))
id_label.pack(pady=10)
name_label = tk.Label(show_window, text="用户名: "+row[1])
name_label.pack(pady=10)
email_label = tk.Label(show_window, text="邮箱: "+row[2])
email_label.pack(pady=10)
# 运行主界面
root = tk.Tk()
main_ui = MainUI(root)
root.mainloop()
# 关闭连接
conn.close()