import flask
from flask import Flask, request, jsonify
import mysql.connector
app = Flask(__name__)
db = mysql.connector.connect(
host="localhost",
user="root",
password="123456",
database="student_db"
)
@app.route('/students', methods=['GET'])
def get_students():
cursor = db.cursor()
cursor.execute("SELECT * FROM students")
result = cursor.fetchall()
return jsonify(result)
if __name__ == '__main__':
app.run(debug=True)
本站部分内容及素材来源于互联网,由AI智能生成,如有侵权或言论不当,联系必删!