我编写了一个函数,该函数应该使用employee ID从数据库中检索一些employee数据。不幸的是,该函数确实检索数据,但它检索的不是一个employee,而是整个表。我怎样才能修好它
型号
def get_employee_data_by_id(self, id):
connection = sqlite3.connect("employees_database.db")
cursor = connection.cursor()
cursor.execute("""
SELECT name, surname from employees WHERE ID = id"""), (id)
data = cursor.fetchall()
connection.commit()
cursor.close()
connection.close()
return data
控制器
def get_employee_data_by_id(self, id):
data = self.model.get_employee_data_by_id(id)
print(type(data))
for i in data:
self.view.employee_data.append(i)
print(i)
查看
def show_frame1(self, event=None):
self.main_frame.grid_forget()
self.edit_employee_frame.grid()
self.controller.get_employee_data_by_id(2)
下一行(注意
(id)
在cursor.execute(...)
之外):应更改为(使用占位符):
相关问题 更多 >
编程相关推荐