SQLBuilderBase.SelectBuilderBase

java.lang.Object
- org.gvsig.expressionevaluator.ExpressionBuilder.AbstractValue
- - org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.AbstractStatementPart
  - - org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.AbstractStatement
    - - org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.SelectBuilderBase

All Implemented Interfaces:

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

Direct Known Subclasses:

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

Enclosing class:

SQLBuilderBase
```
public class SQLBuilderBase.SelectBuilderBase
extends SQLBuilderBase.AbstractStatement
implements SQLBuilder.SelectBuilder
```

Field Summary

Fields
Modifier and Type	Field and Description
`protected boolean`	`check_order_and_offset`
`protected java.util.List<SQLBuilder.SelectColumnBuilder>`	`columns`
`protected boolean`	`distinct`
`protected SQLBuilder.FromBuilder`	`from`
`protected java.util.List<ExpressionBuilder.Value>`	`groupColumn`
`protected long`	`limit`
`protected long`	`offset`
`protected java.util.List<SQLBuilder.OrderByBuilder>`	`order_by`
`protected GeometryExpressionBuilder`	`where`

Fields inherited from class org.gvsig.expressionevaluator.ExpressionBuilder.AbstractValue
properties

Constructor Summary

Constructors
Constructor and Description

SelectBuilderBase()

Constructors
Constructor and Description
`SelectBuilderBase()`

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`void`	`accept(ExpressionBuilder.Visitor visitor, ExpressionBuilder.VisitorFilter filter)`
`SQLBuilder.SelectColumnBuilder`	`column()`
`SQLBuilder.SelectColumnBuilder`	`column(SQLBuilder.SelectColumnBuilder columnBuilder)`
`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... columns)`
`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 column)`
`protected boolean`	`isValid(java.lang.StringBuilder message)`
`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)`
`void`	`replace(ExpressionBuilder.Value target, ExpressionBuilder.Value replacement)`
`java.lang.String`	`toString()` Constructs the SQL statement.
`java.lang.String`	`toString(Formatter<ExpressionBuilder.Value> formatter)`
`GeometryExpressionBuilder`	`where()`

Methods inherited from class org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.AbstractStatement
clone

Methods inherited from class org.gvsig.expressionevaluator.ExpressionBuilder.AbstractValue
copyPropertiesFrom, getProperties, getProperty, setProperty

Methods inherited from class java.lang.Object
equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Methods inherited from interface org.gvsig.expressionevaluator.ExpressionBuilder.Value
clone, copyPropertiesFrom

Methods inherited from interface org.gvsig.tools.util.PropertiesSupport
getProperties, getProperty, setProperty

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

- Field Detail
  - from
```
protected SQLBuilder.FromBuilder from
```
  - where
```
protected GeometryExpressionBuilder where
```
  - limit
```
protected long limit
```
  - offset
```
protected long offset
```
  - columns
```
protected java.util.List<SQLBuilder.SelectColumnBuilder> columns
```
  - order_by
```
protected java.util.List<SQLBuilder.OrderByBuilder> order_by
```
  - distinct
```
protected boolean distinct
```
  - groupColumn
```
protected java.util.List<ExpressionBuilder.Value> groupColumn
```
  - check_order_and_offset
```
protected boolean check_order_and_offset
```
- Constructor Detail
  - SelectBuilderBase
```
public SelectBuilderBase()
```
- Method Detail
  - getGroups
```
public java.util.List<ExpressionBuilder.Value> getGroups()
```
    Specified by:
    
    getGroups in interface SQLBuilder.SelectBuilder
  - getColumns
```
public java.util.List<SQLBuilder.SelectColumnBuilder> getColumns()
```
    Specified by:
    
    getColumns in interface SQLBuilder.SelectBuilder
  - remove_column
```
public void remove_column(java.lang.String columnName)
```
    Specified by:
    
    remove_column in interface SQLBuilder.SelectBuilder
  - group_by
```
public SQLBuilder.SelectBuilder group_by(ExpressionBuilder.Value... columns)
```
    Specified by:
    
    group_by in interface SQLBuilder.SelectBuilder
  - accept
