All Packages Class Hierarchy This Package Previous Next Index
Class Zql.ZQuery
java.lang.Object
|
+----Zql.ZQuery
- public class ZQuery
- extends Object
- implements ZStatement, ZExp
ZQuery: an SQL SELECT statement
-
ZQuery()
- Create a new SELECT statement
-
addFrom(Vector)
- Insert the FROM part of the statement
-
addGroupBy(ZGroupBy)
- Insert a GROUP BY...HAVING clause
-
addOrderBy(Vector)
- Insert an ORDER BY clause
-
addSelect(Vector)
- Insert the SELECT part of the statement
-
addSet(ZExpression)
- Insert a SET clause (generally UNION, INTERSECT or MINUS)
-
addWhere(ZExp)
- Insert a WHERE clause
-
getFrom()
- Get the FROM part of the statement
-
getGroupBy()
- Get the GROUP BY...HAVING part of the statement
-
getOrderBy()
- Get the ORDER BY clause
-
getSelect()
- Get the SELECT part of the statement
-
getSet()
- Get the SET clause (generally UNION, INTERSECT or MINUS)
-
getWhere()
- Get the WHERE part of the statement
-
isDistinct()
-
-
isForUpdate()
-
-
toString()
-
ZQuery
public ZQuery()
- Create a new SELECT statement
addSelect
public void addSelect(Vector s)
- Insert the SELECT part of the statement
- Parameters:
- s - A vector of ZSelectItem objects
addFrom
public void addFrom(Vector f)
- Insert the FROM part of the statement
- Parameters:
- f - a Vector of ZFromItem objects
addWhere
public void addWhere(ZExp w)
- Insert a WHERE clause
- Parameters:
- w - An SQL Expression
addGroupBy
public void addGroupBy(ZGroupBy g)
- Insert a GROUP BY...HAVING clause
- Parameters:
- g - A GROUP BY...HAVING clause
addSet
public void addSet(ZExpression s)
- Insert a SET clause (generally UNION, INTERSECT or MINUS)
- Parameters:
- s - An SQL Expression (generally UNION, INTERSECT or MINUS)
addOrderBy
public void addOrderBy(Vector v)
- Insert an ORDER BY clause
- Parameters:
- v - A vector of ZOrderBy objects
getSelect
public Vector getSelect()
- Get the SELECT part of the statement
- Returns:
- A vector of ZSelectItem objects
getFrom
public Vector getFrom()
- Get the FROM part of the statement
- Returns:
- A vector of ZFromItem objects
getWhere
public ZExp getWhere()
- Get the WHERE part of the statement
- Returns:
- An SQL Expression or sub-query (ZExpression or ZQuery object)
getGroupBy
public ZGroupBy getGroupBy()
- Get the GROUP BY...HAVING part of the statement
- Returns:
- A GROUP BY...HAVING clause
getSet
public ZExpression getSet()
- Get the SET clause (generally UNION, INTERSECT or MINUS)
- Returns:
- An SQL Expression (generally UNION, INTERSECT or MINUS)
getOrderBy
public Vector getOrderBy()
- Get the ORDER BY clause
- Parameters:
- v - A vector of ZOrderBy objects
isDistinct
public boolean isDistinct()
- Returns:
- true if it is a SELECT DISTINCT query, false otherwise.
isForUpdate
public boolean isForUpdate()
- Returns:
- true if it is a FOR UPDATE query, false otherwise.
toString
public String toString()
- Overrides:
- toString in class Object
All Packages Class Hierarchy This Package Previous Next Index