数据表、分页和行选择问题

SELECT * FROM table_name ORDER BY id LIMIT 10 OFFSET 20;

from sqlalchemy import create_engine, Table, MetaData, select

engine = create_engine('sqlite:///example.db')
metadata = MetaData(bind=engine)
table = Table('example_table', metadata, autoload=True)

def get_page(page_number, page_size):
    offset = (page_number - 1) * page_size
    query = select([table]).limit(page_size).offset(offset)
    result = engine.execute(query)
    return result.fetchall()

import React, { useState } from 'react';

function DataTable({ data }) {
    const [currentPage, setCurrentPage] = useState(1);
    const pageSize = 10;

    const totalPages = Math.ceil(data.length / pageSize);
    const startIndex = (currentPage - 1) * pageSize;
    const endIndex = startIndex + pageSize;
    const currentData = data.slice(startIndex, endIndex);

    return (
        <div>
            <table>
                {/* Render table rows */}
            </table>
            <button onClick={() => setCurrentPage(currentPage - 1)} disabled={currentPage === 1}>Previous</button>
            <button onClick={() => setCurrentPage(currentPage + 1)} disabled={currentPage === totalPages}>Next</button>
        </div>
    );
}