Discuss / Python / 交作业
Back

交作业

Topic source

阿花的阿发

#1 Created at ... [Delete] [Delete and Lock User] 
def get_score_in(low, high):
    conn =sqlite3.connect(db_file)
    cursor =conn.cursor()
    cursor.execute("SELECT name FROM user WHERE score > %s AND score <= %s ORDER BY score ASC "%(low,high))
    values= cursor.fetchall()
    result =[]
    for x in values:
        result.append(x[0])
    return  result


print(get_score_in(60,100))


assert get_score_in(80, 95) == ['Adam'], get_score_in(80, 95)
assert get_score_in(60, 80) == ['Bart', 'Lisa'], get_score_in(60, 80)
assert get_score_in(60, 100) == ['Bart', 'Lisa', 'Adam'], get_score_in(60, 100)

print('Pass')

阿花的阿发

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

cursor.close() conn.close() 忘了关掉。。

跫音窗帷

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

最好用？做占位符，防止SQL注入攻击

  • 1

Reply