Model.Finder (Play 2.3.2)

java.lang.Object
- play.db.ebean.Model.Finder<I,T>

All Implemented Interfaces:

com.avaje.ebean.Query<T>, java.io.Serializable

Enclosing class:

Model
```
public static class Model.Finder<I,T>
extends java.lang.Object
implements com.avaje.ebean.Query<T>
```
Helper for Ebean queries.

See Also:
Ebean API documentation, Serialized Form

Constructor Summary

Constructors
Constructor and Description
`Model.Finder(java.lang.Class<I> idType, java.lang.Class<T> type)` Creates a finder for entity of type `T` with ID of type `I`.
`Model.Finder(java.lang.String serverName, java.lang.Class<I> idType, java.lang.Class<T> type)` Creates a finder for entity of type `T` with ID of type `I`, using a specific Ebean server.

Method Summary

Methods
Modifier and Type	Method and Description
`java.util.List<T>`	`all()` Retrieves all entities of the given type.
`T`	`byId(I id)` Retrieves an entity by ID.
`void`	`cancel()` Cancels query execution, if supported by the underlying database and driver.
`com.avaje.ebean.Query<T>`	`copy()` Copies this query.
`com.avaje.ebean.Query<T>`	`fetch(java.lang.String path)` Specifies a path to load including all its properties.
`com.avaje.ebean.Query<T>`	`fetch(java.lang.String path, com.avaje.ebean.FetchConfig joinConfig)` Additionally specifies a `JoinConfig` to specify a 'query join' and/or define the lazy loading query.
`com.avaje.ebean.Query<T>`	`fetch(java.lang.String path, java.lang.String fetchProperties)` Specifies a path to fetch with a specific list properties to include, to load a partial object.
`com.avaje.ebean.Query<T>`	`fetch(java.lang.String assocProperty, java.lang.String fetchProperties, com.avaje.ebean.FetchConfig fetchConfig)` Additionally specifies a `FetchConfig` to use a separate query or lazy loading to load this path.
`com.avaje.ebean.Filter<T>`	`filter()` Creates a filter for sorting and filtering lists of entities locally without going back to the database.
`com.avaje.ebean.ExpressionList<T>`	`filterMany(java.lang.String propertyName)` Applies a filter on the 'many' property list rather than the root level objects.
`com.avaje.ebean.FutureIds<T>`	`findFutureIds()` Executes a find IDs query in a background thread.
`com.avaje.ebean.FutureList<T>`	`findFutureList()` Executes a find list query in a background thread.
`com.avaje.ebean.FutureRowCount<T>`	`findFutureRowCount()` Executes a find row count query in a background thread.
`java.util.List<java.lang.Object>`	`findIds()` Executes a query and returns the results as a list of IDs.
`com.avaje.ebean.QueryIterator<T>`	`findIterate()`
`java.util.List<T>`	`findList()` Executes the query and returns the results as a list of objects.
`java.util.Map<?,T>`	`findMap()` Executes the query and returns the results as a map of objects.
`<K> java.util.Map<K,T>`	`findMap(java.lang.String a, java.lang.Class<K> b)` Executes the query and returns the results as a map of the objects.
`com.avaje.ebean.PagingList<T>`	`findPagingList(int pageSize)` Returns a `PagingList` for this query.
`int`	`findRowCount()` Returns the number of entities this query should return.
`java.util.Set<T>`	`findSet()` Executes the query and returns the results as a set of objects.
`T`	`findUnique()` Executes the query and returns the results as either a single bean or `null`, if no matching bean is found.
`void`	`findVisit(com.avaje.ebean.QueryResultVisitor<T> visitor)`
`com.avaje.ebean.ExpressionFactory`	`getExpressionFactory()` Returns the `ExpressionFactory` used by this query.
`int`	`getFirstRow()` Returns the first row value.
`java.lang.String`	`getGeneratedSql()` Returns the SQL that was generated for executing this query.
`int`	`getMaxRows()` Returns the maximum of rows for this query.
`com.avaje.ebean.RawSql`	`getRawSql()` Returns the `RawSql` that was set to use for this query.
`com.avaje.ebean.ExpressionList<T>`	`having()` Returns the query's `having` clause.
`com.avaje.ebean.Query<T>`	`having(com.avaje.ebean.Expression addExpressionToHaving)` Adds an expression to the `having` clause and returns the query.
`com.avaje.ebean.Query<T>`	`having(java.lang.String addToHavingClause)` Adds clauses to the `having` clause and returns the query.
`boolean`	`isAutofetchTuned()` Returns `true` if this query was tuned by `autoFetch`.
`boolean`	`isForUpdate()` Whether this query is for update
`I`	`nextId()` Returns the next identity value.
`Model.Finder<I,T>`	`on(java.lang.String server)` Changes the Ebean server.
`com.avaje.ebean.OrderBy<T>`	`order()` Returns the `order by` clause so that you can append an ascending or descending property to the `order by` clause.
`com.avaje.ebean.Query<T>`	`order(java.lang.String orderByClause)` Sets the `order by` clause, replacing the existing `order by` clause if there is one.
`com.avaje.ebean.OrderBy<T>`	`orderBy()` Returns the `order by` clause so that you can append an ascending or descending property to the `order by` clause.
`com.avaje.ebean.Query<T>`	`orderBy(java.lang.String orderByClause)` Set the `order by` clause replacing the existing `order by` clause if there is one.
`com.avaje.ebean.Query<T>`	`query()` Creates a query.
`T`	`ref(I id)` Retrieves an entity reference for this ID.
`com.avaje.ebean.Query<T>`	`select(java.lang.String fetchProperties)` Explicitly sets a comma delimited list of the properties to fetch on the 'main' entity bean, to load a partial object.
`com.avaje.ebean.Query<T>`	`setAutofetch(boolean autofetch)` Explicitly specifies whether to use 'Autofetch' for this query.
`com.avaje.ebean.Query<T>`	`setBackgroundFetchAfter(int backgroundFetchAfter)` Sets the rows after which fetching should continue in a background thread.
`com.avaje.ebean.Query<T>`	`setBufferFetchSizeHint(int fetchSize)` Sets a hint, which for JDBC translates to `Statement.fetchSize()`.
`com.avaje.ebean.Query<T>`	`setDistinct(boolean isDistinct)` Sets whether this query uses `DISTINCT`.
`com.avaje.ebean.Query<T>`	`setFirstRow(int firstRow)` Sets the first row to return for this query.
`com.avaje.ebean.Query<T>`	`setForUpdate(boolean forUpdate)` Execute the select with "for update" which should lock the record "on read"
`com.avaje.ebean.Query<T>`	`setId(java.lang.Object id)` Sets the ID value to query.
`com.avaje.ebean.Query<T>`	`setListener(com.avaje.ebean.QueryListener<T> queryListener)` Sets a listener to process the query on a row-by-row basis.
`com.avaje.ebean.Query<T>`	`setLoadBeanCache(boolean loadBeanCache)` When set to `true`, all the beans from this query are loaded into the bean cache.
`com.avaje.ebean.Query<T>`	`setMapKey(java.lang.String mapKey)` Sets the property to use as keys for a map.
`com.avaje.ebean.Query<T>`	`setMaxRows(int maxRows)` Sets the maximum number of rows to return in the query.
`com.avaje.ebean.Query<T>`	`setOrder(com.avaje.ebean.OrderBy<T> orderBy)` Replaces any existing `order by` clause using an `OrderBy` object.
`com.avaje.ebean.Query<T>`	`setOrderBy(com.avaje.ebean.OrderBy<T> orderBy)` Set an OrderBy object to replace any existing `order by` clause.
`com.avaje.ebean.Query<T>`	`setParameter(int position, java.lang.Object value)` Sets an ordered bind parameter according to its position.
`com.avaje.ebean.Query<T>`	`setParameter(java.lang.String name, java.lang.Object value)` Sets a named bind parameter.
`com.avaje.ebean.Query<T>`	`setQuery(java.lang.String oql)` Sets the OQL query to run
`com.avaje.ebean.Query<T>`	`setRawSql(com.avaje.ebean.RawSql rawSql)` Sets `RawSql` to use for this query.
`com.avaje.ebean.Query<T>`	`setReadOnly(boolean readOnly)` Sets whether the returned beans will be read-only.
`com.avaje.ebean.Query<T>`	`setTimeout(int secs)` Sets a timeout on this query.
`com.avaje.ebean.Query<T>`	`setUseCache(boolean useBeanCache)` Sets whether to use the bean cache.
`com.avaje.ebean.Query<T>`	`setUseQueryCache(boolean useQueryCache)` Sets whether to use the query cache.
`com.avaje.ebean.ExpressionList<T>`	`where()` Adds expressions to the `where` clause with the ability to chain on the `ExpressionList`.
`com.avaje.ebean.Query<T>`	`where(com.avaje.ebean.Expression expression)` Adds a single `Expression` to the `where` clause and returns the query.
`com.avaje.ebean.Query<T>`	`where(java.lang.String addToWhereClause)` Adds additional clauses to the `where` clause.

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- Constructor Detail
  - Model.Finder
