构建高效招生管理服务平台及其手册

-- 创建学生信息表

CREATE TABLE student (

id INT AUTO_INCREMENT PRIMARY KEY,

name VARCHAR(100) NOT NULL,

phone VARCHAR(15),

email VARCHAR(100)

);

-- 创建课程表

CREATE TABLE course (

id INT AUTO_INCREMENT PRIMARY KEY,

title VARCHAR(200) NOT NULL,

description TEXT

);

-- 创建报名表

CREATE TABLE enrollment (

id INT AUTO_INCREMENT PRIMARY KEY,

student_id INT,

course_id INT,

enrollment_date DATE,

FOREIGN KEY (student_id) REFERENCES student(id),

FOREIGN KEY (course_id) REFERENCES course(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'] = 'recruitment_system'

mysql = MySQL(app)

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

def add_student():

data = request.get_json()

name = data['name']

phone = data['phone']

email = data['email']

cur = mysql.connection.cursor()

cur.execute("INSERT INTO student (name, phone, email) VALUES (%s, %s, %s)", (name, phone, email))

mysql.connection.commit()

cur.close()

return jsonify({"message": "Student added successfully"}), 201

]]>

# 启动服务

export FLASK_APP=app.py

flask run

]]>