org.jooq

Interface Param<T>

All Superinterfaces:

Field<T>, FieldOrRow, GroupField, OrderField<T>, QueryPart, SelectField<T>, java.io.Serializable

public interface Param<T>
extends Field<T>

A named parameter and/or bind value.

Author:

Lukas Eder

See Also:

DSL.param(String, Object)

Method Summary

Modifier and Type	Method and Description
java.lang.String	getName() The name of the field.
ParamMode	getParamMode() The parameter mode.
java.lang.String	getParamName() The parameter name.
ParamType	getParamType() The parameter type.
T	getValue() Get the parameter's underlying value.
boolean	isInline() A flag on the bind value to force it to be inlined in rendered SQL
void	setConverted(java.lang.Object value) Deprecated. - 3.8.0 - [#4991] In jOOQ 4.0, Param will be made immutable. Modifying Param values is strongly discouraged.
void	setInline(boolean inline) Deprecated. - 3.8.0 - [#4991] In jOOQ 4.0, Param will be made immutable. Modifying Param values is strongly discouraged.
void	setValue(T value) Deprecated. - 3.8.0 - [#4991] In jOOQ 4.0, Param will be made immutable. Modifying Param values is strongly discouraged.

Methods inherited from interface org.jooq.Field

abs, acos, add, add, as, as, as, as, asc, ascii, asin, atan, atan2, atan2, avg, avgOver, between, between, between, between, betweenSymmetric, betweenSymmetric, betweenSymmetric, betweenSymmetric, bitAnd, bitAnd, bitLength, bitNand, bitNand, bitNor, bitNor, bitNot, bitOr, bitOr, bitXNor, bitXNor, bitXor, bitXor, cast, cast, cast, ceil, changed, charLength, coalesce, coalesce, coerce, coerce, coerce, compare, compare, compare, compare, concat, concat, contains, contains, containsIgnoreCase, containsIgnoreCase, cos, cosh, cot, coth, count, countDistinct, countOver, decode, decode, decode, decode, deg, desc, div, div, divide, divide, endsWith, endsWith, eq, eq, eq, eq, equal, equal, equal, equal, equalIgnoreCase, equalIgnoreCase, equals, exp, extract, field, firstValue, floor, from, ge, ge, ge, ge, get, getBinding, getComment, getConverter, getDataType, getDataType, getQualifiedName, getType, getUnqualifiedName, getValue, greaterOrEqual, greaterOrEqual, greaterOrEqual, greaterOrEqual, greaterThan, greaterThan, greaterThan, greaterThan, greatest, greatest, gt, gt, gt, gt, in, in, in, in, in, isDistinctFrom, isDistinctFrom, isFalse, isNotDistinctFrom, isNotDistinctFrom, isNotNull, isNull, isTrue, lag, lag, lag, lag, lastValue, le, le, le, le, lead, lead, lead, lead, least, least, length, lessOrEqual, lessOrEqual, lessOrEqual, lessOrEqual, lessThan, lessThan, lessThan, lessThan, like, like, like, like, likeIgnoreCase, likeIgnoreCase, likeIgnoreCase, likeIgnoreCase, likeRegex, likeRegex, ln, log, lower, lpad, lpad, lpad, lpad, lt, lt, lt, lt, ltrim, max, maxOver, median, min, minOver, minus, minus, mod, mod, modulo, modulo, mul, mul, multiply, multiply, ne, ne, ne, ne, neg, notBetween, notBetween, notBetween, notBetween, notBetweenSymmetric, notBetweenSymmetric, notBetweenSymmetric, notBetweenSymmetric, notContains, notContains, notContainsIgnoreCase, notContainsIgnoreCase, notEqual, notEqual, notEqual, notEqual, notEqualIgnoreCase, notEqualIgnoreCase, notIn, notIn, notIn, notIn, notIn, notLike, notLike, notLike, notLike, notLikeIgnoreCase, notLikeIgnoreCase, notLikeIgnoreCase, notLikeIgnoreCase, notLikeRegex, notLikeRegex, nullif, nullif, nvl, nvl, nvl2, nvl2, octetLength, original, plus, plus, plus, position, position, pow, pow, power, power, rad, rem, rem, repeat, repeat, replace, replace, replace, replace, reset, round, round, rpad, rpad, rpad, rpad, rtrim, shl, shl, shr, shr, sign, sin, sinh, sort, sort, sortAsc, sortAsc, sortDefault, sortDesc, sortDesc, sqrt, startsWith, startsWith, stddevPop, stddevPopOver, stddevSamp, stddevSampOver, sub, sub, substring, substring, substring, substring, subtract, subtract, sum, sumOver, tan, tanh, times, times, trim, unaryMinus, unaryPlus, upper, varPop, varPopOver, varSamp, varSampOver

Methods inherited from interface org.jooq.QueryPart

hashCode, toString

Method Detail

getName

java.lang.String getName()

The name of the field.

The name is any of these:

• The formal name of the field, if it is a physical table/view field
• The alias of an aliased field
• A generated / unspecified value for any other expression
• The name of a parameter if it is a named Param

The Param's value for getName() coincides with getParamName()

Specified by:

getName in interface Field<T>

Specified by:

getName in interface SelectField<T>

getParamName

java.lang.String getParamName()

The parameter name. This name is useful for two things:

• Named parameters in frameworks that support them, such as Spring's JdbcTemplate
• Accessing the parameter from the Query API, with Query.getParam(String), Query.getParams()

getValue

T getValue()

Get the parameter's underlying value. This returns null if no value has been set yet.

setValue

@Deprecated
void setValue(T value)

Deprecated. - 3.8.0 - [#4991] In jOOQ 4.0, Param will be made immutable. Modifying Param values is strongly discouraged.

Set the parameter's underlying value. This is the same as setConverted(Object), but ensures generic type-safety.

See Also:

setConverted(Object)

setConverted

@Deprecated
void setConverted(java.lang.Object value)
                        throws DataTypeException

Deprecated. - 3.8.0 - [#4991] In jOOQ 4.0, Param will be made immutable. Modifying Param values is strongly discouraged.

Sets a converted value, using this Param's underlying DataType, obtained from Field.getDataType()

Throws:

DataTypeException - If value cannot be converted into this parameter's data type.

See Also:

DataType.convert(Object), Convert.convert(Object, Class)

setInline

@Deprecated
void setInline(boolean inline)

Deprecated. - 3.8.0 - [#4991] In jOOQ 4.0, Param will be made immutable. Modifying Param values is strongly discouraged.

A flag on the bind value to force it to be inlined in rendered SQL

isInline

boolean isInline()

A flag on the bind value to force it to be inlined in rendered SQL

getParamType

ParamType getParamType()

The parameter type.

getParamMode

ParamMode getParamMode()

The parameter mode.