org.gvsig.fmap.dal

Interface SQLBuilder.SelectBuilder

All Superinterfaces:

ExpressionBuilder.Visitable, SQLBuilder.Statement

All Known Implementing Classes:

H2SpatialSQLBuilder.H2SpatialSelectBuilderBase, PostgreSQLBuilder.PostgreSQLSelectBuilderBase, SQLBuilderBase.SelectBuilderBase

Enclosing interface:

SQLBuilder

public static interface SQLBuilder.SelectBuilder
extends SQLBuilder.Statement

Method Summary

Modifier and Type	Method and Description
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()
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 interface org.gvsig.fmap.dal.ExpressionBuilder.Visitable

accept

Method Detail

column

SQLBuilder.SelectColumnBuilder column()

from

SQLBuilder.FromBuilder from()

where

ExpressionBuilder where()

order_by

SQLBuilder.OrderByBuilder order_by()

distinct

SQLBuilder.SelectBuilder distinct()

limit

SQLBuilder.SelectBuilder limit(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(String name)

has_where

boolean has_where()

has_from

boolean has_from()

has_order_by

boolean has_order_by()

has_limit

boolean has_limit()

has_offset

boolean has_offset()

toString

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 Object

Returns:

the SQL select statement.

Throws:

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