Discuss / Python / 交作业:

交作业:

Topic source

明天过后.

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

用try...except..finally防止崩溃

#返回指定分数区间的名字,按分数从低到高排序
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()

  • 1

Reply