学生信息管理系统

class Student:

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

self.name = name

self.student_id = student_id

self.major = major

def display_info(self):

print(f"姓名：{self.name}，学号：{self.student_id}，专业：{self.major}")

import sqlite3

# 连接数据库

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

cursor = conn.cursor()

# 创建表

cursor.execute('''

CREATE TABLE IF NOT EXISTS students (

id INTEGER PRIMARY KEY AUTOINCREMENT,

name TEXT,

student_id TEXT,

major TEXT

)

''')

# 插入数据

new_student = Student("张三", "20240101", "计算机科学")

cursor.execute('INSERT INTO students (name, student_id, major) VALUES (?, ?, ?)',

(new_student.name, new_student.student_id, new_student.major))

# 提交事务

conn.commit()

# 关闭连接

conn.close()

def assign_dorm(student):

if student.major == '计算机科学' and student.gender == '男':

return 'A栋301'

elif student.major == '计算机科学' and student.gender == '女':

return 'B栋202'

else:

return '其他宿舍'

# 假设学生对象有gender属性

student = Student("李四", "20240102", "电子信息")

student.gender = '男'

dorm = assign_dorm(student)

print(f"{student.name} 分配到 {dorm}")

from flask import Flask, request, redirect, url_for

from flask_login import LoginManager, UserMixin, login_user, login_required, logout_user

app = Flask(__name__)

login_manager = LoginManager(app)

# 模拟用户数据

users = {

"admin": {"password": "123456", "role": "admin"},

"teacher": {"password": "654321", "role": "teacher"}

}

class User(UserMixin):

def __init__(self, user_id):

self.id = user_id

@login_manager.user_loader

def load_user(user_id):

return User(user_id)

@app.route('/login', methods=['GET', 'POST'])

def login():

if request.method == 'POST':

username = request.form['username']

password = request.form['password']

if username in users and users[username]['password'] == password:

user = User(username)

login_user(user)

return redirect(url_for('dashboard'))

else:

return '登录失败'

return '''

'''

@app.route('/dashboard')

@login_required

def dashboard():

return '欢迎进入管理界面'

if __name__ == '__main__':

app.run(debug=True)