def get_score_in(low, high):
try:
conn=sqlite3.connect(db_file)
cursor=conn.cursor()
cursor.execute('select name from user where score between ? and ? order by score',(low,high))
namelist=cursor.fetchall()
finally:
cursor.close()
conn.close()
return [i[0] for i in namelist]
zL丶_44830
order by 默认升序排列