基于校友管理系统的校园注册功能设计与实现

# Flask API for registration

from flask import Flask, request, jsonify

import mysql.connector

app = Flask(__name__)

数据可视化平台

@app.route('/register', methods=['POST'])

def register():

data = request.get_json()

username = data['username']

password = data['password']

email = data['email']

# Database connection

conn = mysql.connector.connect(

host="localhost",

user="root",

password="password",

database="alumni"

)

cursor = conn.cursor()

# Check if email already exists

cursor.execute("SELECT * FROM users WHERE email=%s", (email,))

if cursor.fetchone():

return jsonify({"message": "Email already registered"}), 400

# Insert new user

cursor.execute("INSERT INTO users (username, password, email) VALUES (%s, %s, %s)",

(username, password, email))

conn.commit()

cursor.close()

conn.close()

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

if __name__ == '__main__':

app.run(debug=True)

]]>