import os,sqlite3 db_file = os.path.join(os.path.dirname(file),'test.db') if os.path.isfile(db_file): os.remove(db_file)

conn = sqlite3.connect(db_file) cursor = conn.cursor() cursor.execute("create table user(id char(20) primary key,name char(20),score int)") cursor.execute("insert into user (id,name,score) values ('A-001','Adam','95')") cursor.execute("insert into user (id,name,score) values ('A-002','Bart','64')") cursor.execute("insert into user (id,name,score) values ('A-003','Lisa','79')") cursor.close() conn.commit() conn.close()

def get_score_in(low,high): conn = sqlite3.connect(db_file) cursor = conn.cursor() cursor.execute("select name from user where score between ? and ? order by score",(low,high)) values = cursor.fetchall() print(values) cursor.close() conn.close()

get_score_in(80,96) get_score_in(70,96) get_score_in(60,96)