```
public Model.Finder(java.lang.Class<I> idType,
            java.lang.Class<T> type)
```
    Creates a finder for entity of type T with ID of type I.
  - Model.Finder
```
public Model.Finder(java.lang.String serverName,
            java.lang.Class<I> idType,
            java.lang.Class<T> type)
```
    Creates a finder for entity of type T with ID of type I, using a specific Ebean server.
- Method Detail
  - on
```
public Model.Finder<I,T> on(java.lang.String server)
```
    Changes the Ebean server.
  - all
```
public java.util.List<T> all()
```
    Retrieves all entities of the given type.
  - byId
```
public T byId(I id)
```
    Retrieves an entity by ID.
  - ref
```
public T ref(I id)
```
    Retrieves an entity reference for this ID.
  - filter
```
public com.avaje.ebean.Filter<T> filter()
```
    Creates a filter for sorting and filtering lists of entities locally without going back to the database.
  - query
```
public com.avaje.ebean.Query<T> query()
```
    Creates a query.
  - nextId
```
public I nextId()
```
    Returns the next identity value.
  - cancel
```
public void cancel()
```
    Cancels query execution, if supported by the underlying database and driver.
    
    Specified by:
    
    cancel in interface com.avaje.ebean.Query<T>
  - copy
```
public com.avaje.ebean.Query<T> copy()
```
    Copies this query.
    
    Specified by:
    
    copy in interface com.avaje.ebean.Query<T>
  - fetch
