SELECT (XDEV Application Framework 6.0.2 API)

java.lang.Object
- com.xdev.jadoth.sqlengine.internal.QueryPart
- - com.xdev.jadoth.sqlengine.types.Query.Implementation
  - - com.xdev.jadoth.sqlengine.types.TableQuery.Implementation
    - - com.xdev.jadoth.sqlengine.SELECT

All Implemented Interfaces:

Copyable, ToString, Conditional<SELECT>, SelectItem, TableExpression, AssembableParamterizedQuery<Object>, ConditionalTableQuery, ConditionalTableReadingTableQuery, Query, TableQuery, TableReadingQuery, TableReadingTableQuery, ValueReadingQuery<ResultSet>, Serializable, Cloneable
```
public class SELECT
extends TableQuery.Implementation
implements ConditionalTableReadingTableQuery, TableExpression, SelectItem, Conditional<SELECT>
```
The Class SELECT.

Author:

Thomas Muenz

See Also:

Serialized Form

Nested Class Summary

Nested Classes
Modifier and Type Class and Description

protected class SELECT.SuperConditionalQuery
- Nested classes/interfaces inherited from class com.xdev.jadoth.sqlengine.types.Query.Implementation
  Query.Implementation.Jdbc, Query.Implementation.Logging
- Nested classes/interfaces inherited from interface com.xdev.jadoth.sqlengine.types.ConditionalTableQuery
  ConditionalTableQuery.Implementation
- Nested classes/interfaces inherited from interface com.xdev.jadoth.sqlengine.internal.interfaces.TableExpression
  TableExpression.Utils

Nested Classes
Modifier and Type	Class and Description
`protected class`	`SELECT.SuperConditionalQuery`

Field Summary
- Fields inherited from class com.xdev.jadoth.sqlengine.types.Query.Implementation
  jdbc, logging, loggingContextExecute
- Fields inherited from class com.xdev.jadoth.sqlengine.internal.QueryPart
  ASEXPRESSION, defaultClauseStringBuilderLength, defaultExpressionStringBuilderLength, defaultQueryStringBuilderLength, DELIMIT_ALIASES, DELIMIT_COLUMN_IDENTIFIERS, DELIMIT_TABLE_IDENTIFIERS, ESCAPE_DBL_QUOTES, ESCAPE_QUOTES, FLAGS_TAKEN, MINIINDENT, OMITALIAS, PACKED, QUALIFY_BY_TABLE, SINGLELINE, UNQUALIFIED

Constructor Summary

Constructors
Constructor and Description

SELECT()
Instantiates a new sELECT.

SELECT(SELECT copySource)

