mdbtools.dbengine.sql

Class Select

java.lang.Object

mdbtools.dbengine.sql.Select

All Implemented Interfaces:

SQL

public class Select
extends Object
implements SQL

Select is the parse tree for a select sql statement. A simple select is handled by: converting a from clause to Data applying the where clause returning Data as the result In the case of an aggregate the above is done to get the data then the aggregate functions are exectuted to filter the data

Field Summary

Fields

Modifier and Type	Field and Description
private ArrayList	columns
private ArrayList	groupBy
private ArrayList	orderBy
private ArrayList	tables
private Object	where

Constructor Summary

Constructors

Constructor and Description
Select()

Method Summary

Methods

Modifier and Type	Method and Description
void	addColumn(Object column)
void	addGroupBy(FQColumn column)
void	addOrderBy(OrderBy o)
void	addTable(Object table)
Object	getColumn(int index)
int	getColumnCount()
Object	getGroupBy(int index)
int	getGroupByCount()
OrderBy	getOrderBy(int index)
int	getOrderByCount()
Object	getTable(int index)
int	getTableCount()
Object	getWhere()
(package private) Table	resolveTable(int index)
void	setWhere(Object where)
String	toString()

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Field Detail

columns

private ArrayList columns

tables

private ArrayList tables

where

private Object where

groupBy

private ArrayList groupBy

orderBy

private ArrayList orderBy

Constructor Detail

Select

public Select()

Method Detail

toString

public String toString()

Overrides:

toString in class Object

getColumnCount

public int getColumnCount()

getColumn

public Object getColumn(int index)

getTableCount

public int getTableCount()

getTable

public Object getTable(int index)

addColumn

public void addColumn(Object column)

addTable

public void addTable(Object table)

addGroupBy

public void addGroupBy(FQColumn column)

getGroupByCount

public int getGroupByCount()

getGroupBy

public Object getGroupBy(int index)

addOrderBy

public void addOrderBy(OrderBy o)

getOrderByCount

public int getOrderByCount()

getOrderBy

public OrderBy getOrderBy(int index)

setWhere

public void setWhere(Object where)

getWhere

public Object getWhere()

resolveTable

Table resolveTable(int index)