CREATE TABLE users (
id INT AUTO_INCREMENT PRIMARY KEY,
username VARCHAR(255) NOT NULL UNIQUE,
password VARCHAR(255) NOT NULL,
email VARCHAR(255)
);
]]>
from flask import Flask, request, jsonify
from werkzeug.security import generate_password_hash, check_password_hash
app = Flask(__name__)
@app.route('/login', methods=['POST'])
def login():
data = request.get_json()
username = data['username']
password = data['password']
# 假设这里查询数据库找到用户
user = get_user_by_username(username)
if user and check_password_hash(user['password'], password):
return jsonify({"status": "success", "message": "Login successful!"})
else:
return jsonify({"status": "failure", "message": "Invalid credentials"})
def get_user_by_username(username):
# 这里应该是一个数据库查询，返回用户信息
return {"id": 1, "username": "alice", "password": generate_password_hash("password123")}
if __name__ == '__main__':
app.run(debug=True)
]]>