```
public com.avaje.ebean.Query<T> fetch(java.lang.String path)
```
    Specifies a path to load including all its properties.
    
    Specified by:
    
    fetch in interface com.avaje.ebean.Query<T>
  - fetch
```
public com.avaje.ebean.Query<T> fetch(java.lang.String path,
                             com.avaje.ebean.FetchConfig joinConfig)
```
    Additionally specifies a JoinConfig to specify a 'query join' and/or define the lazy loading query.
    
    Specified by:
    
    fetch in interface com.avaje.ebean.Query<T>
  - fetch
```
public com.avaje.ebean.Query<T> fetch(java.lang.String path,
                             java.lang.String fetchProperties)
```
    Specifies a path to fetch with a specific list properties to include, to load a partial object.
    
    Specified by:
    
    fetch in interface com.avaje.ebean.Query<T>
  - fetch
```
public com.avaje.ebean.Query<T> fetch(java.lang.String assocProperty,
                             java.lang.String fetchProperties,
                             com.avaje.ebean.FetchConfig fetchConfig)
```
    Additionally specifies a FetchConfig to use a separate query or lazy loading to load this path.
    
    Specified by:
    
    fetch in interface com.avaje.ebean.Query<T>
  - filterMany
```
public com.avaje.ebean.ExpressionList<T> filterMany(java.lang.String propertyName)
```
    Applies a filter on the 'many' property list rather than the root level objects.
    
    Specified by:
    
    filterMany in interface com.avaje.ebean.Query<T>
  - findFutureIds
```
public com.avaje.ebean.FutureIds<T> findFutureIds()
```
    Executes a find IDs query in a background thread.
    
    Specified by:
    
    findFutureIds in interface com.avaje.ebean.Query<T>
  - findFutureList
```
public com.avaje.ebean.FutureList<T> findFutureList()
```
    Executes a find list query in a background thread.
    
    Specified by:
    
    findFutureList in interface com.avaje.ebean.Query<T>
  - findFutureRowCount
```
public com.avaje.ebean.FutureRowCount<T> findFutureRowCount()
```
    Executes a find row count query in a background thread.
    
    Specified by:
    
    findFutureRowCount in interface com.avaje.ebean.Query<T>
  - findIds
