实现效果:写一个接口,从mysql数据库读到user表的数据(用户名和密码),把数据作为回参
用到的库:flask,pymysql
代码:
from flask import Flask, jsonify
import pymysql# 连接数据库
connection = pymysql.connect(host='localhost',user='root',password='123456qq',database='test1',charset='utf8mb4',cursorclass=pymysql.cursors.DictCursor)
# 创建服务
app = Flask(__name__)
@app.route('/data')
def get_data():try:with connection.cursor() as cursor:# 写入SQL查询语句sql = "select * from user"cursor.execute(sql)result = cursor.fetchall()return jsonify(result)finally:connection.close()if __name__ == '__main__':app.run(host='0.0.0.0', port=8880, threaded=True)
代码效果