def get_score_in(low, high):
' 返回指定分数区间的名字,按分数从低到高排序 '
conn = sqlite3.connect(db_file)
cursor = conn.cursor()
cursor.execute('select * from user where score<=? and score>=? order by score', (high,low))
values = cursor.fetchall()
cursor.close()
conn.commit()
conn.close()
result =[]
for i in values:
result.append(i[1])
return result
小羊飞的
def get_score_in(low, high): ' 返回指定分数区间的名字,按分数从低到高排序 ' conn = sqlite3.connect(db_file) cursor = conn.cursor() cursor.execute('select * from user where score<=? and score>=? order by score', (high,low)) values = cursor.fetchall() cursor.close() conn.commit() conn.close() result =[] for i in values: result.append(i[1]) return result