from flask import Flask, request, jsonify
from flask_cors import CORS
import pymysql
app = Flask(__name__)
CORS(app)
# 填写相应的数据库信息,,,
ConSql = pymysql.connect(host='数据库地址',
user='账号',
password='密码',
db='数据库名称',
charset='utf8mb4',
cursorclass=pymysql.cursors.DictCursor)
@app.route('/login', methods=['POST'])
def login():
username = request.json['username']
password = request.json['password']
with ConSql.cursor() as cursor:
sql = "SELECT * FROM login WHERE username = %s AND password = %s"
cursor.execute(sql, (username, password))
result = cursor.fetchone()
if result:
return jsonify({'status': 'success',
12-30
03-30
10-03
281
09-27
1050