オンライン質疑応答における学習記録と学習プロセスの可視化を支援するシステムの設計方法

# 导入必要的库和模块： import sqlite3 # 连接数据库： conn = sqlite3.connect('learning.db') # 创建学习者表格： conn.execute('''CREATE TABLE IF NOT EXISTS learner (id INTEGER PRIMARY KEY AUTOINCREMENT, username TEXT NOT NULL, password TEXT NOT NULL, email TEXT NOT NULL);''') # 创建答题记录表格： conn.execute('''CREATE TABLE IF NOT EXISTS answer (id INTEGER PRIMARY KEY AUTOINCREMENT, learner_id INTEGER NOT NULL, question_id INTEGER NOT NULL, answer TEXT NOT NULL, duration INTEGER NOT NULL, FOREIGN KEY (learner_id) REFERENCES learner(id), FOREIGN KEY (question_id) REFERENCES question(id));''') # 创建问题表格： conn.execute('''CREATE TABLE IF NOT EXISTS question (id INTEGER PRIMARY KEY AUTOINCREMENT, content TEXT NOT NULL, option_1 TEXT NOT NULL, option_2 TEXT NOT NULL, option_3 TEXT NOT NULL, option_4 TEXT NOT NULL, answer TEXT NOT NULL);''') # 插入学习者数据： conn.execute("INSERT INTO learner (username, password, email) VALUES ('learner1', 'password1', 'learner1@example.com')") conn.commit() # 插入问题数据： conn.execute("INSERT INTO question (content, option_1, option_2, option_3, option_4, answer) VALUES ('问题1', '选项1', '选项2', '选项3', '选项4', '答案1')") conn.commit() # 插入答题记录数据： conn.execute("INSERT INTO answer (learner_id, question_id, answer, duration) VALUES (1, 1, '答案1', 30)") conn.commit() # 查询学习者的答题记录： cursor = conn.execute("SELECT * FROM answer WHERE learner_id = 1") # 输出学习者的答题记录： for row in cursor: print("学习者ID：", row[1]) print("题目ID：", row[2]) print("答案：", row[3]) print("答题耗时（秒）：", row[4]) # 关闭数据库连接： conn.close()