org.tinygroup.tinysqldsl.expression

Class CaseExpression

java.lang.Object

org.tinygroup.tinysqldsl.expression.CaseExpression

All Implemented Interfaces:

ExpressionBuildProcessor, Expression

public class CaseExpression
extends Object
implements Expression

CASE/WHEN expression.

Syntax:

 CASE
 WHEN condition THEN expression
 [WHEN condition THEN expression]...
 [ELSE expression]
 END
 

or

 CASE expression
 WHEN condition THEN expression
 [WHEN condition THEN expression]...
 [ELSE expression]
 END
 

See also: https://aurora.vcu.edu/db2help/db2s0/frame3.htm#casexp http://sybooks.sybase.com/onlinebooks/group-as/asg1251e /commands/

Constructor Summary

Constructors

Constructor and Description
CaseExpression()

Method Summary

Modifier and Type	Method and Description
void	builderExpression(StatementSqlBuilder builder) 实现接口的sql片段通过builder.appendSql(String segment)进行拼接,也可以builder.getStringBuilder方法获取StringBuilder,然后进行append 实现的参数信息通过builder.addParamValue(Object...
Expression	getElseExpression()
Expression	getSwitchExpression()
List<Expression>	getWhenClauses()
void	setElseExpression(Expression elseExpression)
void	setSwitchExpression(Expression switchExpression)
void	setWhenClauses(List<Expression> whenClauses)
String	toString()

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Constructor Detail

CaseExpression

public CaseExpression()

Method Detail

getSwitchExpression

public Expression getSwitchExpression()

Returns:

Returns the switchExpression.

setSwitchExpression

public void setSwitchExpression(Expression switchExpression)

Parameters:

switchExpression - The switchExpression to set.

getElseExpression

public Expression getElseExpression()

Returns:

Returns the elseExpression.

setElseExpression

public void setElseExpression(Expression elseExpression)

Parameters:

elseExpression - The elseExpression to set.

getWhenClauses

public List<Expression> getWhenClauses()

Returns:

Returns the whenClauses.

setWhenClauses

public void setWhenClauses(List<Expression> whenClauses)

Parameters:

whenClauses - The whenClauses to set.

toString

public String toString()

Overrides:

toString in class Object

builderExpression

public void builderExpression(StatementSqlBuilder builder)

Description copied from interface: ExpressionBuildProcessor

实现接口的sql片段通过builder.appendSql(String segment)进行拼接,也可以builder.getStringBuilder方法获取StringBuilder,然后进行append 实现的参数信息通过builder.addParamValue(Object... values)进行参数组装

Specified by:

builderExpression in interface ExpressionBuildProcessor