网页连接sql数据库源码

pip install flask mysql-connector-python

from flask import Flask, jsonify
import mysql.connector

app = Flask(__name__)

# 数据库连接配置
db_config = {
    'host': 'localhost',
    'user': 'your_username',
    'password': 'your_password',
    'database': 'your_database'
}

@app.route('/data', methods=['GET'])
def get_data():
    try:
        # 连接数据库
        conn = mysql.connector.connect(**db_config)
        cursor = conn.cursor()
        
        # 执行查询
        query = "SELECT * FROM your_table"
        cursor.execute(query)
        
        # 获取结果
        result = cursor.fetchall()
        
        # 关闭连接
        cursor.close()
        conn.close()
        
        return jsonify(result)
    except Exception as e:
        return jsonify({'error': str(e)})

if __name__ == '__main__':
    app.run(debug=True)