def get_score_in(low, high): # 返回指定分数区间的名字,按分数从低到高排序 # 查询语句 conn1 = sqlite3.connect(db_file) cursor1 = conn1.cursor() cursor1.execute('select * from user FORCE where score BETWEEN ? AND ? order by score ', (low, high)) value = cursor1.fetchall() # print(value) values = [] for i in value: values.append(i[1]) # print(value[0][1]) cursor1.close() conn1.close() return values
Geek_韧