python课程设计-病人信息登记系统(含有MySQL).zip

from tkinter import * from tkinter import messagebox from tkinter.ttk import Combobox class MianWindow(Frame): def __init__(self, master=None): super().__init__(master, padx=30, pady=20) self.flag = 0 self.pack(expand=True, fill=BOTH) self.id = StringVar(value=' ') self.name = StringVar(value=' ') self.style = StringVar(value='') self.number = StringVar(value=' ') self.text_box = StringVar(value=' ') self.Xu_setup() def Xu_setup(self): container = Frame(self) container.pack(side=TOP, fill=X, expand=YES, pady=10) Button(master=container, text='增 加', width=10, command=self.Yao_add).pack(side=LEFT, padx=20, expand=YES) Button(master=container, text='更 改', width=10, command=self.Yao_update).pack(side=LEFT, padx=20, expand=YES) Button(master=container, text='删 除', width=10, command=self.Yao_del).pack(side=LEFT, padx=20, expand=YES) Button(master=container, text='查 询', width=10, command=self.Yao_select).pack(side=LEFT, padx=20, expand=YES) container = Frame(self) container.pack(side=TOP, fill=X, expand=YES, pady=20) lbl1 = Label(master=container, text="编 号", width=10, font=("微软雅黑", 11)) lbl1.pack(side=LEFT, padx=5) self.ent1 = Entry(master=container, textvariable=self.id) self.ent1.pack(ipady=8, side=LEFT, padx=5) lbl2 = Label(master=container, text="姓 名", width=10, font=("微软雅黑", 11)) lbl2.pack(side=LEFT, padx=5) self.ent2 = Entry(master=container, textvariable=self.name) self.ent2.pack(ipady=8, side=LEFT, padx=5, fill=X) lbl_box = Label(master=container, text="性 别", width=10, font=("微软雅黑", 11)) lbl_box.pack(side=LEFT, padx=5) self.comboxlist = Combobox(master=container, textvariable=self.text_box, width=5) self.comboxlist["values"] = ("男", "女") self.comboxlist.current(0) self.comboxlist.bind("<<ComboboxSelected>>", self.func) self.comboxlist.pack(ipady=8, side=RIGHT, fill=X) container = Frame(self) container.pack(side=TOP, fill=X, expand=YES, pady=20) lbl3 = Label(master=container, text="病 型", width=10, font=("微软雅黑", 11)) lbl3.pack(side=LEFT, padx=5) self.ent3 = Entry(master=container, textvariable=self.style) self.ent3.pack(ipady=8, side=LEFT, padx=5, fill=X, expand=YES) lbl4 = Label(master=container, text="年 龄", width=10, font=("微软雅黑", 11)) lbl4.pack(side=LEFT, padx=5) self.ent4 = Entry(master=container, textvariable=self.number) self.ent4.pack(ipady=8, side=LEFT, padx=5, fill=X, expand=YES) container = Frame(self) container.pack(side=TOP, fill=X, expand=YES, pady=20) self.text = Text(master=container) scroll = Scrollbar() scroll.pack(side=RIGHT, fill=Y) scroll.config(command=self.text.yview) self.text.config(yscrollcommand=scroll.set) self.text.pack(fill=X, expand=YES) self.text.insert(INSERT, "") def func(self, *args): self.flag = 1 print(self.flag) return self.flag def clear(self): self.ent1.delete(0, "end") self.ent2.delete(0, "end") self.ent3.delete(0, "end") self.ent4.delete(0, "end") def Yao_add(self): if len(self.id.get()) == 0: messagebox.askokcancel("确定/退出对话框", "插入失败,编号为空") self.clear() return if len(self.name.get()) == 0: messagebox.askokcancel("确定/退出对话框", "插入失败,名称为空") self.clear() return if len(self.style.get()) == 0: messagebox.askokcancel("确定/退出对话框", "插入失败,病型为空") self.clear() return if len(self.number.get()) == 0: messagebox.askokcancel("确定/退出对话框", "插入失败,年龄为空") self.clear() return if self.flag == 0: messagebox.askokcancel("确定/退出对话框", "插入失败,性别未选") self.clear() return else: from Patient.db import Connect con = Connect() con.Zhou_insert(int(self.id.get()), self.name.get(), self.text_box.get(), self.style.get(), self.number.get()) messagebox.showinfo("打印信息对话框", "插入成功") self.clear() from Patient.db import Connect con= Connect() all_ = con.Print_result() for data in all_: s = "编号:%d \t姓名：%s\t性别：%s\t病型：%s\t年龄：%s\n\n" % data self.text.insert(INSERT, s) def Yao_update(self): if len(self.id.get()) != 0 and len(self.name.get()) != 0 and len(self.number.get()) != 0: from Patient.db import Connect con = Connect() re = con.Zhou_update(int(self.id.get()), self.name.get(), self.number.get()) if re: messagebox.askokcancel("确定/退出对话框", "执行成功") self.clear() from Patient.db import Connect con = Connect() all_ = con.Print_result() for data in all_: s = "编号:%d \t姓名：%s\t性别：%s\t病型：%s\t年龄：%s\n\n" % data self.text.insert(INSERT, s) else: messagebox.askokcancel("确定/退出对话框", "执行失败,或数据不存在") self.clear() return return elif len(self.id.get()) != 0 and len(self.name.get()): from Patient.db import Connect con = Connect() re = con.update_name(int(self.id.get()), self.name.get()) if re: messagebox.askokcancel("确定/退出对话框", "执行成功") self.clear() from Patient.db import Connect con = Connect() all_ = con.Print_result() for data in all_: s = "编号:%d \t姓名：%s\t性别：%s\t病型：%s\t年龄：%s\n\n" % data self.text.insert(INSERT, s) else: messagebox.askokcancel("确定/退出对话框", "执行失败,或数据不存在在") self.clear() return return elif len(self.id.get()) != 0 and len(self.number.get()) != 0: from Patient.db import Connect con = Connect() re = con.update_number(int(self.id.get()), self.number.get()) if re: messagebox.askokcancel("确定/退出对话框", "执行成功") self.clear() from Patient.db import Connect con = Connect() all_ = con.Print_result() for data in all_: s = "编号:%d \t姓名：%s\t性别：%s\t病型：%s\t年龄：%s\n\n" % data self.text.insert(INSERT, s) else: messagebox.askokcancel("确定/退出对话框", "执行失败,或数据不存在在") self.clear() return return else: messagebox.askokcancel("确定/退出对话框", "执行失败,或数据不存在在") self.clear() return def Yao_del(self): from Patient.db import