Can not get index from column label ‘date‘

是因为mysql依赖升级之后不能用select *,必须将所有的字段都列出来。

#查询历史记录 def Get_history(): # 连接数据库 conn = pyodbc.connect('DRIVER={SQL Server};SERVER=DESKTOP-JM5K5CS;DATABASE=bank;UID=sa;PWD=1') # 获取游标 cursor = conn.cursor() # 创建窗口 window = tk.Tk() window.title('查询历史记录') # 创建标签和输入框 label_account_number = tk.Label(window, text='卡号:') label_account_number.grid(row=0, column=0) entry_account_number = tk.Entry(window) entry_account_number.grid(row=0, column=1) label_password = tk.Label(window, text='密码:') label_password.grid(row=1, column=0) entry_password = tk.Entry(window, show='*') entry_password.grid(row=1, column=1) label_start_date = tk.Label(window, text='交易日期:') label_start_date.grid(row=2, column=0) entry_start_date = tk.Entry(window) entry_start_date.grid(row=2, column=1) label_transaction_type = tk.Label(window, text='交易方式:') label_transaction_type.grid(row=3, column=0) transaction_var = tk.StringVar(value='所有') transaction_radios = [ ('所有', '所有'), ('存款', '存款'), ('取款', '取款'), ('转入', '转入'), ('转出', '转出') ] for i, (text, value) in enumerate(transaction_radios): radio = tk.Radiobutton(window, text=text, variable=transaction_var, value=value) radio.grid(row=i + 4, column=1) label_password = tk.Label(window, text='备注:') label_password.grid(row=4, column=0) entry_password = tk.Entry(window, show='*') entry_password.grid(row=4, column=1) # 创建按钮和文本框 text_history = tk.Text(window) text_history.grid(row=2, column=0, rowspan=6) def get_history(): # 查询数据 account_number = entry_account_number.get() password = entry_password.get() transaction_date = entry_start_date.get() transaction_type = None if transaction_var.get() != '所有': transaction_type = transaction_var.get() # 查询卡号和密码是否匹配 cursor.execute("SELECT * FROM Accounts WHERE account_number = ? AND password = ?",
06-06
#添加学生类 class InputStudentFrame(Frame): # 继承Frame类 def __init__(self, master=None): Frame.__init__(self, master) self.root = master # 定义内部变量root self.id = StringVar() self.name = StringVar() self.sex = StringVar() self.speciality = StringVar() self.classno = StringVar() self.date = StringVar() self.createPage() def createPage(self): Label(self).grid(row=0, stick=W, pady=10) Label(self, text='学号: ').grid(row=1, stick=W, pady=10) Entry(self, textvariable=self.id).grid(row=1, column=1, stick=E) Label(self, text='姓名: ').grid(row=2, stick=W, pady=10) Entry(self, textvariable=self.name).grid(row=2, column=1, stick=E) Label(self, text='性别: ').grid(row=3, stick=W, pady=10) Entry(self, textvariable=self.sex).grid(row=3, column=1, stick=E) Label(self, text='专业: ').grid(row=4, stick=W, pady=10) Entry(self, textvariable=self.speciality).grid(row=4, column=1, stick=E) Label(self, text='班级: ').grid(row=5, stick=W, pady=10) Entry(self, textvariable=self.classno).grid(row=5, column=1, stick=E) Label(self, text='入学时间: ').grid(row=6, stick=W, pady=10) Entry(self, textvariable=self.date).grid(row=6, column=1, stick=E) Button(self, text='创建学生账号', command=self.AddStudent).grid(row=8, column=1, stick=E, pady=10) #添加学生信息 def AddStudent(self): id = self.id.get() name = self.name.get() sex = self.sex.get() speciality = self.speciality.get() classno = self.classno.get() date = self.date.get() if id == '' or name == '': mb.showerror("错误", "信息不能为空!") else: InsertStudent(id,name,sex,speciality,classno,date) mb.showinfo("成功", "新增学生信息成功") self.id.set('') self.name.set('') self.sex.set('') self.speciality.set('') self.classno.set('') self.date.set('')
06-13
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值