Pagination records using JooqTemplate

public <E> LimitResult<List<E>,E> query(Class<E> cls, LimitSelect limitSelect)

public <E> LimitResult<List<E>,E> query(Class<E> cls, LimitSelect limitSelect, LimitRange range)

public <E> LimitResult<List<E>,E> query(Class<E> cls, LimitSelect limitSelect, List resultFields)

public <E> LimitResult<List<E>,E> query(Class<E> cls, LimitSelect limitSelect, LimitRange range, List resultFields)

// Define pagination query

LimitSelect limitSelect = new LimitSelect() {

    public SelectOrderByStep from(SelectSelectStep select) {

        return select.from(T("user_table"))

            .where(jt.conditions("name%", name, "birthday>=", beginDate));

    }

    public List<OrderField> orderBy() {

        return Arrays.asList(F("birthday").desc());

    }

};



// Mode 1: return all data, no total count

LimitResult res1 = jt.query(User.class, limitSelect);



// Mode 2: return limit rows, no total count

LimitResult res2 = jt.query(User.class, limitSelect, LimitRange.of(20));



// Mode 3: paginate (offset starts at 0), calculate total count

LimitResult res3 = jt.query(User.class, limitSelect,

    LimitRange.of(20, 0));

// res3.getResult() returns data, res3.getTotal() returns total count



// Mode 4: specify result fields

LimitResult res4 = jt.query(User.class, limitSelect,

    LimitRange.of(20, 0), Arrays.asList("id", "name"));



// LimitRange.all(): return all data, no total count

LimitResult res5 = jt.query(User.class, limitSelect, LimitRange.all());



// Access results

List<User> data = res3.getResult();

int total = res3.getTotal();

// LimitSelect is a interface:

public interface LimitSelect {

    // Build the FROM clause; the select parameter allows specifying query fields

    SelectOrderByStep from(SelectSelectStep select);



    // Optional: return order fields; return null to skip ordering

    default List<OrderField> orderBy() { return null; }

}