Discuss / Python / 作业
Back

作业

Topic source

Tonight_dou

#1 Created at ... [Delete] [Delete and Lock User] 
    conn = sqlite3.connect(db_file)
    cursor = conn.cursor()
    cursor.execute('select name from user where score>=? and score <= ? ORDER BY score', (low, high))
    values = cursor.fetchall()
    cursor.close()
    conn.commit()
    conn.close()
    return [x[0] for x in values]

Tonight_dou

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

返回tuple，原来是tuple里表示想要查询的字段

  • 1

Reply