```
public void accept(ExpressionBuilder.Visitor visitor,
                   ExpressionBuilder.VisitorFilter filter)
```
    Specified by:
    
    accept in interface ExpressionBuilder.Visitable
    
    Overrides:
    
    accept in class ExpressionBuilder.AbstractValue
  - replace
```
public void replace(ExpressionBuilder.Value target,
                    ExpressionBuilder.Value replacement)
```
    Specified by:
    
    replace in interface ExpressionBuilder.Value
    
    Overrides:
    
    replace in class ExpressionBuilder.AbstractValue
  - distinct
```
public SQLBuilder.SelectBuilder distinct()
```
    Specified by:
    
    distinct in interface SQLBuilder.SelectBuilder
  - column
```
public SQLBuilder.SelectColumnBuilder column()
```
    Specified by:
    
    column in interface SQLBuilder.SelectBuilder
  - column
```
public SQLBuilder.SelectColumnBuilder column(SQLBuilder.SelectColumnBuilder columnBuilder)
```
    Specified by:
    
    column in interface SQLBuilder.SelectBuilder
  - column
```
public SQLBuilder.SelectColumnBuilder column(java.lang.String name)
```
    Specified by:
    
    column in interface SQLBuilder.SelectBuilder
  - getColumn
```
public SQLBuilder.SelectColumnBuilder getColumn(java.lang.String name)
```
    Specified by:
    
    getColumn in interface SQLBuilder.SelectBuilder
  - remove_all_columns
```
public SQLBuilder.SelectBuilder remove_all_columns()
```
    Specified by:
    
    remove_all_columns in interface SQLBuilder.SelectBuilder
  - has_column
```
public boolean has_column(java.lang.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 GeometryExpressionBuilder 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
  - limit
```
public SQLBuilder.SelectBuilder limit(java.lang.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
  - getOrderBy
```
public SQLBuilder.OrderByBuilder getOrderBy(ExpressionBuilder.Value column)
```
    Specified by:
    
    getOrderBy in interface SQLBuilder.SelectBuilder
  - getOrderBy
```
public SQLBuilder.OrderByBuilder getOrderBy(java.lang.String column)
```
    Specified by:
    
    getOrderBy in interface SQLBuilder.SelectBuilder
  - isGroupBy
```
public boolean isGroupBy(java.lang.String column)
```
    Specified by:
    
    isGroupBy in interface SQLBuilder.SelectBuilder
  - has_order_by
```
public boolean has_order_by()
```
    Specified by:
    
    has_order_by in interface SQLBuilder.SelectBuilder
  - has_group_by
```
public boolean has_group_by()
```
    Specified by:
    
    has_group_by in interface SQLBuilder.SelectBuilder
  - has_aggregate_functions
```
public boolean has_aggregate_functions()
```
    Specified by:
    
    has_aggregate_functions in interface SQLBuilder.SelectBuilder
  - disable_check_order_and_offset
```
public void disable_check_order_and_offset()
```
    Specified by:
    
    disable_check_order_and_offset in interface SQLBuilder.SelectBuilder
  - isValid
```
protected boolean isValid(java.lang.StringBuilder message)
```
  - toString
```
public java.lang.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 java.lang.Object
    
    Returns:
    
    the SQL select statement.
  - toString
```
public java.lang.String toString(Formatter<ExpressionBuilder.Value> formatter)
```
    Specified by:
    
    toString in interface ExpressionBuilder.Value

Class SQLBuilderBase.SelectBuilderBase

Field Summary

Fields inherited from class org.gvsig.expressionevaluator.ExpressionBuilder.AbstractValue

Constructor Summary

Method Summary

Methods inherited from class org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.AbstractStatement

Methods inherited from class org.gvsig.expressionevaluator.ExpressionBuilder.AbstractValue

Methods inherited from class java.lang.Object

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

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

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

Field Detail

from

where

limit

offset

columns

order_by

distinct

groupColumn

check_order_and_offset

Constructor Detail

SelectBuilderBase

Method Detail

getGroups

getColumns

remove_column

group_by

accept

replace

distinct

column

column

column

getColumn

remove_all_columns

has_column

from

has_from

where

has_where

limit

limit

has_limit

offset

has_offset

order_by

getOrderBy

getOrderBy

isGroupBy

has_order_by

has_group_by

has_aggregate_functions

disable_check_order_and_offset

isValid

toString

toString