|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
public interface Case
The SQL case statement.
This construct can be used to create expressions of the type
or of the type
CASE x WHEN 1 THEN 'one'
WHEN 2 THEN 'two'
ELSE 'three'
END
Instances of Case are created through the
CASE WHEN x < 1 THEN 'one'
WHEN x >= 2 THEN 'two'
ELSE 'three'
END
Factory.decode()
method
Method Summary | ||
---|---|---|
|
value(Field<V> 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
|
|
|
value(V 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
|
|
|
when(Condition condition,
Field<T> result)
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
Instances of Case are created through the |
|
|
when(Condition condition,
T result)
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
Instances of Case are created through the |
Method Detail |
---|
<V> CaseValueStep<V> value(V value)
CASE value WHEN 1 THEN 'one'
WHEN 2 THEN 'two'
ELSE 'three'
END
V
- The generic value type parametervalue
- The value to do the case statement on
<V> CaseValueStep<V> value(Field<V> value)
CASE value WHEN 1 THEN 'one'
WHEN 2 THEN 'two'
ELSE 'three'
END
V
- The generic value type parametervalue
- The value to do the case statement on
<T> CaseConditionStep<T> when(Condition condition, T result)
CASE WHEN x < 1 THEN 'one'
WHEN x >= 2 THEN 'two'
ELSE 'three'
END
Instances of Case are created through the
T
- The generic field type parametercondition
- A condition to check in the case statementresult
- The result if the condition holds true
<T> CaseConditionStep<T> when(Condition condition, Field<T> result)
CASE WHEN x < 1 THEN 'one'
WHEN x >= 2 THEN 'two'
ELSE 'three'
END
Instances of Case are created through the
T
- The generic field type parametercondition
- A condition to check in the case statementresult
- The result if the condition holds true
|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |