基于Python的学生管理信息系统与排行榜实现

import sqlite3

# 创建数据库连接

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

cursor = conn.cursor()

# 创建表

cursor.execute('''

CREATE TABLE IF NOT EXISTS students (

id INTEGER PRIMARY KEY AUTOINCREMENT,

student_id TEXT UNIQUE,

name TEXT,

grade TEXT,

class_name TEXT,

score REAL

)

''')

# 插入学生信息

def add_student(student_id, name, grade, class_name, score):

cursor.execute('''

INSERT INTO students (student_id, name, grade, class_name, score)

VALUES (?, ?, ?, ?, ?)

''', (student_id, name, grade, class_name, score))

conn.commit()

# 查询所有学生信息

def get_all_students():

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

return cursor.fetchall()

# 关闭数据库连接

conn.close()

在线排课软件

]]>