B
- public interface SatisfiedQueryBuilder<B extends SatisfiedQueryBuilder<?>>
ColumnSelectBuilder<B> select(Column column)
SatisfiedSelectBuilder<B> select(Column... columns)
SatisfiedQueryBuilder<B> offset(int offset)
firstRow(int)
.offset
- the number of rows to skipSatisfiedQueryBuilder<B> firstRow(int firstRow)
limit(int)
.firstRow
- SatisfiedQueryBuilder<B> limit(int limit)
limit
- SatisfiedQueryBuilder<B> maxRows(int maxRows)
maxRows
- FunctionSelectBuilder<B> select(FunctionType function, Column column)
SatisfiedQueryBuilder<?> select(FunctionType function, String columnName)
CountSelectBuilder<B> selectCount()
ColumnSelectBuilder<B> select(String columnName)
WhereBuilder<B> where(Column column)
WhereBuilder<B> where(String columnName)
WhereBuilder<B> where(ScalarFunction function, Column column)
WhereBuilder<B> where(ScalarFunction function, String columnName)
SatisfiedQueryBuilder<B> where(FilterItem... filters)
SatisfiedQueryBuilder<B> where(Iterable<FilterItem> filters)
SatisfiedOrderByBuilder<B> orderBy(String columnName)
SatisfiedOrderByBuilder<B> orderBy(Column column)
GroupedQueryBuilder groupBy(String columnName)
GroupedQueryBuilder groupBy(String... columnNames)
GroupedQueryBuilder groupBy(Column column)
GroupedQueryBuilder groupBy(Column... columns)
Query toQuery()
Query
object. Typically the returned
query will be a clone of the built query to prevent conflicting
mutations.Query
object representing the built query.CompiledQuery compile()
DataSet execute()
toQuery()
and then DataContext.executeQuery(Query)
.DataSet
that is returned by executing the query.Column findColumn(String columnName) throws IllegalArgumentException
columnName
- IllegalArgumentException
Copyright © 2007–2017 The Apache Software Foundation. All rights reserved.