|
||||||||||
| PREV NEXT | FRAMES NO FRAMES | |||||||||
| Packages that use QueryBuilder | |
|---|---|
| com.j256.ormlite.dao | Database Access Object classes. |
| com.j256.ormlite.stmt | SQL statement generation and processing. |
| Uses of QueryBuilder in com.j256.ormlite.dao |
|---|
| Methods in com.j256.ormlite.dao that return QueryBuilder | |
|---|---|
QueryBuilder<T,ID> |
RuntimeExceptionDao.queryBuilder()
|
QueryBuilder<T,ID> |
Dao.queryBuilder()
Create and return a new query builder object which allows you to build a custom SELECT statement. |
QueryBuilder<T,ID> |
BaseDaoImpl.queryBuilder()
|
| Uses of QueryBuilder in com.j256.ormlite.stmt |
|---|
| Methods in com.j256.ormlite.stmt that return QueryBuilder | |
|---|---|
QueryBuilder<T,ID> |
QueryBuilder.distinct()
Add "DISTINCT" clause to the SQL query statement. |
QueryBuilder<T,ID> |
QueryBuilder.groupBy(String columnName)
Add "GROUP BY" clause to the SQL query statement. |
QueryBuilder<T,ID> |
QueryBuilder.groupByRaw(String rawSql)
Add a raw SQL "GROUP BY" clause to the SQL query statement. |
QueryBuilder<T,ID> |
QueryBuilder.having(String having)
Add raw SQL "HAVING" clause to the SQL query statement. |
QueryBuilder<T,ID> |
QueryBuilder.join(QueryBuilder<?,?> joinedQueryBuilder)
Join with another query builder. |
QueryBuilder<T,ID> |
QueryBuilder.leftJoin(QueryBuilder<?,?> joinedQueryBuilder)
Similar to join(QueryBuilder) but it will use "LEFT JOIN" instead. |
QueryBuilder<T,ID> |
QueryBuilder.limit(int maxRows)
Deprecated. Should use limit(Long) |
QueryBuilder<T,ID> |
QueryBuilder.limit(Long maxRows)
Limit the output to maxRows maximum number of rows. |
QueryBuilder<T,ID> |
QueryBuilder.offset(int startRow)
Deprecated. Should use offset(Long) |
QueryBuilder<T,ID> |
QueryBuilder.offset(Long startRow)
Start the output at this row number. |
QueryBuilder<T,ID> |
QueryBuilder.orderBy(String columnName,
boolean ascending)
Add "ORDER BY" clause to the SQL query statement. |
QueryBuilder<T,ID> |
QueryBuilder.orderByRaw(String rawSql)
Add raw SQL "ORDER BY" clause to the SQL query statement. |
QueryBuilder<T,ID> |
QueryBuilder.orderByRaw(String rawSql,
ArgumentHolder... args)
Add raw SQL "ORDER BY" clause to the SQL query statement. |
QueryBuilder<T,ID> |
QueryBuilder.selectColumns(Iterable<String> columns)
Same as selectColumns(String...) except the columns are specified as an iterable -- probably will be a
Collection. |
QueryBuilder<T,ID> |
QueryBuilder.selectColumns(String... columns)
Add columns to be returned by the SELECT query. |
QueryBuilder<T,ID> |
QueryBuilder.selectRaw(String... columns)
Add raw columns or aggregate functions (COUNT, MAX, ...) to the query. |
QueryBuilder<T,ID> |
QueryBuilder.setCountOf(boolean countOf)
Set whether or not we should only return the count of the results. |
| Methods in com.j256.ormlite.stmt with parameters of type QueryBuilder | |
|---|---|
Where<T,ID> |
Where.exists(QueryBuilder<?,?> subQueryBuilder)
Add a EXISTS clause with a sub-query inside of parenthesis. |
Where<T,ID> |
Where.in(String columnName,
QueryBuilder<?,?> subQueryBuilder)
Add a IN clause which makes sure the column is in one of the columns returned from a sub-query inside of parenthesis. |
QueryBuilder<T,ID> |
QueryBuilder.join(QueryBuilder<?,?> joinedQueryBuilder)
Join with another query builder. |
QueryBuilder<T,ID> |
QueryBuilder.leftJoin(QueryBuilder<?,?> joinedQueryBuilder)
Similar to join(QueryBuilder) but it will use "LEFT JOIN" instead. |
Where<T,ID> |
Where.notIn(String columnName,
QueryBuilder<?,?> subQueryBuilder)
Same as Where.in(String, QueryBuilder) except with a NOT IN clause. |
|
||||||||||
| PREV NEXT | FRAMES NO FRAMES | |||||||||