Constructors
Constructor and Description
`SELECT()` Instantiates a new sELECT.
`SELECT(SELECT copySource)`

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`SELECT`	`addJoinClause(JoinClause joinClause)`
`void`	`addSelectItem(SelectItem selectItem)`
`void`	`addSelectItems(List<SelectItem> selectItems)` Adds `selectItems` via the internal selectitems' implementation of `java.util.List.addAll(Collection)`
`SELECT`	`AND(Object condition)` AND.
`SELECT`	`AS(String newAlias)` AS.
`protected StringBuilder`	`assemble(DbmsDMLAssembler<?> dmlAssembler, StringBuilder sb, int indentLevel, int flags)` Assemble.
`void`	`clearSelectItems()` Clear select items.
`SELECT`	`clone()`
`SELECT`	`columns(Object... columns)` Columns.
`SELECT`	`copy()`
`SELECT`	`DISTINCT()` DISTINCT.
`SELECT`	`EXCEPT(SELECT exceptSelect)` EXCEPT.
`ResultSet`	`execute(Object... parameters)`
`Object`	`executeSingle(Object... parameters)` Execute single.
`SELECT`	`FETCH_FIRST(Integer n)` See SQL:2008 non-core feature IDs F856, F857, F858, and F859.
`SELECT`	`FROM(TableExpression table)`
`String`	`getAlias()` Gets the alias.
`List<SqlTableIdentity>`	`getClauseTables()`
`SELECT`	`getExceptSelect()` Gets the except select.
`Integer`	`getFetchFirstRowCount()` Gets the fetch first row count.
`FROM`	`getFromClause()`
`GROUP_BY`	`getGroupByClause()` Gets the group by clause.
`HAVING`	`getHavingClause()` Gets the having clause.
`SELECT`	`getIntersectSelect()` Gets the intersect select.
`int`	`getJoinCount()`
`List<JoinClause>`	`getJoins()`
`ConditionClause<?>`	`getLastConditionClause()`
`Integer`	`getOffsetSkipCount()` Gets the offset skip count.
`ORDER_BY`	`getOrderByClause()` Gets the order by clause.
`List<SelectItem>`	`getSelectItems()` Gets the select items.
`SqlClause<?>[]`	`getSqlClauses()`
`TableExpression`	`getTable()`
`SELECT`	`getUnionAllSelect()` Gets the union all select.
`SELECT`	`getUnionSelect()` Gets the union select.
`WHERE`	`getWhereClause()`
`SELECT`	`GROUP_BY(Object... groupByFields)` Creates a new GROUP BY clause for this SELECT object using the field list provided by `orderByFields`. See `setGroupByClause(GROUP_BY)` for setting an GROUP_BY clause object directly.
`SELECT`	`HAVING(Object havingCondition)` HAVING.
`SELECT`	`INNER_JOIN(TableExpression table, Object joinCondition)`
`SELECT`	`INTERSECT(SELECT intersectSelect)` INTERSECT.
`boolean`	`isDistinct()` Checks if is distinct.
`SELECT`	`items(Object... items)` Items.
`String`	`keyword()`
`SELECT`	`LEFT_JOIN(TableExpression table, Object joinCondition)`
`SELECT`	`OFFSET(Integer offsetRowCount)` OFFSET.
`SELECT`	`OR(Object condition)` OR.
`SELECT`	`ORDER_BY(Object... orderByFields)` Creates a new ORDER BY clause for this SELECT object using the field list provided by `orderByFields`. See `setOrderByClause(ORDER_BY)` for setting an ORDER_BY clause object directly.
`SELECT`	`OUTER_JOIN(TableExpression table, Object joinCondition)`
`SELECT`	`pack()`
`<C extends JoinClause> C`	`registerJoinClause(C join)`
`SELECT`	`RIGHT_JOIN(TableExpression table, Object joinCondition)`
`SELECT`	`setAlias(String alias)` Sets the alias.
`SELECT`	`setComment(String comment)`
`SELECT`	`setDatabaseGateway(DatabaseGateway<?> databaseGateway)`
`SELECT`	`setDistinct(boolean distinct)` Sets the distinct.
`SELECT`	`setExceptSelect(SELECT exceptSelect)` Sets the except select.
`SELECT`	`setFromClause(FROM fromClause)` Sets the from clause.
`SELECT`	`setGroupByClause(GROUP_BY groupByClause)` Sets the group by clause.
`SELECT`	`setHavingClause(HAVING havingClause)` Sets the having clause.
`SELECT`	`setIntersectSelect(SELECT intersectSelect)` Sets the intersect select.
`SELECT`	`setName(String name)`
`SELECT`	`setOrderByClause(ORDER_BY orderByClause)` Sets the order by clause.
`SELECT`	`setPacked(boolean packed)`
`void`	`setSelectItems(List<SelectItem> selectItems)` Sets this SELECT's new selectItems list to the elements of `selectItems`
`SELECT`	`setSingleLineMode(boolean singleLineMode)`
`SELECT`	`setUnionAllSelect(SELECT unionAllSelect)` Sets the union all select.
`SELECT`	`setUnionSelect(SELECT unionSelect)` Sets the union select.
`SELECT`	`setWhereClause(WHERE whereClause)`
`SELECT`	`singleLineMode()`
`SqlExpression`	`toSqlExpression()` To sql expression.
`SELECT`	`UNION_All(SELECT unionAllSelect)` UNIO n_ all.
`SELECT`	`UNION(SELECT unionSelect)` UNION.
`SELECT`	`WHERE(Object condition)`

