/** * Generate SQL query string using a TOP clause * * @param provider {@link AbstractSqlPagingQueryProvider} providing the * implementation specifics * @param topClause the implementation specific top clause to be used * @return the generated query */ public static String generateTopJumpToQuery(AbstractSqlPagingQueryProvider provider, String topClause) { StringBuilder sql = new StringBuilder(); sql.append("SELECT ").append(topClause).append(" ").append(buildSortKeySelect(provider)); sql.append(" FROM ").append(provider.getFromClause()); sql.append(provider.getWhereClause() == null ? "" : " WHERE " + provider.getWhereClause()); buildGroupByClause(provider, sql); sql.append(" ORDER BY ").append(buildSortClause(provider)); return sql.toString(); }
/** * Generate SQL query string using a LIMIT clause * * @param provider {@link AbstractSqlPagingQueryProvider} providing the * implementation specifics * @param limitClause the implementation specific top clause to be used * @return the generated query */ public static String generateLimitJumpToQuery(AbstractSqlPagingQueryProvider provider, String limitClause) { StringBuilder sql = new StringBuilder(); sql.append("SELECT ").append(buildSortKeySelect(provider)); sql.append(" FROM ").append(provider.getFromClause()); sql.append(provider.getWhereClause() == null ? "" : " WHERE " + provider.getWhereClause()); buildGroupByClause(provider, sql); sql.append(" ORDER BY ").append(buildSortClause(provider)); sql.append(" " + limitClause); return sql.toString(); }
/** * Generate SQL query string using a TOP clause * * @param provider {@link AbstractSqlPagingQueryProvider} providing the * implementation specifics * @param topClause the implementation specific top clause to be used * @return the generated query */ public static String generateTopJumpToQuery(AbstractSqlPagingQueryProvider provider, String topClause) { StringBuilder sql = new StringBuilder(); sql.append("SELECT ").append(topClause).append(" ").append(buildSortKeySelect(provider)); sql.append(" FROM ").append(provider.getFromClause()); sql.append(provider.getWhereClause() == null ? "" : " WHERE " + provider.getWhereClause()); buildGroupByClause(provider, sql); sql.append(" ORDER BY ").append(buildSortClause(provider)); return sql.toString(); }
/** * Generate SQL query string using a LIMIT clause * * @param provider {@link AbstractSqlPagingQueryProvider} providing the * implementation specifics * @param limitClause the implementation specific top clause to be used * @return the generated query */ public static String generateLimitJumpToQuery(AbstractSqlPagingQueryProvider provider, String limitClause) { StringBuilder sql = new StringBuilder(); sql.append("SELECT ").append(buildSortKeySelect(provider)); sql.append(" FROM ").append(provider.getFromClause()); sql.append(provider.getWhereClause() == null ? "" : " WHERE " + provider.getWhereClause()); buildGroupByClause(provider, sql); sql.append(" ORDER BY ").append(buildSortClause(provider)); sql.append(" " + limitClause); return sql.toString(); }