WhereClauseCondition

java.lang.Object
- com.ibm.commerce.member.search.WhereClauseCondition

All Implemented Interfaces:

java.io.Serializable

Direct Known Subclasses:

WhereClauseFilterCondition, WhereClauseFreeFormCondition, WhereClauseSearchCondition
```
public class WhereClauseCondition
extends java.lang.Object
implements java.io.Serializable
```
Represents a WHERE clause condition.

See Also:

Serialized Form

Field Summary

Fields
Modifier and Type	Field and Description
`static java.lang.String`	`CLASSNAME` Class name
`static java.lang.String`	`COPYRIGHT` IBM Copyright
`static java.lang.String`	`SQL_AND` SQL ' AND'
`static java.lang.String`	`SQL_CLOSE_BRACKET` SQL ')'
`static java.lang.String`	`SQL_EQUALS` SQL ' = ?'
`static java.lang.String`	`SQL_ESCAPE` SQL Escape clause.
`static java.lang.String`	`SQL_LIKE` SQL ' LIKE ?'
`static java.lang.String`	`SQL_NOT_EQUALS` SQL ' <> ?'
`static java.lang.String`	`SQL_OPEN_BRACKET` SQL '('
`static java.lang.String`	`SQL_OR` SQL ' OR '
`static java.lang.String`	`SQL_QUOTE` SQL '[']' Single quote
`static java.lang.String`	`SQL_SOUNDEX` SQL 'SOUNDEX'
`static java.lang.String`	`SQL_TRUE_CONDITION` SQL condition that always validates to TRUE '(1=1)'
`static java.lang.String`	`SQL_WILDCARD` SQL '%'

Constructor Summary

Constructors
Constructor and Description

WhereClauseCondition()
Constructor.

Constructors
Constructor and Description
`WhereClauseCondition()` Constructor.

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`void`	`appendANDCondition(WhereClauseCondition aWhereClause)` Append a condition using AND.
`void`	`appendORCondition(WhereClauseCondition aWhereClause)` Append a condition using OR.
`java.util.Set`	`getFromTables()` Returns a Set of FROM tables used by this query.
`java.util.Vector`	`getWhereClauseParameterValues()` Get the where clause parameter values.
`java.lang.String`	`getWhereClauseSQL()` Get the WHERE clause string.
`boolean`	`isValid()` Whether or not this WHERE clause condition is valid.
`java.lang.String`	`toString()` Returns the string representation of this WHERE clause object.

Methods inherited from class java.lang.Object
equals, getClass, hashCode, notify, notifyAll, wait, wait, wait

- Field Detail
  - COPYRIGHT
```
public static final java.lang.String COPYRIGHT
```
    IBM Copyright
    
    See Also:
    
    Constant Field Values
  - CLASSNAME
```
public static final java.lang.String CLASSNAME
```
    Class name
  - SQL_AND
```
public static java.lang.String SQL_AND
```
    SQL ' AND'
  - SQL_OR
```
public static java.lang.String SQL_OR
```
    SQL ' OR '
  - SQL_OPEN_BRACKET
```
public static java.lang.String SQL_OPEN_BRACKET
```
    SQL '('
  - SQL_CLOSE_BRACKET
```
public static java.lang.String SQL_CLOSE_BRACKET
```
    SQL ')'
  - SQL_QUOTE
```
public static final java.lang.String SQL_QUOTE
```
    SQL '[']' Single quote
    
    See Also:
    
    Constant Field Values
  - SQL_LIKE
```
public static final java.lang.String SQL_LIKE
```
    SQL ' LIKE ?'
    
    See Also:
    
    Constant Field Values
  - SQL_EQUALS
```
public static final java.lang.String SQL_EQUALS
```
    SQL ' = ?'
    
    See Also:
    
    Constant Field Values
  - SQL_NOT_EQUALS
```
public static final java.lang.String SQL_NOT_EQUALS
```
    SQL ' <> ?'
    
    See Also:
    
    Constant Field Values
  - SQL_WILDCARD
```
public static final java.lang.String SQL_WILDCARD
```
    SQL '%'
    
    See Also:
    
    Constant Field Values
  - SQL_SOUNDEX
```
public static final java.lang.String SQL_SOUNDEX
```
    SQL 'SOUNDEX'
    
    See Also:
    
    Constant Field Values
  - SQL_TRUE_CONDITION
```
public static final java.lang.String SQL_TRUE_CONDITION
```
    SQL condition that always validates to TRUE '(1=1)'
    
    See Also:
    
    Constant Field Values
  - SQL_ESCAPE
```
public static final java.lang.String SQL_ESCAPE
```
    SQL Escape clause.
    
    See Also:
    
    Constant Field Values
- Constructor Detail
  - WhereClauseCondition
```
public WhereClauseCondition()
```
    Constructor.
- Method Detail
  - getFromTables
```
public java.util.Set getFromTables()
```
    Returns a Set of FROM tables used by this query.
    
    Returns:
    
    Set The FROM tables.
  - getWhereClauseSQL
```
public java.lang.String getWhereClauseSQL()
```
    Get the WHERE clause string.
    
    Returns:
    
    The WHERE clause string.
  - getWhereClauseParameterValues
```
public java.util.Vector getWhereClauseParameterValues()
```
    Get the where clause parameter values.
    
    Returns:
    
    Vector The parameter values for the where clause.
  - isValid
```
public boolean isValid()
```
    Whether or not this WHERE clause condition is valid.
    
    Returns:
    
    true if the WHERE clause condition is valid, false otherwise
  - appendANDCondition
```
public void appendANDCondition(WhereClauseCondition aWhereClause)
```
    Append a condition using AND.
    
    Parameters:
    
    aWhereClause - The WHERE clause condition to AND to the current condition.
  - appendORCondition
```
public void appendORCondition(WhereClauseCondition aWhereClause)
```
    Append a condition using OR. When a condition is OR'd with an existing expression, the entire object is wrapped with brackets. For example, given condition "A AND B AND C" that is to be OR'd with condition "X AND Y", the resulting expression will be "((A AND B AND C) OR (X AND Y))".
    
    Parameters:
    
    aWhereClause - The WHERE clause condition to OR to the current condition.
  - toString
```
public java.lang.String toString()
```
    Returns the string representation of this WHERE clause object.
    
    Overrides:
    
    toString in class java.lang.Object
    
    Returns:
    
    String The string representation of this object.

Methods inherited from class java.lang.Object

COPYRIGHT

CLASSNAME

SQL_AND

SQL_OR

SQL_OPEN_BRACKET

SQL_CLOSE_BRACKET

SQL_QUOTE

SQL_LIKE

SQL_EQUALS

SQL_NOT_EQUALS

SQL_WILDCARD

SQL_SOUNDEX

SQL_TRUE_CONDITION

SQL_ESCAPE

WhereClauseCondition

getFromTables

getWhereClauseSQL

getWhereClauseParameterValues

isValid

appendANDCondition

appendORCondition

toString