Methods inherited from class com.xdev.jadoth.sqlengine.types.TableQuery.Implementation
getDatabaseGatewayForExecution

Methods inherited from class com.xdev.jadoth.sqlengine.types.Query.Implementation
assemble, execute, getComment, getCommentLines, getDatabaseGateway, getDMLAssembler, getListeners, getName, isDatabaseGatewaySet, isPacked, isPrepared, isSingleLineMode, listeners, prepare, setListeners, toString

Methods inherited from class com.xdev.jadoth.sqlengine.internal.QueryPart
assembleAlias, assembleObject, assembleQuery, bitAsExpression, bitDelimitAliases, bitDelimitColumnIdentifiers, bitDelimitTableIdentifiers, bitEscapeDoubleQuotes, bitMiniIndent, bitOmitAlias, bitPacked, bitQualified, bitQualifyByTable, bitSingleLine, concat, concatSqlExpressions, EscapeQuotes, flagsToString, function, indent, isAsExpression, isDelimitAliases, isDelimitColumnIdentifiers, isDelimitTableIdentifiers, isEscapeDoubleQuotes, isEscapeQuotes, isMiniIndent, isOmitAlias, isPacked, isQualifyByTable, isSingleLine, isUnqualified, list, printFlags, setAsExpression, setDelimitAliases, setDelimitColumnIdentifiers, setDelimitTableIdentifiers, setEscapeDoubleQuotes, setEscapeQuotes, setMiniIndent, setPacked, setQualified, setQualifyByTable, setSingleLine, setUseAlias

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

Methods inherited from interface com.xdev.jadoth.sqlengine.types.Query
assemble, getComment, getCommentLines, getDatabaseGatewayForExecution, getListeners, getName, isDatabaseGatewaySet, isPacked, isSingleLineMode, listeners, prepare, setListeners, toString

- Constructor Detail
  - SELECT
```
public SELECT()
```
    Instantiates a new sELECT.
  - SELECT
```
public SELECT(SELECT copySource)
```
- Method Detail
  - isDistinct
```
public boolean isDistinct()
```
    Checks if is distinct.
    
    Returns:
    
    the distinct
  - getUnionSelect
```
public SELECT getUnionSelect()
```
    Gets the union select.
    
    Returns:
    
    the unionSelect
  - getUnionAllSelect
```
public SELECT getUnionAllSelect()
```
    Gets the union all select.
    
    Returns:
    
    the unionAllSelect
  - getIntersectSelect
```
public SELECT getIntersectSelect()
```
    Gets the intersect select.
    
    Returns:
    
    the intersectSelect
  - getExceptSelect
```
public SELECT getExceptSelect()
```
    Gets the except select.
    
    Returns:
    
    the exceptSelect
  - getSelectItems
```
public List<SelectItem> getSelectItems()
```
    Gets the select items.
    
    Returns:
    
    the selectItems
  - getGroupByClause
```
public GROUP_BY getGroupByClause()
```
    Gets the group by clause.
    
    Returns:
    
    the groupByClause
  - getHavingClause
```
public HAVING getHavingClause()
```
    Gets the having clause.
    
    Returns:
    
    the havingClause
  - getOrderByClause
```
public ORDER_BY getOrderByClause()
```
    Gets the order by clause.
    
    Returns:
    
    the orderByClause
  - getOffsetSkipCount
```
public Integer getOffsetSkipCount()
```
    Gets the offset skip count.
    
    Returns:
    
    the offset skip count
  - getFetchFirstRowCount
```
public Integer getFetchFirstRowCount()
```
    Gets the fetch first row count.
    
    Returns:
    
    the fetch first row count
  - setDistinct
