|
||||||||||
PREV NEXT | FRAMES NO FRAMES |
Packages that use Where | |
---|---|
com.j256.ormlite.stmt | SQL statement generation and processing. |
Uses of Where in com.j256.ormlite.stmt |
---|
Fields in com.j256.ormlite.stmt declared as Where | |
---|---|
protected Where<T,ID> |
StatementBuilder.where
|
Methods in com.j256.ormlite.stmt that return Where | ||
---|---|---|
Where<T,ID> |
Where.and()
AND operation which takes the previous clause and the next clause and AND's them together. |
|
Where<T,ID> |
Where.and(int numClauses)
This method needs to be used carefully. |
|
Where<T,ID> |
Where.and(Where<T,ID> first,
Where<T,ID> second,
Where<T,ID>... others)
AND operation which takes 2 (or more) arguments and AND's them together. |
|
Where<T,ID> |
Where.between(String columnName,
Object low,
Object high)
Add a BETWEEN clause so the column must be between the low and high parameters. |
|
Where<T,ID> |
Where.clear()
Clear out the Where object so it can be re-used. |
|
Where<T,ID> |
Where.eq(String columnName,
Object value)
Add a '=' clause so the column must be equal to the value. |
|
Where<T,ID> |
Where.exists(QueryBuilder<?,?> subQueryBuilder)
Add a EXISTS clause with a sub-query inside of parenthesis. |
|
Where<T,ID> |
Where.ge(String columnName,
Object value)
Add a '>=' clause so the column must be greater-than or equals-to the value. |
|
Where<T,ID> |
Where.gt(String columnName,
Object value)
Add a '>' clause so the column must be greater-than the value. |
|
|
Where.idEq(Dao<OD,?> dataDao,
OD data)
Add a clause where the ID is from an existing object. |
|
Where<T,ID> |
Where.idEq(ID id)
Add a clause where the ID is equal to the argument. |
|
Where<T,ID> |
Where.in(String columnName,
Iterable<?> objects)
Add a IN clause so the column must be equal-to one of the objects from the list passed in. |
|
Where<T,ID> |
Where.in(String columnName,
Object... objects)
Add a IN clause so the column must be equal-to one of the objects passed in. |
|
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.isNotNull(String columnName)
Add a 'IS NOT NULL' clause so the column must not be null. |
|
Where<T,ID> |
Where.isNull(String columnName)
Add a 'IS NULL' clause so the column must be null. |
|
Where<T,ID> |
Where.le(String columnName,
Object value)
Add a '<=' clause so the column must be less-than or equals-to the value. |
|
Where<T,ID> |
Where.like(String columnName,
Object value)
Add a LIKE clause so the column must mach the value using '%' patterns. |
|
Where<T,ID> |
Where.lt(String columnName,
Object value)
Add a '<' clause so the column must be less-than the value. |
|
Where<T,ID> |
Where.ne(String columnName,
Object value)
Add a '<>' clause so the column must be not-equal-to the value. |
|
Where<T,ID> |
Where.not()
Used to NOT the next clause specified. |
|
Where<T,ID> |
Where.not(Where<T,ID> comparison)
Used to NOT the argument clause specified. |
|
Where<T,ID> |
Where.notIn(String columnName,
Iterable<?> objects)
Same as in(String, Iterable) except with a NOT IN clause. |
|
Where<T,ID> |
Where.notIn(String columnName,
Object... objects)
Same as in(String, Object...) except with a NOT IN clause. |
|
Where<T,ID> |
Where.notIn(String columnName,
QueryBuilder<?,?> subQueryBuilder)
Same as in(String, QueryBuilder) except with a NOT IN clause. |
|
Where<T,ID> |
Where.or()
OR operation which takes the previous clause and the next clause and OR's them together. |
|
Where<T,ID> |
Where.or(int numClauses)
This method needs to be used carefully. |
|
Where<T,ID> |
Where.or(Where<T,ID> left,
Where<T,ID> right,
Where<T,ID>... others)
OR operation which takes 2 arguments and OR's them together. |
|
Where<T,ID> |
Where.raw(String rawStatement,
ArgumentHolder... args)
Add a raw statement as part of the where that can be anything that the database supports. |
|
Where<T,ID> |
Where.rawComparison(String columnName,
String rawOperator,
Object value)
Make a comparison where the operator is specified by the caller. |
|
Where<T,ID> |
StatementBuilder.where()
Returns a Where object that should be used to add SQL where clauses to the statement. |
Methods in com.j256.ormlite.stmt with parameters of type Where | |
---|---|
Where<T,ID> |
Where.and(Where<T,ID> first,
Where<T,ID> second,
Where<T,ID>... others)
AND operation which takes 2 (or more) arguments and AND's them together. |
Where<T,ID> |
Where.and(Where<T,ID> first,
Where<T,ID> second,
Where<T,ID>... others)
AND operation which takes 2 (or more) arguments and AND's them together. |
Where<T,ID> |
Where.and(Where<T,ID> first,
Where<T,ID> second,
Where<T,ID>... others)
AND operation which takes 2 (or more) arguments and AND's them together. |
Where<T,ID> |
Where.not(Where<T,ID> comparison)
Used to NOT the argument clause specified. |
Where<T,ID> |
Where.or(Where<T,ID> left,
Where<T,ID> right,
Where<T,ID>... others)
OR operation which takes 2 arguments and OR's them together. |
Where<T,ID> |
Where.or(Where<T,ID> left,
Where<T,ID> right,
Where<T,ID>... others)
OR operation which takes 2 arguments and OR's them together. |
Where<T,ID> |
Where.or(Where<T,ID> left,
Where<T,ID> right,
Where<T,ID>... others)
OR operation which takes 2 arguments and OR's them together. |
void |
StatementBuilder.setWhere(Where<T,ID> where)
Set the Where object on the query. |
|
||||||||||
PREV NEXT | FRAMES NO FRAMES |