Module org.jooq
Package org.jooq

Interface CaseWhenStep<V,​T>

    • Method Detail

      • when

        @Support
        CaseWhenStep<V,​T> when​(V compareValue,
                                     T result)
        Compare a value to the already constructed case statement, return result if values are equal.
        Parameters:
        compareValue - The value to compare with the already constructed case statement
        result - The result value if values are equal
        Returns:
        An intermediary step for case statement construction
      • when

        @Support
        CaseWhenStep<V,​T> when​(V compareValue,
                                     Field<T> result)
        Compare a value to the already constructed case statement, return result if values are equal.
        Parameters:
        compareValue - The value to compare with the already constructed case statement
        result - The result value if values are equal
        Returns:
        An intermediary step for case statement construction
      • when

        @Support
        CaseWhenStep<V,​T> when​(Field<V> compareValue,
                                     T result)
        Compare a value to the already constructed case statement, return result if values are equal.
        Parameters:
        compareValue - The value to compare with the already constructed case statement
        result - The result value if values are equal
        Returns:
        An intermediary step for case statement construction
      • when

        @Support
        CaseWhenStep<V,​T> when​(Field<V> compareValue,
                                     Field<T> result)
        Compare a value to the already constructed case statement, return result if values are equal.
        Parameters:
        compareValue - The value to compare with the already constructed case statement
        result - The result value if values are equal
        Returns:
        An intermediary step for case statement construction
      • mapValues

        @Support
        CaseWhenStep<V,​T> mapValues​(Map<V,​T> values)
        Create WHEN .. THEN expressions from a Map.

        This will iterate over the map's entries to create individual WHEN .. THEN expressions for each map entry.

      • mapFields

        @Support
        CaseWhenStep<V,​T> mapFields​(Map<? extends Field<V>,​? extends Field<T>> fields)
        Create WHEN .. THEN expressions from a Map.

        This will iterate over the map's entries to create individual WHEN .. THEN expressions for each map entry.

      • otherwise

        @Support
        Field<T> otherwise​(T result)
        Add an else clause to the already constructed case statement
        Parameters:
        result - The result value if no other value matches the case
        Returns:
        The resulting field from case statement construction
      • otherwise

        @Support
        Field<T> otherwise​(Field<T> result)
        Add an else clause to the already constructed case statement
        Parameters:
        result - The result value if no other value matches the case
        Returns:
        The resulting field from case statement construction
      • else_

        @Support
        Field<T> else_​(T result)
        Add an else clause to the already constructed case statement
        Parameters:
        result - The result value if no other value matches the case
        Returns:
        The resulting field from case statement construction
      • else_

        @Support
        Field<T> else_​(Field<T> result)
        Add an else clause to the already constructed case statement
        Parameters:
        result - The result value if no other value matches the case
        Returns:
        The resulting field from case statement construction