Skip to content
The Chat Archive
gpt-4-0314· OpenAI WildChat-4.8M (AI2)

try: 这里总分通过求和得到结果 sql = "INSERT INTO student(ID,NAME,数学成绩,Python成绩,英语成绩,成绩毛概,总分)" sql +=…

  1. User

    try: # 这里总分通过求和得到结果 sql = "INSERT INTO student(ID,NAME,数学成绩,Python成绩,英语成绩,成绩毛概,总分)" sql += "VALUES(%d,'%s',%.2f,%.2f,%.2f,%.2f,%.2f)" % ( student_id, student_name, math_grade, python_grade, modian_grade, shudian_grade, math_grade + python_grade + modian_grade + shudian_grade) cur.execute(sql) db.commit() messagebox.showinfo(message="录入信息成功!") except: messagebox.showerror(message="录入信息失败!请检查是否有ID重复") 如何解决或优化

  2. Assistant

    您可以在插入数据之前检查数据库中是否已经存在具有相同ID的学生。为此,您可以执行以下查询来检查是否已经存在具有相同ID的学生:

    def check_student_exists(student_id):
        cur.execute("SELECT COUNT(*) FROM student WHERE ID=%d" % student_id)
        if cur.fetchone()[0] > 0:
            return True
        return False
    

    现在,使用此函数检查学生是否存在,如果已经存在,则显示错误消息,否则插入数据:

    if check_student_exists(student_id):
        messagebox.showerror(message="学生ID已存在,请检查输入")
    else:
        try:
            sql = "INSERT INTO student(ID,NAME,数学成绩,Python成绩,英语成绩,成绩毛概,总分)"
            sql += "VALUES(%d,'%s',%.2f,%.2f,%.2f,%.2f,%.2f)" % (
                student_id, student_name, math_grade, python_grade, modian_grade,
                shudian_grade, math_grade + python_grade + modian_grade + shudian_grade)
            cur.execute(sql)
            db.commit()
            messagebox.showinfo(message="录入信息成功!")
        except Exception as e:
            db.rollback()
            messagebox.showerror(message="录入信息失败! 错误原因: " + str(e))
    

    这将确保您在执行插入操作之前检查了学生ID的唯一性,从而减少了出现错误的可能性。

  3. User

    db, cur = Sql_link() student_id = int (entrystudent_id.get()) # 查找ID对应的学生 sql = "SELECT * FROM student WHERE ID = %d" % (student_id) num = cur.execute(sql) if (num > 0): cursor = cur.fetchall() def search_student_info(student_id): for row in cursor: if student_id == row[0]: return row[1], row[2], row[3], row[4], row[5] student_info = search_student_info(student_id) if student_info: student_name.set(student_info[0]) math_grade.set(student_info[1]) python_grade.set(student_info[2]) modian_grade.set(student_info[3]) shudian_grade.set(student_info[4]) 如何解决和优化

  4. Assistant

    这段代码看起来可以正确执行根据学生ID查找对应学生信息。如果您需要对其进行优化,我建议将搜索学生信息的过程封装为一个单独的函数。以下是一种更简洁的方法,在其中也添加了注释以帮助理解:

    def search_student_info(student_id):
        sql = "SELECT * FROM student WHERE ID = %d" % (student_id)
        num = cur.execute(sql)
        if num > 0:
            cursor = cur.fetchone()
            return cursor[1], cursor[2], cursor[3], cursor[4], cursor[5]
        return None
    
    db, cur = Sql_link()
    student_id = int(entrystudent_id.get())
    
    # 调用函数并更新存在的学生信息
    student_info = search_student_info(student_id)
    if student_info:
        student_name.set(student_info[0])
        math_grade.set(student_info[1])
        python_grade.set(student_info[2])
        modian_grade.set(student_info[3])
        shudian_grade.set(student_info[4])
    else:
        messagebox.showerror(message="没有找到对应的学生信息,请检查输入")
    

    在这个优化版本里,我们把查找学生信息的过程封装在 search_student_info 函数中。这使得代码结构更简洁和易于理解。另外,这段代码还增加了对查找结果的判断,如果没有找到对应学生,将弹出一个错误提示框。