import mysql.connector
mydb = mysql.connector.connect(
host="localhost",
user="root",
password="password"
)
mycursor = mydb.cursor()
mycursor.execute("CREATE DATABASE IF NOT EXISTS freshmen_db")
接下来，我们将创建表用于存储学生信息。
mycursor.execute("USE freshmen_db")
mycursor.execute("""
CREATE TABLE IF NOT EXISTS students (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(255),
student_id VARCHAR(20),
phone VARCHAR(15)
)""")
from flask import Flask, request, jsonify
app = Flask(__name__)
@app.route('/login', methods=['POST'])
def login():
data = request.get_json()
username = data['username']
password = data['password']
# 假设我们已经连接到数据库
cursor.execute("SELECT * FROM users WHERE username=%s AND password=%s", (username, password))
result = cursor.fetchone()
if result:
return jsonify({"status": "success"})
else:
return jsonify({"status": "failure"})