Top Description Constructors Methods
org.jooq.impl

pack-priv final Class CaseImpl

extends Object
implements Case, UTransient
Class Inheritance
All Implemented Interfaces
org.jooq.impl.QOM.UTransient, org.jooq.impl.QOM.UEmpty, org.jooq.QueryPart, java.io.Serializable, org.jooq.Case
Imports
org.jooq.Case, .CaseConditionStep, .CaseValueStep, .Condition, .Field, .Record1, .Select, org.jooq.impl.QOM.UTransient
A transient step in the construction of CASE statements.
Author
Lukas Eder

Constructor Summary

AccessConstructor and Description
pack-priv
CaseImpl()

Method Summary

Modifier and TypeMethod and Description
public final <V> CaseValueStep<V>
value(V
The value to do the case statement on
value)

Implements org.jooq.Case.value.

This construct can be used to create expressions of the type 

CASE value WHEN 1 THEN 'one'
           WHEN 2 THEN 'two'
           ELSE        'three'
END
public final <V> CaseValueStep<V>
value(Field<V>
The value to do the case statement on
value)

Implements org.jooq.Case.value, org.jooq.Case.value.

Deprecated as a consequence of Field being deprecated.
This construct can be used to create expressions of the type 

CASE value WHEN 1 THEN 'one'
           WHEN 2 THEN 'two'
           ELSE        'three'
END
public final <T> CaseConditionStep<T>
when(Condition
A condition to check in the case statement
condition, T
The result if the condition holds true
result)

Implements org.jooq.Case.when.

Deprecated as a consequence of Condition and CaseConditionStep being deprecated.
This construct can be used to create expressions of the type 

CASE WHEN x < 1  THEN 'one'
     WHEN x >= 2 THEN 'two'
     ELSE            'three'
END
public final <T> CaseConditionStep<T>
when(Condition
A condition to check in the case statement
condition, Field<T>
The result if the condition holds true
result)

Implements org.jooq.Case.when, org.jooq.Case.when.

Deprecated as a consequence of Condition, Field and CaseConditionStep being deprecated.
This construct can be used to create expressions of the type 

CASE WHEN x < 1  THEN 'one'
     WHEN x >= 2 THEN 'two'
     ELSE            'three'
END
public final <T> CaseConditionStep<T>
when(Condition
A condition to check in the case statement
condition, Select<? extends Record1<T>>
The result if the condition holds true
result)

Implements org.jooq.Case.when, org.jooq.Case.when.

Deprecated as a consequence of Condition and CaseConditionStep being deprecated.
This construct can be used to create expressions of the type 

CASE WHEN x < 1  THEN 'one'
     WHEN x >= 2 THEN 'two'
     ELSE            'three'
END
public final <T> CaseConditionStep<T>
when(Field<Boolean>
A condition to check in the case statement
condition, T
The result if the condition holds true
result)

Implements org.jooq.Case.when.

Deprecated as a consequence of Field and CaseConditionStep being deprecated.
This construct can be used to create expressions of the type 

CASE WHEN x < 1  THEN 'one'
     WHEN x >= 2 THEN 'two'
     ELSE            'three'
END
public final <T> CaseConditionStep<T>
when(Field<Boolean>
A condition to check in the case statement
condition, Field<T>
The result if the condition holds true
result)

Implements org.jooq.Case.when, org.jooq.Case.when.

Deprecated as a consequence of Field and CaseConditionStep being deprecated.
This construct can be used to create expressions of the type 

CASE WHEN x < 1  THEN 'one'
     WHEN x >= 2 THEN 'two'
     ELSE            'three'
END
public final <T> CaseConditionStep<T>
when(Field<Boolean>
A condition to check in the case statement
condition, Select<? extends Record1<T>>
The result if the condition holds true
result)

Implements org.jooq.Case.when, org.jooq.Case.when.

Deprecated as a consequence of Field and CaseConditionStep being deprecated.
This construct can be used to create expressions of the type 

CASE WHEN x < 1  THEN 'one'
     WHEN x >= 2 THEN 'two'
     ELSE            'three'
END
Inherited from java.lang.Object:
cloneequalsfinalizegetClasshashCodenotifynotifyAlltoStringwaitwaitwait

Constructor Detail

CaseImplback to summary
pack-priv CaseImpl()

Method Detail

valueback to summary
public final <V> CaseValueStep<V> value(V value)

Implements org.jooq.Case.value.

Doc from org.jooq.Case.value.

This construct can be used to create expressions of the type 


CASE value WHEN 1 THEN 'one'
           WHEN 2 THEN 'two'
           ELSE        'three'
END
Parameters
<V>
The generic value type parameter
value:V

The value to do the case statement on

Returns:CaseValueStep<V>

An intermediary step for case statement construction

Annotations
@Override
valueback to summary
public final <V> CaseValueStep<V> value(Field<V> value)

