-- coding: utf-8 --\nimport tkinter as tk\nfrom tkinter import *\nimport pymysql\nclass HerdManage:\n def init(self):\n self.win = Tk()\n self.herdid_t = tk.StringVar()\n self.herdname_t = tk.StringVar()\n self.creattime_t = tk.StringVar()\n self.win.title('Pig Herd Management Interface')\n self.win.geometry('800x400')\n Label(self.win,text='Herd ID').place(x=50, y=50)\n self.herdid = Entry(self.win,textvariable=self.herdid_t)\n self.herdid.place(x=100, y=50)\n Label(self.win,text='Herd Name').place(x=400, y=50)\n self.herdname = Entry(self.win,textvariable=self.herdname_t)\n self.herdname.place(x=450, y=50)\n Label(self.win,text='Creation Time').place(x=50, y=100)\n self.creattime = Entry(self.win,textvariable=self.creattime_t)\n self.creattime.place(x=100, y=100)\n # self.herdid_t=self.herdid.get()\n # self.herdname_t=self.herdname.get()\n # self.creattime_t=self.creattime.get()\n Button(self.win, text='Search', command=self.select).place(x=100, y=150)\n Button(self.win, text='Add', command=self.add).place(x=250, y=150)\n Button(self.win, text='Delete', command=self.delete).place(x=400, y=150)\n Button(self.win, text='Update', command=self.upgrade).place(x=550, y=150)\n self.result_label = tk.Label(self.win,text="")\n self.result_label.pack(x=200,y=300)\n self.win.mainloop()\n def select(self):\n db = pymysql.connect(host='localhost', user='root', password='111111', port=3306, db='student', charset='utf8')\n self.cursor = db.cursor()\n sql = f"SELECT * FROM pigherd WHERE herdid='{self.herdid_t.get()}' OR herdname='{self.herdname_t.get()}' OR creattime='{self.creattime_t.get()}'"\n self.cursor.execute(sql)\n result = self.cursor.fetchone()\n self.result_label.config(text=result)\n db.close()\n def add(self):\n pass\n def delete(self):\n pass\n def upgrade(self):\n pass\nHerdManage()