网页模板带数据库

import mysql.connector

try:
    conn = mysql.connector.connect(
        host="localhost",
        user="yourusername",
        password="yourpassword",
        database="yourdatabase"
    )
    print("Database connected successfully!")
except mysql.connector.Error as err:
    print(f"Error: '{err}'")

import mysql.connector

conn = mysql.connector.connect(
    host="localhost",
    user="yourusername",
    password="yourpassword",
    database="yourdatabase"
)

cursor = conn.cursor(prepared=True)
query = "SELECT * FROM users WHERE username = %s AND password = %s"
cursor.execute(query, (username, password))
result = cursor.fetchall()

-- 创建索引
CREATE INDEX idx_username ON users(username);

-- 优化查询
SELECT * FROM users WHERE username = 'example' LIMIT 10;