账号管理服务如何创建

CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(50) NOT NULL UNIQUE,
    password_hash VARCHAR(255) NOT NULL,
    email VARCHAR(100),
    phone VARCHAR(15),
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

from flask import Flask, request, jsonify
from werkzeug.security import generate_password_hash

app = Flask(__name__)

@app.route('/register', methods=['POST'])
def register():
    data = request.get_json()
    username = data.get('username')
    password = data.get('password')
    email = data.get('email')

    if not username or not password:
        return jsonify({"error": "Username and password are required"}), 400

    password_hash = generate_password_hash(password, method='sha256')

    # 这里应调用数据库操作函数保存用户信息
    save_user_to_db(username, password_hash, email)

    return jsonify({"message": "User registered successfully"}), 201

def save_user_to_db(username, password_hash, email):
    # 实现数据库插入操作
    pass

if __name__ == '__main__':
    app.run(debug=True)

from flask import Flask, request, jsonify
from werkzeug.security import check_password_hash

app = Flask(__name__)

@app.route('/login', methods=['POST'])
def login():
    data = request.get_json()
    username = data.get('username')
    password = data.get('password')

    user = get_user_from_db(username)

    if user and check_password_hash(user['password_hash'], password):
        return jsonify({"message": "Login successful"}), 200
    else:
        return jsonify({"error": "Invalid username or password"}), 401

def get_user_from_db(username):
    # 实现数据库查询操作
    pass

if __name__ == '__main__':
    app.run(debug=True)