```
public SELECT setDistinct(boolean distinct)
```
    Sets the distinct.
    
    Parameters:
    
    distinct - the distinct to set
    
    Returns:
    
    the sELECT
  - setFromClause
```
public SELECT setFromClause(FROM fromClause)
```
    Sets the from clause.
    
    Specified by:
    
    setFromClause in interface ConditionalTableQuery
    
    Parameters:
    
    fromClause - the from clause
    
    Returns:
    
    the sELECT
  - setDatabaseGateway
```
public SELECT setDatabaseGateway(DatabaseGateway<?> databaseGateway)
```
    Specified by:
    
    setDatabaseGateway in interface Query
    
    Overrides:
    
    setDatabaseGateway in class Query.Implementation
    
    Parameters:
    
    databaseGateway -
    
    Returns:
  - setWhereClause
```
public SELECT setWhereClause(WHERE whereClause)
```
    Specified by:
    
    setWhereClause in interface ConditionalTableQuery
    
    Parameters:
    
    whereClause -
    
    Returns:
  - setGroupByClause
```
public SELECT setGroupByClause(GROUP_BY groupByClause)
```
    Sets the group by clause.
    
    Parameters:
    
    groupByClause - the groupByClause to set
    
    Returns:
    
    the sELECT
  - setHavingClause
```
public SELECT setHavingClause(HAVING havingClause)
```
    Sets the having clause.
    
    Parameters:
    
    havingClause - the havingClause to set
    
    Returns:
    
    the sELECT
  - setOrderByClause
```
public SELECT setOrderByClause(ORDER_BY orderByClause)
```
    Sets the order by clause.
    
    Parameters:
    
    orderByClause - the orderByClause to set
    
    Returns:
    
    the sELECT
  - setUnionSelect
```
public SELECT setUnionSelect(SELECT unionSelect)
```
    Sets the union select.
    
    Parameters:
    
    unionSelect - the unionSelect to set
    
    Returns:
    
    the sELECT
  - setUnionAllSelect
```
public SELECT setUnionAllSelect(SELECT unionAllSelect)
```
    Sets the union all select.
    
    Parameters:
    
    unionAllSelect - the unionAllSelect to set
    
    Returns:
    
    the sELECT
  - setIntersectSelect
```
public SELECT setIntersectSelect(SELECT intersectSelect)
```
    Sets the intersect select.
    
    Parameters:
    
    intersectSelect - the intersectSelect to set
    
    Returns:
    
    the sELECT
  - setExceptSelect
```
public SELECT setExceptSelect(SELECT exceptSelect)
```
    Sets the except select.
    
    Parameters:
    
    exceptSelect - the exceptSelect to set
    
    Returns:
    
    the sELECT
  - setAlias
```
public SELECT setAlias(String alias)
```
    Sets the alias.
    
    Parameters:
    
    alias - the alias to set
    
    Returns:
    
    the sELECT
  - setName
```
public SELECT setName(String name)
```
    Specified by:
    
    setName in interface Query
    
    Overrides:
    
    setName in class Query.Implementation
  - setComment
```
public SELECT setComment(String comment)
```
    Specified by:
    
    setComment in interface Query
    
    Overrides:
    
    setComment in class Query.Implementation
  - DISTINCT
```
public SELECT DISTINCT()
```
    DISTINCT.
    
    Returns:
    
    the sELECT
  - columns
```
public SELECT columns(Object... columns)
```
    Columns.
    
    Parameters:
    
    columns - the columns
    
    Returns:
    
    the sELECT
  - items
```
public SELECT items(Object... items)
```
    Items.
    
    Parameters:
    
    items - the items
    
    Returns:
    
    the sELECT
  - clearSelectItems
```
public void clearSelectItems()
```
    Clear select items.
  - GROUP_BY
