构建免费的校友录管理系统

CREATE DATABASE alumni_system;

USE alumni_system;

CREATE TABLE users (

id INT AUTO_INCREMENT PRIMARY KEY,

username VARCHAR(50) NOT NULL UNIQUE,

password VARCHAR(255) NOT NULL,

email VARCHAR(100) NOT NULL UNIQUE,

created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP

);

CREATE TABLE alumni (

id INT AUTO_INCREMENT PRIMARY KEY,

user_id INT NOT NULL,

name VARCHAR(100) NOT NULL,

graduation_year YEAR,

position VARCHAR(100),

company VARCHAR(100),

FOREIGN KEY (user_id) REFERENCES users(id)

);

from flask import Flask, request, jsonify

from werkzeug.security import generate_password_hash, check_password_hash

import mysql.connector

app = Flask(__name__)

# 连接数据库

db = mysql.connector.connect(

host="localhost",

user="root",

password="yourpassword",

database="alumni_system"

)

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

def register():

data = request.get_json()

username = data['username']

password = data['password']

email = data['email']

cursor = db.cursor()

hashed_password = generate_password_hash(password)

try:

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

(username, hashed_password, email))

db.commit()

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

except Exception as e:

db.rollback()

return jsonify({"error": str(e)}), 500

if __name__ == '__main__':

app.run(debug=True)