### 创建基于Python的科学问答选择题程序 为了创建一个有效的基于Python的科学问答选择题程序，可以从定义基本架构入手。该系统能够存储题目、选项以及正确答案，并具备评估答题情况的功能。 #### 设计数据库模型 首先考虑使用SQLite作为轻量级的关系型数据库来保存问题及其相关信息。每条记录应至少包含如下字段： - `id`: 唯一标识符； - `question_text`: 题目描述； - `option_a`, `option_b`, `option_c`, `option_d`: 各个备选答案； - `correct_answer`: 正确答案对应的字母标记（A/B/C/D）； ```sql CREATE TABLE IF NOT EXISTS questions ( id INTEGER PRIMARY KEY AUTOINCREMENT, question_text TEXT NOT NULL, option_a TEXT NOT NULL, option_b TEXT NOT NULL, option_c TEXT NOT NULL, option_d TEXT NOT NULL, correct_answer CHAR(1) CHECK (correct_answer IN ('A', 'B', 'C', 'D')) ); ``` #### 构建应用程序逻辑 接下来编写Python脚本来操作上述表格并提供交互界面给用户完成测试过程。这里采用简单的命令行方式展示如何实现这一目标。 ```python import sqlite3 def initialize_db(): conn = sqlite3.connect('quiz.db') cursor = conn.cursor() create_table_query = """ CREATE TABLE IF NOT EXISTS questions( id INTEGER PRIMARY KEY AUTOINCREMENT, question_text TEXT NOT NULL, option_a TEXT NOT NULL, option_b TEXT NOT NULL, option_c TEXT NOT NULL, option_d TEXT NOT NULL, correct_answer CHAR(1) CHECK(correct_answer IN ('A','B','C','D')) ); """ cursor.execute(create_table_query) conn.commit() initialize_db() def add_question(question_data): """Add a new multiple choice question into the database.""" conn = sqlite3.connect('quiz.db') cursor = conn.cursor() insert_query = "INSERT INTO questions VALUES(NULL, ?, ?, ?, ?, ?, ?)" cursor.execute(insert_query, tuple(question_data.values())) conn.commit() sample_questions = [ { "question_text": "What is Python?", "option_a": "Programming Language", "option_b": "Operating System", "option_c": "Database Management Tool", "option_d": "Web Browser Plugin", "correct_answer": "A" }, ] for q in sample_questions: add_question(q) def run_quiz(): score = 0 with sqlite3.connect('quiz.db') as connection: c = connection.cursor() query = "SELECT * FROM questions ORDER BY RANDOM() LIMIT 5;" results = list(c.execute(query)) for idx, row in enumerate(results, start=1): print(f"\nQuestion {idx}: ", end="") print(row[1]) options = ['a)', 'b)', 'c)', 'd)'] answers = [row[i] for i in range(2, 6)] for opt, ans in zip(options, answers): print(opt, ans) user_choice = input("\nEnter your answer(A-D): ").upper().strip()[0] if user_choice == row[-1]: print("Correct!") score += 1 else: print(f"Incorrect! The right answer was '{chr(ord(user_choice)-ord(user_choice)+ord(row[-1]))}'") print(f'\nYour final score: {score}/{len(results)}') if __name__ == '__main__': run_quiz() ``` 这段代码实现了初始化数据库表单、向其中添加样例问题集以及运行一个小测验的过程，在每次执行`run_quiz()`函数时都会随机抽取五道不同类型的题目供玩家挑战[^1]。