基于教材发放管理系统的学校信息化建设实践

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))

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()

]]>