import sqlite3

def login(username, password):

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

cursor = conn.cursor()

cursor.execute("SELECT * FROM users WHERE username=? AND password=?", (username, password))

result = cursor.fetchone()

if result:

return True

else:

return False

]]>

def add_distribution(book_name, quantity, student_id):

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

cursor = conn.cursor()

cursor.execute("INSERT INTO distributions VALUES (?, ?, ?)", (book_name, quantity, student_id))

科研管理系統(tǒng)

conn.commit()

]]>

def undo_distribution(distribution_id):

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

cursor = conn.cursor()

cursor.execute("UPDATE distributions SET valid=0 WHERE id=?", (distribution_id,))

conn.commit()

]]>