数字化校园与工程学院的技术融合

from flask import Flask, request, jsonify

app = Flask(__name__)

# 模拟实验设备数据

equipment_list = [

{"id": 1, "name": "示波器", "status": "空闲"},

{"id": 2, "name": "万用表", "status": "占用"}

]

@app.route('/api/equipment', methods=['GET'])

def get_equipment():

return jsonify(equipment_list)

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

def book_equipment():

data = request.get_json()

for item in equipment_list:

if item['id'] == data['id']:

item['status'] = '占用'

return jsonify({"message": "设备已成功预约！"})

高校一站式办事大厅

return jsonify({"message": "设备ID不存在！"})

if __name__ == '__main__':

app.run(debug=True)

]]>

import mysql.connector

db = mysql.connector.connect(

host="localhost",

user="root",

password="password",

database="engineering"

)

cursor = db.cursor()

# 创建表

cursor.execute("CREATE TABLE IF NOT EXISTS equipment (id INT PRIMARY KEY, name VARCHAR(50), status VARCHAR(20))")

# 插入数据

cursor.execute("INSERT INTO equipment VALUES (1, '示波器', '空闲')")

cursor.execute("INSERT INTO equipment VALUES (2, '万用表', '占用')")

db.commit()

]]>