为教育编写评分手册

import sqlite3

# 创建数据库和表
conn = sqlite3.connect('grading_system.db')
c = conn.cursor()
c.execute('''CREATE TABLE IF NOT EXISTS students (
                id INTEGER PRIMARY KEY,
                name TEXT NOT NULL,
                course TEXT NOT NULL,
                score REAL NOT NULL,
                comment TEXT
            )''')
conn.commit()

# 添加学生信息
def add_student(name, course, score, comment):
    c.execute("INSERT INTO students (name, course, score, comment) VALUES (?, ?, ?, ?)", (name, course, score, comment))
    conn.commit()

# 查询学生信息
def get_student(student_id):
    c.execute("SELECT * FROM students WHERE id = ?", (student_id,))
    return c.fetchone()

# 更新学生信息
def update_student(student_id, score, comment):
    c.execute("UPDATE students SET score = ?, comment = ? WHERE id = ?", (score, comment, student_id))
    conn.commit()

# 删除学生信息
def delete_student(student_id):
    c.execute("DELETE FROM students WHERE id = ?", (student_id,))
    conn.commit()

# 示例操作
add_student('Alice', 'Math', 95.0, 'Excellent work!')
print(get_student(1))
update_student(1, 96.0, 'Keep it up!')
print(get_student(1))
delete_student(1)

conn.close()