All Packages  Class Hierarchy

$ _ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

Index of all Fields and Methods

A

addColumns(Vector). Method in class Zql.ZInsert
Specify which columns to insert
addFrom(Vector). Method in class Zql.ZQuery
Insert the FROM part of the statement
addGroupBy(ZGroupBy). Method in class Zql.ZQuery
Insert a GROUP BY...HAVING clause
addOperand(ZExp). Method in class Zql.ZExpression
Add an operand to the current expression.
addOrderBy(Vector). Method in class Zql.ZQuery
Insert an ORDER BY clause
addSelect(Vector). Method in class Zql.ZQuery
Insert the SELECT part of the statement
addSet(Hashtable). Method in class Zql.ZUpdate
Insert a SET...
addSet(ZExpression). Method in class Zql.ZQuery
Insert a SET clause (generally UNION, INTERSECT or MINUS)
addTables(Vector). Method in class Zql.ZLockTable
addValueSpec(ZExp). Method in class Zql.ZInsert
Specify the VALUES part or SQL sub-query of the INSERT statement
addWhere(ZExp). Method in class Zql.ZDelete
Add a WHERE clause to the DELETE statement
addWhere(ZExp). Method in class Zql.ZQuery
Insert a WHERE clause
addWhere(ZExp). Method in class Zql.ZUpdate
Insert a WHERE...

C

COLUMNNAME. Static variable in class Zql.ZConstant

E

eval(ZTuple, ZExp). Method in class Zql.ZEval
Evaluate a boolean expression to true or false (for example, SQL WHERE clauses are boolean expressions)
evalExpValue(ZTuple, ZExp). Method in class Zql.ZEval
Evaluate a numeric or string expression (example: a+1)

F

FORM_COLUMN. Static variable in class Zql.ZAliasedName
FORM_TABLE. Static variable in class Zql.ZAliasedName

G

