def get_score_in(low, high):
conn = sqlite3.connect('test.db')
cursor = conn.cursor()
cursor.execute('select * from user where score>= ? and score <=?',(low,high))
# cursor.execute('select * from user order by score desc')
values = cursor.fetchall()
cursor.close()
conn.close()
print(values)
果味II0
def get_score_in(low, high): conn = sqlite3.connect('test.db') cursor = conn.cursor() cursor.execute('select * from user where score>= ? and score <=?',(low,high))