如何用AI写查成绩的代码

# 学生成绩查询系统 - AI生成的示例代码
import sqlite3
import hashlib

class Student:
    def __init__(self, student_id, name):
        self.student_id = student_id
        self.name = name
    
    def get_info(self):
        return f"学号: {self.student_id}, 姓名: {self.name}"

class GradeSystem:
    def __init__(self, db_name="grades.db"):
        self.conn = sqlite3.connect(db_name)
        self.create_tables()
    
    def create_tables(self):
        cursor = self.conn.cursor()
        # 创建学生表
        cursor.execute('''CREATE TABLE IF NOT EXISTS students
                     (id TEXT PRIMARY KEY, name TEXT, password TEXT)''')
        # 创建成绩表
        cursor.execute('''CREATE TABLE IF NOT EXISTS grades
                     (id INTEGER PRIMARY KEY, student_id TEXT, 
                     subject TEXT, score REAL)''')
        self.conn.commit()
    
    def query_grades(self, student_id):
        # 查询指定学生的所有成绩
        cursor = self.conn.cursor()
        cursor.execute("SELECT subject, score FROM grades WHERE student_id=?", (student_id,))
        grades = cursor.fetchall()
        
        if not grades:
            return "未找到该学生的成绩记录"
        
        result = f"学号 {student_id} 的成绩单:\n"
        for subject, score in grades:
            result += f"  {subject}: {score}分\n"
        
        return result

# 使用示例
if __name__ == "__main__":
    system = GradeSystem()
    # 这里可以添加模拟数据并查询
    print("成绩查询系统初始化完成")