Implements org.jooq.Case.value, org.jooq.Case.value.

Doc from org.jooq.Case.value.

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

This construct can be used to create expressions of the type 


CASE value WHEN 1 THEN 'one'
           WHEN 2 THEN 'two'
           ELSE        'three'
END
Parameters
<V>
The generic value type parameter
value:Field<V>

The value to do the case statement on

Returns:CaseValueStep<V>

An intermediary step for case statement construction

Annotations
@Override
whenback to summary
public final <T> CaseConditionStep<T> when(Condition condition, T result)

Implements org.jooq.Case.when.

Doc from org.jooq.Case.when.

Deprecated

as a consequence of Condition and CaseConditionStep being deprecated. See corresponding docs for further information.

This construct can be used to create expressions of the type 


CASE WHEN x < 1  THEN 'one'
     WHEN x >= 2 THEN 'two'
     ELSE            'three'
END
Parameters
<T>
The generic field type parameter
condition:Condition

A condition to check in the case statement

result:T

The result if the condition holds true

Returns:CaseConditionStep<T>

An intermediary step for case statement construction

Annotations
@Override
whenback to summary
public final <T> CaseConditionStep<T> when(Condition condition, Field<T> result)

Implements org.jooq.Case.when, org.jooq.Case.when.

Doc from org.jooq.Case.when.

Deprecated

as a consequence of Condition, Field and CaseConditionStep being deprecated. See corresponding docs for further information.

This construct can be used to create expressions of the type 


CASE WHEN x < 1  THEN 'one'
     WHEN x >= 2 THEN 'two'
     ELSE            'three'
END
Parameters
<T>
The generic field type parameter
condition:Condition

A condition to check in the case statement

result:Field<T>

The result if the condition holds true

Returns:CaseConditionStep<T>

An intermediary step for case statement construction

Annotations
@Override
whenback to summary
public final <T> CaseConditionStep<T> when(Condition condition, Select<? extends Record1<T>> result)

Implements org.jooq.Case.when, org.jooq.Case.when.

Doc from org.jooq.Case.when.

Deprecated

as a consequence of Condition and CaseConditionStep being deprecated. See corresponding docs for further information.

This construct can be used to create expressions of the type 


CASE WHEN x < 1  THEN 'one'
     WHEN x >= 2 THEN 'two'
     ELSE            'three'
END
Parameters
<T>
The generic field type parameter
condition:Condition

A condition to check in the case statement

result:Select<? extends Record1<T>>

The result if the condition holds true

Returns:CaseConditionStep<T>

An intermediary step for case statement construction

Annotations
@Override
whenback to summary
public final <T> CaseConditionStep<T> when(Field<Boolean> condition, T result)

Implements org.jooq.Case.when.

Doc from org.jooq.Case.when.

Deprecated

as a consequence of Field and CaseConditionStep being deprecated. See corresponding docs for further information.

This construct can be used to create expressions of the type 


CASE WHEN x < 1  THEN 'one'
     WHEN x >= 2 THEN 'two'
     ELSE            'three'
END
Parameters
<T>
The generic field type parameter
condition:Field<Boolean>

A condition to check in the case statement

result:T

The result if the condition holds true

Returns:CaseConditionStep<T>

An intermediary step for case statement construction

Annotations
@Override
whenback to summary
public final <T> CaseConditionStep<T> when(Field<Boolean> condition, Field<T> result)

Implements org.jooq.Case.when, org.jooq.Case.when.

Doc from org.jooq.Case.when.

Deprecated

as a consequence of Field and CaseConditionStep being deprecated. See corresponding docs for further information.

This construct can be used to create expressions of the type 


CASE WHEN x < 1  THEN 'one'
     WHEN x >= 2 THEN 'two'
     ELSE            'three'
END
Parameters
<T>
The generic field type parameter
condition:Field<Boolean>

A condition to check in the case statement

result:Field<T>

The result if the condition holds true

Returns:CaseConditionStep<T>

An intermediary step for case statement construction

Annotations
@Override
whenback to summary
public final <T> CaseConditionStep<T> when(Field<Boolean> condition, Select<? extends Record1<T>> result)

Implements org.jooq.Case.when, org.jooq.Case.when.

Doc from org.jooq.Case.when.

Deprecated

as a consequence of Field and CaseConditionStep being deprecated. See corresponding docs for further information.

This construct can be used to create expressions of the type 


CASE WHEN x < 1  THEN 'one'
     WHEN x >= 2 THEN 'two'
     ELSE            'three'
END
Parameters
<T>
The generic field type parameter
condition:Field<Boolean>

A condition to check in the case statement

result:Select<? extends Record1<T>>

The result if the condition holds true

Returns:CaseConditionStep<T>

An intermediary step for case statement construction

Annotations
@Override