app.py
from flask import Flask,request,render_template,Response
import pymysql
from flask import jsonify
app=Flask(__name__)
@app.route('/login',methods=['POST','GET'])
def login():
name=request.form.get('name')
mydb=pymysql.Connect(host='xxxx',port=3306,user='xxxx',
password='xxxx',db='xxxx',charset='utf8')
cursor=mydb.cursor()
sql = "select * from admin"
cursor.execute(sql)
results=cursor.fetchall()
cursor.close()
mydb.close()
results=jsonify(results)
return results
if __name__=='__main__':
app.run(host='127.0.0.1',port=5003,debug=True)
展示