利用mysql实现登录界面

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

import mysql.connector

def login(username, password):
    try:
        # 连接到MySQL数据库
        db = mysql.connector.connect(
            host="localhost",
            user="yourusername",
            password="yourpassword",
            database="yourdatabase"
        )
        cursor = db.cursor()

        # 查询用户信息
        query = "SELECT * FROM Users WHERE username = %s AND password = %s"
        cursor.execute(query, (username, password))
        result = cursor.fetchone()

        if result:
            print("登录成功")
        else:
            print("用户名或密码错误")

    except mysql.connector.Error as err:
        print(f"数据库错误: {err}")
    finally:
        if db.is_connected():
            cursor.close()
            db.close()

# 测试登录
login("testuser", "testpassword")