Package com.invirgance.convirgance.jdbc.sql

Class ColumnExpressionStatement

java.lang.Object

com.invirgance.convirgance.jdbc.sql.ColumnExpressionStatement

All Implemented Interfaces:

NamedSchema, ExpressionStatement, SQLStatement

public class ColumnExpressionStatement
extends Object
implements ExpressionStatement

Represents a database column in SQL queries, with optional column aliasing (naming).

 DatabaseSchemaLayout layout = getHSQLLayout();
 
 Column column = layout.getCurrentSchema().getTable("customer").getColumn("zip");
 
 ColumnExpressionStatement expression = new 
 ColumnExpressionStatement(layout, column);
 
 expression.setName("zipcode");
 

Author:

jbanes

Constructor Summary

Constructors

Constructor	Description
ColumnExpressionStatement(DatabaseSchemaLayout layout, Column column)	Creates a column expression that can be used in SQL statements like SELECT, WHERE, etc.
ColumnExpressionStatement(DatabaseSchemaLayout layout, Column column, String name)	Creates a column expression with an alias (for "AS" clauses in SELECT statements).

Method Summary

Modifier and Type	Method	Description
Column	getColumn()	Returns the column.
String	getName()	Get the schema name of this database object
SQLStatement	getParent()	If this statement is part of a larger statement, this returns the parent statement.
String	getQuotedName()	Get the schema name of this database object quoted for use in a SQL statement
SQLRenderer	render(SQLRenderer renderer)
void	setName(String name)	Sets the alias name for this expression.
void	setParent(SQLStatement parent)
String	toString()

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

query, query

Constructor Details

ColumnExpressionStatement

public ColumnExpressionStatement(DatabaseSchemaLayout layout,
 Column column)

Creates a column expression that can be used in SQL statements like SELECT, WHERE, etc.

Parameters:

layout - The database schema layout with table and driver information.

column - The database column to reference.

ColumnExpressionStatement

public ColumnExpressionStatement(DatabaseSchemaLayout layout,
 Column column,
 String name)

Creates a column expression with an alias (for "AS" clauses in SELECT statements).

Parameters:

layout - The database schema layout with table and driver information.

column - The database column to reference.

name - The alias to give this column (creates "column AS name" in SQL)

Method Details

getParent

public SQLStatement getParent()

Description copied from interface: SQLStatement

If this statement is part of a larger statement, this returns the parent statement.

Specified by:

getParent in interface SQLStatement

Returns:

the parent statement

setParent

public void setParent(SQLStatement parent)

Specified by:

setParent in interface SQLStatement

getColumn

public Column getColumn()

Returns the column.

Returns:

Column

getName

public String getName()

Description copied from interface: NamedSchema

Get the schema name of this database object

Specified by:

getName in interface NamedSchema

Returns:

name of the object with exact database capitalization

setName

public void setName(String name)

Sets the alias name for this expression.

Parameters:

name - Name.

getQuotedName

public String getQuotedName()

Description copied from interface: NamedSchema

Get the schema name of this database object quoted for use in a SQL statement

Specified by:

getQuotedName in interface NamedSchema

Returns:

name of the object quoted for use in a SQL statement

render

public SQLRenderer render(SQLRenderer renderer)

Specified by:

render in interface SQLStatement

toString

public String toString()

Overrides:

toString in class Object