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

Constructor Summary

Constructors

Constructor and Description
Select()

Method Summary

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()
void	setWhere(Object where)
String	toString()

Methods inherited from class java.lang.Object

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

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()