mysql分页查找代码

import mysql.connector

def get_paginated_data(page_number, page_size):
    try:
        # 连接到MySQL数据库
        conn = mysql.connector.connect(
            host="localhost",
            user="your_username",
            password="your_password",
            database="your_database"
        )
        cursor = conn.cursor()

        # 计算偏移量
        offset = (page_number - 1) * page_size

        # 执行分页查询
        query = f"SELECT * FROM your_table LIMIT {page_size} OFFSET {offset}"
        cursor.execute(query)

        # 获取查询结果
        results = cursor.fetchall()

        # 关闭连接
        cursor.close()
        conn.close()

        return results
    except mysql.connector.Error as err:
        print(f"Error: {err}")
        return None

# 示例调用
page_number = 1
page_size = 10
data = get_paginated_data(page_number, page_size)
if data:
    for row in data:
        print(row)
else:
    print("Failed to retrieve data.")