Discuss / Python / 在Sqlite中根据分数段查找指定的名字的函数。

在Sqlite中根据分数段查找指定的名字的函数。

Topic source

灿_Clarence

#1 Created at ... [Delete] [Delete and Lock User]

def get_score_in(low, high):

    try:

        conn=sqlite3.connect('test.db')

        cursor=conn.cursor()

        cursor.execute('select * from user where score>=? and score<=? order by score',(low,high))

        values=cursor.fetchall()

    finally:

        cursor.close()

        conn.close()

    return [ value[1] for value in values ]


  • 1

Reply