Module org.jooq

Package org.jooq

Interface IfElseStep

All Superinterfaces:

QueryPart, Serializable, Statement

@Pro
public interface IfElseStep
extends Statement

An intermediate step in building a procedural IF statement.

Author:

Lukas Eder

Method Summary

Modifier and Type	Method	Description
@NotNull Statement	else_(Collection<? extends Statement> statements)	Add an ELSE clause to the IF statement.
@NotNull Statement	else_(Statement... statements)	Add an ELSE clause to the IF statement.
@NotNull IfThenStep	elsif(Condition condition)	Add an ELSIF clause to the IF statement.

Methods inherited from interface org.jooq.QueryPart

$replace, $replace, $traverse, $traverse, equals, hashCode, toString

Method Details

elsif

@NotNull
@Support({AURORA_POSTGRES,BIGQUERY,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,MARIADB,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,YUGABYTEDB})
@NotNull IfThenStep elsif(Condition condition)

Add an ELSIF clause to the IF statement.

else_

@NotNull
@Support({AURORA_POSTGRES,BIGQUERY,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,MARIADB,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,YUGABYTEDB})
@NotNull Statement else_(Statement... statements)

Add an ELSE clause to the IF statement.

else_

@NotNull
@Support({AURORA_POSTGRES,BIGQUERY,DB2,EXASOL,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,MARIADB,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,YUGABYTEDB})
@NotNull Statement else_(Collection<? extends Statement> statements)

Add an ELSE clause to the IF statement.