#返回指定分数区间的名字,按分数从低到高排序
def get_score_in(low, high):
try:
conn = sqlite3.connect('test.db')
cursor = conn.cursor()
cursor.execute(r'SELECT name FROM user WHERE score BETWEEN? AND? ORDER BY score', (low, high))
values = [name[0] for name in cursor.fetchall()]
return values
except Exception as e:
print(e)
finally:
cursor.close()
conn.close()
明天过后.
用try...except..finally防止崩溃