```
public java.util.List<java.lang.Object> findIds()
```
    Executes a query and returns the results as a list of IDs.
    
    Specified by:
    
    findIds in interface com.avaje.ebean.Query<T>
  - findList
```
public java.util.List<T> findList()
```
    Executes the query and returns the results as a list of objects.
    
    Specified by:
    
    findList in interface com.avaje.ebean.Query<T>
  - findMap
```
public java.util.Map<?,T> findMap()
```
    Executes the query and returns the results as a map of objects.
    
    Specified by:
    
    findMap in interface com.avaje.ebean.Query<T>
  - findMap
```
public <K> java.util.Map<K,T> findMap(java.lang.String a,
                             java.lang.Class<K> b)
```
    Executes the query and returns the results as a map of the objects.
    
    Specified by:
    
    findMap in interface com.avaje.ebean.Query<T>
  - findPagingList
```
public com.avaje.ebean.PagingList<T> findPagingList(int pageSize)
```
    Returns a PagingList for this query.
    
    Specified by:
    
    findPagingList in interface com.avaje.ebean.Query<T>
  - findRowCount
```
public int findRowCount()
```
    Returns the number of entities this query should return.
    
    Specified by:
    
    findRowCount in interface com.avaje.ebean.Query<T>
  - findSet
```
public java.util.Set<T> findSet()
```
    Executes the query and returns the results as a set of objects.
    
    Specified by:
    
    findSet in interface com.avaje.ebean.Query<T>
  - findUnique
```
public T findUnique()
```
    Executes the query and returns the results as either a single bean or null, if no matching bean is found.
    
    Specified by:
    
    findUnique in interface com.avaje.ebean.Query<T>
  - findVisit
```
public void findVisit(com.avaje.ebean.QueryResultVisitor<T> visitor)
```
    Specified by:
    
    findVisit in interface com.avaje.ebean.Query<T>
  - findIterate
```
public com.avaje.ebean.QueryIterator<T> findIterate()
```
    Specified by:
    
    findIterate in interface com.avaje.ebean.Query<T>
  - getExpressionFactory
```
public com.avaje.ebean.ExpressionFactory getExpressionFactory()
```
    Returns the ExpressionFactory used by this query.
    
    Specified by:
    
    getExpressionFactory in interface com.avaje.ebean.Query<T>
  - getFirstRow
```
public int getFirstRow()
```
    Returns the first row value.
    
    Specified by:
    
    getFirstRow in interface com.avaje.ebean.Query<T>
  - getGeneratedSql
```
public java.lang.String getGeneratedSql()
```
    Returns the SQL that was generated for executing this query.
    
    Specified by:
    
    getGeneratedSql in interface com.avaje.ebean.Query<T>
  - getMaxRows
```
public int getMaxRows()
```
    Returns the maximum of rows for this query.
    
    Specified by:
    
    getMaxRows in interface com.avaje.ebean.Query<T>
  - getRawSql
```
public com.avaje.ebean.RawSql getRawSql()
```
    Returns the RawSql that was set to use for this query.
    
    Specified by:
    
    getRawSql in interface com.avaje.ebean.Query<T>
  - having
```
public com.avaje.ebean.ExpressionList<T> having()
```
    Returns the query's having clause.
    
    Specified by:
    
    having in interface com.avaje.ebean.Query<T>
  - having
```
public com.avaje.ebean.Query<T> having(com.avaje.ebean.Expression addExpressionToHaving)
```
    Adds an expression to the having clause and returns the query.
    
    Specified by:
    
    having in interface com.avaje.ebean.Query<T>
  - having
```
public com.avaje.ebean.Query<T> having(java.lang.String addToHavingClause)
```
    Adds clauses to the having clause and returns the query.
    
    Specified by:
    
    having in interface com.avaje.ebean.Query<T>
  - isAutofetchTuned
```
public boolean isAutofetchTuned()
```
    Returns true if this query was tuned by autoFetch.
    
    Specified by:
    
    isAutofetchTuned in interface com.avaje.ebean.Query<T>
  - order
```
public com.avaje.ebean.OrderBy<T> order()
```
    Returns the order by clause so that you can append an ascending or descending property to the order by clause.
    This is exactly the same as orderBy().
    
    Specified by:
    
    order in interface com.avaje.ebean.Query<T>
  - order
