数据库

import mysql.connector

# 连接数据库
cnx = mysql.connector.connect(user='root', password='password',
                              host='127.0.0.1',
                              database='article_db')
cursor = cnx.cursor()

# 获取总记录数  
query = "SELECT COUNT(*) FROM articles"
cursor.execute(query)
total_count = cursor.fetchone()[0]


    /pagenum  第几页 / pagesize 每页多少数据 /total_count 查询的总记录 / total_pages 总页数
    /offset = (page_num - 1) * page_size   需要跳过的数据数
    
# 设置分页参数 
page_size = 10  
page_num = 1 

# 计算总页数
total_pages = total_count // page_size
if total_count % page_size != 0:
    total_pages += 1

# 获取当前页数据
offset = (page_num - 1) * page_size
query = "SELECT id, title, content, userid FROM articles LIMIT %s OFFSET %s"
cursor.execute(query, (page_size, offset))
current_page_data = cursor.fetchall()

# 页面切换逻辑
while True:
    # 显示当前页数据
    display_page(current_page_data)
    
    # 获取用户输入的页码
    page_num = input("请输入要跳转的页码(1-%d):" % total_pages)
    page_num = int(page_num)
    if page_num < 1 or page_num > total_pages:
        print("页码越界,请重新输入")
        continue

    # 计算偏移量
    offset = (page_num - 1) * page_size
    
    # 获取新一页数据
    cursor.execute(query, (page_size, offset)) 
    current_page_data = cursor.fetchall()

# 关闭连接
cnx.close()