学生信息管理系统

# 学生信息管理模块（Python示例）

class Student:

def __init__(self, student_id, name, major, grade):

self.student_id = student_id

self.name = name

self.major = major

self.grade = grade

def display_info(self):

print(f"学号: {self.student_id}, 姓名: {self.name}, 专业: {self.major}, 年级: {self.grade}")

students = []

def add_student(student):

students.append(student)

def find_student(student_id):

for s in students:

if s.student_id == student_id:

return s

return None

def update_student(student_id, new_name=None, new_major=None, new_grade=None):

student = find_student(student_id)

if student:

if new_name:

student.name = new_name

if new_major:

student.major = new_major

if new_grade:

student.grade = new_grade

return True

return False

def delete_student(student_id):

global students

students = [s for s in students if s.student_id != student_id]

# 示例

s1 = Student("2023001", "张三", "计算机科学", "大二")

add_student(s1)

s1.display_info()

s2 = Student("2023002", "李四", "软件工程", "大一")

add_student(s2)

s2.display_info()

update_student("2023001", new_name="张三丰")

find_student("2023001").display_info()

delete_student("2023002")

print("删除后学生列表:")

for s in students:

s.display_info()

import sqlite3

# 创建数据库连接

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

cursor = conn.cursor()

# 创建课程表

cursor.execute('''

CREATE TABLE IF NOT EXISTS courses (

course_id TEXT PRIMARY KEY,

course_name TEXT,

teacher TEXT,

time TEXT,

room TEXT

)

''')

# 添加课程

def add_course(course_id, course_name, teacher, time, room):

cursor.execute('INSERT INTO courses VALUES (?, ?, ?, ?, ?)',

(course_id, course_name, teacher, time, room))

conn.commit()

# 查询课程

def get_course(course_id):

cursor.execute('SELECT * FROM courses WHERE course_id = ?', (course_id,))

return cursor.fetchone()

# 更新课程

def update_course(course_id, new_teacher=None, new_time=None, new_room=None):

query = 'UPDATE courses SET'

params = []

if new_teacher:

query += ' teacher = ?,'

params.append(new_teacher)

if new_time:

query += ' time = ?,'

params.append(new_time)

if new_room:

query += ' room = ?,'

params.append(new_room)

query = query.rstrip(',') + ' WHERE course_id = ?'

params.append(course_id)

cursor.execute(query, params)

conn.commit()

# 删除课程

def delete_course(course_id):

cursor.execute('DELETE FROM courses WHERE course_id = ?', (course_id,))

conn.commit()

# 示例

add_course("C001", "操作系统", "王老师", "周一上午", "教学楼A101")

add_course("C002", "数据结构", "李老师", "周三下午", "教学楼B202")

print("课程列表:")

cursor.execute('SELECT * FROM courses')

for row in cursor.fetchall():

print(row)

# 更新课程

update_course("C001", new_teacher="赵老师", new_room="教学楼B301")

# 查询更新后的课程

print("更新后的课程信息:")

print(get_course("C001"))

# 删除课程

delete_course("C002")

# 关闭连接

conn.close()

import sqlite3

# 创建数据库连接

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

cursor = conn.cursor()

# 创建成绩表

cursor.execute('''

CREATE TABLE IF NOT EXISTS grades (

student_id TEXT,

course_id TEXT,

score INTEGER,

PRIMARY KEY (student_id, course_id)

)

''')

# 录入成绩

def add_grade(student_id, course_id, score):

cursor.execute('INSERT INTO grades VALUES (?, ?, ?)', (student_id, course_id, score))

conn.commit()

# 查询成绩

def get_grade(student_id, course_id):

cursor.execute('SELECT score FROM grades WHERE student_id = ? AND course_id = ?', (student_id, course_id))

result = cursor.fetchone()

return result[0] if result else None

# 计算平均分

def calculate_average(student_id):

cursor.execute('SELECT AVG(score) FROM grades WHERE student_id = ?', (student_id,))

result = cursor.fetchone()

return result[0] if result else 0

# 示例

add_grade("2023001", "C001", 85)

add_grade("2023001", "C002", 90)

add_grade("2023002", "C001", 75)

print("张三的成绩:")

print(get_grade("2023001", "C001"))

print(get_grade("2023001", "C002"))

print("张三的平均分:")

print(calculate_average("2023001"))

# 关闭连接

conn.close()

# RBAC权限控制模块（Python示例）

class Role:

def __init__(self, role_name, permissions):

self.role_name = role_name

self.permissions = permissions

class User:

def __init__(self, user_id, username, role):

self.user_id = user_id

self.username = username

self.role = role

def has_permission(user, permission):

return permission in user.role.permissions

# 定义角色和权限

admin_role = Role("管理员", ["创建用户", "删除用户", "修改权限", "查看所有数据"])

teacher_role = Role("教师", ["发布课程", "录入成绩", "查看学生信息"])

student_role = Role("学生", ["查看成绩", "提交作业", "查看课程表"])

# 创建用户

user1 = User("U001", "管理员", admin_role)

user2 = User("U002", "李老师", teacher_role)

user3 = User("U003", "张三", student_role)

# 检查权限

print("管理员是否有创建用户权限？", has_permission(user1, "创建用户"))

print("李老师是否有录入成绩权限？", has_permission(user2, "录入成绩"))

print("张三是否有查看成绩权限？", has_permission(user3, "查看成绩"))