Package | Description |
---|---|
org.jooq |
The
org.jooq package contains jOOQ's public API. |
org.jooq.impl |
The
org.jooq.impl package contains jOOQ's implementation classes. |
Modifier and Type | Method and Description |
---|---|
Param<?> |
DSLContext.extractParam(QueryPart part,
String name)
Get a named parameter from a
QueryPart , provided its name. |
Param<?> |
Query.getParam(String name)
Get a named parameter from the
Query , provided its name. |
Modifier and Type | Method and Description |
---|---|
Map<String,Param<?>> |
DSLContext.extractParams(QueryPart part)
Get a
Map of named parameters. |
Map<String,Param<?>> |
Query.getParams()
Get a
Map of named parameters. |
Modifier and Type | Method and Description |
---|---|
void |
SelectQuery.addLimit(int offset,
Param<Integer> numberOfRows)
Limit the results of this select using named parameters.
|
void |
SelectQuery.addLimit(Param<Integer> numberOfRows)
Limit the results of this select using named parameters.
|
void |
SelectQuery.addLimit(Param<Integer> offset,
int numberOfRows)
Limit the results of this select.
|
void |
SelectQuery.addLimit(Param<Integer> offset,
Param<Integer> numberOfRows)
Limit the results of this select using named parameters.
|
void |
SelectQuery.addLimit(Param<Integer> offset,
Param<Integer> numberOfRows)
Limit the results of this select using named parameters.
|
void |
SelectQuery.addOffset(Param<Integer> offset)
Add an
OFFSET clause to the query using a named parameter. |
SelectForUpdateStep<R> |
SelectLimitStep.limit(int offset,
Param<Integer> numberOfRows)
Add a
LIMIT clause to the query using named parameters
Note that some dialects do not support bind values at all in
LIMIT or TOP clauses! |
SelectForUpdateStep<R> |
SelectSeekLimitStep.limit(Param<Integer> numberOfRows)
Add a
LIMIT clause to the query using named parameters. |
SelectOffsetStep<R> |
SelectLimitStep.limit(Param<Integer> numberOfRows)
Add a
LIMIT clause to the query using named parameters
Note that some dialects do not support bind values at all in
LIMIT or TOP clauses! |
SelectForUpdateStep<R> |
SelectLimitAfterOffsetStep.limit(Param<Integer> numberOfRows)
Add a
LIMIT clause to the query using named parameters
Note that some dialects do not support bind values at all in
LIMIT or TOP clauses! |
SelectForUpdateStep<R> |
SelectLimitStep.limit(Param<Integer> offset,
int numberOfRows)
Add a
LIMIT clause to the query using named parameters
Note that some dialects do not support bind values at all in
LIMIT or TOP clauses! |
SelectForUpdateStep<R> |
SelectLimitStep.limit(Param<Integer> offset,
Param<Integer> numberOfRows)
Add a
LIMIT clause to the query using named parameters
Note that some dialects do not support bind values at all in
LIMIT or TOP clauses! |
SelectForUpdateStep<R> |
SelectLimitStep.limit(Param<Integer> offset,
Param<Integer> numberOfRows)
Add a
LIMIT clause to the query using named parameters
Note that some dialects do not support bind values at all in
LIMIT or TOP clauses! |
SelectForUpdateStep<R> |
SelectOffsetStep.offset(Param<Integer> offset)
Add an
OFFSET clause to the query using a named parameter. |
SelectLimitAfterOffsetStep<R> |
SelectLimitStep.offset(Param<Integer> offset)
Add an
OFFSET clause to the query using a named parameter
If there is no LIMIT .. |
Modifier and Type | Method and Description |
---|---|
Param<?> |
DefaultDSLContext.extractParam(QueryPart part,
String name) |
static Param<BigDecimal> |
DSL.inline(BigDecimal value)
Create a bind value that is always inlined.
|
static Param<BigInteger> |
DSL.inline(BigInteger value)
Create a bind value that is always inlined.
|
static Param<Boolean> |
DSL.inline(boolean value)
Create a bind value that is always inlined.
|
static Param<Boolean> |
DSL.inline(Boolean value)
Create a bind value that is always inlined.
|
static Param<Byte> |
DSL.inline(byte value)
Create a bind value that is always inlined.
|
static Param<Byte> |
DSL.inline(Byte value)
Create a bind value that is always inlined.
|
static Param<byte[]> |
DSL.inline(byte[] value)
Create a bind value that is always inlined.
|
static Param<String> |
DSL.inline(char character)
Create a bind value, that is always inlined.
|
static Param<String> |
DSL.inline(Character character)
Create a bind value, that is always inlined.
|
static Param<String> |
DSL.inline(CharSequence character)
Create a bind value, that is always inlined.
|
static Param<Date> |
DSL.inline(Date value)
Create a bind value that is always inlined.
|
static Param<Double> |
DSL.inline(double value)
Create a bind value that is always inlined.
|
static Param<Double> |
DSL.inline(Double value)
Create a bind value that is always inlined.
|
static Param<Float> |
DSL.inline(float value)
Create a bind value that is always inlined.
|
static Param<Float> |
DSL.inline(Float value)
Create a bind value that is always inlined.
|
static Param<Integer> |
DSL.inline(int value)
Create a bind value that is always inlined.
|
static Param<Integer> |
DSL.inline(Integer value)
Create a bind value that is always inlined.
|
static Param<java.time.LocalDate> |
DSL.inline(java.time.LocalDate value)
Create a bind value that is always inlined.
|
static Param<java.time.LocalDateTime> |
DSL.inline(java.time.LocalDateTime value)
Create a bind value that is always inlined.
|
static Param<java.time.LocalTime> |
DSL.inline(java.time.LocalTime value)
Create a bind value that is always inlined.
|
static Param<Long> |
DSL.inline(long value)
Create a bind value that is always inlined.
|
static Param<Long> |
DSL.inline(Long value)
Create a bind value that is always inlined.
|
static <T> Param<T> |
DSL.inline(Object value,
Class<T> type)
Create a bind value, that is always inlined.
|
static <T> Param<T> |
DSL.inline(Object value,
DataType<T> type)
Create a bind value, that is always inlined.
|
static <T> Param<T> |
DSL.inline(Object value,
Field<T> field)
Create a bind value, that is always inlined.
|
static Param<java.time.OffsetDateTime> |
DSL.inline(java.time.OffsetDateTime value)
Create a bind value that is always inlined.
|
static Param<java.time.OffsetTime> |
DSL.inline(java.time.OffsetTime value)
Create a bind value that is always inlined.
|
static Param<Short> |
DSL.inline(short value)
Create a bind value that is always inlined.
|
static Param<Short> |
DSL.inline(Short value)
Create a bind value that is always inlined.
|
static Param<String> |
DSL.inline(String value)
Create a bind value that is always inlined.
|
static <T> Param<T> |
DSL.inline(T value)
Create a bind value, that is always inlined.
|
static Param<Time> |
DSL.inline(Time value)
Create a bind value that is always inlined.
|
static Param<Timestamp> |
DSL.inline(Timestamp value)
Create a bind value that is always inlined.
|
static Param<UByte> |
DSL.inline(UByte value)
Create a bind value that is always inlined.
|
static Param<UInteger> |
DSL.inline(UInteger value)
Create a bind value that is always inlined.
|
static Param<ULong> |
DSL.inline(ULong value)
Create a bind value that is always inlined.
|
static Param<UShort> |
DSL.inline(UShort value)
Create a bind value that is always inlined.
|
static Param<UUID> |
DSL.inline(UUID value)
Create a bind value that is always inlined.
|
static Param<Integer> |
DSL.one()
A
1 literal. |
static <T> Param<Object> |
DSL.param()
Create an unnamed parameter with a generic type (
Object /
SQLDataType.OTHER ) and no initial value. |
static <T> Param<T> |
DSL.param(Class<T> type)
Create an unnamed parameter with a defined type and no initial value.
|
static <T> Param<T> |
DSL.param(DataType<T> type)
Create an unnamed parameter with a defined type and no initial value.
|
static <T> Param<T> |
DSL.param(Field<T> field)
Create an unnamed parameter with the defined type of another field and no
initial value.
|
static Param<Object> |
DSL.param(String name)
Create a named parameter with a generic type (
Object /
SQLDataType.OTHER ) and no initial value. |
static <T> Param<T> |
DSL.param(String name,
Class<T> type)
Create a named parameter with a defined type and no initial value.
|
static <T> Param<T> |
DSL.param(String name,
DataType<T> type)
Create a named parameter with a defined type and no initial value.
|
static <T> Param<T> |
DSL.param(String name,
Field<T> type)
Create a named parameter with a defined type of another field and no
initial value.
|
static <T> Param<T> |
DSL.param(String name,
T value)
Create a named parameter with an initial value.
|
static Param<Integer> |
DSL.two()
A
2 literal. |
static Param<BigDecimal> |
DSL.val(BigDecimal value)
Get a bind value.
|
static Param<BigInteger> |
DSL.val(BigInteger value)
Get a bind value.
|
static Param<Boolean> |
DSL.val(boolean value)
Get a bind value.
|
static Param<Boolean> |
DSL.val(Boolean value)
Get a bind value.
|
static Param<Byte> |
DSL.val(byte value)
Get a bind value.
|
static Param<Byte> |
DSL.val(Byte value)
Get a bind value.
|
static Param<byte[]> |
DSL.val(byte[] value)
Get a bind value.
|
static Param<Date> |
DSL.val(Date value)
Get a bind value.
|
static Param<Double> |
DSL.val(double value)
Get a bind value.
|
static Param<Double> |
DSL.val(Double value)
Get a bind value.
|
static Param<Float> |
DSL.val(float value)
Get a bind value.
|
static Param<Float> |
DSL.val(Float value)
Get a bind value.
|
static Param<Integer> |
DSL.val(int value)
Get a bind value.
|
static Param<Integer> |
DSL.val(Integer value)
Get a bind value.
|
static Param<java.time.LocalDate> |
DSL.val(java.time.LocalDate value)
Get a bind value.
|
static Param<java.time.LocalDateTime> |
DSL.val(java.time.LocalDateTime value)
Get a bind value.
|
static Param<java.time.LocalTime> |
DSL.val(java.time.LocalTime value)
Get a bind value.
|
static Param<Long> |
DSL.val(long value)
Get a bind value.
|
static Param<Long> |
DSL.val(Long value)
Get a bind value.
|
static <T> Param<T> |
DSL.val(Object value,
Class<T> type)
Get a bind value with an associated type, taken from a field.
|
static <T> Param<T> |
DSL.val(Object value,
DataType<T> type)
Get a bind value with an associated type.
|
static <T> Param<T> |
DSL.val(Object value,
Field<T> field)
Get a bind value with an associated type, taken from a field.
|
static Param<java.time.OffsetDateTime> |
DSL.val(java.time.OffsetDateTime value)
Get a bind value.
|
static Param<java.time.OffsetTime> |
DSL.val(java.time.OffsetTime value)
Get a bind value.
|
static Param<Short> |
DSL.val(short value)
Get a bind value.
|
static Param<Short> |
DSL.val(Short value)
Get a bind value.
|
static Param<String> |
DSL.val(String value)
Get a bind value.
|
static <T> Param<T> |
DSL.val(T value)
Get a bind value.
|
static Param<Time> |
DSL.val(Time value)
Get a bind value.
|
static Param<Timestamp> |
DSL.val(Timestamp value)
Get a bind value.
|
static Param<UByte> |
DSL.val(UByte value)
Get a bind value.
|
static Param<UInteger> |
DSL.val(UInteger value)
Get a bind value.
|
static Param<ULong> |
DSL.val(ULong value)
Get a bind value.
|
static Param<UShort> |
DSL.val(UShort value)
Get a bind value.
|
static Param<UUID> |
DSL.val(UUID value)
Get a bind value.
|
static Param<BigDecimal> |
DSL.value(BigDecimal value)
A synonym for
DSL.val(Object) to be used in Scala and Groovy, where
val is a reserved keyword. |
static Param<BigInteger> |
DSL.value(BigInteger value)
A synonym for
DSL.val(Object) to be used in Scala and Groovy, where
val is a reserved keyword. |
static Param<Boolean> |
DSL.value(boolean value)
A synonym for
DSL.val(Object) to be used in Scala and Groovy, where
val is a reserved keyword. |
static Param<Boolean> |
DSL.value(Boolean value)
A synonym for
DSL.val(Object) to be used in Scala and Groovy, where
val is a reserved keyword. |
static Param<Byte> |
DSL.value(byte value)
A synonym for
DSL.val(Object) to be used in Scala and Groovy, where
val is a reserved keyword. |
static Param<Byte> |
DSL.value(Byte value)
A synonym for
DSL.val(Object) to be used in Scala and Groovy, where
val is a reserved keyword. |
static Param<byte[]> |
DSL.value(byte[] value)
A synonym for
DSL.val(Object) to be used in Scala and Groovy, where
val is a reserved keyword. |
static Param<Date> |
DSL.value(Date value)
A synonym for
DSL.val(Object) to be used in Scala and Groovy, where
val is a reserved keyword. |
static Param<Double> |
DSL.value(double value)
A synonym for
DSL.val(Object) to be used in Scala and Groovy, where
val is a reserved keyword. |
static Param<Double> |
DSL.value(Double value)
A synonym for
DSL.val(Object) to be used in Scala and Groovy, where
val is a reserved keyword. |
static Param<Float> |
DSL.value(float value)
A synonym for
DSL.val(Object) to be used in Scala and Groovy, where
val is a reserved keyword. |
static Param<Float> |
DSL.value(Float value)
A synonym for
DSL.val(Object) to be used in Scala and Groovy, where
val is a reserved keyword. |
static Param<Integer> |
DSL.value(int value)
A synonym for
DSL.val(Object) to be used in Scala and Groovy, where
val is a reserved keyword. |
static Param<Integer> |
DSL.value(Integer value)
A synonym for
DSL.val(Object) to be used in Scala and Groovy, where
val is a reserved keyword. |
static Param<java.time.LocalDate> |
DSL.value(java.time.LocalDate value)
A synonym for
DSL.val(Object) to be used in Scala and Groovy, where
val is a reserved keyword. |
static Param<java.time.LocalDateTime> |
DSL.value(java.time.LocalDateTime value)
A synonym for
DSL.val(Object) to be used in Scala and Groovy, where
val is a reserved keyword. |
static Param<java.time.LocalTime> |
DSL.value(java.time.LocalTime value)
A synonym for
DSL.val(Object) to be used in Scala and Groovy, where
val is a reserved keyword. |
static Param<Long> |
DSL.value(long value)
A synonym for
DSL.val(Object) to be used in Scala and Groovy, where
val is a reserved keyword. |
static Param<Long> |
DSL.value(Long value)
A synonym for
DSL.val(Object) to be used in Scala and Groovy, where
val is a reserved keyword. |
static <T> Param<T> |
DSL.value(Object value,
Class<T> type)
A synonym for
DSL.val(Object, Class) to be used in Scala and Groovy, where
val is a reserved keyword. |
static <T> Param<T> |
DSL.value(Object value,
DataType<T> type)
A synonym for
DSL.val(Object, DataType) to be used in Scala and Groovy, where
val is a reserved keyword. |
static <T> Param<T> |
DSL.value(Object value,
Field<T> field)
A synonym for
DSL.val(Object, Field) to be used in Scala and Groovy, where
val is a reserved keyword. |
static Param<java.time.OffsetDateTime> |
DSL.value(java.time.OffsetDateTime value)
A synonym for
DSL.val(Object) to be used in Scala and Groovy, where
val is a reserved keyword. |
static Param<java.time.OffsetTime> |
DSL.value(java.time.OffsetTime value)
A synonym for
DSL.val(Object) to be used in Scala and Groovy, where
val is a reserved keyword. |
static Param<Short> |
DSL.value(short value)
A synonym for
DSL.val(Object) to be used in Scala and Groovy, where
val is a reserved keyword. |
static Param<Short> |
DSL.value(Short value)
A synonym for
DSL.val(Object) to be used in Scala and Groovy, where
val is a reserved keyword. |
static Param<String> |
DSL.value(String value)
A synonym for
DSL.val(Object) to be used in Scala and Groovy, where
val is a reserved keyword. |
static <T> Param<T> |
DSL.value(T value)
A synonym for
DSL.val(Object) to be used in Scala and Groovy, where
val is a reserved keyword. |
static Param<Time> |
DSL.value(Time value)
A synonym for
DSL.val(Object) to be used in Scala and Groovy, where
val is a reserved keyword. |
static Param<Timestamp> |
DSL.value(Timestamp value)
A synonym for
DSL.val(Object) to be used in Scala and Groovy, where
val is a reserved keyword. |
static Param<UByte> |
DSL.value(UByte value)
A synonym for
DSL.val(Object) to be used in Scala and Groovy, where
val is a reserved keyword. |
static Param<UInteger> |
DSL.value(UInteger value)
A synonym for
DSL.val(Object) to be used in Scala and Groovy, where
val is a reserved keyword. |
static Param<ULong> |
DSL.value(ULong value)
A synonym for
DSL.val(Object) to be used in Scala and Groovy, where
val is a reserved keyword. |
static Param<UShort> |
DSL.value(UShort value)
A synonym for
DSL.val(Object) to be used in Scala and Groovy, where
val is a reserved keyword. |
static Param<UUID> |
DSL.value(UUID value)
A synonym for
DSL.val(Object) to be used in Scala and Groovy, where
val is a reserved keyword. |
static Param<Integer> |
DSL.zero()
A
0 literal. |
Modifier and Type | Method and Description |
---|---|
Map<String,Param<?>> |
DefaultDSLContext.extractParams(QueryPart part) |
Copyright © 2016. All Rights Reserved.