MySQL と Python を使用して簡単なログイン関数を開発する方法

CREATE DATABASE user;

USE user;

CREATE TABLE login (
    id INT AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(50) NOT NULL,
    password VARCHAR(50) NOT NULL
);

pip install mysql-connector-python

import mysql.connector

# 连接到MySQL数据库
db = mysql.connector.connect(
    host="localhost",
    user="root",
    passwd="your_mysql_password",
    database="user"
)

# 注册功能
def register(username, password):
    cursor = db.cursor()

    # 检查用户名是否已存在
    cursor.execute("SELECT * FROM login WHERE username = %s", (username,))
    result = cursor.fetchone()
    if result:
        print("该用户名已存在，请重新输入！")
        return False

    # 插入新用户的信息
    sql = "INSERT INTO login (username, password) VALUES (%s, %s)"
    values = (username, password)
    cursor.execute(sql, values)
    db.commit()

    print("注册成功！")
    return True

# 登录功能
def login(username, password):
    cursor = db.cursor()

    # 验证用户名和密码是否匹配
    cursor.execute("SELECT * FROM login WHERE username = %s AND password = %s", (username, password))
    result = cursor.fetchone()
    if result:
        print("登录成功！")
        return True
    else:
        print("用户名或密码错误，请重新输入！")
        return False

# 调用注册和登录功能
register("user1", "password1")
login("user1", "password1")