org.edg.info.sqlutil.parsql
Class SelectStatement

java.lang.Object
  extended byorg.edg.info.sqlutil.parsql.SelectStatement
All Implemented Interfaces:
ExpSelConst, java.io.Serializable, Statement

public class SelectStatement
extends java.lang.Object
implements Statement, ExpSelConst

SelectStatement: an SQL SELECT statement

See Also:
Serialized Form

Constructor Summary
SelectStatement()
          Create a new SELECT statement
 
Method Summary
 void addFrom(java.util.Vector f)
          Insert the FROM part of the statement
 void addGroupBy(GroupBy g)
          Insert a GROUP BY...HAVING clause
 void addOrderBy(java.util.Vector v)
          Insert an ORDER BY clause
 void addSelect(java.util.Vector s)
          Insert the SELECT part of the statement
 void addSet(Expression s)
          Insert a SET clause (generally UNION, INTERSECT or MINUS)
 void addWhere(ExpSelConst w)
          Insert a WHERE clause
 java.util.Vector getFrom()
          Get the FROM part of the statement
 GroupBy getGroupBy()
          Get the GROUP BY...HAVING part of the statement
 java.util.Vector getOrderBy()
          Get the ORDER BY clause
 java.util.Vector getSelect()
          Get the SELECT part of the statement
 Expression getSet()
          Get the SET clause (generally UNION, INTERSECT or MINUS)
 ExpSelConst getWhere()
          Get the WHERE part of the statement
 boolean isDistinct()
          DOCUMENT ME!
 boolean isForUpdate()
          DOCUMENT ME!
 java.lang.String toString()
          DOCUMENT ME!
 
Methods inherited from class java.lang.Object
equals, getClass, hashCode, notify, notifyAll, wait, wait, wait
 

Constructor Detail

SelectStatement

public SelectStatement()
Create a new SELECT statement

Method Detail

isDistinct

public boolean isDistinct()
DOCUMENT ME!

Returns:
true if it is a SELECT DISTINCT query, false otherwise.

isForUpdate

public boolean isForUpdate()
DOCUMENT ME!

Returns:
true if it is a FOR UPDATE query, false otherwise.

getFrom

public java.util.Vector getFrom()
Get the FROM part of the statement

Returns:
A vector of ZFromItem objects

getGroupBy

public GroupBy getGroupBy()
Get the GROUP BY...HAVING part of the statement

Returns:
A GROUP BY...HAVING clause

getOrderBy

public java.util.Vector getOrderBy()
Get the ORDER BY clause

Returns:
DOCUMENT ME!

getSelect

public java.util.Vector getSelect()
Get the SELECT part of the statement

Returns:
A vector of ZSelectItem objects

getSet

public Expression getSet()
Get the SET clause (generally UNION, INTERSECT or MINUS)

Returns:
An SQL Expression (generally UNION, INTERSECT or MINUS)

getWhere

public ExpSelConst getWhere()
Get the WHERE part of the statement

Returns:
An SQL Expression or sub-query (Expression or SelectStatement object)

addFrom

public void addFrom(java.util.Vector f)
Insert the FROM part of the statement

Parameters:
f - a Vector of ZFromItem objects

addGroupBy

public void addGroupBy(GroupBy g)
Insert a GROUP BY...HAVING clause

Parameters:
g - A GROUP BY...HAVING clause

addOrderBy

public void addOrderBy(java.util.Vector v)
Insert an ORDER BY clause

Parameters:
v - A vector of OrderBy objects

addSelect

public void addSelect(java.util.Vector s)
Insert the SELECT part of the statement

Parameters:
s - A vector of ZSelectItem objects

addSet

public void addSet(Expression s)
Insert a SET clause (generally UNION, INTERSECT or MINUS)

Parameters:
s - An SQL Expression (generally UNION, INTERSECT or MINUS)

addWhere

public void addWhere(ExpSelConst w)
Insert a WHERE clause

Parameters:
w - An SQL Expression

toString

public java.lang.String toString()
DOCUMENT ME!

Returns:
DOCUMENT ME!