try: 这里总分通过求和得到结果 sql = "INSERT INTO student(ID,NAME,数学成绩,Python成绩,英语成绩,成绩毛概,总分)" sql +=…
- 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重复") 如何解决或优化
- 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的唯一性,从而减少了出现错误的可能性。
- 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]) 如何解决和优化
- 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函数中。这使得代码结构更简洁和易于理解。另外,这段代码还增加了对查找结果的判断,如果没有找到对应学生,将弹出一个错误提示框。