一站式网上办事大厅

-- 创建数据库

CREATE DATABASE IF NOT EXISTS office_system;

USE office_system;

-- 创建用户表

CREATE TABLE users (

id INT AUTO_INCREMENT PRIMARY KEY,

username VARCHAR(50) NOT NULL UNIQUE,

password VARCHAR(255) NOT NULL,

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

);

-- 创建收文表

CREATE TABLE incoming_documents (

id INT AUTO_INCREMENT PRIMARY KEY,

title VARCHAR(255) NOT NULL,

content TEXT NOT NULL,

sender_id INT NOT NULL,

receiver_id INT NOT NULL,

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

FOREIGN KEY (sender_id) REFERENCES users(id),

FOREIGN KEY (receiver_id) REFERENCES users(id)

);

from flask import Flask, request, jsonify

import os

app = Flask(__name__)

UPLOAD_FOLDER = './uploads'

app.config['UPLOAD_FOLDER'] = UPLOAD_FOLDER

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

def upload_file():

if 'file' not in request.files:

return jsonify({"error": "No file part"}), 400

file = request.files['file']

if file.filename == '':

return jsonify({"error": "No selected file"}), 400

file.save(os.path.join(app.config['UPLOAD_FOLDER'], file.filename))

return jsonify({"message": "File uploaded successfully", "filename": file.filename}), 200