构建校友录管理系统与知识库的技术实践

CREATE TABLE users (

user_id INT PRIMARY KEY AUTO_INCREMENT,

username VARCHAR(50) NOT NULL UNIQUE,

password_hash VARCHAR(255) NOT NULL,

email VARCHAR(100) UNIQUE

);

CREATE TABLE alumni (

alumni_id INT PRIMARY KEY AUTO_INCREMENT,

name VARCHAR(100),

graduation_year YEAR,

department VARCHAR(100),

user_id INT,

FOREIGN KEY (user_id) REFERENCES users(user_id)

);

]]>

CREATE TABLE knowledge_base (

article_id INT PRIMARY KEY AUTO_INCREMENT,

title VARCHAR(255) NOT NULL,

content TEXT NOT NULL,

author_id INT,

created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,

FOREIGN KEY (author_id) REFERENCES users(user_id)

);

]]>

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 = query_user(username)

if user and check_password_hash(user['password_hash'], password):

return jsonify({'message': 'Login successful!'})

else:

return jsonify({'message': 'Invalid credentials'}), 401

]]>