net.windward.datasource

Class SelectFilter.Filter

java.lang.Object

net.windward.datasource.SelectFilter.Filter

Enclosing class:

SelectFilter

public static class SelectFilter.Filter
extends java.lang.Object

An individual filter in the select.

Field Summary

Fields

Modifier and Type	Field and Description
static int	DATA_TYPE_DATE Filtering a date.
static int	DATA_TYPE_NUMBER Filtering a number.
static int	DATA_TYPE_STRING Filtering a string.
static int	OP_BEGIN_WITH starts with (text only)
static int	OP_CONTAINS contains (text only)
static int	OP_END_WITH ends with (text only)
static int	OP_EQUALS equal
static int	OP_GREATER_THAN greater than (SQL: date/number only, XML: number only)
static int	OP_GREATER_THAN_OR_EQUAL greater than or equal (SQL: date/number only, XML: number only)
static int	OP_LESS_THAN less than (SQL: date/number only, XML: number only)
static int	OP_LESS_THAN_OR_EQUAL less than or equals (SQL: date/number only, XML: number only)
static int	OP_LIKE like (no wildcards added, but existing ones respected)
static int	OP_NONE no op
static int	OP_NOT_BEGIN_WITH does not start with (text only)
static int	OP_NOT_CONTAINS does not contain (text only)
static int	OP_NOT_END_WITH does not end with (text only)
static int	OP_NOT_EQUALS not equal
static int	OP_NOT_LIKE not like (no wildcards added, but existing ones respected)

Constructor Summary

Constructors

Constructor and Description
Filter(java.lang.String fieldName, int opCode, java.util.Date value) A date filter for the select.
Filter(java.lang.String fieldName, int opCode, java.lang.Number value) A number filter for the select.
Filter(java.lang.String fieldName, int opCode, java.lang.Object value) A filter for the select.
Filter(java.lang.String fieldName, int opCode, java.lang.String value) A string filter for the select.

Method Summary

Modifier and Type	Method and Description
java.lang.String	getFieldName() The column (SQL) or node (XML) to compare on.
int	getOpCode() The OP_* to use.
java.lang.String	getSqlOpCode() The opcode as SQL will use it.
java.lang.Object	getSqlValue() The value for the filter.
java.lang.Object	getValue() The value for the filter.
java.util.Date	getValueAsDate() The date value for the filter.
java.lang.Number	getValueAsNumber() The number value for the filter.
java.lang.String	getValueAsString() The string value for the filter.
java.lang.String	getXpathOpCode() The opcode as XPath will use it.
java.lang.String	toString() Returns a string representation of the object.

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, wait, wait, wait

Field Detail

OP_NONE

public static final int OP_NONE

no op

See Also:

Constant Field Values

OP_EQUALS

public static final int OP_EQUALS

equal

See Also:

Constant Field Values

OP_NOT_EQUALS

public static final int OP_NOT_EQUALS

not equal

See Also:

Constant Field Values

OP_GREATER_THAN

public static final int OP_GREATER_THAN

greater than (SQL: date/number only, XML: number only)

See Also:

Constant Field Values

OP_GREATER_THAN_OR_EQUAL

public static final int OP_GREATER_THAN_OR_EQUAL

greater than or equal (SQL: date/number only, XML: number only)

See Also:

Constant Field Values

OP_LESS_THAN

public static final int OP_LESS_THAN

less than (SQL: date/number only, XML: number only)

See Also:

Constant Field Values

OP_LESS_THAN_OR_EQUAL

public static final int OP_LESS_THAN_OR_EQUAL

less than or equals (SQL: date/number only, XML: number only)

See Also:

Constant Field Values

OP_BEGIN_WITH

public static final int OP_BEGIN_WITH

starts with (text only)

See Also:

Constant Field Values

OP_NOT_BEGIN_WITH

public static final int OP_NOT_BEGIN_WITH

does not start with (text only)

See Also:

Constant Field Values

OP_END_WITH

public static final int OP_END_WITH

ends with (text only)

See Also:

Constant Field Values

OP_NOT_END_WITH

public static final int OP_NOT_END_WITH

does not end with (text only)

See Also:

Constant Field Values

OP_CONTAINS

public static final int OP_CONTAINS

contains (text only)

See Also:

Constant Field Values

OP_NOT_CONTAINS

public static final int OP_NOT_CONTAINS

does not contain (text only)

See Also:

Constant Field Values

OP_LIKE

public static final int OP_LIKE

like (no wildcards added, but existing ones respected)

See Also:

Constant Field Values

OP_NOT_LIKE

public static final int OP_NOT_LIKE

not like (no wildcards added, but existing ones respected)

See Also:

Constant Field Values

DATA_TYPE_STRING

public static final int DATA_TYPE_STRING

Filtering a string.

See Also:

Constant Field Values

DATA_TYPE_NUMBER

public static final int DATA_TYPE_NUMBER

Filtering a number.

See Also:

Constant Field Values

DATA_TYPE_DATE

public static final int DATA_TYPE_DATE

Filtering a date.

See Also:

Constant Field Values

Constructor Detail

Filter

public Filter(java.lang.String fieldName,
              int opCode,
              java.lang.Object value)

A filter for the select.

Parameters:

fieldName - The column (SQL) or node (XML) to compare on. If you are using aliases (SQL), this must use the alias.

opCode - The OP_* to use.

value - The value for the filter.

Filter

public Filter(java.lang.String fieldName,
              int opCode,
              java.lang.String value)

A string filter for the select.

Parameters:

fieldName - The column (SQL) or node (XML) to compare on. If you are using aliases (SQL), this must use the alias.

opCode - The OP_* to use.

value - The value for the filter.

Filter

public Filter(java.lang.String fieldName,
              int opCode,
              java.lang.Number value)

A number filter for the select.

Parameters:

fieldName - The column (SQL) or node (XML) to compare on. If you are using aliases (SQL), this must use the alias.

opCode - The OP_* to use.

value - The value for the filter.

Filter

public Filter(java.lang.String fieldName,
              int opCode,
              java.util.Date value)

A date filter for the select.

Parameters:

fieldName - The column (SQL) or node (XML) to compare on. If you are using aliases (SQL), this must use the alias.

opCode - The OP_* to use.

value - The value for the filter.

Method Detail

getFieldName

public java.lang.String getFieldName()

The column (SQL) or node (XML) to compare on. If you are using aliases (SQL), this must use the alias.

Returns:

The column (SQL) or node (XML) to compare on.

getOpCode

public int getOpCode()

The OP_* to use.

Returns:

The OP_* to use.

getSqlOpCode

public java.lang.String getSqlOpCode()

The opcode as SQL will use it.

Returns:

The opcode as SQL will use it.

getXpathOpCode

public java.lang.String getXpathOpCode()

The opcode as XPath will use it.

Returns:

The opcode as XPath will use it.

getSqlValue

public java.lang.Object getSqlValue()

The value for the filter.

Returns:

The value for the filter.

getValue

public java.lang.Object getValue()

The value for the filter.

Returns:

The value for the filter.

getValueAsString

public java.lang.String getValueAsString()

The string value for the filter. Can be any type.

Returns:

The string value for the filter.

getValueAsNumber

public java.lang.Number getValueAsNumber()

The number value for the filter. Must be a DATA_TYPE_NUMBER.

Returns:

The number value for the filter.

getValueAsDate

public java.util.Date getValueAsDate()

The date value for the filter. Must be a DATA_TYPE_NUMBER.

Returns:

The date value for the filter.

toString

public java.lang.String toString()

Returns a string representation of the object.

Overrides:

toString in class java.lang.Object

Returns:

a string representation of the object.