-- 创建学生表
CREATE TABLE students (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(50) NOT NULL,
university VARCHAR(100),
email VARCHAR(100)
);
-- 创建实习单位表
CREATE TABLE companies (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(100) NOT NULL,
address VARCHAR(200),
contact_email VARCHAR(100)
);
-- 创建实习记录表
CREATE TABLE internships (
id INT AUTO_INCREMENT PRIMARY KEY,
student_id INT,
company_id INT,
start_date DATE,
end_date DATE,
feedback TEXT,
FOREIGN KEY (student_id) REFERENCES students(id),
FOREIGN KEY (company_id) REFERENCES companies(id)
);
]]>
from flask import Flask, request, jsonify
app = Flask(__name__)
@app.route('/add_student', methods=['POST'])
def add_student():
data = request.get_json()
# Insert into database logic here...
return jsonify({"status": "success", "message": "Student added successfully."})
if __name__ == '__main__':
app.run(debug=True)
]]>