在使用Java时如何在Spanner中实现分页

import com.google.cloud.spanner.DatabaseClient;
import com.google.cloud.spanner.DatabaseId;
import com.google.cloud.spanner.ResultSet;
import com.google.cloud.spanner.Spanner;
import com.google.cloud.spanner.SpannerOptions;
import com.google.cloud.spanner.Statement;

public class SpannerPaginationExample {
  public static void main(String[] args) {
    // 设置Spanner实例连接参数
    SpannerOptions options = SpannerOptions.newBuilder().build();
    Spanner spanner = options.getService();
    
    // 设置数据库ID
    DatabaseId databaseId = DatabaseId.of("project-id", "instance-id", "database-id");
    
    // 创建数据库客户端
    DatabaseClient client = spanner.getDatabaseClient(databaseId);
    
    // 设置分页参数
    int pageSize = 10; // 每页记录数
    int pageNumber = 2; // 页码
    
    // 构建查询语句
    String query = "SELECT * FROM YourTable LIMIT @limit OFFSET @offset";
    Statement statement =
        Statement.newBuilder(query)
            .bind("limit")
            .to(pageSize)
            .bind("offset")
            .to((pageNumber - 1) * pageSize)
            .build();
    
    // 执行查询
    ResultSet resultSet = client.singleUse().executeQuery(statement);
    
    // 处理查询结果
    while (resultSet.next()) {
      // 处理每一条记录
    }
    
    // 关闭连接
    resultSet.close();
    client.close();
    spanner.close();
  }
}