```
public SELECT GROUP_BY(Object... groupByFields)
```
    Creates a new GROUP BY clause for this SELECT object using the field list provided by orderByFields.
    See setGroupByClause(GROUP_BY) for setting an GROUP_BY clause object directly. *
    
    Parameters:
    
    groupByFields - the fields to use in the GROUP BY clause of this SELECT object.
    
    Returns:
    
    this SELECT object
    
    See Also:
    
    setGroupByClause(GROUP_BY)
  - HAVING
```
public SELECT HAVING(Object havingCondition)
```
    HAVING.
    
    Parameters:
    
    havingCondition - the having condition
    
    Returns:
    
    the sELECT
  - ORDER_BY
```
public SELECT ORDER_BY(Object... orderByFields)
```
    Creates a new ORDER BY clause for this SELECT object using the field list provided by orderByFields.
    See setOrderByClause(ORDER_BY) for setting an ORDER_BY clause object directly. *
    
    Parameters:
    
    orderByFields - the fields to use in the ORDER BY clause of this SELECT object.
    
    Returns:
    
    this SELECT object
    
    See Also:
    
    setOrderByClause(ORDER_BY)
  - FETCH_FIRST
```
public SELECT FETCH_FIRST(Integer n)
```
    See SQL:2008 non-core feature IDs F856, F857, F858, and F859.
    
    Parameters:
    
    n - the n
    
    Returns:
    
    the sELECT
  - OFFSET
```
public SELECT OFFSET(Integer offsetRowCount)
```
    OFFSET.
    
    Parameters:
    
    offsetRowCount - the skip
    
    Returns:
    
    the sELECT
  - UNION
```
public SELECT UNION(SELECT unionSelect)
```
    UNION.
    
    Parameters:
    
    unionSelect - the union select
    
    Returns:
    
    the sELECT
  - UNION_All
```
public SELECT UNION_All(SELECT unionAllSelect)
```
    UNIO n_ all.
    
    Parameters:
    
    unionAllSelect - the union all select
    
    Returns:
    
    the sELECT
  - INTERSECT
```
public SELECT INTERSECT(SELECT intersectSelect)
```
    INTERSECT.
    
    Parameters:
    
    intersectSelect - the intersect select
    
    Returns:
    
    the sELECT
  - EXCEPT
```
public SELECT EXCEPT(SELECT exceptSelect)
```
    EXCEPT.
    
    Parameters:
    
    exceptSelect - the except select
    
    Returns:
    
    the sELECT
  - pack
```
public SELECT pack()
```
    Specified by:
    
    pack in interface Query
    
    Overrides:
    
    pack in class Query.Implementation
  - setPacked
```
public SELECT setPacked(boolean packed)
```
    Specified by:
    
    setPacked in interface Query
    
    Overrides:
    
    setPacked in class Query.Implementation
  - setSingleLineMode
```
public SELECT setSingleLineMode(boolean singleLineMode)
```
    Specified by:
    
    setSingleLineMode in interface Query
    
    Overrides:
    
    setSingleLineMode in class Query.Implementation
  - singleLineMode
```
public SELECT singleLineMode()
```
    Specified by:
    
    singleLineMode in interface Query
    
    Overrides:
    
    singleLineMode in class Query.Implementation
  - keyword
```
public String keyword()
```
    Specified by:
    
    keyword in interface Query
    
    Overrides:
    
    keyword in class QueryPart
    
    Returns:
    
    See Also:
    
    net.net.jadoth.sqlengine.interfaces.TableQuery#keyword()
  - AS
```
public SELECT AS(String newAlias)
```
    Description copied from interface: TableExpression
    
    AS.
    
    Specified by:
    
    AS in interface TableExpression
    
    Parameters:
    
    newAlias -
    
    Returns:
    
    See Also:
    
    TableExpression.AS(java.lang.String)
  - execute
```
public ResultSet execute(Object... parameters)
                  throws SQLEngineException
```
    Specified by:
    
    execute in interface Query
    
    Specified by:
    
    execute in interface ValueReadingQuery<ResultSet>
    
    Specified by:
    
    execute in class Query.Implementation
    
    Parameters:
    
    parameters -
    
    Returns:
    
    Throws:
    
    SQLEngineException
    
    See Also:
    
    net.net.jadoth.sqlengine.interfaces.TableQuery#execute(java.lang.Object[])
  - getTable
