寫了一個(gè)疫苗信息管理系統(tǒng)！(附源碼)

    def connect_DBS(self, database, content):        db = pymysql.connect(host="localhost", user="root", password="pwd", database=database)        cursor = db.cursor()        cursor.execute(content)        data = cursor.fetchone()        db.commit()        db.close()        return data

    def main_window(self):        tk.Button(app, text='登錄', bg='white', font=("Arial,12"), width=12, height=1, command=self.login).place(x=260,                                                                                                      y=200)        tk.Button(app, text='注冊', bg='white', font=("Arial,12"), width=12, height=1, command=self.register).place(x=260,                                                                                                                y=240)        tk.Button(app, text='退出', bg='white', font=("Arial,12"), width=12, height=1, command=self.quit_mainloop).place(x=260, y=280)

    def register(self):        register = tk.Toplevel(app)        register.title('用戶注冊')        register.geometry("600x400")        tk.Label(register, text="歡迎注冊", font=("KaiTi", 40)).place(x=200, y=20)        tk.Label(register, text='添加管理員姓名：', font=("Arial", 9)).place(x=80, y=120)        tk.Label(register, text='確認(rèn)管理員編號：', font=('Arial', 9)).place(x=80, y=150)        entry1 = tk.Entry(register, font=("Arial, 9"), width=46, )        entry2 = tk.Entry(register, font=("Arial, 9"), width=46, )        entry1.pack()        entry2.pack()        entry1.place(x=180, y=120, width=350, height=25)        entry2.place(x=180, y=150, width=350, height=25)
        def user_register():            user_name = entry1.get()            user_code = entry2.get()            if user_name == "" or user_code == "":                tkinter.messagebox.showwarning(title="警告", message="用戶名或密碼不能為空！")            else:                content = "INSERT INTO user_info (user_name, user_code) VALUES ('%s', '%s');" % (user_name, user_code)                self.connect_DBS(database="vaccine_info", content=content)                tkinter.messagebox.showinfo(title="信息", message="注冊成功！")        tk.Button(register, text="注冊", bg='white', font=("Arial,9"), width=12, height=0, command=user_register).place(x=250, y=250)

    def login(self):        login = tk.Toplevel(app)        login.title('用戶登錄')        login.geometry("600x400")        tk.Label(login, text="歡迎登錄", font=("KaiTi", 40)).place(x=200, y=20)        tk.Label(login, text='管理員姓名：', font=("Arial", 9)).place(x=80, y=120)        tk.Label(login, text='管理員編號：', font=('Arial', 9)).place(x=80, y=150)        entry1 = tk.Entry(login, font=("Arial, 9"), width=46)        entry2 = tk.Entry(login, font=("Arial, 9"), width=46, show="*")        entry1.pack()        entry2.pack()        entry1.place(x=180, y=120, width=350, height=25)        entry2.place(x=180, y=150, width=350, height=25)
        def user_check():            user_name = entry1.get()            user_code = entry2.get()            content = "SELECT * FROM user_info WHERE user_name = '%s';" % user_name            data = self.connect_DBS(database="vaccine_info", content=content)            try:                if user_name == data[1] and user_code == data[2]:                    tkinter.messagebox.showinfo(title="信息", message="歡迎登錄！")                    self.options()                elif user_name != data[1]:                    tkinter.messagebox.showerror(title="錯(cuò)誤", message="請注冊后再進(jìn)行登錄！")                elif user_name == data[1] and user_code != data[2]:                    tkinter.messagebox.showerror(title="錯(cuò)誤", message="密碼錯(cuò)誤！")            except TypeError:                tkinter.messagebox.showerror(title="錯(cuò)誤", message="請注冊后再進(jìn)行登錄！")        tk.Button(login, text="登錄", bg='white', font=("Arial,9"), width=12, height=0, command=user_check).place(x=250, y=250)

    def options(self):        options = tk.Toplevel(app)        options.title('功能選項(xiàng)')        options.geometry("600x500")        tk.Label(options, text="歡迎使用！", font=("KaiTi", 40)).place(x=180, y=15)        tk.Button(options, text='新建疫苗信息', bg='white', font=("Arial,12"), width=20, height=2,command=self.add_vacc_info).place(x=100, y=100)        tk.Button(options, text='新建疫苗分配信息', bg='white', font=("Arial,12"), width=20, height=2,command=self.add_vaccine_distr_info).place(x=100, y=160)        tk.Button(options, text='新建疫苗養(yǎng)護(hù)信息', bg='white', font=("Arial,12"), width=20, height=2,              command=self.add_vaccine_maintenance_info).place(x=100, y=220)        tk.Button(options, text='新建接種人員信息', bg='white', font=("Arial,12"), width=20, height=2,command=self.add_vaccination_person_info).place(x=100, y=280)        tk.Button(options, text='查詢疫苗分配信息', bg='white', font=("Arial,12"), width=20, height=2,command=self.vaccine_distr_info_query).place(x=100, y=340)        tk.Button(options, text='查詢疫苗養(yǎng)護(hù)信息', bg='white', font=("Arial,12"), width=20, height=2,           command=self.vaccination_maintenance_info_query).place(x=320, y=100)        tk.Button(options, text='查詢接種人員信息', bg='white', font=("Arial,12"), width=20, height=2,command=self.vaccination_person_info_query).place(x=320, y=160)        tk.Button(options, text='查詢疫苗信息', bg='white', font=("Arial,12"), width=20, height=2,command=self.vaccine_info_query).place(x=320, y=220)        tk.Button(options, text='修改疫苗信息', bg='white', font=("Arial,12"), width=20, height=2,command=self.modify_vaccine_info).place(x=320, y=280)        tk.Button(options, text='刪除疫苗信息', bg='white', font=("Arial,12"), width=20, height=2,command=self.del_vaccine_info).place(x=320, y=340)

    def add_vacc_info(self):        add_vacc_info = tk.Toplevel(app)        add_vacc_info.title('添加疫苗信息')        add_vacc_info.geometry("600x400")        tk.Label(add_vacc_info, text='疫苗批號：', font=("Arial", 9)).place(x=80, y=60)        tk.Label(add_vacc_info, text='疫苗名稱：', font=('Arial', 9)).place(x=80, y=90)        tk.Label(add_vacc_info, text='企業(yè)名稱：', font=('Arial', 9)).place(x=80, y=120)        tk.Label(add_vacc_info, text='企業(yè)編號：', font=('Arial', 9)).place(x=80, y=150)        tk.Label(add_vacc_info, text='    規(guī)格：', font=('Arial', 9)).place(x=80, y=180)        tk.Label(add_vacc_info, text='    進(jìn)價(jià)：', font=('Arial', 9)).place(x=80, y=210)        tk.Label(add_vacc_info, text='  預(yù)售價(jià)：', font=('Arial', 9)).place(x=80, y=240)        tk.Label(add_vacc_info, text='企業(yè)上限：', font=('Arial', 9)).place(x=80, y=270)        tk.Label(add_vacc_info, text='企業(yè)下限：', font=('Arial', 9)).place(x=80, y=300)        entry1 = tk.Entry(add_vacc_info, font=("Arial, 9"), width=46)        entry2 = tk.Entry(add_vacc_info, font=("Arial, 9"), width=46)        entry3 = tk.Entry(add_vacc_info, font=("Arial, 9"), width=46)        entry4 = tk.Entry(add_vacc_info, font=("Arial, 9"), width=46)        entry5 = tk.Entry(add_vacc_info, font=("Arial, 9"), width=46)        entry6 = tk.Entry(add_vacc_info, font=("Arial, 9"), width=46)        entry7 = tk.Entry(add_vacc_info, font=("Arial, 9"), width=46)        entry8 = tk.Entry(add_vacc_info, font=("Arial, 9"), width=46)        entry9 = tk.Entry(add_vacc_info, font=("Arial, 9"), width=46)        entry1.pack()        entry2.pack()        entry3.pack()        entry4.pack()        entry5.pack()        entry6.pack()        entry7.pack()        entry8.pack()        entry9.pack()        entry1.place(x=180, y=60, width=350)        entry2.place(x=180, y=90, width=350)        entry3.place(x=180, y=120, width=350)        entry4.place(x=180, y=150, width=350)        entry5.place(x=180, y=180, width=350)        entry6.place(x=180, y=210, width=350)        entry7.place(x=180, y=240, width=350)        entry8.place(x=180, y=270, width=350)        entry9.place(x=180, y=300, width=350)
        def add():            text1 = entry1.get()            text2 = entry2.get()            text3 = entry3.get()            text4 = entry4.get()            text5 = entry5.get()            text6 = entry6.get()            text7 = entry7.get()            text8 = entry8.get()            text9 = entry9.get()            content = "INSERT INTO vaccine_info (" \                      "vaccine_num, vaccine_name, company_name, company_num, size, buy_price, pre_sale_price, limit_up, limit_down" \                      ")" \                      " VALUES (%s, '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s');" % (                      text1, text2, text3, text4, text5, text6, text7, text8, text9)            self.connect_DBS(database="vaccine_info", content=content)            tkinter.messagebox.showinfo(title="信息", message="數(shù)據(jù)添加成功！")
        def clear():            entry1.delete(0, "end")            entry2.delete(0, "end")            entry3.delete(0, "end")            entry4.delete(0, "end")            entry5.delete(0, "end")            tkinter.messagebox.showinfo(title="信息", message="數(shù)據(jù)已清空，請繼續(xù)添加！")        tk.Button(add_vacc_info, text="添加", bg='white', font=("Arial,9"), width=9, height=0, command=add).place(x=400,                                                                                                       y=360)        tk.Button(add_vacc_info, text="清空", bg='white', font=("Arial,9"), width=9, height=0, command=clear).place(x=160,                                                                                                             y=360)

    def add_vaccine_distr_info(self):        add_vaccine_distr_info = tk.Toplevel(app)        add_vaccine_distr_info.title('添加疫苗分配信息')        add_vaccine_distr_info.geometry("600x400")        tk.Label(add_vaccine_distr_info, text='疫苗分配單號：', font=("Arial", 9)).place(x=80, y=60)        tk.Label(add_vaccine_distr_info, text='       日期：', font=('Arial', 9)).place(x=80, y=90)        tk.Label(add_vaccine_distr_info, text='   疫苗批號：', font=('Arial', 9)).place(x=80, y=120)        tk.Label(add_vaccine_distr_info, text='   疫苗名稱：', font=('Arial', 9)).place(x=80, y=150)        tk.Label(add_vaccine_distr_info, text='   企業(yè)編號：', font=('Arial', 9)).place(x=80, y=180)        tk.Label(add_vaccine_distr_info, text=' 質(zhì)檢員編號：', font=('Arial', 9)).place(x=80, y=210)        tk.Label(add_vaccine_distr_info, text='      數(shù)量：', font=('Arial', 9)).place(x=80, y=240)        entry1 = tk.Entry(add_vaccine_distr_info, font=("Arial, 9"), width=46)        entry2 = tk.Entry(add_vaccine_distr_info, font=("Arial, 9"), width=46)        entry3 = tk.Entry(add_vaccine_distr_info, font=("Arial, 9"), width=46)        entry4 = tk.Entry(add_vaccine_distr_info, font=("Arial, 9"), width=46)        entry5 = tk.Entry(add_vaccine_distr_info, font=("Arial, 9"), width=46)        entry6 = tk.Entry(add_vaccine_distr_info, font=("Arial, 9"), width=46)        entry7 = tk.Entry(add_vaccine_distr_info, font=("Arial, 9"), width=46)        entry1.pack()        entry2.pack()        entry3.pack()        entry4.pack()        entry5.pack()        entry6.pack()        entry7.pack()        entry1.place(x=180, y=60, width=350)        entry2.place(x=180, y=90, width=350)        entry3.place(x=180, y=120, width=350)        entry4.place(x=180, y=150, width=350)        entry5.place(x=180, y=180, width=350)        entry6.place(x=180, y=210, width=350)        entry7.place(x=180, y=240, width=350)
        def add():            text1 = entry1.get()            text2 = entry2.get()            text3 = entry3.get()            text4 = entry4.get()            text5 = entry5.get()            text6 = entry6.get()            text7 = entry7.get()            content = "INSERT INTO vaccine_distr_info (" \                      "vaccine_distr_num, date, vaccine_num, vaccine_name, company_num, operator_num, num" \                      ")" \                      " VALUES (%s, '%s', '%s', '%s', '%s', '%s', '%s');" % (                          text1, text2, text3, text4, text5, text6, text7)            self.connect_DBS(database="vaccine_info", content=content)            tkinter.messagebox.showinfo(title="信息", message="數(shù)據(jù)添加成功！")
        def clear():            entry1.delete(0, "end")            entry2.delete(0, "end")            entry3.delete(0, "end")            entry4.delete(0, "end")            entry5.delete(0, "end")            entry6.delete(0, "end")            entry7.delete(0, "end")            tkinter.messagebox.showinfo(title="信息", message="數(shù)據(jù)已清空，請繼續(xù)添加！")        tk.Button(add_vaccine_distr_info, text="添加", bg='white', font=("Arial,9"), width=9, height=0,command=add).place(x=400,y=360)        tk.Button(add_vaccine_distr_info, text="清空", bg='white', font=("Arial,9"), width=9, height=0,command=clear).place(x=160,y=360)

    def add_vaccine_maintenance_info(self):        vaccine_maintenance_info = tk.Toplevel(app)        vaccine_maintenance_info.title('添加疫苗養(yǎng)護(hù)信息')        vaccine_maintenance_info.geometry("600x400")        tk.Label(vaccine_maintenance_info, text='養(yǎng)護(hù)疫苗批號：', font=("Arial", 9)).place(x=80, y=60)        tk.Label(vaccine_maintenance_info, text='養(yǎng)護(hù)疫苗名稱：', font=('Arial', 9)).place(x=80, y=90)        tk.Label(vaccine_maintenance_info, text=' 管理員編號：', font=('Arial', 9)).place(x=80, y=120)        tk.Label(vaccine_maintenance_info, text=' 管理員姓名：', font=('Arial', 9)).place(x=80, y=150)        tk.Label(vaccine_maintenance_info, text='   養(yǎng)護(hù)時(shí)間：', font=('Arial', 9)).place(x=80, y=180)        tk.Label(vaccine_maintenance_info, text=' 冷藏室溫度：', font=('Arial', 9)).place(x=80, y=210)        tk.Label(vaccine_maintenance_info, text=' 冷凍室溫度：', font=('Arial', 9)).place(x=80, y=240)        tk.Label(vaccine_maintenance_info, text='設(shè)備運(yùn)轉(zhuǎn)情況：', font=('Arial', 9)).place(x=80, y=270)        tk.Label(vaccine_maintenance_info, text='    是否報(bào)警：', font=('Arial', 9)).place(x=80, y=300)        entry1 = tk.Entry(vaccine_maintenance_info, font=("Arial, 9"), width=46)        entry2 = tk.Entry(vaccine_maintenance_info, font=("Arial, 9"), width=46)        entry3 = tk.Entry(vaccine_maintenance_info, font=("Arial, 9"), width=46)        entry4 = tk.Entry(vaccine_maintenance_info, font=("Arial, 9"), width=46)        entry5 = tk.Entry(vaccine_maintenance_info, font=("Arial, 9"), width=46)        entry6 = tk.Entry(vaccine_maintenance_info, font=("Arial, 9"), width=46)        entry7 = tk.Entry(vaccine_maintenance_info, font=("Arial, 9"), width=46)        entry8 = tk.Entry(vaccine_maintenance_info, font=("Arial, 9"), width=46)        entry9 = tk.Entry(vaccine_maintenance_info, font=("Arial, 9"), width=46)        entry1.pack()        entry2.pack()        entry3.pack()        entry4.pack()        entry5.pack()        entry6.pack()        entry7.pack()        entry8.pack()        entry9.pack()        entry1.place(x=180, y=60, width=350)        entry2.place(x=180, y=90, width=350)        entry3.place(x=180, y=120, width=350)        entry4.place(x=180, y=150, width=350)        entry5.place(x=180, y=180, width=350)        entry6.place(x=180, y=210, width=350)        entry7.place(x=180, y=240, width=350)        entry8.place(x=180, y=270, width=350)        entry9.place(x=180, y=300, width=350)
        def add():            text1 = entry1.get()            text2 = entry2.get()            text3 = entry3.get()            text4 = entry4.get()            text5 = entry5.get()            text6 = entry6.get()            text7 = entry7.get()            text8 = entry8.get()            text9 = entry9.get()            content = "INSERT INTO vaccine_maintenance_info (" \                      "vaccine_maintenance_num, vaccine_maintenance_name, admin_num, admin_name, maintenance_time, cold_storage_temp, freezer_temp, equipment_operation, alter_info" \                      ")" \                      " VALUES (%s, '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s');" % (                          text1, text2, text3, text4, text5, text6, text7, text8, text9)            self.connect_DBS(database="vaccine_info", content=content)            tkinter.messagebox.showinfo(title="信息", message="數(shù)據(jù)添加成功！")
        def clear():            entry1.delete(0, "end")            entry2.delete(0, "end")            entry3.delete(0, "end")            entry4.delete(0, "end")            entry5.delete(0, "end")            entry6.delete(0, "end")            entry7.delete(0, "end")            entry8.delete(0, "end")            entry9.delete(0, "end")            tkinter.messagebox.showinfo(title="信息", message="數(shù)據(jù)已清空，請繼續(xù)添加！")        tk.Button(vaccine_maintenance_info, text="添加", bg='white', font=("Arial,9"), width=9, height=0,command=add).place(x=400,y=360)        tk.Button(vaccine_maintenance_info, text="清空", bg='white', font=("Arial,9"), width=9, height=0,command=clear).place(x=160,y=360)

    def add_vaccination_person_info(self):        add_vaccination_person_info = tk.Toplevel(app)        add_vaccination_person_info.title('添加接種人員信息')        add_vaccination_person_info.geometry("600x400")        tk.Label(add_vaccination_person_info, text='姓名：', font=("Arial", 9)).place(x=80, y=60)        tk.Label(add_vaccination_person_info, text='性別：', font=('Arial', 9)).place(x=80, y=90)        tk.Label(add_vaccination_person_info, text='年齡：', font=('Arial', 9)).place(x=80, y=120)        tk.Label(add_vaccination_person_info, text='身份證號：', font=('Arial', 9)).place(x=80, y=150)        tk.Label(add_vaccination_person_info, text='家庭住址：', font=('Arial', 9)).place(x=80, y=180)        tk.Label(add_vaccination_person_info, text='是否過敏：', font=('Arial', 9)).place(x=80, y=210)        tk.Label(add_vaccination_person_info, text='接種時(shí)間：', font=('Arial', 9)).place(x=80, y=240)        entry1 = tk.Entry(add_vaccination_person_info, font=("Arial, 9"), width=46)        entry2 = tk.Entry(add_vaccination_person_info, font=("Arial, 9"), width=46)        entry3 = tk.Entry(add_vaccination_person_info, font=("Arial, 9"), width=46)        entry4 = tk.Entry(add_vaccination_person_info, font=("Arial, 9"), width=46)        entry5 = tk.Entry(add_vaccination_person_info, font=("Arial, 9"), width=46)        entry6 = tk.Entry(add_vaccination_person_info, font=("Arial, 9"), width=46)        entry7 = tk.Entry(add_vaccination_person_info, font=("Arial, 9"), width=46)        entry1.pack()        entry2.pack()        entry3.pack()        entry4.pack()        entry5.pack()        entry6.pack()        entry7.pack()        entry1.place(x=180, y=60, width=350)        entry2.place(x=180, y=90, width=350)        entry3.place(x=180, y=120, width=350)        entry4.place(x=180, y=150, width=350)        entry5.place(x=180, y=180, width=350)        entry6.place(x=180, y=210, width=350)        entry7.place(x=180, y=240, width=350)
        def add():            text1 = entry1.get()            text2 = entry2.get()            text3 = entry3.get()            text4 = entry4.get()            text5 = entry5.get()            text6 = entry6.get()            text7 = entry7.get()            content = "INSERT INTO vaccination_person_info (" \                      "name, sexy, age, ID_num, address, allergy, date" \                      ")" \                      " VALUES ('%s', '%s', '%s', '%s', '%s', '%s', '%s');" % (                          text1, text2, text3, text4, text5, text6, text7)            self.connect_DBS(database="vaccine_info", content=content)            tkinter.messagebox.showinfo(title="信息", message="數(shù)據(jù)添加成功！")
        def clear():            entry1.delete(0, "end")            entry2.delete(0, "end")            entry3.delete(0, "end")            entry4.delete(0, "end")            entry5.delete(0, "end")            entry6.delete(0, "end")            entry7.delete(0, "end")            tkinter.messagebox.showinfo(title="信息", message="數(shù)據(jù)已清空，請繼續(xù)添加！")        tk.Button(add_vaccination_person_info, text="添加", bg='white', font=("Arial,9"), width=9, height=0,command=add).place(x=400, y=360)        tk.Button(add_vaccination_person_info, text="清空", bg='white', font=("Arial,9"), width=9, height=0,command=clear).place(x=160, y=360)

    def vaccine_distr_info_query(self):        query = tk.Toplevel(app)        query.title('信息查詢')        query.geometry("600x400")        entry = tk.Entry(query, width=30)        entry.pack()        entry.place(x=200, y=80)        tk.Label(query, text="請輸入疫苗分配單號：", font=("Arial", 9)).place(x=50, y=80)        tk.Label(query, text='查詢結(jié)果：', font=('Arial', 9)).place(x=50, y=120)        text1 = tk.Text(query, width=50, height=20)        text1.pack()        text1.place(x=150, y=120)
        def base_query():            vaccine_distr_num = entry.get()            print(vaccine_distr_num)            content = "SELECT * FROM vaccine_distr_info WHERE vaccine_distr_num = %s;" % vaccine_distr_num            data = self.connect_DBS(database="vaccine_info", content=content)            text1.delete(1.0, "end")            text1.insert(chars="{}".format(data), index="insert")        tk.Button(query, text='查詢', bg='white', font=("Arial,12"), width=9, height=0, command=base_query).place(x=450,                                                                                                                y=75)

    def vaccination_maintenance_info_query(self):        query = tk.Toplevel(app)        query.title('疫苗養(yǎng)護(hù)信息查詢')        query.geometry("600x400")        entry = tk.Entry(query, width=30)        entry.pack()        entry.place(x=200, y=80)        tk.Label(query, text="請輸入疫苗養(yǎng)護(hù)批號：", font=("Arial", 9)).place(x=50, y=80)        tk.Label(query, text='查詢結(jié)果：', font=('Arial', 9)).place(x=50, y=120)        text1 = tk.Text(query, width=50, height=20)        text1.pack()        text1.place(x=150, y=120)
        def base_query():            vaccine_maintenance_num = entry.get()            print(vaccine_maintenance_num)            content = "SELECT * FROM vaccine_maintenance_info WHERE vaccine_maintenance_num = %s;" % vaccine_maintenance_num            data = self.connect_DBS(database="vaccine_info", content=content)            text1.delete(1.0, "end")            text1.insert(chars="{}".format(data), index="insert")        tk.Button(query, text='查詢', bg='white', font=("Arial,12"), width=9, height=0, command=base_query).place(x=450,                                                                                                                y=75)    def vaccine_distr_info_query(self):        query = tk.Toplevel(app)        query.title('信息查詢')        query.geometry("600x400")        entry = tk.Entry(query, width=30)        entry.pack()        entry.place(x=200, y=80)        tk.Label(query, text="請輸入疫苗分配單號：", font=("Arial", 9)).place(x=50, y=80)        tk.Label(query, text='查詢結(jié)果：', font=('Arial', 9)).place(x=50, y=120)        text1 = tk.Text(query, width=50, height=20)        text1.pack()        text1.place(x=150, y=120)
        def base_query():            vaccine_distr_num = entry.get()            print(vaccine_distr_num)            content = "SELECT * FROM vaccine_distr_info WHERE vaccine_distr_num = %s;" % vaccine_distr_num            data = self.connect_DBS(database="vaccine_info", content=content)            text1.delete(1.0, "end")            text1.insert(chars="{}".format(data), index="insert")        tk.Button(query, text='查詢', bg='white', font=("Arial,12"), width=9, height=0, command=base_query).place(x=450,                                                                                                                y=75)

 def vaccination_person_info_query(self):        query = tk.Toplevel(app)        query.title('接種人員信息查詢')        query.geometry("600x400")        entry = tk.Entry(query, width=30)        entry.pack()        entry.place(x=200, y=80)        tk.Label(query, text="請輸入接種人員身份證號：", font=("Arial", 9)).place(x=50, y=80)        tk.Label(query, text='查詢結(jié)果：', font=('Arial', 9)).place(x=50, y=120)        text1 = tk.Text(query, width=50, height=20)        text1.pack()        text1.place(x=150, y=120)
        def base_query():            ID_num = entry.get()            content = "SELECT * FROM vaccination_person_info WHERE ID_num = %s;" % ID_num            data = self.connect_DBS(database="vaccine_info", content=content)            text1.delete(1.0, "end")            text1.insert(chars="{}".format(data), index="insert")        tk.Button(query, text='查詢', bg='white', font=("Arial,12"), width=9, height=0, command=base_query).place(x=450,                                                                                                          y=75)

    def vaccine_info_query(self):        query = tk.Toplevel(app)        query.title('疫苗信息查詢')        query.geometry("600x400")        entry = tk.Entry(query, width=30)        entry.pack()        entry.place(x=200, y=80)        tk.Label(query, text="請輸入疫苗批號：", font=("Arial", 9)).place(x=50, y=80)        tk.Label(query, text='查詢結(jié)果：', font=('Arial', 9)).place(x=50, y=120)        text1 = tk.Text(query, width=50, height=20)        text1.pack()        text1.place(x=150, y=120)
        def base_query():            vaccine_num = entry.get()            content = "SELECT * FROM vaccine_info WHERE vaccine_num = %s;" % vaccine_num            data = self.connect_DBS(database="vaccine_info", content=content)            text1.delete(1.0, "end")            text1.insert(chars="{}".format(data), index="insert")        tk.Button(query, text='查詢', bg='white', font=("Arial,12"), width=9, height=0, command=base_query).place(x=450,                                                                                                          y=75)

    def modify_vaccine_info(self):        modify_info = tk.Toplevel(app)        modify_info.title('疫苗信息修改')        modify_info.geometry("600x400")        entry = tk.Entry(modify_info, width=30)        entry.pack()        entry.place(x=200, y=60)        tk.Label(modify_info, text="請輸入疫苗分配單號：", font=("Arial", 9)).place(x=50, y=60)        tk.Label(modify_info, text='疫苗批號：', font=("Arial", 9)).place(x=80, y=100)        tk.Label(modify_info, text='疫苗名稱：', font=('Arial', 9)).place(x=80, y=130)        tk.Label(modify_info, text='企業(yè)名稱：', font=('Arial', 9)).place(x=80, y=160)        tk.Label(modify_info, text='企業(yè)編號：', font=('Arial', 9)).place(x=80, y=190)        tk.Label(modify_info, text='    規(guī)格：', font=('Arial', 9)).place(x=80, y=220)        tk.Label(modify_info, text='    進(jìn)價(jià)：', font=('Arial', 9)).place(x=80, y=250)        tk.Label(modify_info, text='  預(yù)售價(jià)：', font=('Arial', 9)).place(x=80, y=280)        tk.Label(modify_info, text='企業(yè)上限：', font=('Arial', 9)).place(x=80, y=310)        tk.Label(modify_info, text='企業(yè)下限：', font=('Arial', 9)).place(x=80, y=340)        text1 = tk.Text(modify_info, width=50, height=1)        text2 = tk.Text(modify_info, width=50, height=1)        text3 = tk.Text(modify_info, width=50, height=1)        text4 = tk.Text(modify_info, width=50, height=1)        text5 = tk.Text(modify_info, width=50, height=1)        text6 = tk.Text(modify_info, width=50, height=1)        text7 = tk.Text(modify_info, width=50, height=1)        text8 = tk.Text(modify_info, width=50, height=1)        text9 = tk.Text(modify_info, width=50, height=1)        text1.pack()        text2.pack()        text3.pack()        text4.pack()        text5.pack()        text6.pack()        text7.pack()        text8.pack()        text9.pack()        text1.place(x=150, y=100)        text2.place(x=150, y=130)        text3.place(x=150, y=160)        text4.place(x=150, y=190)        text5.place(x=150, y=220)        text6.place(x=150, y=250)        text7.place(x=150, y=280)        text8.place(x=150, y=310)        text9.place(x=150, y=340)
        def base_query():            vaccine_modify_num = entry.get()            content = "SELECT * FROM vaccine_info WHERE vaccine_num = %s;" % vaccine_modify_num            data = self.connect_DBS(database="vaccine_info", content=content)            text1.delete(1.0, "end")            text2.delete(1.0, "end")            text3.delete(1.0, "end")            text4.delete(1.0, "end")            text5.delete(1.0, "end")            text6.delete(1.0, "end")            text7.delete(1.0, "end")            text8.delete(1.0, "end")            text9.delete(1.0, "end")            text1.insert(chars="{}".format(data[0]), index="insert")            text2.insert(chars="{}".format(data[1]), index="insert")            text3.insert(chars="{}".format(data[2]), index="insert")            text4.insert(chars="{}".format(data[3]), index="insert")            text5.insert(chars="{}".format(data[4]), index="insert")            text6.insert(chars="{}".format(data[5]), index="insert")            text7.insert(chars="{}".format(data[6]), index="insert")            text8.insert(chars="{}".format(data[7]), index="insert")            text9.insert(chars="{}".format(data[8]), index="insert")
        def update_info():            vaccine_del_num = entry.get()            str_ls = [text1.get("1.0", "end")[0:-1], text2.get("1.0", "end")[0:-1], text3.get("1.0", "end")[0:-1],                      text4.get("1.0", "end")[0:-1], text5.get("1.0", "end")[0:-1], text6.get("1.0", "end")[0:-1],                      text7.get("1.0", "end")[0:-1], text8.get("1.0", "end")[0:-1], text9.get("1.0", "end")[0:-1]]            str_ls = [str(i) for i in str_ls]            content = "UPDATE vaccine_info  SET vaccine_num='%s', vaccine_name='%s', company_name='%s', vaccine_num='%s'" \                      ", size='%s', buy_price='%s', pre_sale_price='%s', limit_up='%s', limit_down='%s' WHERE " \                      "vaccine_num = '%s';" % (                      str_ls[0], str_ls[1], str_ls[2], str_ls[3], str_ls[4], str_ls[5], str_ls[6], str_ls[7], str_ls[8],vaccine_del_num)            self.connect_DBS(database="vaccine_info", content=content)            tkinter.messagebox.showinfo(title="信息", message="疫苗分配單號：{}數(shù)據(jù)修改成功！".format(vaccine_modify_num)            return None        tk.Button(modify_info, text='查詢', bg='white', font=("Arial,12"), width=9, height=0, command=base_query).place(x=450,y=55)        tk.Button(modify_info, text='修改', bg='white', font=("Arial,12"), width=9, height=0, command=update_info).place(x=260,y=370)

   def del_vaccine_info(self):        del_info = tk.Toplevel(app)        del_info.title('疫苗信息刪除')        del_info.geometry("600x500")        entry = tk.Entry(del_info, width=30)        entry.pack()        entry.place(x=200, y=80)        tk.Label(del_info, text="請輸入疫苗批號：", font=("Arial", 9)).place(x=50, y=80)        tk.Label(del_info, text='查詢結(jié)果：', font=('Arial', 9)).place(x=50, y=120)        text1 = tk.Text(del_info, width=50, height=20)        text1.pack()        text1.place(x=150, y=120)
        def base_query():            vaccine_del_num = entry.get()            print(vaccine_del_num)            content = "SELECT * FROM vaccine_info WHERE vaccine_num = %s;" % vaccine_del_num            data = self.connect_DBS(database="vaccine_info", content=content)            text1.delete(1.0, "end")            text1.insert(chars="{}".format(data), index="insert")
        def del_infor():            vaccine_del_num = entry.get()            print(vaccine_del_num)            content = "DELETE FROM vaccine_info  WHERE vaccine_num = %s;" % vaccine_del_num            data = self.connect_DBS(database="vaccine_info", content=content)            tkinter.messagebox.showinfo(title="信息", message="疫苗批號：{}數(shù)據(jù)已刪除！".format(vaccine_del_num))            return None        tk.Button(del_info, text='查詢', bg='white', font=("Arial,12"), width=9, height=0, command=base_query).place(x=450,y=75)        tk.Button(del_info, text='刪除', bg='white', font=("Arial,12"), width=9, height=0, command=del_infor).place(x=280,                                                                                                                  y=400

create table vaccine_info(    vaccine_num    char(50) not null primary key,    vaccine_name   char(50) not null,    company_name   char(50) not null,    company_num    char(50) not null,    size           char(50) null,    buy_price      char(50) not null,    pre_sale_price char(20) not null,    limit_up       char(50) not null,    limit_down     char(50) not null);
create table user_info(  id int auto_increment primary key,    user_name char(50) NOT NULL ,    user_code char(50) NOT NULL);                        create table if not exists vaccine_distr_info (    vaccine_distr_num char(50) primary key,    date date not null ,    vaccine_num char(50) not null ,    vaccine_name char(50) not null ,    company_num char(50) not null ,    operator_num char(50) not null ,    num int not null );
create table if not exists vaccine_maintenance_info (    vaccine_maintenance_num char(50) primary key ,    vaccine_maintenance_name char(50) not null ,    admin_num char(50) not null ,    admin_name char(50) not null ,    maintenance_time date,    cold_storage_temp char(20) not null ,    freezer_temp char(20) not null ,    equipment_operation char(50) not null ,    alter_info char(50) not null );
create table if not exists vaccination_person_info(    id int auto_increment primary key,    name char(20) not null ,    sexy char(10) not null ,    age char(10) not null ,    ID_num char(50) not null ,    address char(70) not null ,    allergy char(10) not null ,    date date);