org.gvsig.fmap.dal.feature.spi

Class SQLBuilderBase.SelectBuilderBase

java.lang.Object

org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.SelectBuilderBase

All Implemented Interfaces:

ExpressionBuilder.Visitable, SQLBuilder.SelectBuilder, SQLBuilder.Statement

Direct Known Subclasses:

H2SpatialSQLBuilder.H2SpatialSelectBuilderBase, PostgreSQLBuilder.PostgreSQLSelectBuilderBase

Enclosing class:

SQLBuilderBase

public class SQLBuilderBase.SelectBuilderBase
extends Object
implements SQLBuilder.SelectBuilder

Field Summary

Fields

Modifier and Type	Field and Description
protected List<SQLBuilder.SelectColumnBuilder>	columns
protected boolean	distinct
protected SQLBuilder.FromBuilder	from
protected long	limit
protected long	offset
protected List<SQLBuilder.OrderByBuilder>	order_by
protected ExpressionBuilder	where

Constructor Summary

Constructors

Constructor and Description
SelectBuilderBase()

Method Summary

Modifier and Type	Method and Description
void	accept(ExpressionBuilder.Visitor visitor, ExpressionBuilder.VisitorFilter filter)
SQLBuilder.SelectColumnBuilder	column()
SQLBuilder.SelectBuilder	distinct()
SQLBuilder.FromBuilder	from()
boolean	has_column(String name)
boolean	has_from()
boolean	has_limit()
boolean	has_offset()
boolean	has_order_by()
boolean	has_where()
protected boolean	isValid(StringBuilder message)
SQLBuilder.SelectBuilder	limit(long limit)
SQLBuilder.SelectBuilder	offset(long offset) Specifies an offset to be applied to the SQL statement.
SQLBuilder.OrderByBuilder	order_by()
String	toString() Constructs the SQL statement.
ExpressionBuilder	where()

Methods inherited from class java.lang.Object

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

Field Detail

from

protected SQLBuilder.FromBuilder from

where

protected ExpressionBuilder where

limit

protected long limit

offset

protected long offset

columns

protected List<SQLBuilder.SelectColumnBuilder> columns

order_by

protected List<SQLBuilder.OrderByBuilder> order_by

distinct

protected boolean distinct

Constructor Detail

SelectBuilderBase

public SelectBuilderBase()

Method Detail

accept

public void accept(ExpressionBuilder.Visitor visitor,
                   ExpressionBuilder.VisitorFilter filter)

Specified by:

accept in interface ExpressionBuilder.Visitable

distinct

public SQLBuilder.SelectBuilder distinct()

Specified by:

distinct in interface SQLBuilder.SelectBuilder

column

public SQLBuilder.SelectColumnBuilder column()

Specified by:

column in interface SQLBuilder.SelectBuilder

has_column

public boolean has_column(String name)

Specified by:

has_column in interface SQLBuilder.SelectBuilder

from

public SQLBuilder.FromBuilder from()

Specified by:

from in interface SQLBuilder.SelectBuilder

has_from

public boolean has_from()

Specified by:

has_from in interface SQLBuilder.SelectBuilder

where

public ExpressionBuilder where()

Specified by:

where in interface SQLBuilder.SelectBuilder

has_where

public boolean has_where()

Specified by:

has_where in interface SQLBuilder.SelectBuilder

limit

public SQLBuilder.SelectBuilder limit(long limit)

Specified by:

limit in interface SQLBuilder.SelectBuilder

has_limit

public boolean has_limit()

Specified by:

has_limit in interface SQLBuilder.SelectBuilder

offset

public SQLBuilder.SelectBuilder offset(long offset)

Description copied from interface: SQLBuilder.SelectBuilder

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.

Specified by:

offset in interface SQLBuilder.SelectBuilder

Returns:

this SelectBuilder

has_offset

public boolean has_offset()

Specified by:

has_offset in interface SQLBuilder.SelectBuilder

order_by

public SQLBuilder.OrderByBuilder order_by()

Specified by:

order_by in interface SQLBuilder.SelectBuilder

has_order_by

public boolean has_order_by()

Specified by:

has_order_by in interface SQLBuilder.SelectBuilder

isValid

protected boolean isValid(StringBuilder message)

toString

public String toString()

Description copied from interface: SQLBuilder.SelectBuilder

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

Specified by:

toString in interface SQLBuilder.SelectBuilder

Overrides:

toString in class Object

Returns:

the SQL select statement.