```
public com.avaje.ebean.Query<T> order(java.lang.String orderByClause)
```
    Sets the order by clause, replacing the existing order by clause if there is one.
    This is exactly the same as orderBy(String).
    
    Specified by:
    
    order in interface com.avaje.ebean.Query<T>
  - orderBy
```
public com.avaje.ebean.OrderBy<T> orderBy()
```
    Returns the order by clause so that you can append an ascending or descending property to the order by clause.
    This is exactly the same as order().
    
    Specified by:
    
    orderBy in interface com.avaje.ebean.Query<T>
  - orderBy
```
public com.avaje.ebean.Query<T> orderBy(java.lang.String orderByClause)
```
    Set the order by clause replacing the existing order by clause if there is one.
    This is exactly the same as order(String).
    
    Specified by:
    
    orderBy in interface com.avaje.ebean.Query<T>
  - select
```
public com.avaje.ebean.Query<T> select(java.lang.String fetchProperties)
```
    Explicitly sets a comma delimited list of the properties to fetch on the 'main' entity bean, to load a partial object.
    
    Specified by:
    
    select in interface com.avaje.ebean.Query<T>
  - setAutofetch
```
public com.avaje.ebean.Query<T> setAutofetch(boolean autofetch)
```
    Explicitly specifies whether to use 'Autofetch' for this query.
    
    Specified by:
    
    setAutofetch in interface com.avaje.ebean.Query<T>
  - setBackgroundFetchAfter
```
public com.avaje.ebean.Query<T> setBackgroundFetchAfter(int backgroundFetchAfter)
```
    Sets the rows after which fetching should continue in a background thread.
    
    Specified by:
    
    setBackgroundFetchAfter in interface com.avaje.ebean.Query<T>
  - setBufferFetchSizeHint
```
public com.avaje.ebean.Query<T> setBufferFetchSizeHint(int fetchSize)
```
    Sets a hint, which for JDBC translates to Statement.fetchSize().
    
    Specified by:
    
    setBufferFetchSizeHint in interface com.avaje.ebean.Query<T>
  - setDistinct
```
public com.avaje.ebean.Query<T> setDistinct(boolean isDistinct)
```
    Sets whether this query uses DISTINCT.
    
    Specified by:
    
    setDistinct in interface com.avaje.ebean.Query<T>
  - setFirstRow
```
public com.avaje.ebean.Query<T> setFirstRow(int firstRow)
```
    Sets the first row to return for this query.
    
    Specified by:
    
    setFirstRow in interface com.avaje.ebean.Query<T>
  - setId
```
public com.avaje.ebean.Query<T> setId(java.lang.Object id)
```
    Sets the ID value to query.
    
    Specified by:
    
    setId in interface com.avaje.ebean.Query<T>
  - setListener
```
public com.avaje.ebean.Query<T> setListener(com.avaje.ebean.QueryListener<T> queryListener)
```
    Sets a listener to process the query on a row-by-row basis.
    
    Specified by:
    
    setListener in interface com.avaje.ebean.Query<T>
  - setLoadBeanCache
```
public com.avaje.ebean.Query<T> setLoadBeanCache(boolean loadBeanCache)
```
    When set to true, all the beans from this query are loaded into the bean cache.
    
    Specified by:
    
    setLoadBeanCache in interface com.avaje.ebean.Query<T>
  - setMapKey
```
public com.avaje.ebean.Query<T> setMapKey(java.lang.String mapKey)
```
    Sets the property to use as keys for a map.
    
    Specified by:
    
    setMapKey in interface com.avaje.ebean.Query<T>
  - setMaxRows
```
public com.avaje.ebean.Query<T> setMaxRows(int maxRows)
```
    Sets the maximum number of rows to return in the query.
    
    Specified by:
    
    setMaxRows in interface com.avaje.ebean.Query<T>
  - setOrder
```
public com.avaje.ebean.Query<T> setOrder(com.avaje.ebean.OrderBy<T> orderBy)
```
    Replaces any existing order by clause using an OrderBy object.
    This is exactly the same as setOrderBy(com.avaje.ebean.OrderBy).
    
    Specified by:
    
    setOrder in interface com.avaje.ebean.Query<T>
  - setOrderBy
