Package org.gvsig.fmap.dal

Interface SQLBuilder.OrderByBuilder

All Superinterfaces:

Cloneable, org.gvsig.tools.lang.Cloneable, org.gvsig.expressionevaluator.ExpressionBuilder.Value, org.gvsig.expressionevaluator.ExpressionBuilder.Visitable, org.gvsig.tools.util.PropertiesSupport, SQLBuilder.StatementPart

Enclosing interface:

SQLBuilder

public static interface SQLBuilder.OrderByBuilder
extends SQLBuilder.StatementPart

Field Summary

Fields

Modifier and Type	Field	Description
static final int	MODE_NULLS_FIRST
static final int	MODE_NULLS_LAST
static final int	MODE_NULLS_NOT_SPECIFIED

Method Summary

Modifier and Type	Method	Description
SQLBuilder.OrderByBuilder	ascending()
SQLBuilder.OrderByBuilder	ascending(boolean asc)
SQLBuilder.OrderByBuilder	column(String name)
SQLBuilder.OrderByBuilder	custom(String order)
SQLBuilder.OrderByBuilder	descending()
int	getNullsMode()
boolean	isColumn(String name)
boolean	isColumn(org.gvsig.expressionevaluator.ExpressionBuilder.Value value)
SQLBuilder.OrderByBuilder	nulls(int mode)
SQLBuilder.OrderByBuilder	value(org.gvsig.expressionevaluator.ExpressionBuilder.Value expression)

Methods inherited from interface org.gvsig.expressionevaluator.ExpressionBuilder.Value

clone, copyPropertiesFrom, replace, toString

Methods inherited from interface org.gvsig.expressionevaluator.ExpressionBuilder.Visitable

accept

Methods inherited from interface org.gvsig.tools.util.PropertiesSupport

getProperties, getProperty, setProperty

Field Details

MODE_NULLS_FIRST

static final int MODE_NULLS_FIRST

See Also:

• Constant Field Values

MODE_NULLS_LAST

static final int MODE_NULLS_LAST

See Also:

• Constant Field Values

MODE_NULLS_NOT_SPECIFIED

static final int MODE_NULLS_NOT_SPECIFIED

See Also:

• Constant Field Values

Method Details

column

SQLBuilder.OrderByBuilder column(String name)

isColumn

boolean isColumn(String name)

isColumn

boolean isColumn(org.gvsig.expressionevaluator.ExpressionBuilder.Value value)

value

SQLBuilder.OrderByBuilder value(org.gvsig.expressionevaluator.ExpressionBuilder.Value expression)

ascending

SQLBuilder.OrderByBuilder ascending(boolean asc)

ascending

SQLBuilder.OrderByBuilder ascending()

descending

SQLBuilder.OrderByBuilder descending()

nulls

SQLBuilder.OrderByBuilder nulls(int mode)

custom

SQLBuilder.OrderByBuilder custom(String order)

getNullsMode

int getNullsMode()