public PreparedStatementCreator page(final Dialect dialect, final int limit, final int offset) {
        return new PreparedStatementCreator() {
            public PreparedStatement createPreparedStatement(Connection con) throws SQLException {
                return getPreparedStatementCreator()
                .setSql(dialect.createPageSelect(builder.toString(), limit, offset))
                .createPreparedStatement(con);
            }
        };
    }
public PreparedStatementCreator page ( final Dialect dialect , final int limit , final int offset ) { return new PreparedStatementCreator ( ) { public PreparedStatement createPreparedStatement ( Connection con ) throws SQLException { return getPreparedStatementCreator ( ) . setSql ( dialect . createPageSelect ( builder . toString ( ) , limit , offset ) ) . createPreparedStatement ( con ) ; } } ; }
Returns a PreparedStatementCreator that returns a page of the underlying
result set.

@param dialect
Database dialect to use.
@param limit
Maximum number of rows to return.
@param offset
Index of the first row to return.