-- 创建学生表

CREATE TABLE students (

id INT PRIMARY KEY,

name VARCHAR(50),

grade INT

);

-- 创建课程表

CREATE TABLE courses (

id INT PRIMARY KEY,

course_name VARCHAR(50),

teacher_id INT

);

-- 创建选课记录表

CREATE TABLE selections (

student_id INT,

course_id INT,

FOREIGN KEY (student_id) REFERENCES students(id),

FOREIGN KEY (course_id) REFERENCES courses(id)

);

]]>

from flask import Flask, request, jsonify

app = Flask(__name__)

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

def select_course():

data = request.get_json()

student_id = data['student_id']

course_id = data['course_id']

# 插入选课记录

insert_sql = "INSERT INTO selections (student_id, course_id) VALUES (%s, %s)"

cursor.execute(insert_sql, (student_id, course_id))

db.commit()

return jsonify({"status": "success"})

if __name__ == '__main__':

app.run(debug=True)

]]>

SELECT c.course_name, s.day, s.time_slot

FROM courses c

JOIN selections sel ON c.id = sel.course_id

JOIN teachers t ON c.teacher_id = t.id

WHERE t.id = [教师ID];

]]>