PlainSelect

java.lang.Object
- com.fr.general.jsqlparser.statement.select.PlainSelect

所有已实现的接口:

SelectBody
```
public class PlainSelect
extends java.lang.Object
implements SelectBody
```
The core of a "SELECT" statement (no UNION, no ORDER BY)

构造器概要

构造器
构造器和说明

PlainSelect()

构造器
构造器和说明
`PlainSelect()`

方法概要

方法
限定符和类型	方法和说明
`void`	`accept(SelectVisitor selectVisitor)`
`void`	`addGroupByColumnReference(Expression expr)`
`void`	`addSelectItems(SelectItem... items)`
`Distinct`	`getDistinct()`
`Fetch`	`getFetch()`
`First`	`getFirst()`
`static java.lang.String`	`getFormatedList(java.util.List<?> list, java.lang.String expression)`
`static java.lang.String`	`getFormatedList(java.util.List<?> list, java.lang.String expression, boolean useComma, boolean useBrackets)`
`Table`	`getForUpdateTable()`
`FromItem`	`getFromItem()` The `FromItem` in this query
`java.util.List<Expression>`	`getGroupByColumnReferences()` A list of `Expression`s of the GROUP BY clause.
`Expression`	`getHaving()`
`java.util.List<Table>`	`getIntoTables()`
`java.util.List<Join>`	`getJoins()` The list of `Join`s
`Limit`	`getLimit()`
`Offset`	`getOffset()`
`OracleHierarchicalExpression`	`getOracleHierarchical()`
`OracleHint`	`getOracleHint()`
`java.util.List<OrderByElement>`	`getOrderByElements()`
`java.util.List<SelectItem>`	`getSelectItems()` The `SelectItem`s in this query (for example the A,B,C in "SELECT A,B,C")
`Skip`	`getSkip()`
`static java.lang.String`	`getStringList(java.util.List<?> list)` List the toString out put of the objects in the List comma separated.
`static java.lang.String`	`getStringList(java.util.List<?> list, boolean useComma, boolean useBrackets)` List the toString out put of the objects in the List that can be comma separated.
`Top`	`getTop()`
`Wait`	`getWait()` Returns the value of the `Wait` set for this SELECT
`Expression`	`getWhere()`
`boolean`	`isForUpdate()`
`boolean`	`isOracleSiblings()`
`boolean`	`isUseBrackets()`
`static java.lang.String`	`orderByToString(boolean oracleSiblings, java.util.List<OrderByElement> orderByElements)`
`static java.lang.String`	`orderByToString(java.util.List<OrderByElement> orderByElements)`
`void`	`setDistinct(Distinct distinct)`
`void`	`setFetch(Fetch fetch)`
`void`	`setFirst(First first)`
`void`	`setForUpdate(boolean forUpdate)`
`void`	`setForUpdateTable(Table forUpdateTable)`
`void`	`setFromItem(FromItem item)`
`void`	`setGroupByColumnReferences(java.util.List<Expression> list)`
`void`	`setHaving(Expression expression)`
`void`	`setIntoTables(java.util.List<Table> intoTables)`
`void`	`setJoins(java.util.List<Join> list)`
`void`	`setLimit(Limit limit)`
`void`	`setOffset(Offset offset)`
`void`	`setOracleHierarchical(OracleHierarchicalExpression oracleHierarchical)`
`void`	`setOracleHint(OracleHint oracleHint)`
`void`	`setOracleSiblings(boolean oracleSiblings)`
`void`	`setOrderByElements(java.util.List<OrderByElement> orderByElements)`
`void`	`setSelectItems(java.util.List<SelectItem> list)`
`void`	`setSkip(Skip skip)`
`void`	`setTop(Top top)`
`void`	`setUseBrackets(boolean useBrackets)`
`void`	`setWait(Wait wait)` Sets the `Wait` for this SELECT
`void`	`setWhere(Expression where)`
`java.lang.String`	`toString()`

从类继承的方法 java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

构造器详细资料
- PlainSelect
```
public PlainSelect()
```

方法详细资料

isUseBrackets
```
public boolean isUseBrackets()
```

setUseBrackets

public void setUseBrackets(boolean useBrackets)

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

返回:
the FromItem

getIntoTables

public java.util.List<Table> getIntoTables()

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

返回:
a list of SelectItems

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

setFromItem

public void setFromItem(FromItem item)

setIntoTables

public void setIntoTables(java.util.List<Table> intoTables)

setSelectItems

public void setSelectItems(java.util.List<SelectItem> list)

addSelectItems

public void addSelectItems(SelectItem... items)

setWhere

public void setWhere(Expression where)

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

返回:
the list of Joins

setJoins

public void setJoins(java.util.List<Join> list)

accept

public void accept(SelectVisitor selectVisitor)

指定者:: accept 在接口中 SelectBody

getOrderByElements

public java.util.List<OrderByElement> getOrderByElements()

setOrderByElements

public void setOrderByElements(java.util.List<OrderByElement> orderByElements)

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)
```

getTop
```
public Top getTop()
```

setTop
```
public void setTop(Top top)
```

getSkip
```
public Skip getSkip()
```

setSkip
```
public void setSkip(Skip skip)
```

getFirst
```
public First getFirst()
```

setFirst
```
public void setFirst(First first)
```

getDistinct
```
public Distinct getDistinct()
```

setDistinct

public void setDistinct(Distinct distinct)

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

setHaving

public void setHaving(Expression expression)

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

返回:
a list of Expressions

setGroupByColumnReferences

public void setGroupByColumnReferences(java.util.List<Expression> list)

addGroupByColumnReference

public void addGroupByColumnReference(Expression expr)

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)

getForUpdateTable
```
public Table getForUpdateTable()
```

setForUpdateTable

public void setForUpdateTable(Table forUpdateTable)

getOracleHint
```
public OracleHint getOracleHint()
```

setOracleHint

public void setOracleHint(OracleHint oracleHint)

setWait
```
public void setWait(Wait wait)
```
Sets the Wait for this SELECT

参数:
wait - the Wait for this SELECT

getWait
```
public Wait getWait()
```
Returns the value of the Wait set for this SELECT

返回:
the value of the Wait set for this SELECT

toString
```
public java.lang.String toString()
```
覆盖:

toString 在类中 java.lang.Object

orderByToString

public static java.lang.String orderByToString(java.util.List<OrderByElement> orderByElements)

orderByToString

public static java.lang.String orderByToString(boolean oracleSiblings,
                               java.util.List<OrderByElement> orderByElements)

getFormatedList

public static java.lang.String getFormatedList(java.util.List<?> list,
                               java.lang.String expression)

getFormatedList

public static java.lang.String getFormatedList(java.util.List<?> list,
                               java.lang.String expression,
                               boolean useComma,
                               boolean useBrackets)

getStringList
```
public static java.lang.String getStringList(java.util.List<?> list)
```
List the toString out put of the objects in the List comma separated. If the List is null or empty an empty string is returned. The same as getStringList(list, true, false)

参数:
list - list of objects with toString methods

返回:
comma separated list of the elements in the list
另请参阅:
getStringList(List, boolean, boolean)

getStringList
```
public static java.lang.String getStringList(java.util.List<?> list,
                             boolean useComma,
                             boolean useBrackets)
```
List the toString out put of the objects in the List that can be comma separated. If the List is null or empty an empty string is returned.

参数:
list - list of objects with toString methods
useComma - true if the list has to be comma separated
useBrackets - true if the list has to be enclosed in brackets

返回:
comma separated list of the elements in the list

类 PlainSelect

构造器概要

方法概要

从类继承的方法 java.lang.Object

构造器详细资料

PlainSelect

方法详细资料

isUseBrackets

setUseBrackets

getFromItem

getIntoTables

getSelectItems

getWhere

setFromItem

setIntoTables

setSelectItems

addSelectItems

setWhere

getJoins

setJoins

accept

getOrderByElements

setOrderByElements

getLimit

setLimit

getOffset

setOffset

getFetch

setFetch

getTop

setTop

getSkip

setSkip

getFirst

setFirst

getDistinct

setDistinct

getHaving

setHaving

getGroupByColumnReferences

setGroupByColumnReferences

addGroupByColumnReference

getOracleHierarchical

setOracleHierarchical

isOracleSiblings

setOracleSiblings

isForUpdate

setForUpdate

getForUpdateTable

setForUpdateTable

getOracleHint

setOracleHint

setWait

getWait

toString

orderByToString

orderByToString

getFormatedList

getFormatedList

getStringList

getStringList