Uses of Class
com.j256.ormlite.stmt.QueryBuilder

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.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.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.
 Where<T,ID> Where.notIn(String columnName, QueryBuilder<?,?> subQueryBuilder)
          Same as Where.in(String, QueryBuilder) except with a NOT IN clause.
 



This content is licensed by Gray Watson under the Creative Commons Attribution-Share Alike 3.0 License.