@RestController
@RequestMapping("/products")
@RequiredArgsConstructor
public class ProductController {
  private final ProductService productService;
  private final ProductServiceJooq productServiceJooq;

  @GetMapping("/jpa/withPage")
  @ResponseStatus(HttpStatus.OK)
  public Page<Product> findAll(
      @RequestParam(name = "page") int page, @RequestParam(name = "pageSize") int size) {
    return productService.findByPage(page, size);
  }

  @GetMapping("/jpa/withSkipAndTop")
  @ResponseStatus(HttpStatus.OK)
  public Iterable<Product> findWithSkipAndTop(
      @RequestParam(name = "skip") int skip, @RequestParam(name = "top") int top) {
    return productService.findWithSkipAndTop(skip, top);
  }

  @GetMapping("/jooq/withPage")
  @ResponseStatus(HttpStatus.OK)
  public Page<ProductRecord> findAllJooq(
      @RequestParam(name = "page") int page, @RequestParam(name = "pageSize") int size) {
    return productServiceJooq.findWithPageable(page, size);
  }

  @GetMapping("/jooq/withSkipAndTop")
  @ResponseStatus(HttpStatus.OK)
  public Iterable<ProductRecord> findWithSkipAndTopJooq(
      @RequestParam(name = "skip") int skip, @RequestParam(name = "top") int top) {
    return productServiceJooq.findWithSkipAndTop(skip, top);
  }
}

@Repository
public interface ProductRepository extends CrudRepository<Product, Long> {
  Page<Product> findAll(Pageable pageable);
}

@Service
@RequiredArgsConstructor
public class ProductService {
  private final ProductRepository productRepository;

  public Page<Product> findByPage(int page, int size) {
    return productRepository.findAll(PageRequest.of(page, size));
  }

}

{
    "content": [
        {
            "id": 26,
            "name": "Product 1",
            "description": "Description for Product 1",
            "price": 10.99,
            "image": "image1.jpg",
            ...
        },
        {
            "id": 27,
            "name": "Product 2",
            "description": "Description for Product 2",
            "price": 15.49,
            "image": "image2.jpg",
            ...
        },
        ...
    ],
    "pageable": {
        "pageNumber": 0,
        "pageSize": 10,
        "sort": {
            "empty": true,
            "sorted": false,
            "unsorted": true
        },
        "offset": 0,
        "unpaged": false,
        "paged": true
    },
    "last": false,
    "totalPages": 3,
    "totalElements": 25,
    "first": true,
    "size": 10,
    "number": 0,
    "sort": {
        "empty": true,
        "sorted": false,
        "unsorted": true
    },
    "numberOfElements": 10,
    "empty": false
}

@RequiredArgsConstructor(staticName = "of")
public class PageableWithSkipAndTop implements Pageable {

  private final int skip;
  private final int top;

  private final Sort sort = Sort.unsorted();

  @Override
  public int getPageNumber() {
    return 0;
  }

  @Override
  public int getPageSize() {
    return top;
  }

  @Override
  public long getOffset() {
    return skip;
  }

  @Override
  public Sort getSort() {
    return sort;
  }

  @Override
  public Pageable next() {
    return this;
  }

  @Override
  public Pageable previousOrFirst() {
    return this;
  }

  @Override
  public Pageable first() {
    return this;
  }

  @Override
  public Pageable withPage(int pageNumber) {
    return this;
  }

  @Override
  public boolean hasPrevious() {
    return false;
  }
}

@Service
@RequiredArgsConstructor
public class ProductService {
  private final ProductRepository productRepository;

  public List<Product> findWithSkipAndTop(int skip, int top) {
    return productRepository.findAll(PageableWithSkipAndTop.of(skip, top)).getContent();
  }
}

@Repository
@RequiredArgsConstructor
public class ProductRepositoryJooq {
  private final DSLContext dslContext;

  public List<ProductRecord> findWithSkipAndTop(int skip, int top) {
    return dslContext
 . select ()
 . from (ProductTable.PRODUCT)
        .offset(skip)
 . limit (top)
        .fetchinto(ProductRecord.class);
  }
}

@Service
@RequiredArgsConstructor
public class ProductServiceJooq {
  private final ProductRepositoryJooq productRepositoryJooq;

  public List<ProductRecord> findWithSkipAndTop(int skip, int top) {
    return productRepositoryJooq.findWithSkipAndTop(skip, top);
  }
}

@Repository
@RequiredArgsConstructor
public class ProductRepositoryJooq {
  private final DSLContext dslContext;

  public Page<ProductRecord> findWithPageable(int page, int size) {
    Pageable pageable = PageRequest.of(page, size);

    List<ProductRecord> records =
        dslContext
     . select from(ProductTable.PRODUCT)
     . limit (pageable.getPageSize())
            .offset((int) pageable.getOffset())
            .fetchinto(ProductRecord.class);

    int total = dslContext.fetchCount(DSL.select().from(ProductTable.PRODUCT));

    return new PageImpl<>(records, pageable, total);
  }

}