研究生管理信息系统的排行功能实现

import mysql.connector

# 连接数据库

db = mysql.connector.connect(

host="localhost",

user="yourusername",

password="yourpassword",

database="yourdatabase"

)

cursor = db.cursor()

# 查询并排序

def get_rank_by(field):

query = f"SELECT name, {field} FROM students ORDER BY {field} DESC"

cursor.execute(query)

results = cursor.fetchall()

return results

# 调用函数

print(get_rank_by('grade'))

print(get_rank_by('research_results'))

print(get_rank_by('teacher_evaluation'))