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.limit(Integer maxRows)
          Limit the output to maxRows maximum number of rows.
 QueryBuilder<T,ID> QueryBuilder.offset(Integer 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)
          Add columns to be returned by the SELECT query.
 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.
 



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