基于高校科研管理系统的校内项目开发与实践——以湖北某高校为例

CREATE TABLE users (

id INT AUTO_INCREMENT PRIMARY KEY,

username VARCHAR(50) NOT NULL,

password VARCHAR(255) NOT NULL,

role ENUM('admin', 'teacher') DEFAULT 'teacher'

);

CREATE TABLE projects (

id INT AUTO_INCREMENT PRIMARY KEY,

title VARCHAR(255) NOT NULL,

实习生管理系统

description TEXT,

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

user_id INT,

FOREIGN KEY (user_id) REFERENCES users(id)

);

]]>

from flask import Flask, request, jsonify

app = Flask(__name__)

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

def submit_project():

data = request.get_json()

# Insert into database logic here

return jsonify({"message": "Project submitted successfully"}), 201

if __name__ == '__main__':

app.run(debug=True)

]]>