| Package | Description |
|---|---|
| com.j256.ormlite.stmt |
SQL statement generation and processing.
|
| Modifier and Type | Field and Description |
|---|---|
protected Where<T,ID> |
StatementBuilder.where |
| Modifier and Type | Method and Description |
|---|---|
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)
AND operation which takes 2 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.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.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.
|
<OD> Where<T,ID> |
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)
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 (or more) 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> |
Where.reset()
Reset the Where object so it can be re-used.
|
Where<T,ID> |
StatementBuilder.where()
Creates and returns a new
Where object for this QueryBulder that can be used to add WHERE clauses to the
SQL statement. |
| Modifier and Type | Method and Description |
|---|---|
Where<T,ID> |
Where.and(Where<T,ID> first,
Where<T,ID> second)
AND operation which takes 2 arguments and AND's them together.
|
Where<T,ID> |
Where.and(Where<T,ID> first,
Where<T,ID> second)
AND operation which takes 2 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.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)
OR operation which takes 2 arguments and OR's them together.
|
Where<T,ID> |
Where.or(Where<T,ID> left,
Where<T,ID> right)
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 (or more) 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 (or more) 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 (or more) arguments and OR's them together.
|
void |
StatementBuilder.setWhere(Where<T,ID> where)
Set the
Where object on the query. |
This documentation is licensed by Gray Watson under the Creative Commons Attribution-Share Alike 3.0 License.