org.gvsig.fmap.dal

Interface SQLBuilder.SelectBuilder

All Superinterfaces:

java.lang.Cloneable, ExpressionBuilder.Value, ExpressionBuilder.Visitable, PropertiesSupport, SQLBuilder.Statement, SQLBuilder.StatementPart

All Known Implementing Classes:

H2SpatialSQLBuilder.H2SpatialSelectBuilderBase, MDBSQLBuilder.MDBSelectBuilderBase, PostgreSQLBuilder.PostgreSQLSelectBuilderBase, SQLBuilderBase.SelectBuilderBase, SQLiteSQLBuilder.SQLiteSelectBuilderBase

Enclosing interface:

SQLBuilder

public static interface SQLBuilder.SelectBuilder
extends SQLBuilder.Statement

Method Summary

Modifier and Type	Method and Description
SQLBuilder.SelectColumnBuilder	column()
SQLBuilder.SelectColumnBuilder	column(SQLBuilder.SelectColumnBuilder column)
SQLBuilder.SelectColumnBuilder	column(java.lang.String name)
void	disable_check_order_and_offset()
SQLBuilder.SelectBuilder	distinct()
SQLBuilder.FromBuilder	from()
SQLBuilder.SelectColumnBuilder	getColumn(java.lang.String name)
java.util.List<SQLBuilder.SelectColumnBuilder>	getColumns()
java.util.List<ExpressionBuilder.Value>	getGroups()
SQLBuilder.OrderByBuilder	getOrderBy(ExpressionBuilder.Value column)
SQLBuilder.OrderByBuilder	getOrderBy(java.lang.String column)
SQLBuilder.SelectBuilder	group_by(ExpressionBuilder.Value... column)
boolean	has_aggregate_functions()
boolean	has_column(java.lang.String name)
boolean	has_from()
boolean	has_group_by()
boolean	has_limit()
boolean	has_offset()
boolean	has_order_by()
boolean	has_where()
boolean	isGroupBy(java.lang.String name)
SQLBuilder.SelectBuilder	limit(long limit)
SQLBuilder.SelectBuilder	limit(java.lang.Long limit)
SQLBuilder.SelectBuilder	offset(long offset) Specifies an offset to be applied to the SQL statement.
SQLBuilder.OrderByBuilder	order_by()
SQLBuilder.SelectBuilder	remove_all_columns()
void	remove_column(java.lang.String columnName)
java.lang.String	toString() Constructs the SQL statement.
GeometryExpressionBuilder	where()

Methods inherited from interface org.gvsig.expressionevaluator.ExpressionBuilder.Value

clone, copyPropertiesFrom, replace, toString

Methods inherited from interface org.gvsig.expressionevaluator.ExpressionBuilder.Visitable

accept

Methods inherited from interface org.gvsig.tools.util.PropertiesSupport

getProperties, getProperty, setProperty

Methods inherited from interface org.gvsig.tools.lang.Cloneable

cloneQuietly, cloneQuietly

Method Detail

column

SQLBuilder.SelectColumnBuilder column()

column

SQLBuilder.SelectColumnBuilder column(java.lang.String name)

column

SQLBuilder.SelectColumnBuilder column(SQLBuilder.SelectColumnBuilder column)

remove_all_columns

SQLBuilder.SelectBuilder remove_all_columns()

from

SQLBuilder.FromBuilder from()

where

GeometryExpressionBuilder where()

order_by

SQLBuilder.OrderByBuilder order_by()

getOrderBy

SQLBuilder.OrderByBuilder getOrderBy(java.lang.String column)

getOrderBy

SQLBuilder.OrderByBuilder getOrderBy(ExpressionBuilder.Value column)

group_by

SQLBuilder.SelectBuilder group_by(ExpressionBuilder.Value... column)

distinct

SQLBuilder.SelectBuilder distinct()

limit

SQLBuilder.SelectBuilder limit(long limit)

limit

SQLBuilder.SelectBuilder limit(java.lang.Long limit)

offset

SQLBuilder.SelectBuilder offset(long offset)

Specifies an offset to be applied to the SQL statement. Only an offset can be applied if an order has been specified. Otherwise an IllegalStateException exception will be thrown when constructing the SQL statement invoking the toString method.

Parameters:

offset -

Returns:

this SelectBuilder

has_column

boolean has_column(java.lang.String name)

has_where

boolean has_where()

has_from

boolean has_from()

has_order_by

boolean has_order_by()

has_group_by

boolean has_group_by()

has_aggregate_functions

boolean has_aggregate_functions()

has_limit

boolean has_limit()

has_offset

boolean has_offset()

disable_check_order_and_offset

void disable_check_order_and_offset()

toString

java.lang.String toString()

Constructs the SQL statement. If the values associated with the SQL statement are not valid an IllegalStateException exception is thrown.

Overrides:

toString in class java.lang.Object

Returns:

the SQL select statement.

Throws:

java.lang.IllegalStateException - if the values of select statement are not valids.

getGroups

java.util.List<ExpressionBuilder.Value> getGroups()

getColumns

java.util.List<SQLBuilder.SelectColumnBuilder> getColumns()

getColumn

SQLBuilder.SelectColumnBuilder getColumn(java.lang.String name)

remove_column

void remove_column(java.lang.String columnName)

isGroupBy

boolean isGroupBy(java.lang.String name)