mysql登录注册留言

import mysql.connector

# 连接数据库
db = mysql.connector.connect(
    host="localhost",
    user="yourusername",
    password="yourpassword",
    database="yourdatabase"
)

cursor = db.cursor()

# 用户注册
def register(username, password):
    sql = "INSERT INTO users (username, password) VALUES (%s, %s)"
    val = (username, password)
    cursor.execute(sql, val)
    db.commit()

# 用户登录
def login(username, password):
    sql = "SELECT * FROM users WHERE username = %s AND password = %s"
    cursor.execute(sql, (username, password))
    result = cursor.fetchall()
    return len(result) > 0

# 示例调用
register("testuser", "testpassword")
print(login("testuser", "testpassword"))

# 留言功能
def add_message(user_id, content):
    sql = "INSERT INTO messages (user_id, content) VALUES (%s, %s)"
    val = (user_id, content)
    cursor.execute(sql, val)
    db.commit()

def get_messages():
    sql = "SELECT * FROM messages"
    cursor.execute(sql)
    result = cursor.fetchall()
    return result

# 示例调用
add_message(1, "这是一个测试留言")
messages = get_messages()
for message in messages:
    print(message)