```
public com.avaje.ebean.Query<T> setOrderBy(com.avaje.ebean.OrderBy<T> orderBy)
```
    Set an OrderBy object to replace any existing order by clause.
    This is exactly the same as setOrder(com.avaje.ebean.OrderBy).
    
    Specified by:
    
    setOrderBy in interface com.avaje.ebean.Query<T>
  - setParameter
```
public com.avaje.ebean.Query<T> setParameter(int position,
                                    java.lang.Object value)
```
    Sets an ordered bind parameter according to its position.
    
    Specified by:
    
    setParameter in interface com.avaje.ebean.Query<T>
  - setParameter
```
public com.avaje.ebean.Query<T> setParameter(java.lang.String name,
                                    java.lang.Object value)
```
    Sets a named bind parameter.
    
    Specified by:
    
    setParameter in interface com.avaje.ebean.Query<T>
  - setQuery
```
public com.avaje.ebean.Query<T> setQuery(java.lang.String oql)
```
    Sets the OQL query to run
  - setRawSql
```
public com.avaje.ebean.Query<T> setRawSql(com.avaje.ebean.RawSql rawSql)
```
    Sets RawSql to use for this query.
    
    Specified by:
    
    setRawSql in interface com.avaje.ebean.Query<T>
  - setReadOnly
```
public com.avaje.ebean.Query<T> setReadOnly(boolean readOnly)
```
    Sets whether the returned beans will be read-only.
    
    Specified by:
    
    setReadOnly in interface com.avaje.ebean.Query<T>
  - setTimeout
```
public com.avaje.ebean.Query<T> setTimeout(int secs)
```
    Sets a timeout on this query.
    
    Specified by:
    
    setTimeout in interface com.avaje.ebean.Query<T>
  - setUseCache
```
public com.avaje.ebean.Query<T> setUseCache(boolean useBeanCache)
```
    Sets whether to use the bean cache.
    
    Specified by:
    
    setUseCache in interface com.avaje.ebean.Query<T>
  - setUseQueryCache
```
public com.avaje.ebean.Query<T> setUseQueryCache(boolean useQueryCache)
```
    Sets whether to use the query cache.
    
    Specified by:
    
    setUseQueryCache in interface com.avaje.ebean.Query<T>
  - where
```
public com.avaje.ebean.ExpressionList<T> where()
```
    Adds expressions to the where clause with the ability to chain on the ExpressionList.
    
    Specified by:
    
    where in interface com.avaje.ebean.Query<T>
  - where
```
public com.avaje.ebean.Query<T> where(com.avaje.ebean.Expression expression)
```
    Adds a single Expression to the where clause and returns the query.
    
    Specified by:
    
    where in interface com.avaje.ebean.Query<T>
  - where
```
public com.avaje.ebean.Query<T> where(java.lang.String addToWhereClause)
```
    Adds additional clauses to the where clause.
    
    Specified by:
    
    where in interface com.avaje.ebean.Query<T>
  - setForUpdate
```
public com.avaje.ebean.Query<T> setForUpdate(boolean forUpdate)
```
    Execute the select with "for update" which should lock the record "on read"
    
    Specified by:
    
    setForUpdate in interface com.avaje.ebean.Query<T>
  - isForUpdate
```
public boolean isForUpdate()
```
    Whether this query is for update
    
    Specified by:
    
    isForUpdate in interface com.avaje.ebean.Query<T>

Class Model.Finder<I,T>

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Constructor Detail

Model.Finder

Model.Finder

Method Detail

on

all

byId

ref

filter

query

nextId

cancel

copy

fetch

fetch

fetch

fetch

filterMany

findFutureIds

findFutureList

findFutureRowCount

findIds

findList

findMap

findMap

findPagingList

findRowCount

findSet

findUnique

findVisit

findIterate

getExpressionFactory

getFirstRow

getGeneratedSql

getMaxRows

getRawSql

having

having

having

isAutofetchTuned

order

order

orderBy

orderBy

select

setAutofetch

setBackgroundFetchAfter

setBufferFetchSizeHint

setDistinct

setFirstRow

setId

setListener

setLoadBeanCache

setMapKey

setMaxRows

setOrder

setOrderBy

setParameter

setParameter

setQuery

setRawSql

setReadOnly

setTimeout

setUseCache

setUseQueryCache

where

where

where

setForUpdate

isForUpdate