code: 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);
              }
          };
      }
docs: 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.