mysql记录登陆账号

CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(50) UNIQUE NOT NULL,
    password VARCHAR(255) NOT NULL,
    email VARCHAR(100),
    phone VARCHAR(20),
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);

import bcrypt

# 加密密码
password = "user_password".encode('utf-8')
hashed_password = bcrypt.hashpw(password, bcrypt.gensalt())

# 存储到数据库
cursor.execute("INSERT INTO users (username, password) VALUES (%s, %s)", ('user1', hashed_password))

import mysql.connector

db = mysql.connector.connect(host="localhost", user="user", password="password", database="mydatabase")
cursor = db.cursor()

# 使用参数化查询
username = "user1"
password = "hashed_password"
cursor.execute("SELECT * FROM users WHERE username = %s AND password = %s", (username, password))

try:
    db.start_transaction()
    cursor.execute("UPDATE users SET email = %s WHERE id = %s", ('new_email@example.com', 1))
    cursor.execute("UPDATE users SET phone = %s WHERE id = %s", ('1234567890', 1))
    db.commit()
except mysql.connector.Error as err:
    db.rollback()
    print(f"Error: {err}")