Package com.invirgance.convirgance.jdbc.sql

Class SelectStatement

java.lang.Object

com.invirgance.convirgance.jdbc.sql.SelectStatement

All Implemented Interfaces:

SQLStatement

public class SelectStatement
extends Object
implements SQLStatement

Author:

jbanes

Constructor Summary

Constructors

Constructor	Description
SelectStatement(DatabaseSchemaLayout layout)

Method Summary

Modifier and Type	Method	Description
SelectStatement	column(Column column)	Adds a column to the select clause
SelectStatement	column(Column column, String name)	Adds a column to the select clause with the specified result set name
SelectStatement	from(TabularStructure table)
SelectStatement	from(TabularStructure table, String name)
ExpressionStatement[]	getColumns()
SelectStatement	order(Column column)
SelectStatement	order(Column column, OrderBy order)
SelectStatement	order(ExpressionStatement column)
SelectStatement	order(ExpressionStatement column, OrderBy order)
SQLRenderer	render(SQLRenderer renderer)
String	toString()
WhereStatement<SelectStatement>	where()

Methods inherited from class java.lang.Object

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

Methods inherited from interface com.invirgance.convirgance.jdbc.sql.SQLStatement

getParent, query, query, setParent

Constructor Details

SelectStatement

public SelectStatement(DatabaseSchemaLayout layout)

Method Details

getColumns

public ExpressionStatement[] getColumns()

column

public SelectStatement column(Column column)

Adds a column to the select clause

Parameters:

column - Column to select

Returns:

this object for chaining

column

public SelectStatement column(Column column,
 String name)

Adds a column to the select clause with the specified result set name

Parameters:

column - Column to select

name - to generate "as" clause

Returns:

this object for chaining

from

public SelectStatement from(TabularStructure table)

from

public SelectStatement from(TabularStructure table,
 String name)

where

public WhereStatement<SelectStatement> where()

order

public SelectStatement order(ExpressionStatement column)

order

public SelectStatement order(ExpressionStatement column,
 OrderBy order)

order

public SelectStatement order(Column column)

order

public SelectStatement order(Column column,
 OrderBy order)

render

public SQLRenderer render(SQLRenderer renderer)

Specified by:

render in interface SQLStatement

toString

public String toString()

Overrides:

toString in class Object