Main3.java

package com.example;

import com.company.sakila.SakilaApplication;
import com.company.sakila.SakilaApplicationBuilder;
import com.company.sakila.sakila.sakila.film.Film;
import com.company.sakila.sakila.sakila.film.FilmManager;
import com.speedment.runtime.core.ApplicationBuilder;
import com.speedment.runtime.core.manager.Manager;

import java.util.Comparator;
import java.util.function.Predicate;
import java.util.stream.Stream;

public class Main3 {

    public static void main(final String... args) {
        SakilaApplication app = new SakilaApplicationBuilder()
            .withPassword("sakila-password")
            .withLogging(ApplicationBuilder.LogType.STREAM)
            .build();
        
        // Obtains a FilmManager that allows us to
        // work with the "film" table
        FilmManager films = app.getOrThrow(FilmManager.class);

        page(films, Film.LENGTH.greaterThan(60), Film.TITLE, 3)
            .forEach(System.out::println);

        app.close();
    }


    private static final int PAGE_SIZE = 50;

    public static <T> Stream<T> page(
        Manager<T> manager,
        Predicate<? super T> predicate,
        Comparator<? super T> comparator,
        int pageNo
    ) {
        return manager.stream()
            .filter(predicate)
            .sorted(comparator)
            .skip(pageNo * PAGE_SIZE)
            .limit(PAGE_SIZE);
    }

}