PlainSelect (JSQLParser library 3.1 API)

java.lang.Object
- net.sf.jsqlparser.parser.ASTNodeAccessImpl
- - net.sf.jsqlparser.statement.select.PlainSelect

All Implemented Interfaces:: ASTNodeAccess, SelectBody

public class PlainSelect
extends ASTNodeAccessImpl
implements SelectBody

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`	`accept(SelectVisitor selectVisitor)`
`void`	`addGroupByColumnReference(Expression expr)`
`void`	`addSelectItems(SelectItem... items)`
`Distinct`	`getDistinct()`
`Fetch`	`getFetch()`
`First`	`getFirst()`
`static String`	`getFormatedList(List<?> list, String expression)`
`static String`	`getFormatedList(List<?> list, String expression, boolean useComma, boolean useBrackets)`
`Table`	`getForUpdateTable()`
`String`	`getForXmlPath()`
`FromItem`	`getFromItem()`
`GroupByElement`	`getGroupBy()` A list of `Expression`s of the GROUP BY clause.
`Expression`	`getHaving()`
`List<Table>`	`getIntoTables()`
`List<Join>`	`getJoins()` The list of `Join`s
`KSQLWindow`	`getKsqlWindow()`
`Limit`	`getLimit()`
`boolean`	`getMySqlSqlCalcFoundRows()`
`boolean`	`getMySqlSqlNoCache()`
`Offset`	`getOffset()`
`OptimizeFor`	`getOptimizeFor()`
`OracleHierarchicalExpression`	`getOracleHierarchical()`
`OracleHint`	`getOracleHint()`
`List<OrderByElement>`	`getOrderByElements()`
`List<SelectItem>`	`getSelectItems()`
`Skip`	`getSkip()`
`static String`	`getStringList(List<?> list)` List the toString out put of the objects in the List comma separated.
`static String`	`getStringList(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 String`	`orderByToString(boolean oracleSiblings, List<OrderByElement> orderByElements)`
`static String`	`orderByToString(List<OrderByElement> orderByElements)`
`void`	`setDistinct(Distinct distinct)`
`void`	`setFetch(Fetch fetch)`
`void`	`setFirst(First first)`
`void`	`setForUpdate(boolean forUpdate)`
`void`	`setForUpdateTable(Table forUpdateTable)`
`void`	`setForXmlPath(String forXmlPath)`
`void`	`setFromItem(FromItem item)`
`void`	`setGroupByElement(GroupByElement groupBy)`
`void`	`setHaving(Expression expression)`
`void`	`setIntoTables(List<Table> intoTables)`
`void`	`setJoins(List<Join> list)`
`void`	`setKsqlWindow(KSQLWindow ksqlWindow)`
`void`	`setLimit(Limit limit)`
`void`	`setMySqlSqlCalcFoundRows(boolean mySqlCalcFoundRows)`
`void`	`setMySqlSqlNoCache(boolean sqlNoCacheFlagSet)`
`void`	`setOffset(Offset offset)`
`void`	`setOptimizeFor(OptimizeFor optimizeFor)`
`void`	`setOracleHierarchical(OracleHierarchicalExpression oracleHierarchical)`
`void`	`setOracleHint(OracleHint oracleHint)`
`void`	`setOracleSiblings(boolean oracleSiblings)`
`void`	`setOrderByElements(List<OrderByElement> orderByElements)`
`void`	`setSelectItems(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)`
`String`	`toString()`

Methods inherited from class net.sf.jsqlparser.parser.ASTNodeAccessImpl
getASTNode, setASTNode

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

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

Method Detail

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

setUseBrackets

public void setUseBrackets(boolean useBrackets)

getFromItem
```
public FromItem getFromItem()
```

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

getSelectItems

public List<SelectItem> getSelectItems()

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

setFromItem

public void setFromItem(FromItem item)

setIntoTables

public void setIntoTables(List<Table> intoTables)

setSelectItems

public void setSelectItems(List<SelectItem> list)

addSelectItems

public void addSelectItems(SelectItem... items)

setWhere

public void setWhere(Expression where)

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

Returns:

the list of Joins

setJoins

public void setJoins(List<Join> list)

accept

public void accept(SelectVisitor selectVisitor)

Specified by:: accept in interface SelectBody

getOrderByElements

public List<OrderByElement> getOrderByElements()

setOrderByElements

public void setOrderByElements(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)
```

getOptimizeFor
```
public OptimizeFor getOptimizeFor()
```

setOptimizeFor

public void setOptimizeFor(OptimizeFor optimizeFor)

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)

getGroupBy
```
public GroupByElement getGroupBy()
```
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

setGroupByElement

public void setGroupByElement(GroupByElement groupBy)

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

Parameters:

wait - the Wait for this SELECT

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

Returns:

the value of the Wait set for this SELECT

getForXmlPath
```
public String getForXmlPath()
```

setForXmlPath

public void setForXmlPath(String forXmlPath)

getKsqlWindow
```
public KSQLWindow getKsqlWindow()
```

setKsqlWindow

public void setKsqlWindow(KSQLWindow ksqlWindow)

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

toString in class Object

orderByToString

public static String orderByToString(List<OrderByElement> orderByElements)

orderByToString

public static String orderByToString(boolean oracleSiblings,
                                     List<OrderByElement> orderByElements)

getFormatedList

public static String getFormatedList(List<?> list,
                                     String expression)

getFormatedList

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

getStringList
```
public static String getStringList(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)

Parameters:

list - list of objects with toString methods

Returns:

comma separated list of the elements in the list

See Also:

getStringList(List, boolean, boolean)

getStringList
```
public static String getStringList(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.

Parameters:

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

Returns:

comma separated list of the elements in the list

setMySqlSqlCalcFoundRows

public void setMySqlSqlCalcFoundRows(boolean mySqlCalcFoundRows)

setMySqlSqlNoCache

public void setMySqlSqlNoCache(boolean sqlNoCacheFlagSet)

getMySqlSqlCalcFoundRows

public boolean getMySqlSqlCalcFoundRows()

getMySqlSqlNoCache
```
public boolean getMySqlSqlNoCache()
```

Class PlainSelect

Constructor Summary

Method Summary

Methods inherited from class net.sf.jsqlparser.parser.ASTNodeAccessImpl

Methods inherited from class java.lang.Object

Constructor Detail

PlainSelect

Method Detail

isUseBrackets

setUseBrackets

getFromItem

getIntoTables

getSelectItems

getWhere

setFromItem

setIntoTables

setSelectItems

addSelectItems

setWhere

getJoins

setJoins

accept

getOrderByElements

setOrderByElements

getLimit

setLimit

getOffset

setOffset

getFetch

setFetch

getOptimizeFor

setOptimizeFor

getTop

setTop

getSkip

setSkip

getFirst

setFirst

getDistinct

setDistinct

getHaving

setHaving

getGroupBy

setGroupByElement

addGroupByColumnReference

getOracleHierarchical

setOracleHierarchical

isOracleSiblings

setOracleSiblings

isForUpdate

setForUpdate

getForUpdateTable

setForUpdateTable

getOracleHint

setOracleHint

setWait

getWait

getForXmlPath

setForXmlPath

getKsqlWindow

setKsqlWindow

toString

orderByToString

orderByToString

getFormatedList

getFormatedList

getStringList

getStringList

setMySqlSqlCalcFoundRows

setMySqlSqlNoCache

getMySqlSqlCalcFoundRows

getMySqlSqlNoCache