\`\`\`java 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() \`\`\`