-- 创建用户表
CREATE TABLE User (
user_id INT PRIMARY KEY AUTO_INCREMENT,
username VARCHAR(50) NOT NULL,
password VARCHAR(50) NOT NULL,
role_type ENUM('student', 'teacher', 'admin') NOT NULL
);
-- 创建课程表
CREATE TABLE Course (
course_id INT PRIMARY KEY AUTO_INCREMENT,
course_name VARCHAR(100) NOT NULL,
teacher_id INT,
FOREIGN KEY (teacher_id) REFERENCES User(user_id)
);
-- 创建设备表
CREATE TABLE Equipment (
equipment_id INT PRIMARY KEY AUTO_INCREMENT,
equipment_name VARCHAR(100) NOT NULL,
location VARCHAR(200),
status ENUM('available', 'unavailable') DEFAULT 'available'
);
]]>
from flask import Flask, jsonify
app = Flask(__name__)
@app.route('/api/courses', methods=['GET'])
def get_courses():
# 假设我们有一个函数从数据库获取课程数据
courses = get_all_courses_from_db()
return jsonify(courses)
if __name__ == '__main__':
app.run(debug=True)
]]>
