|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
R
- The record type being returned by this querypublic interface SimpleSelectConditionStep<R extends Record>
This type is used for the Select
's DSL API when selecting specific
Record
types.
Example:
Refer to the manual for more details
create.selectFrom(T_AUTHOR)
.where(TBook.LANGUAGE.equal("DE"))
.and(TBook.PUBLISHED.greaterThan(parseDate('2008-01-01')))
.orderBy(TAuthor.LAST_NAME.asc().nullsFirst())
.limit(2)
.offset(1)
.forUpdate()
.of(TAuthor.FIRST_NAME, TAuthor.LAST_NAME)
.noWait();
Method Summary | |
---|---|
SimpleSelectConditionStep<R> |
and(Condition condition)
Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step. |
SimpleSelectConditionStep<R> |
and(String sql)
Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step. |
SimpleSelectConditionStep<R> |
and(String sql,
Object... bindings)
Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step. |
SimpleSelectConditionStep<R> |
and(String sql,
QueryPart... parts)
Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step. |
SimpleSelectConditionStep<R> |
andExists(Select<?> select)
Combine the currently assembled conditions with an EXISTS clause using the Operator.AND operator and proceed to the next step. |
SimpleSelectConditionStep<R> |
andNot(Condition condition)
Combine the currently assembled conditions with a negated other one using the Operator.AND operator and proceed to the next step. |
SimpleSelectConditionStep<R> |
andNotExists(Select<?> select)
Combine the currently assembled conditions with a NOT EXISTS clause using the Operator.AND operator and proceed to the next step. |
SimpleSelectConditionStep<R> |
or(Condition condition)
Combine the currently assembled conditions with another one using the Operator.OR operator and proceed to the next step. |
SimpleSelectConditionStep<R> |
or(String sql)
Combine the currently assembled conditions with another one using the Operator.OR operator and proceed to the next step. |
SimpleSelectConditionStep<R> |
or(String sql,
Object... bindings)
Combine the currently assembled conditions with another one using the Operator.OR operator and proceed to the next step. |
SimpleSelectConditionStep<R> |
or(String sql,
QueryPart... parts)
Combine the currently assembled conditions with another one using the Operator.OR operator and proceed to the next step. |
SimpleSelectConditionStep<R> |
orExists(Select<?> select)
Combine the currently assembled conditions with an EXISTS clause using the Operator.OR operator and proceed to the next step. |
SimpleSelectConditionStep<R> |
orNot(Condition condition)
Combine the currently assembled conditions with a negated other one using the Operator.OR operator and proceed to the next step. |
SimpleSelectConditionStep<R> |
orNotExists(Select<?> select)
Combine the currently assembled conditions with a NOT EXISTS clause using the Operator.OR operator and proceed to the next step. |
Methods inherited from interface org.jooq.SimpleSelectOrderByStep |
---|
orderBy, orderBy, orderBy, orderBy, orderSiblingsBy, orderSiblingsBy, orderSiblingsBy, orderSiblingsBy |
Methods inherited from interface org.jooq.SimpleSelectLimitStep |
---|
limit, limit, limit, limit, limit, limit |
Methods inherited from interface org.jooq.SimpleSelectForUpdateStep |
---|
forShare, forUpdate |
Methods inherited from interface org.jooq.SimpleSelectFinalStep |
---|
getQuery |
Methods inherited from interface org.jooq.Select |
---|
except, getSelect, intersect, union, unionAll |
Methods inherited from interface org.jooq.ResultQuery |
---|
bind, bind, fetch, fetch, fetch, fetch, fetch, fetch, fetch, fetch, fetch, fetch, fetchAny, fetchArray, fetchArray, fetchArray, fetchArray, fetchArray, fetchArray, fetchArray, fetchArray, fetchArray, fetchArrays, fetchGroups, fetchGroups, fetchInto, fetchInto, fetchInto, fetchLater, fetchLater, fetchLazy, fetchLazy, fetchMany, fetchMap, fetchMap, fetchMaps, fetchOne, fetchOne, fetchOne, fetchOne, fetchOne, fetchOne, fetchOne, fetchOne, fetchOne, fetchOne, fetchOneArray, fetchOneMap, fetchResultSet, getRecordType, getResult |
Methods inherited from interface org.jooq.Query |
---|
execute, getBindValues, getParam, getParams, getSQL, getSQL, isExecutable |
Methods inherited from interface org.jooq.QueryPart |
---|
attach |
Methods inherited from interface org.jooq.Adapter |
---|
internalAPI |
Methods inherited from interface org.jooq.TableLike |
---|
asTable, asTable |
Methods inherited from interface org.jooq.FieldLike |
---|
asField, asField |
Methods inherited from interface org.jooq.FieldProvider |
---|
getField, getField, getField, getFields, getIndex |
Method Detail |
---|
SimpleSelectConditionStep<R> and(Condition condition)
Operator.AND
operator and proceed to the next step.
SimpleSelectConditionStep<R> and(String sql)
Operator.AND
operator and proceed to the next step.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
Factory.condition(String)
SimpleSelectConditionStep<R> and(String sql, Object... bindings)
Operator.AND
operator and proceed to the next step.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
Factory.condition(String, Object...)
SimpleSelectConditionStep<R> and(String sql, QueryPart... parts)
Operator.AND
operator and proceed to the next step.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
Factory.condition(String, QueryPart...)
SimpleSelectConditionStep<R> andNot(Condition condition)
Operator.AND
operator and proceed to the next step.
SimpleSelectConditionStep<R> andExists(Select<?> select)
Operator.AND
operator and proceed to the next step.
SimpleSelectConditionStep<R> andNotExists(Select<?> select)
Operator.AND
operator and proceed to the next step.
SimpleSelectConditionStep<R> or(Condition condition)
Operator.OR
operator and proceed to the next step.
SimpleSelectConditionStep<R> or(String sql)
Operator.OR
operator and proceed to the next step.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
Factory.condition(String)
SimpleSelectConditionStep<R> or(String sql, Object... bindings)
Operator.OR
operator and proceed to the next step.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
Factory.condition(String, Object...)
SimpleSelectConditionStep<R> or(String sql, QueryPart... parts)
Operator.OR
operator and proceed to the next step.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
Factory.condition(String, QueryPart...)
SimpleSelectConditionStep<R> orNot(Condition condition)
Operator.OR
operator and proceed to the next step.
SimpleSelectConditionStep<R> orExists(Select<?> select)
Operator.OR
operator and proceed to the next step.
SimpleSelectConditionStep<R> orNotExists(Select<?> select)
Operator.OR
operator and proceed to the next step.
|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |