PlainSelect (tiny-码云(gitee.com))

java.lang.Object
- org.tinygroup.tinysqldsl.select.PlainSelect

All Implemented Interfaces:

SelectBody, StatementBody, StatementBuildProcessor
```
public class PlainSelect
extends Object
implements SelectBody
```
普通的select对象

Author:

renhui

Constructor Summary

Constructors
Constructor and Description

PlainSelect()

Constructors
Constructor and Description
`PlainSelect()`

Method Summary

All Methods Static Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`void`	`addGroupByExpressions(Expression... expressions)`
`void`	`addIntoTables(Table... tables)`
`void`	`addJoins(Join... joinArray)`
`void`	`addOrderByElements(OrderByElement... orderBys)`
`void`	`addSelectItems(SelectItem... items)`
`void`	`builderStatement(StatementSqlBuilder builder)` 实现接口的sql片段通过builder.appendSql(String segment)进行拼接,也可以builder.getStringBuilder方法获取StringBuilder,然后进行append 实现的参数信息通过builder.addParamValue(Object...
`static PlainSelect`	`copy(PlainSelect plainSelect)`
`Fetch`	`getFetch()`
`FromItem`	`getFromItem()` The `FromItem` in this query
`List<Expression>`	`getGroupByColumnReferences()` A list of `Expression`s of the GROUP BY clause.
`Expression`	`getHaving()`
`List<Table>`	`getIntoTables()`
`List<Join>`	`getJoins()` The list of `Join`s
`Limit`	`getLimit()`
`Offset`	`getOffset()`
`OracleHierarchicalExpression`	`getOracleHierarchical()`
`List<OrderByElement>`	`getOrderByElements()`
`List<SelectItem>`	`getSelectItems()` The `SelectItem`s in this query (for example the A,B,C in "SELECT A,B,C")
`Expression`	`getWhere()`
`boolean`	`isForUpdate()`
`boolean`	`isOracleSiblings()`
`void`	`setFetch(Fetch fetch)`
`void`	`setForUpdate(boolean forUpdate)`
`void`	`setFromItem(FromItem item)`
`void`	`setGroupByColumnReferences(List<Expression> list)`
`void`	`setHaving(Expression expression)`
`void`	`setIntoTables(List<Table> intoTables)`
`void`	`setJoins(List<Join> list)`
`void`	`setLimit(Limit limit)`
`void`	`setOffset(Offset offset)`
`void`	`setOracleHierarchical(OracleHierarchicalExpression oracleHierarchical)`
`void`	`setOracleSiblings(boolean oracleSiblings)`
`void`	`setOrderByElements(List<OrderByElement> orderByElements)`
`void`	`setSelectItems(List<SelectItem> list)`
`void`	`setWhere(Expression where)`
`String`	`toString()`

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

Constructor Detail
- PlainSelect
```
public PlainSelect()
```

Method Detail

copy

public static PlainSelect copy(PlainSelect plainSelect)

getFromItem
```
public FromItem getFromItem()
```
The FromItem in this query

Returns:

the FromItem

setFromItem

public void setFromItem(FromItem item)

getIntoTables
```
public List<Table> getIntoTables()
```

setIntoTables

public void setIntoTables(List<Table> intoTables)

getSelectItems
```
public List<SelectItem> getSelectItems()
```
The SelectItems in this query (for example the A,B,C in "SELECT A,B,C")

Returns:

a list of SelectItems

setSelectItems

public void setSelectItems(List<SelectItem> list)

getWhere
```
public Expression getWhere()
```

setWhere

public void setWhere(Expression where)

addSelectItems

public void addSelectItems(SelectItem... items)

addIntoTables

public void addIntoTables(Table... tables)

getJoins
```
public List<Join> getJoins()
```
The list of Joins

Returns:

the list of Joins

setJoins

public void setJoins(List<Join> list)

addJoins

public void addJoins(Join... joinArray)

getOrderByElements

public List<OrderByElement> getOrderByElements()

setOrderByElements

public void setOrderByElements(List<OrderByElement> orderByElements)

addOrderByElements

public void addOrderByElements(OrderByElement... orderBys)

getLimit
```
public Limit getLimit()
```

setLimit
```
public void setLimit(Limit limit)
```

getOffset
```
public Offset getOffset()
```

setOffset
```
public void setOffset(Offset offset)
```

getFetch
```
public Fetch getFetch()
```

setFetch
```
public void setFetch(Fetch fetch)
```

getHaving
```
public Expression getHaving()
```

setHaving

public void setHaving(Expression expression)

getGroupByColumnReferences
```
public List<Expression> getGroupByColumnReferences()
```
A list of Expressions of the GROUP BY clause. It is null in case there is no GROUP BY clause

Returns:

a list of Expressions

setGroupByColumnReferences

public void setGroupByColumnReferences(List<Expression> list)

addGroupByExpressions

public void addGroupByExpressions(Expression... expressions)

getOracleHierarchical

public OracleHierarchicalExpression getOracleHierarchical()

setOracleHierarchical

public void setOracleHierarchical(OracleHierarchicalExpression oracleHierarchical)

isOracleSiblings
```
public boolean isOracleSiblings()
```

setOracleSiblings

public void setOracleSiblings(boolean oracleSiblings)

isForUpdate
```
public boolean isForUpdate()
```

setForUpdate

public void setForUpdate(boolean forUpdate)

toString
```
public String toString()
```
Overrides:

toString in class Object

builderStatement
```
public void builderStatement(StatementSqlBuilder builder)
```
Description copied from interface: StatementBuildProcessor

实现接口的sql片段通过builder.appendSql(String segment)进行拼接,也可以builder.getStringBuilder方法获取StringBuilder,然后进行append 实现的参数信息通过builder.addParamValue(Object... values)进行参数组装

Specified by:

builderStatement in interface StatementBuildProcessor

Class PlainSelect

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Constructor Detail

PlainSelect

Method Detail

copy

getFromItem

setFromItem

getIntoTables

setIntoTables

getSelectItems

setSelectItems

getWhere

setWhere

addSelectItems

addIntoTables

getJoins

setJoins

addJoins

getOrderByElements

setOrderByElements

addOrderByElements

getLimit

setLimit

getOffset

setOffset

getFetch

setFetch

getHaving

setHaving

getGroupByColumnReferences

setGroupByColumnReferences

addGroupByExpressions

getOracleHierarchical

setOracleHierarchical

isOracleSiblings

setOracleSiblings

isForUpdate

setForUpdate

toString

builderStatement