一站式网上办事大厅

CREATE DATABASE school_service;

USE school_service;

CREATE TABLE user_info (

id INT AUTO_INCREMENT PRIMARY KEY,

username VARCHAR(50) NOT NULL UNIQUE,

password VARCHAR(100) NOT NULL,

role ENUM('student', 'teacher') NOT NULL

);

CREATE TABLE application (

id INT AUTO_INCREMENT PRIMARY KEY,

user_id INT NOT NULL,

type ENUM('leave', 'course_change') NOT NULL,

description TEXT,

status ENUM('pending', 'approved', 'rejected') DEFAULT 'pending',

created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,

FOREIGN KEY (user_id) REFERENCES user_info(id)

);

CREATE TABLE approval_record (

id INT AUTO_INCREMENT PRIMARY KEY,

application_id INT NOT NULL,

approver_id INT NOT NULL,

remarks TEXT,

approved_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,

FOREIGN KEY (application_id) REFERENCES application(id),

单点登录

FOREIGN KEY (approver_id) REFERENCES user_info(id)

);

]]>

from flask import Flask, request, jsonify

from flask_mysqldb import MySQL

app = Flask(__name__)

app.config['MYSQL_HOST'] = 'localhost'

app.config['MYSQL_USER'] = 'root'

app.config['MYSQL_PASSWORD'] = ''

app.config['MYSQL_DB'] = 'school_service'

mysql = MySQL(app)

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

def apply():

data = request.get_json()

cur = mysql.connection.cursor()

cur.execute("INSERT INTO application (user_id, type, description) VALUES (%s, %s, %s)",

(data['user_id'], data['type'], data['description']))

mysql.connection.commit()

return jsonify({"status": "success", "message": "Application submitted."})

if __name__ == '__main__':

app.run(debug=True)

]]>