```
public TableExpression getTable()
```
    Specified by:
    
    getTable in interface TableQuery
    
    Returns:
    
    See Also:
    
    net.net.jadoth.sqlengine.interfaces.TableQuery#getTable()
  - assemble
```
protected StringBuilder assemble(DbmsDMLAssembler<?> dmlAssembler,
                                 StringBuilder sb,
                                 int indentLevel,
                                 int flags)
```
    Description copied from class: QueryPart
    
    Assemble.
    
    Overrides:
    
    assemble in class TableQuery.Implementation
    
    Parameters:
    
    dmlAssembler -
    
    sb -
    
    indentLevel -
    
    flags -
    
    Returns:
    
    See Also:
    
    net.net.jadoth.sqlengine.interfaces.TableQuery#assemble(com.xdev.jadoth.sqlengine.dbms.DbmsDMLAssembler, java.lang.StringBuilder, int, int)
  - AND
```
public SELECT AND(Object condition)
```
    Description copied from interface: Conditional
    
    AND.
    
    Specified by:
    
    AND in interface Conditional<SELECT>
    
    Specified by:
    
    AND in interface ConditionalTableQuery
    
    Parameters:
    
    condition - the condition
    
    Returns:
    
    the c
  - FROM
```
public SELECT FROM(TableExpression table)
```
    Specified by:
    
    FROM in interface ConditionalTableQuery
  - INNER_JOIN
```
public SELECT INNER_JOIN(TableExpression table,
                         Object joinCondition)
```
    Specified by:
    
    INNER_JOIN in interface ConditionalTableQuery
  - LEFT_JOIN
```
public SELECT LEFT_JOIN(TableExpression table,
                        Object joinCondition)
```
    Specified by:
    
    LEFT_JOIN in interface ConditionalTableQuery
  - OR
```
public SELECT OR(Object condition)
```
    Description copied from interface: Conditional
    
    OR.
    
    Specified by:
    
    OR in interface Conditional<SELECT>
    
    Specified by:
    
    OR in interface ConditionalTableQuery
    
    Parameters:
    
    condition - the condition
    
    Returns:
    
    the c
  - OUTER_JOIN
```
public SELECT OUTER_JOIN(TableExpression table,
                         Object joinCondition)
```
    Specified by:
    
    OUTER_JOIN in interface ConditionalTableQuery
  - RIGHT_JOIN
```
public SELECT RIGHT_JOIN(TableExpression table,
                         Object joinCondition)
```
    Specified by:
    
    RIGHT_JOIN in interface ConditionalTableQuery
  - WHERE
```
public SELECT WHERE(Object condition)
```
    Specified by:
    
    WHERE in interface ConditionalTableQuery
  - addJoinClause
```
public SELECT addJoinClause(JoinClause joinClause)
```
    Specified by:
    
    addJoinClause in interface ConditionalTableQuery
  - getClauseTables
```
public List<SqlTableIdentity> getClauseTables()
```
    Specified by:
    
    getClauseTables in interface ConditionalTableQuery
  - getFromClause
```
public FROM getFromClause()
```
    Specified by:
    
    getFromClause in interface ConditionalTableQuery
  - getJoinCount
```
public int getJoinCount()
```
    Specified by:
    
    getJoinCount in interface ConditionalTableQuery
  - getJoins
```
public List<JoinClause> getJoins()
```
    Specified by:
    
    getJoins in interface ConditionalTableQuery
  - getLastConditionClause
```
public ConditionClause<?> getLastConditionClause()
```
    Specified by:
    
    getLastConditionClause in interface ConditionalTableQuery
  - getSqlClauses
```
public SqlClause<?>[] getSqlClauses()
```
    Specified by:
    
    getSqlClauses in interface ConditionalTableQuery
  - getWhereClause
