CREATE TABLE User (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(50) NOT NULL,
phone VARCHAR(15) UNIQUE NOT NULL,
password VARCHAR(100) NOT NULL,
major VARCHAR(50)
);
]]>
from flask import Flask, request, jsonify
app = Flask(__name__)
@app.route('/register', methods=['POST'])
def register():
data = request.get_json()
name = data['name']
phone = data['phone']
password = data['password']
major = data['major']
# 验证手机号是否已存在
if User.query.filter_by(phone=phone).first():
return jsonify({"message": "Phone number already exists"}), 409
new_user = User(name=name, phone=phone, password=password, major=major)
db.session.add(new_user)
db.session.commit()
return jsonify({"message": "User registered successfully"}), 201
]]>