今天我们来做一个后端查询账号信息的例子[Python] 纯文本查看 复制代码 import flask
import pymysql
app = flask.Flask(__name__)
@app.route('/cx',methods=['post'])
我们这里前端用post form格式传数据给后端
[Python] 纯文本查看 复制代码 def cx():
token = flask.request.form.get('token')
db = pymysql.connect(host="127.0.0.1", port=3306, user="账号", password="密码", db="...",
charset="utf8")
cursor = db.cursor()
cursor.execute("SELECT * FROM user")
result = cursor.fetchall()
for k in result:
if token in k:
cursor.execute(f"SELECT * FROM user where token = '{token}'")
result = cursor.fetchall()
for b in result:
h=b[1]
ren = {'msg': f"用户：{token},余额：{h}", 'msg_code': 200}
return json.dumps(ren, ensure_ascii=False)
else:
continue
cursor.close()
db.close()
[Python] 纯文本查看 复制代码 if __name__ == '__main__':
app.run(port=开放的端口,debug=True,host='0.0.0.0',threaded=True)
| 
发表于 2022-11-15 16:34
