如何使用flask rest API向Mysql数据库添加用户时获取JSON结果

pip install flask
pip install flask-mysql

from flask import Flask, request, jsonify
from flask_mysql import MySQL

app = Flask(__name__)
app.config['MYSQL_HOST'] = 'your_mysql_host'
app.config['MYSQL_USER'] = 'your_mysql_username'
app.config['MYSQL_PASSWORD'] = 'your_mysql_password'
app.config['MYSQL_DB'] = 'your_mysql_database'
mysql = MySQL(app)

@app.route('/users', methods=['POST'])
def add_user():
    # 获取请求中的JSON数据
    user = request.get_json()
    name = user['name']
    email = user['email']

    # 连接到MySQL数据库
    conn = mysql.connect()
    cursor = conn.cursor()

    # 执行插入操作
    cursor.execute("INSERT INTO users (name, email) VALUES (%s, %s)", (name, email))
    conn.commit()

    # 关闭数据库连接
    cursor.close()
    conn.close()

    # 返回JSON响应
    return jsonify({'message': 'User added successfully'})

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