基于Python实现的研究生管理系统与排行榜功能

import sqlite3

conn = sqlite3.connect('student.db')

cursor = conn.cursor()

cursor.execute('''

CREATE TABLE IF NOT EXISTS students (

id INTEGER PRIMARY KEY,

name TEXT NOT NULL,

score REAL

)

''')

conn.commit()

conn.close()

]]>

def add_student(student_id, name, score):

conn = sqlite3.connect('student.db')

cursor = conn.cursor()

cursor.execute('INSERT INTO students (id, name, score) VALUES (?, ?, ?)',

(student_id, name, score))

conn.commit()

conn.close()

# 示例数据插入

add_student(1, 'Alice', 95.5)

add_student(2, 'Bob', 87.0)

add_student(3, 'Charlie', 92.3)

]]>

def generate_ranking():

conn = sqlite3.connect('student.db')

cursor = conn.cursor()

cursor.execute('SELECT * FROM students ORDER BY score DESC')

rankings = cursor.fetchall()

conn.close()

return rankings

# 打印排行榜

rankings = generate_ranking()

for idx, (student_id, name, score) in enumerate(rankings, start=1):

print(f'{idx}. {name} ({score})')

]]>

from tkinter import *

root = Tk()

root.title("研究生管理系统")

def show_ranking():

rankings = generate_ranking()

result.delete(1.0, END)

for idx, (student_id, name, score) in enumerate(rankings, start=1):

一站式网上服务大厅

result.insert(END, f'{idx}. {name} ({score})\n')

Button(root, text="查看排行榜", command=show_ranking).pack()

result = Text(root, height=10, width=50)

result.pack()

root.mainloop()

]]>