一站式网上办事大厅

import sqlite3

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

cursor = conn.cursor()

# 创建学生表

cursor.execute('''

CREATE TABLE IF NOT EXISTS students (

id INTEGER PRIMARY KEY AUTOINCREMENT,

name TEXT NOT NULL,

email TEXT UNIQUE NOT NULL

)

''')

# 创建教师表

cursor.execute('''

CREATE TABLE IF NOT EXISTS teachers (

id INTEGER PRIMARY KEY AUTOINCREMENT,

name TEXT NOT NULL,

department TEXT NOT NULL

)

''')

# 创建请假申请表

单点登录跨域解决方案

cursor.execute('''

CREATE TABLE IF NOT EXISTS leave_requests (

id INTEGER PRIMARY KEY AUTOINCREMENT,

student_id INTEGER,

teacher_id INTEGER,

reason TEXT NOT NULL,

status TEXT DEFAULT 'pending',

FOREIGN KEY(student_id) REFERENCES students(id),

FOREIGN KEY(teacher_id) REFERENCES teachers(id)

)

''')

conn.commit()

conn.close()

]]>

from flask import Flask, request, jsonify

import jwt

from datetime import datetime, timedelta

app = Flask(__name__)

SECRET_KEY = 'your_secret_key'

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

def login():

auth = request.authorization

if auth and auth.username == 'admin' and auth.password == 'password':

token = jwt.encode({

'user': auth.username,

'exp': datetime.utcnow() + timedelta(minutes=30)

}, SECRET_KEY, algorithm='HS256')

return jsonify({'token': token})

return jsonify({'message': 'Invalid credentials'}), 401

if __name__ == '__main__':

app.run(debug=True)

]]>