-- 創(chuàng)建數(shù)據(jù)庫(kù)

CREATE DATABASE InternshipSystem;

USE InternshipSystem;

-- 學(xué)生表

CREATE TABLE Students (

student_id INT PRIMARY KEY AUTO_INCREMENT,

name VARCHAR(50),

major VARCHAR(50)

);

-- 實(shí)習(xí)崗位表

CREATE TABLE Positions (

position_id INT PRIMARY KEY AUTO_INCREMENT,

title VARCHAR(100),

description TEXT

);

排課系統(tǒng)源碼

-- 分配任務(wù)表

CREATE TABLE Tasks (

task_id INT PRIMARY KEY AUTO_INCREMENT,

position_id INT,

description TEXT,

FOREIGN KEY (position_id) REFERENCES Positions(position_id)

);

from flask import Flask, request, jsonify

app = Flask(__name__)

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

def apply_internship():

data = request.get_json()

# 假設(shè)接收到的數(shù)據(jù)包含student_id和position_id

student_id = data['student_id']

position_id = data['position_id']

# 插入到申請(qǐng)表中

# 省略插入代碼...

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