com.xdev.jadoth.sqlengine.internal

Class SqlFunctionSUBSTRING

java.lang.Object

com.xdev.jadoth.sqlengine.internal.QueryPart

com.xdev.jadoth.sqlengine.internal.SqlExpression

com.xdev.jadoth.sqlengine.internal.SqlFunction

com.xdev.jadoth.sqlengine.internal.SqlFunctionSUBSTRING

All Implemented Interfaces:

Copyable, SelectItem, Serializable

public class SqlFunctionSUBSTRING
extends SqlFunction

The Class SqlFunctionSUBSTRING.

Author:

Thomas Muenz

See Also:

Serialized Form

Field Summary

Fields inherited from class com.xdev.jadoth.sqlengine.internal.SqlFunction

parameters

Fields inherited from class com.xdev.jadoth.sqlengine.internal.SqlExpression

expression

Fields inherited from class com.xdev.jadoth.sqlengine.internal.QueryPart

ASEXPRESSION, defaultClauseStringBuilderLength, defaultExpressionStringBuilderLength, defaultQueryStringBuilderLength, DELIMIT_ALIASES, DELIMIT_COLUMN_IDENTIFIERS, DELIMIT_TABLE_IDENTIFIERS, ESCAPE_DBL_QUOTES, ESCAPE_QUOTES, FLAGS_TAKEN, MINIINDENT, OMITALIAS, PACKED, QUALIFY_BY_TABLE, SINGLELINE, UNQUALIFIED

Constructor Summary

Constructors

Constructor and Description
SqlFunctionSUBSTRING(Object characterValueExpression) Instantiates a new sql function substring.
SqlFunctionSUBSTRING(Object characterValueExpression, Integer startPosition) Instantiates a new sql function substring.
SqlFunctionSUBSTRING(Object characterValueExpression, Integer startPosition, Integer stringLength) Instantiates a new sql function substring.
SqlFunctionSUBSTRING(Object characterValueExpression, Integer startPosition, Integer stringLength, Integer charLengthUnits) Instantiates a new sql function substring.

Method Summary

Modifier and Type	Method and Description
Object	getCharacterValueExpression() Gets the character value expression.
Integer	getCharLengthUnits() Gets the char length units.
String	getFunctionName() Gets the function name.
Integer	getStartPosition() Gets the start position.
Integer	getStringLength() Gets the string length.

Methods inherited from class com.xdev.jadoth.sqlengine.internal.SqlFunction

assemble, assembleFunction, getParameters, setParameter

Methods inherited from class com.xdev.jadoth.sqlengine.internal.SqlExpression

_ASC, _DESC, _NULLS_FIRST, _NULLS_LAST, AS, BETWEEN, c, CONCAT, CONTAINS, copy, copyAS, eq, getExpression, getExpressionObject, gt, gte, IN, IS_NOT_NULL, IS_NULL, LIKE, lt, lte, ne, NOT_BETWEEN, NOT_CONTAINS, NOT_IN, NOT_LIKE, o, toString

Methods inherited from class com.xdev.jadoth.sqlengine.internal.QueryPart

assembleAlias, assembleObject, assembleQuery, bitAsExpression, bitDelimitAliases, bitDelimitColumnIdentifiers, bitDelimitTableIdentifiers, bitEscapeDoubleQuotes, bitMiniIndent, bitOmitAlias, bitPacked, bitQualified, bitQualifyByTable, bitSingleLine, concat, concatSqlExpressions, EscapeQuotes, flagsToString, function, indent, isAsExpression, isDelimitAliases, isDelimitColumnIdentifiers, isDelimitTableIdentifiers, isEscapeDoubleQuotes, isEscapeQuotes, isMiniIndent, isOmitAlias, isPacked, isQualifyByTable, isSingleLine, isUnqualified, keyword, list, printFlags, setAsExpression, setDelimitAliases, setDelimitColumnIdentifiers, setDelimitTableIdentifiers, setEscapeDoubleQuotes, setEscapeQuotes, setMiniIndent, setPacked, setQualified, setQualifyByTable, setSingleLine, setUseAlias

Methods inherited from class java.lang.Object

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

Constructor Detail

SqlFunctionSUBSTRING

public SqlFunctionSUBSTRING(Object characterValueExpression,
                            Integer startPosition,
                            Integer stringLength,
                            Integer charLengthUnits)

Instantiates a new sql function substring.

Parameters:

characterValueExpression - the character value expression

startPosition - the start position

stringLength - the string length

charLengthUnits - the char length units

SqlFunctionSUBSTRING

public SqlFunctionSUBSTRING(Object characterValueExpression,
                            Integer startPosition,
                            Integer stringLength)

Instantiates a new sql function substring.

Parameters:

characterValueExpression - the character value expression

startPosition - the start position

stringLength - the string length

SqlFunctionSUBSTRING

public SqlFunctionSUBSTRING(Object characterValueExpression,
                            Integer startPosition)

Instantiates a new sql function substring.

Parameters:

characterValueExpression - the character value expression

startPosition - the start position

SqlFunctionSUBSTRING

public SqlFunctionSUBSTRING(Object characterValueExpression)

Instantiates a new sql function substring.

Parameters:

characterValueExpression - the character value expression

Method Detail

getFunctionName

public String getFunctionName()

Description copied from class: SqlFunction

Gets the function name.

Specified by:

getFunctionName in class SqlFunction

Returns:

See Also:

SqlFunction.getFunctionName()

getCharacterValueExpression

public Object getCharacterValueExpression()

Gets the character value expression.

Returns:

the characterValueExpression

getStartPosition

public Integer getStartPosition()

Gets the start position.

Returns:

the startPosition

getStringLength

public Integer getStringLength()

Gets the string length.

Returns:

the stringLength

getCharLengthUnits

public Integer getCharLengthUnits()

Gets the char length units.

Returns:

the charLengthUnits