猪群管理系统 - 使用 Python 和 Tkinter 实现猪群信息查询、添加、删除和修改

///'def herd_manage(self)://n//tself.win = Tk()//n//tself.herdid_t = tk.StringVar()//n//tself.herdname_t = tk.StringVar()//n//tself.creattime_t = tk.StringVar()//n//tself.win.title('猪群管理界面')//n//tself.win.geometry('800x400')//n//tLabel(self.win,text='猪群id').place(x=50, y=50)//n//tself.herdid = Entry(self.win,textvariable=self.herdid_t)//n//tself.herdid.place(x=100, y=50)//n//tLabel(self.win,text='猪群名称').place(x=400, y=50)//n//tself.herdname = Entry(self.win,textvariable=self.herdname_t)//n//tself.herdname.place(x=450, y=50)//n//tLabel(self.win,text='创建时间').place(x=50, y=100)//n//tself.creattime = Entry(self.win,textvariable=self.creattime_t)//n//tself.creattime.place(x=100, y=100)//n//t# self.herdid_t=self.herdid.get()//n//t# self.herdname_t=self.herdname.get()//n//t# self.creattime_t=self.creattime.get()//n//tButton(self.win, text='查找', command=self.select).place(x=100, y=150)//n//tButton(self.win, text='添加', command=self.add).place(x=250, y=150)//n//tButton(self.win, text='删除', command=self.delect).place(x=400, y=150)//n//tButton(self.win, text='修改', command=self.upgrade()).place(x=550, y=150)//n//tself.result_label = tk.Label(self.win,text=/'/')//n//tself.result_label.pack(x=200,y=300)//n//tself.win.mainloop()//n//ndef select(self)://n//tdb = pymysql.connect(host='localhost', user='root', password='111111', port=3306, db='student', charset='utf8')//n//tself.cursor = db.cursor()//n//tsql = /'SELECT * FROM pigherd WHERE herdid=%s OR herdname=%s OR creattime=%s/'//n//tself.cursor.execute(sql, (self.herdid_t.get(), self.herdname_t.get(), self.creattime_t.get()))//n//tresult = self.cursor.fetchone()//n//tself.result_label.config(text=result)//n//tdb.close()//n//n代码中self.cursor.execute(sql, (self.herdid_t.get(), self.herdname_t.get(), self.creattime_t.get()))出错的原因是参数传递的顺序不正确。应该将参数按照sql语句中的顺序进行传递。//n//n修改方法如下：//n//npython//nself.cursor.execute(sql, (self.herdid_t.get(), self.herdname_t.get(), self.creattime_t.get()))//n//n//n改为：//n//npython//nself.cursor.execute(sql, (self.herdid_t.get(), self.herdname_t.get(), self.creattime_t.get()))//n//n//n注意，这里的参数传递顺序要与sql语句中的占位符顺序一致。/