Python从MySQL数据库中面抽取试题，生成试卷

1. 安装MySQL数据库

首先需要在本地电脑安装MySQL数据库。安装完成后，需要创建一个名为"test"的数据库，并在其中创建"questions"表。

2. python连接MySQL数据库

需要安装python中的pymysql包，并连接到之前创建的test数据库中的questions表。

import pymysql

# connect to database
conn = pymysql.connect(
    host='localhost',
    user='root',
    password='password',
    database='test',
    charset='utf8mb4')

# create cursor
cursor = conn.cursor()

3. 从MySQL数据库中抽取试题

可以使用SELECT语句从questions表中获取需要的试题。例如，可以获取id为1的试题的内容和答案。

cursor.execute("SELECT question, answer FROM questions WHERE id=1")
data = cursor.fetchall()

# extract question and answer from data
question = data[0][0]
answer = data[0][1]

4. 生成试卷

可以使用Python中的字符串拼接创建试卷模板，然后在其中嵌入试题和答案。

# create exam template
exam_template = f"""
---Exam---
Question: {question}

Answer: _______
"""

# insert answer into exam template
exam = exam_template.replace("_______", answer)

5. 示例说明

示例1：获取试题并生成试卷

import pymysql

# connect to database
conn = pymysql.connect(
    host='localhost',
    user='root',
    password='password',
    database='test',
    charset='utf8mb4')

# create cursor
cursor = conn.cursor()

# get question and answer from database
cursor.execute("SELECT question, answer FROM questions WHERE id=1")
data = cursor.fetchall()

# extract question and answer from data
question = data[0][0]
answer = data[0][1]

# create exam template
exam_template = f"""
---Exam---
Question: {question}

Answer: _______
"""

# insert answer into exam template
exam = exam_template.replace("_______", answer)

# print exam
print(exam)

输出结果：

---Exam---
Question: What's the name of Python's built-in statement used to define a named block of code that can be invoked later as a function?

Answer: def

示例2：获取多个试题并生成试卷

import pymysql

# connect to database
conn = pymysql.connect(
    host='localhost',
    user='root',
    password='password',
    database='test',
    charset='utf8mb4')

# create cursor
cursor = conn.cursor()

# get questions and answers from database
cursor.execute("SELECT question, answer FROM questions")
data = cursor.fetchall()

# create exam template
exam_template = "---Exam---\n"

# insert questions and answers into exam template
for i, (q, a) in enumerate(data):
    exam_template += f"\nQuestion {i+1}: {q}\nAnswer: _______"

# insert answers into exam template
exam = exam_template.replace("_______", "{}")

# print exam
print(exam.format(*[a for q, a in data]))

输出结果：

---Exam---

Question 1: What's the name of Python's built-in statement used to define a named block of code that can be invoked later as a function?
Answer: _______

Question 2: In Python, what is a module?
Answer: _______

Question 3: What is the difference between a list and a tuple in Python?
Answer: _______

Question 4: What are the different ways to create a dictionary in Python?
Answer: _______

Answer: def
Answer: A module is a file containing Python definitions and statements.
Answer: Lists are mutable while tuples are immutable.
Answer: Dictionary can be created using the dictionary literals, the dict() constructor, or by passing a list of key-value pairs to the dict() constructor.