如图圈起来的,我想以参数的形式来打开指定的表和表中的属性,但我这样写行不通,要怎样写才对》?
import sqlite3
def Analysis_data(aa, bb):
# 1.创建数据库连接
conn = sqlite3.connect('test.db')
# 2.创建游标
cursor = conn.cursor()
# 查询数据库表
sql = f"SELECT {aa} FROM {bb}"
results = cursor.execute(sql)
print(type(results))
# 转成元组组成的列表
students = results.fetchall()
print(type(students))
for student in students:
print(student)
cursor.close() # 关闭cursor对象
conn.close() # 关闭数据库连接
if __name__ == '__main__':
Analysis_data(aa='*', bb='student')
# (1, 'Jack', 18, 'male')
# (2, 'Tom', 24, 'male')
# (3, 'Mike', 20, 'male')
# (4, 'Mary', 22, 'female')