def get_score_in(low, high):
print(' 返回指定分数区间(闭区间)的名字,按分数从低到高排序 ')
with sqlite3.connect(db_file) as conn:
cursor = conn.cursor()
cursor.execute('Select name from user Where score Between ? and ? Order By score;',(low, high))
values = cursor.fetchall()
result = []
for x in values:
result.append(x[0])
cursor.close()
return result
厦大游园惊梦
def get_score_in(low, high): print(' 返回指定分数区间(闭区间)的名字,按分数从低到高排序 ') with sqlite3.connect(db_file) as conn: cursor = conn.cursor() cursor.execute('Select name from user Where score Between ? and ? Order By score;',(low, high)) values = cursor.fetchall() result = [] for x in values: result.append(x[0]) cursor.close() return result