```
public WHERE getWhereClause()
```
    Specified by:
    
    getWhereClause in interface ConditionalTableQuery
  - registerJoinClause
```
public <C extends JoinClause> C registerJoinClause(C join)
                                            throws SQLEngineMissingFromClauseException
```
    Specified by:
    
    registerJoinClause in interface ConditionalTableQuery
    
    Throws:
    
    SQLEngineMissingFromClauseException
  - copy
```
public SELECT copy()
```
    Specified by:
    
    copy in interface Copyable
  - clone
```
public SELECT clone()
             throws CloneNotSupportedException
```
    Overrides:
    
    clone in class Object
    
    Returns:
    
    Throws:
    
    CloneNotSupportedException - is never thrown at the moment
  - getAlias
```
public String getAlias()
```
    Gets the alias.
    
    Returns:
    
    the alias
  - executeSingle
```
public Object executeSingle(Object... parameters)
                     throws SQLEngineException
```
    Execute single.
    
    Parameters:
    
    parameters - the parameters
    
    Returns:
    
    the object
    
    Throws:
    
    SQLEngineException - the sQL engine exception
  - toSqlExpression
```
public SqlExpression toSqlExpression()
```
    To sql expression.
    
    Returns:
    
    the sql expression
  - setSelectItems
```
public void setSelectItems(List<SelectItem> selectItems)
```
    Sets this SELECT's new selectItems list to the elements of selectItems
    
    Parameters:
    
    selectItems - the selectItems to set
  - addSelectItems
```
public void addSelectItems(List<SelectItem> selectItems)
```
    Adds selectItems via the internal selectitems' implementation of java.util.List.addAll(Collection)
    
    Parameters:
    
    selectItems - the selectItems to set
  - addSelectItem
```
public void addSelectItem(SelectItem selectItem)
```
    Parameters:
    
    selectItems - the selectItems to set

Class SELECT

Nested Class Summary

Nested classes/interfaces inherited from class com.xdev.jadoth.sqlengine.types.Query.Implementation

Nested classes/interfaces inherited from interface com.xdev.jadoth.sqlengine.types.ConditionalTableQuery

Nested classes/interfaces inherited from interface com.xdev.jadoth.sqlengine.internal.interfaces.TableExpression

Field Summary

Fields inherited from class com.xdev.jadoth.sqlengine.types.Query.Implementation

Fields inherited from class com.xdev.jadoth.sqlengine.internal.QueryPart

Constructor Summary

Method Summary

Methods inherited from class com.xdev.jadoth.sqlengine.types.TableQuery.Implementation

Methods inherited from class com.xdev.jadoth.sqlengine.types.Query.Implementation

Methods inherited from class com.xdev.jadoth.sqlengine.internal.QueryPart

Methods inherited from class java.lang.Object

Methods inherited from interface com.xdev.jadoth.sqlengine.types.Query

Constructor Detail

SELECT

SELECT

Method Detail

isDistinct

getUnionSelect

getUnionAllSelect

getIntersectSelect

getExceptSelect

getSelectItems

getGroupByClause

getHavingClause

getOrderByClause

getOffsetSkipCount

getFetchFirstRowCount

setDistinct

setFromClause

setDatabaseGateway

setWhereClause

setGroupByClause

setHavingClause

setOrderByClause

setUnionSelect

setUnionAllSelect

setIntersectSelect

setExceptSelect

setAlias

setName

setComment

DISTINCT

columns

items

clearSelectItems

GROUP_BY

HAVING

ORDER_BY

FETCH_FIRST

OFFSET

UNION

UNION_All

INTERSECT

EXCEPT

pack

setPacked

setSingleLineMode

singleLineMode

keyword

AS

execute

getTable

assemble

AND

FROM

INNER_JOIN

LEFT_JOIN

OR

OUTER_JOIN

RIGHT_JOIN

WHERE

addJoinClause

getClauseTables

getFromClause

getJoinCount

getJoins

getLastConditionClause