import sqlite3

from cryptography.fernet import Fernet

# 初始化数据库连接

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

cursor = conn.cursor()

# 创建表

cursor.execute('''

CREATE TABLE IF NOT EXISTS schedules (

id INTEGER PRIMARY KEY AUTOINCREMENT,

course_name TEXT NOT NULL,

teacher_name TEXT NOT NULL,

room TEXT NOT NULL,

encrypted_password BLOB

)

''')

# 密钥生成与加密

key = Fernet.generate_key()

cipher_suite = Fernet(key)

def encrypt_data(data):

return cipher_suite.encrypt(data.encode())

def decrypt_data(encrypted_data):

return cipher_suite.decrypt(encrypted_data).decode()

# 示例插入数据

教材发放管理

encrypted_password = encrypt_data("securepassword")

cursor.execute('INSERT INTO schedules (course_name, teacher_name, room, encrypted_password) VALUES (?, ?, ?, ?)',

('Math', 'Mr. Zhang', 'Room A1', encrypted_password))

conn.commit()

conn.close()

]]>