Package | Description |
---|---|
org.jooq |
The
org.jooq package contains jOOQ's public API
This package mostly contains interfaces that are implemented by the
org.jooq.impl package. |
org.jooq.impl |
The
org.jooq.impl package contains jOOQ's implementation classes
This package provides implementations for the jOOQ API from
org.jooq , whose interfaces are constructed mostly through the
Factory class, which hides implementation facts from
the public API |
Modifier and Type | Method and Description |
---|---|
Select<R> |
Select.except(Select<R> select)
Combine with other selects
|
Select<R> |
Select.intersect(Select<R> select)
Combine with other selects
|
Select<R> |
Select.union(Select<R> select)
Combine with other selects
|
Select<R> |
Select.unionAll(Select<R> select)
Combine with other selects
|
Modifier and Type | Method and Description |
---|---|
UpdateConditionStep<R> |
UpdateConditionStep.andExists(Select<?> select)
Combine the currently assembled conditions with an EXISTS clause using
the
Operator.AND operator |
TableOnConditionStep |
TableOnConditionStep.andExists(Select<?> select)
Combine the currently assembled conditions with an
EXISTS
clause using the Operator.AND operator. |
SimpleSelectConditionStep<R> |
SimpleSelectConditionStep.andExists(Select<?> select)
Combine the currently assembled conditions with an EXISTS clause using
the
Operator.AND operator and proceed to the next step. |
SelectOnConditionStep |
SelectOnConditionStep.andExists(Select<?> select)
Combine the currently assembled conditions with an EXISTS clause using
the
Operator.AND operator and proceed to the next step. |
SelectHavingConditionStep |
SelectHavingConditionStep.andExists(Select<?> select)
Combine the currently assembled conditions with an EXISTS clause using
the
Operator.AND operator and proceed to the next step. |
SelectConditionStep |
SelectConditionStep.andExists(Select<?> select)
Combine the currently assembled conditions with an EXISTS clause using
the
Operator.AND operator and proceed to the next step. |
MergeOnConditionStep<R> |
MergeOnConditionStep.andExists(Select<?> select)
Combine the currently assembled conditions with an EXISTS clause using
the
Operator.AND operator and proceed to the next step. |
DivideByOnConditionStep |
DivideByOnConditionStep.andExists(Select<?> select)
Combine the currently assembled conditions with an
EXISTS
clause using the Operator.AND operator. |
DeleteConditionStep<R> |
DeleteConditionStep.andExists(Select<?> select)
Combine the currently assembled conditions with an EXISTS clause using
the
Operator.AND operator |
Condition |
Condition.andExists(Select<?> select)
Combine this condition with an EXISTS clause using the
Operator.AND operator. |
UpdateConditionStep<R> |
UpdateConditionStep.andNotExists(Select<?> select)
Combine the currently assembled conditions with a NOT EXISTS clause using
the
Operator.AND operator |
TableOnConditionStep |
TableOnConditionStep.andNotExists(Select<?> select)
Combine the currently assembled conditions with a
NOT EXISTS
clause using the Operator.AND operator. |
SimpleSelectConditionStep<R> |
SimpleSelectConditionStep.andNotExists(Select<?> select)
Combine the currently assembled conditions with a NOT EXISTS clause using
the
Operator.AND operator and proceed to the next step. |
SelectOnConditionStep |
SelectOnConditionStep.andNotExists(Select<?> select)
Combine the currently assembled conditions with a NOT EXISTS clause using
the
Operator.AND operator and proceed to the next step. |
SelectHavingConditionStep |
SelectHavingConditionStep.andNotExists(Select<?> select)
Combine the currently assembled conditions with a NOT EXISTS clause using
the
Operator.AND operator and proceed to the next step. |
SelectConditionStep |
SelectConditionStep.andNotExists(Select<?> select)
Combine the currently assembled conditions with a NOT EXISTS clause using
the
Operator.AND operator and proceed to the next step. |
MergeOnConditionStep<R> |
MergeOnConditionStep.andNotExists(Select<?> select)
Combine the currently assembled conditions with a NOT EXISTS clause using
the
Operator.AND operator and proceed to the next step. |
DivideByOnConditionStep |
DivideByOnConditionStep.andNotExists(Select<?> select)
Combine the currently assembled conditions with a
NOT EXISTS
clause using the Operator.AND operator. |
DeleteConditionStep<R> |
DeleteConditionStep.andNotExists(Select<?> select)
Combine the currently assembled conditions with a NOT EXISTS clause using
the
Operator.AND operator |
Condition |
Condition.andNotExists(Select<?> select)
Combine this condition with a NOT EXIST clause using the
Operator.AND operator. |
Condition |
Field.eq(Select<?> query)
this = (Select |
Condition |
Field.equal(Select<?> query)
this = (Select |
Condition |
Field.equalAll(Select<?> query)
this = all (Select |
Condition |
Field.equalAny(Select<?> query)
this = any (Select |
Condition |
Field.equalSome(Select<?> query)
Deprecated.
- 2.0.2 - Use
Field.equalAny(Select) instead |
Select<R> |
Select.except(Select<R> select)
Combine with other selects
|
Condition |
Field.ge(Select<?> query)
this >= (Select |
Condition |
Field.greaterOrEqual(Select<?> query)
this >= (Select |
Condition |
Field.greaterOrEqualAll(Select<?> query)
this >= all (Select |
Condition |
Field.greaterOrEqualAny(Select<?> query)
this >= any (Select |
Condition |
Field.greaterOrEqualSome(Select<?> query)
Deprecated.
- 2.0.2 - Use
Field.greaterOrEqualAny(Select) instead |
Condition |
Field.greaterThan(Select<?> query)
this > (Select |
Condition |
Field.greaterThanAll(Select<?> query)
this > all (Select |
Condition |
Field.greaterThanAny(Select<?> query)
this > any (Select |
Condition |
Field.greaterThanSome(Select<?> query)
Deprecated.
- 2.0.2 - Use
Field.greaterThanAny(Select) instead |
Condition |
Field.gt(Select<?> query)
this > (Select |
Condition |
Row.in(Select<?> select)
Compare this row value expression with a subselect for equality
Note that the subquery must return a table of the same degree as this row
value expression.
|
Condition |
Field.in(Select<?> query)
Create a condition to check this field against a subquery
Note that the subquery must return exactly one field.
|
<R extends Record> |
FactoryOperations.insertInto(Table<R> into,
Select<?> select)
Deprecated.
- 2.0.3 - Use any of these methods instead:
|
Select<R> |
Select.intersect(Select<R> select)
Combine with other selects
|
Condition |
Field.le(Select<?> query)
this <= (Select |
Condition |
Field.lessOrEqual(Select<?> query)
this <= (Select |
Condition |
Field.lessOrEqualAll(Select<?> query)
this <= all (Select |
Condition |
Field.lessOrEqualAny(Select<?> query)
this <= any (Select |
Condition |
Field.lessOrEqualSome(Select<?> query)
Deprecated.
- 2.0.2 - Use
Field.lessOrEqualAny(Select) instead |
Condition |
Field.lessThan(Select<?> query)
this < (Select |
Condition |
Field.lessThanAll(Select<?> query)
this < all (Select |
Condition |
Field.lessThanAny(Select<?> query)
this < any (Select |
Condition |
Field.lessThanSome(Select<?> query)
Deprecated.
- 2.0.2 - Use
Field.lessThanAny(Select) instead |
Condition |
Field.lt(Select<?> query)
this < (Select |
Condition |
Field.ne(Select<?> query)
this ! |
Condition |
Field.notEqual(Select<?> query)
this ! |
Condition |
Field.notEqualAll(Select<?> query)
this ! |
Condition |
Field.notEqualAny(Select<?> query)
this ! |
Condition |
Field.notEqualSome(Select<?> query)
Deprecated.
- 2.0.2 - Use
Field.notEqualAny(Select) instead |
Condition |
Row.notIn(Select<?> select)
Compare this row value expression with a subselect for non-equality
Note that the subquery must return a table of the same degree as this row
value expression.
|
Condition |
Field.notIn(Select<?> query)
Create a condition to check this field against a subquery
Note that the subquery must return exactly one field.
|
UpdateConditionStep<R> |
UpdateConditionStep.orExists(Select<?> select)
Combine the currently assembled conditions with an EXISTS clause using
the
Operator.OR operator |
TableOnConditionStep |
TableOnConditionStep.orExists(Select<?> select)
Combine the currently assembled conditions with an
EXISTS
clause using the Operator.OR operator. |
SimpleSelectConditionStep<R> |
SimpleSelectConditionStep.orExists(Select<?> select)
Combine the currently assembled conditions with an EXISTS clause using
the
Operator.OR operator and proceed to the next step. |
SelectOnConditionStep |
SelectOnConditionStep.orExists(Select<?> select)
Combine the currently assembled conditions with an EXISTS clause using
the
Operator.OR operator and proceed to the next step. |
SelectHavingConditionStep |
SelectHavingConditionStep.orExists(Select<?> select)
Combine the currently assembled conditions with an EXISTS clause using
the
Operator.OR operator and proceed to the next step. |
SelectConditionStep |
SelectConditionStep.orExists(Select<?> select)
Combine the currently assembled conditions with an EXISTS clause using
the
Operator.OR operator and proceed to the next step. |
MergeOnConditionStep<R> |
MergeOnConditionStep.orExists(Select<?> select)
Combine the currently assembled conditions with an EXISTS clause using
the
Operator.OR operator and proceed to the next step. |
DivideByOnConditionStep |
DivideByOnConditionStep.orExists(Select<?> select)
Combine the currently assembled conditions with an
EXISTS
clause using the Operator.OR operator. |
DeleteConditionStep<R> |
DeleteConditionStep.orExists(Select<?> select)
Combine the currently assembled conditions with an EXISTS clause using
the
Operator.OR operator |
Condition |
Condition.orExists(Select<?> select)
Combine this condition with an EXISTS clause using the
Operator.OR operator. |
UpdateConditionStep<R> |
UpdateConditionStep.orNotExists(Select<?> select)
Combine the currently assembled conditions with a NOT EXISTS clause using
the
Operator.OR operator |
TableOnConditionStep |
TableOnConditionStep.orNotExists(Select<?> select)
Combine the currently assembled conditions with a
NOT EXISTS
clause using the Operator.OR operator. |
SimpleSelectConditionStep<R> |
SimpleSelectConditionStep.orNotExists(Select<?> select)
Combine the currently assembled conditions with a NOT EXISTS clause using
the
Operator.OR operator and proceed to the next step. |
SelectOnConditionStep |
SelectOnConditionStep.orNotExists(Select<?> select)
Combine the currently assembled conditions with a NOT EXISTS clause using
the
Operator.OR operator and proceed to the next step. |
SelectHavingConditionStep |
SelectHavingConditionStep.orNotExists(Select<?> select)
Combine the currently assembled conditions with a NOT EXISTS clause using
the
Operator.OR operator and proceed to the next step. |
SelectConditionStep |
SelectConditionStep.orNotExists(Select<?> select)
Combine the currently assembled conditions with a NOT EXISTS clause using
the
Operator.OR operator and proceed to the next step. |
MergeOnConditionStep<R> |
MergeOnConditionStep.orNotExists(Select<?> select)
Combine the currently assembled conditions with a NOT EXISTS clause using
the
Operator.OR operator and proceed to the next step. |
DivideByOnConditionStep |
DivideByOnConditionStep.orNotExists(Select<?> select)
Combine the currently assembled conditions with a
NOT EXISTS
clause using the Operator.OR operator. |
DeleteConditionStep<R> |
DeleteConditionStep.orNotExists(Select<?> select)
Combine the currently assembled conditions with a NOT EXISTS clause using
the
Operator.OR operator |
Condition |
Condition.orNotExists(Select<?> select)
Combine this condition with a NOT EXIST clause using the
Operator.OR operator. |
Merge<R> |
MergeValuesStep.select(Select<?> select)
Use a
SELECT statement as the source of values for the
MERGE statement
This variant of the MERGE .. |
Insert<R> |
InsertValuesStep.select(Select<?> select)
Use a
SELECT statement as the source of values for the
INSERT statement
This variant of the INSERT .. |
Insert<R> |
InsertSetStep.select(Select<?> select)
Use a
SELECT statement as the source of values for the
INSERT statement
This variant of the INSERT .. |
Select<R> |
Select.union(Select<R> select)
Combine with other selects
|
Select<R> |
Select.unionAll(Select<R> select)
Combine with other selects
|
UpdateConditionStep<R> |
UpdateWhereStep.whereExists(Select<?> select)
Add an EXISTS clause to the query
|
SimpleSelectConditionStep<R> |
SimpleSelectWhereStep.whereExists(Select<?> select)
Add a
WHERE EXISTS clause to the query |
SelectConditionStep |
SelectWhereStep.whereExists(Select<?> select)
Add a
WHERE EXISTS clause to the query |
DeleteConditionStep<R> |
DeleteWhereStep.whereExists(Select<?> select)
Add an EXISTS clause to the query
|
UpdateConditionStep<R> |
UpdateWhereStep.whereNotExists(Select<?> select)
Add a NOT EXISTS clause to the query
|
SimpleSelectConditionStep<R> |
SimpleSelectWhereStep.whereNotExists(Select<?> select)
Add a
WHERE NOT EXISTS clause to the query |
SelectConditionStep |
SelectWhereStep.whereNotExists(Select<?> select)
Add a
WHERE NOT EXISTS clause to the query |
DeleteConditionStep<R> |
DeleteWhereStep.whereNotExists(Select<?> select)
Add a NOT EXISTS clause to the query
|
Modifier and Type | Method and Description |
---|---|
static Condition |
Factory.exists(Select<?> query)
Create an exists condition.
|
<R extends Record> |
FactoryProxy.insertInto(Table<R> into,
Select<?> select)
Deprecated.
|
<R extends Record> |
Factory.insertInto(Table<R> into,
Select<?> select)
Deprecated.
|
static Condition |
Factory.notExists(Select<?> query)
Create a not exists condition.
|
static <R extends Record> |
Factory.table(Select<R> select)
A synonym for
TableLike.asTable() . |
Copyright © 2013. All Rights Reserved.