com.cyclops.dbdigger.sql
Class Select

java.lang.Object
  com.cyclops.dbdigger.sql.SQL
      com.cyclops.dbdigger.sql.Select

public class Select

extends SQL

Add description HERE!

Since:

2003-6-6 15:19:01

Author:

joel guo

Field Summary

static Select[]	EMPTY_ARRAY Empty select array
static String	OPERATION Select sql keyword

Constructor Summary

Select()
Constructor of class Select

Method Summary

void	addOrderBy(OrderBy orderBy) Method addOrderBy()
Select	addSelectedColumn(Column column) Add single select column
Select	addSelectedColumns(Column[] columns) Add selected columns
Table[]	getFroms() Method getFroms() in class Select
OrderBy[]	getOrderBys() Method getOrderBys()
Column[]	getSeletedColumns() Method getSeletedColumns() in class Select
Condition	getWhere() Get root where criterion
Select	setWhere(Condition c) Set root where Criterion

Methods inherited from class com.cyclops.dbdigger.sql.SQL

getOperation

Methods inherited from class java.lang.Object

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

Field Detail

EMPTY_ARRAY

public static final Select[] EMPTY_ARRAY

Empty select array

OPERATION

public static final String OPERATION

Select sql keyword

See Also:

Constant Field Values

Constructor Detail

Select

public Select()

Constructor of class Select

Method Detail

addOrderBy

public void addOrderBy(OrderBy orderBy)

Method addOrderBy()

Parameters:

orderBy - OrderBy object to be added

addSelectedColumn

public Select addSelectedColumn(Column column)

Add single select column

Parameters:

column - Database column

Returns:

This select object

addSelectedColumns

public Select addSelectedColumns(Column[] columns)

Add selected columns

Parameters:

columns - Array of database columns

Returns:

This select object

getFroms

public Table[] getFroms()

Method getFroms() in class Select

Returns:

From tables

getOrderBys

public OrderBy[] getOrderBys()

Method getOrderBys()

Returns:

OrderBy object array

getSeletedColumns

public Column[] getSeletedColumns()

Method getSeletedColumns() in class Select

Returns:

Column object array

getWhere

public Condition getWhere()

Get root where criterion

Returns:

Criterion object

setWhere

public Select setWhere(Condition c)

Set root where Criterion

Parameters:

c - Criterion object

Returns:

This select object