org.arch4j.dataaccess.common
Class Select

java.lang.Object
  |
  +--org.arch4j.dataaccess.common.Select

All Implemented Interfaces:

Query

public class Select

extends Object

implements Query

This class acts as a wrapper around select statements It takes a table name and a Condition object in its contructor A typical usage would be Select sel = new Select ("MyTable", new Condition ())

Version:

1.0

Author:

SpiderLogic Team

Constructor Summary

Select(String tableName)

Select(String tableName, Condition condition)

Select(String tableName, Condition condition, OrderBy orderBy)

Select(String tableName, Join aJoinClause, Condition whereCondition)

Select(String tableName, Join aJoinClause, Condition whereCondition, OrderBy orderBy)

Method Summary

void	addTable(String aTableName) Add a table to the select statement
void	addWhat(String columnName)
Join	getJoinClause()
OrderBy	getOrderBy()
Condition	getWhereClause() Get a reference to the where clause
boolean	isDistinct()
void	setDistinct(boolean isDistinct)
void	setJoinClause(Join aJoinClause)
void	setOrderBy(OrderBy orderBy)
void	setWhereClause(Condition aWhereCondition) Set the where clause
String	toString()

Methods inherited from class java.lang.Object

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

Constructor Detail

Select

public Select(String tableName,
              Join aJoinClause,
              Condition whereCondition,
              OrderBy orderBy)

Select

public Select(String tableName,
              Join aJoinClause,
              Condition whereCondition)

Select

public Select(String tableName,
              Condition condition,
              OrderBy orderBy)

Select

public Select(String tableName,
              Condition condition)

Select

public Select(String tableName)

Method Detail

addTable

public void addTable(String aTableName)

Add a table to the select statement

getWhereClause

public Condition getWhereClause()

Get a reference to the where clause

setWhereClause

public void setWhereClause(Condition aWhereCondition)

Set the where clause

getJoinClause

public Join getJoinClause()

setJoinClause

public void setJoinClause(Join aJoinClause)

setDistinct

public void setDistinct(boolean isDistinct)

isDistinct

public boolean isDistinct()

addWhat

public void addWhat(String columnName)

getOrderBy

public OrderBy getOrderBy()

Returns:

the OrderBy attribute associated with the select statement or null if it isn't specified.

setOrderBy

public void setOrderBy(OrderBy orderBy)

toString

public String toString()

Overrides:

toString in class Object