getAggregate(). Method in class Zql.ZSelectItem
If this item is an aggregate function, return the function name.
getAlias(). Method in class Zql.ZAliasedName
getAscOrder(). Method in class Zql.ZOrderBy
Get the order (ascending or descending)
getColumn(). Method in class Zql.ZAliasedName
getColumnUpdate(String). Method in class Zql.ZUpdate
Get the SQL expression that specifies a given column's update value.
getComment(). Method in class Zql.ZTransactStmt
getExpression(). Method in class Zql.ZOrderBy
Get the ORDER BY expression.
getExpression(). Method in class Zql.ZSelectItem
getFrom(). Method in class Zql.ZQuery
Get the FROM part of the statement
getGroupBy(). Method in class Zql.ZGroupBy
Get the GROUP BY expressions
getGroupBy(). Method in class Zql.ZQuery
Get the GROUP BY...HAVING part of the statement
getHaving(). Method in class Zql.ZGroupBy
Get the HAVING clause
getLockMode(). Method in class Zql.ZLockTable
getOperand(int). Method in class Zql.ZExpression
Get an operand according to its index (position).
getOperands(). Method in class Zql.ZExpression
Get this expression's operands.
getOperator(). Method in class Zql.ZExpression
Get this expression's operator.
getOrderBy(). Method in class Zql.ZQuery
Get the ORDER BY clause
getQuery(). Method in class Zql.ZInsert
Get the sub-query (ex.
getSchema(). Method in class Zql.ZAliasedName
getSelect(). Method in class Zql.ZQuery
Get the SELECT part of the statement
getSet(). Method in class Zql.ZQuery
Get the SET clause (generally UNION, INTERSECT or MINUS)
getSet(). Method in class Zql.ZUpdate
Get the whole SET...
getTable(). Method in class Zql.ZAliasedName
getTable(). Method in class Zql.ZDelete
getTables(). Method in class Zql.ZLockTable
getType(). Method in class Zql.ZConstant
getValue(). Method in class Zql.ZConstant
getValues(). Method in class Zql.ZInsert
Get the VALUES part of the INSERT statement
getWhere(). Method in class Zql.ZDelete
getWhere(). Method in class Zql.ZQuery
Get the WHERE part of the statement
getWhere(). Method in class Zql.ZUpdate
Get the WHERE clause of this UPDATE statement.

I

initParser(InputStream). Method in class Zql.ZqlParser
Initialize (or re-initialize) the input stream for the parser.
isDistinct(). Method in class Zql.ZQuery
isExpression(). Method in class Zql.ZSelectItem
isForUpdate(). Method in class Zql.ZQuery
isNowait(). Method in class Zql.ZLockTable
isReadOnly(). Method in class Zql.ZTransactStmt
isWildcard(). Method in class Zql.ZAliasedName

M

main(String[]). Static method in class Zql.ZEval
main(String[]). Static method in class Zql.ZqlParser
Test program: Parses SQL statements from stdin or from a text file.
If the program receives one argument, it is an SQL text file name; if there's no argument, the program reads from stdin.

N

nbOperands(). Method in class Zql.ZExpression
Get the number of operands
NULL. Static variable in class Zql.ZConstant
NUMBER. Static variable in class Zql.ZConstant

R

readExpression(). Method in class Zql.ZqlParser
Parse an SQL Expression (like the WHERE clause of an SQL query).
readStatement(). Method in class Zql.ZqlParser
Parse an SQL Statement from the parser's input stream.
readStatements(). Method in class Zql.ZqlParser
Parse a set of SQL Statements from the parser's input stream (all the available statements are parsed and returned).

S

setAggregate(String). Method in class Zql.ZSelectItem
Initialize an aggregate function on this item (generally SUM, AVG, MAX, MIN) Example: SELECT AVG(age) FROM people; -> The aggregate function is AVG.
setAlias(String). Method in class Zql.ZAliasedName
Associate an alias with the current name.
setAscOrder(boolean). Method in class Zql.ZOrderBy
Set the order to ascending or descending (defailt is ascending order).
setComment(String). Method in class Zql.ZTransactStmt
setExpression(ZExp). Method in class Zql.ZSelectItem
Initialize this SELECT item as an SQL expression (not a column name nor wildcard) Example: SELECT a+b FROM table1; (a+b is an expression)
setHaving(ZExp). Method in class Zql.ZGroupBy
Initiallize the HAVING part of the GROUP BY
setLockMode(String). Method in class Zql.ZLockTable
setOperands(Vector). Method in class Zql.ZExpression
Set the operands list
setRow(String). Method in class Zql.ZTuple
Set the current tuple's column values.
setRow(Vector). Method in class Zql.ZTuple
Set the current tuple's column values.
STRING. Static variable in class Zql.ZConstant

T

toReversePolish(). Method in class Zql.ZExpression
String form of the current expression (reverse polish notation).
toString(). Method in class Zql.ZAliasedName
toString(). Method in class Zql.ZConstant
toString(). Method in class Zql.ZDelete
toString(). Method in class Zql.ZExpression
toString(). Method in class Zql.ZGroupBy
toString(). Method in class Zql.ZInsert
toString(). Method in class Zql.ZOrderBy
toString(). Method in class Zql.ZQuery
toString(). Method in class Zql.ZUpdate

U

UNKNOWN. Static variable in class Zql.ZConstant
ZConstant types

Z

ZAliasedName(). Constructor for class Zql.ZAliasedName
ZAliasedName(String, int). Constructor for class Zql.ZAliasedName
Create a new ZAliasedName given it's full name.
ZConstant(String, int). Constructor for class Zql.ZConstant
Create a new constant, given its name and type.
ZDelete(String). Constructor for class Zql.ZDelete
Create a DELETE statement on a given table
ZEval(). Constructor for class Zql.ZEval
ZExpression(String). Constructor for class Zql.ZExpression
Create an SQL Expression given the operator
ZExpression(String, ZExp). Constructor for class Zql.ZExpression
Create an SQL Expression given the operator and 1st operand
ZExpression(String, ZExp, ZExp). Constructor for class Zql.ZExpression
Create an SQL Expression given the operator, 1st and 2nd operands
ZFromItem(). Constructor for class Zql.ZFromItem
Create a new FROM clause.
ZFromItem(String). Constructor for class Zql.ZFromItem
Create a new FROM clause on a given table.
ZGroupBy(Vector). Constructor for class Zql.ZGroupBy
Create a GROUP BY given a set of Expressions
ZInsert(String). Constructor for class Zql.ZInsert
Create an INSERT statement on a given table
ZLockTable(). Constructor for class Zql.ZLockTable
ZOrderBy(ZExp). Constructor for class Zql.ZOrderBy
ZqlParser(). Constructor for class Zql.ZqlParser
Create a new parser: before use, call initParser(InputStream) to specify an input stream for the parsing.
ZqlParser(InputStream). Constructor for class Zql.ZqlParser
Create a new parser to parse SQL statements from a given input stream.
ZQuery(). Constructor for class Zql.ZQuery
Create a new SELECT statement
ZSelectItem(). Constructor for class Zql.ZSelectItem
Create a new SELECT item
ZSelectItem(String). Constructor for class Zql.ZSelectItem
Create a new SELECT item, given its name (for column names and wildcards).
ZTransactStmt(String). Constructor for class Zql.ZTransactStmt
ZTuple(). Constructor for class Zql.ZTuple
ZTuple(String). Constructor for class Zql.ZTuple
Create a new tuple, given it's column names
ZUpdate(String). Constructor for class Zql.ZUpdate
Create an UPDATE statement on a given table.