create database exam;use exam;SET NAMES utf8mb4;SET FOREIGN_KEY_CHECKS = 0;DROP TABLE IF EXISTS question;CREATE TABLE question COURSE varchar100 CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAU

问题类：

class Exam: def init(self, db): self.db = db

# 获取所有问题
def get_questions(self):
    cursor = self.db.cursor()
    cursor.execute("SELECT * FROM question")
    questions = cursor.fetchall()
    cursor.close()
    return questions

# 添加问题
def add_question(self, course, qname, ans1, ans2, ans3, ans4, answer):
    cursor = self.db.cursor()
    cursor.execute("INSERT INTO question (COURSE, QNAME, ANS1, ANS2, ANS3, ANS4, ANSWER) VALUES (%s, %s, %s, %s, %s, %s, %s)", (course, qname, ans1, ans2, ans3, ans4, answer))
    self.db.commit()
    cursor.close()

# 查询问题
def search_question(self, qno):
    cursor = self.db.cursor()
    cursor.execute("SELECT * FROM question WHERE QNO = %s", (qno,))
    question = cursor.fetchone()
    cursor.close()
    return question

# 修改问题
def update_question(self, qno, course, qname, ans1, ans2, ans3, ans4, answer):
    cursor = self.db.cursor()
    cursor.execute("UPDATE question SET COURSE = %s, QNAME = %s, ANS1 = %s, ANS2 = %s, ANS3 = %s, ANS4 = %s, ANSWER = %s WHERE QNO = %s", (course, qname, ans1, ans2, ans3, ans4, answer, qno))
    self.db.commit()
    cursor.close()

# 删除问题
def delete_question(self, qno):
    cursor = self.db.cursor()
    cursor.execute("DELETE FROM question WHERE QNO = %s", (qno,))
    self.db.commit()
    cursor.close()

# 查询成绩
def search_score(self, sno):
    cursor = self.db.cursor()
    cursor.execute("SELECT * FROM result WHERE SNO = %s", (sno,))
    score = cursor.fetchone()
    cursor.close()
    return score

# 添加成绩
def add_score(self, sno, sname, course, score, date):
    cursor = self.db.cursor()
    cursor.execute("INSERT INTO result (SNO, SNAME, COURSE, SCORE, DATE) VALUES (%s, %s, %s, %s, %s)", (sno, sname, course, score, date))
    self.db.commit()
    cursor.close(