public H2PagingQueryProviderTests() { pagingQueryProvider = new H2PagingQueryProvider(); }
@Override public String generateFirstPageQuery(int pageSize) { return SqlPagingQueryUtils.generateTopSqlQuery(this, false, buildTopClause(pageSize)); }
private PagingQueryProvider createQueryProvider() { H2PagingQueryProvider queryProvider = new H2PagingQueryProvider(); queryProvider.setSelectClause("SELECT email_address, name, purchased_package"); queryProvider.setFromClause("FROM students"); queryProvider.setSortKeys(sortByEmailAddressAsc()); return queryProvider; }
private PagingQueryProvider createQueryProvider() { H2PagingQueryProvider queryProvider = new H2PagingQueryProvider(); queryProvider.setSelectClause("SELECT email_address, name, purchased_package"); queryProvider.setFromClause("FROM students"); queryProvider.setSortKeys(sortByEmailAddressAsc()); return queryProvider; }
case DB2ZOS: case DB2AS400: provider = new Db2PagingQueryProvider(); break; case H2: provider = new H2PagingQueryProvider(); break; case HSQL: provider = new HsqlPagingQueryProvider(); break; case SQLSERVER: provider = new SqlServerPagingQueryProvider(); break;
@Override public String generateRemainingPagesQuery(int pageSize) { return SqlPagingQueryUtils.generateTopSqlQuery(this, true, buildTopClause(pageSize)); }
case DB2ZOS: case DB2AS400: provider = new Db2PagingQueryProvider(); break; case H2: provider = new H2PagingQueryProvider(); break; case HSQL: provider = new HsqlPagingQueryProvider(); break; case SQLSERVER: provider = new SqlServerPagingQueryProvider(); break;
@Override public String generateRemainingPagesQuery(int pageSize) { return SqlPagingQueryUtils.generateTopSqlQuery(this, true, buildTopClause(pageSize)); }
@Override public String generateFirstPageQuery(int pageSize) { return SqlPagingQueryUtils.generateTopSqlQuery(this, false, buildTopClause(pageSize)); }