Class PlainSelect
java.lang.Object
net.sf.jsqlparser.parser.ASTNodeAccessImpl
net.sf.jsqlparser.statement.select.Select
net.sf.jsqlparser.statement.select.PlainSelect
- All Implemented Interfaces:
Serializable
,Expression
,Model
,ASTNodeAccess
,Statement
- See Also:
-
Field Summary
FieldsModifier and TypeFieldDescriptionprivate Distinct
private boolean
private First
private ForMode
private Table
private String
private FromItem
private GroupByElement
private Expression
private Table
private boolean
private boolean
private KSQLWindow
private List
<LateralView> private MySqlSqlCacheFlags
private boolean
private boolean
private boolean
private OptimizeFor
private OracleHierarchicalExpression
private OracleHint
private Expression
private List
<SelectItem<?>> private Skip
private boolean
private Top
private boolean
private Wait
private Expression
private List
<WindowDefinition> Fields inherited from class net.sf.jsqlparser.statement.select.Select
fetch, forClause, isolation, limit, limitBy, offset, oracleSiblings, orderByElements, withItemsList
-
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionvoid
accept
(SelectVisitor selectVisitor) addIntoTables
(Collection<? extends Table> intoTables) addIntoTables
(Table... intoTables) addJoins
(Collection<? extends Join> joins) addLateralView
(LateralView lateralView) addSelectItem
(Expression expression) addSelectItem
(Expression expression, Alias alias) addSelectItems
(Collection<? extends SelectItem<?>> selectItems) addSelectItems
(Expression... expressions) addSelectItems
(SelectItem<?>... items) appendSelectBodyTo
(StringBuilder builder) getFirst()
<E extends FromItem>
EgetFromItem
(Class<E> type) A list ofExpression
s of the GROUP BY clause.<E extends Expression>
EgetJoin
(int index) getJoins()
The list ofJoin
sboolean
boolean
SelectItem
<?> getSelectItem
(int index) List
<SelectItem<?>> getSkip()
getTop()
getWait()
Returns the value of theWait
set for this SELECTgetWhere()
<E extends Expression>
Eboolean
boolean
isNoWait()
boolean
boolean
Deprecated.boolean
boolean
boolean
void
setDistinct
(Distinct distinct) void
setEmitChanges
(boolean emitChanges) void
void
setForMode
(ForMode forMode) 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
setIntoTempTable
(Table intoTempTable) void
void
setKsqlWindow
(KSQLWindow ksqlWindow) void
setLateralViews
(Collection<LateralView> lateralViews) void
setMySqlHintStraightJoin
(boolean mySqlHintStraightJoin) void
setMySqlSqlCacheFlag
(MySqlSqlCacheFlags sqlCacheFlag) void
setMySqlSqlCalcFoundRows
(boolean mySqlCalcFoundRows) void
setNoWait
(boolean noWait) void
setOptimizeFor
(OptimizeFor optimizeFor) void
setOracleHierarchical
(OracleHierarchicalExpression oracleHierarchical) void
setOracleHint
(OracleHint oracleHint) setQualify
(Expression qualify) void
setSelectItems
(List<SelectItem<?>> list) void
void
setSkipLocked
(boolean skipLocked) void
void
setUseWithNoLog
(boolean useWithNoLog) void
setUsingFinal
(boolean usingFinal) void
setUsingOnly
(boolean usingOnly) void
Sets theWait
for this SELECTvoid
setWhere
(Expression where) void
setWindowDefinitions
(List<WindowDefinition> windowDefinitions) toString()
withDistinct
(Distinct distinct) withForMode
(ForMode forMode) withForUpdateTable
(Table forUpdateTable) withForXmlPath
(String forXmlPath) withFromItem
(FromItem item) withHaving
(Expression having) withIntoTables
(List<Table> intoTables) withIntoTempTable
(Table intoTempTable) withKsqlWindow
(KSQLWindow ksqlWindow) withLateralViews
(Collection<LateralView> lateralViews) withMySqlHintStraightJoin
(boolean mySqlHintStraightJoin) withMySqlSqlCalcFoundRows
(boolean mySqlCalcFoundRows) withMySqlSqlNoCache
(MySqlSqlCacheFlags mySqlCacheFlag) withNoWait
(boolean noWait) withOptimizeFor
(OptimizeFor optimizeFor) withOracleHierarchical
(OracleHierarchicalExpression oracleHierarchical) withOracleHint
(OracleHint oracleHint) withOracleSiblings
(boolean oracleSiblings) withSelectItems
(List<SelectItem<?>> list) withSkipLocked
(boolean skipLocked) withUseWithNoLog
(boolean useWithNoLog) withUsingFinal
(boolean usingFinal) withUsingOnly
(boolean usingOnly) withWhere
(Expression where) Methods inherited from class net.sf.jsqlparser.statement.select.Select
accept, accept, addOrderByElements, addOrderByElements, addWithItemsList, addWithItemsList, appendStringListTo, appendTo, as, getFetch, getForClause, getFormattedList, getFormattedList, getIsolation, getLimit, getLimitBy, getOffset, getOrderByElements, getPlainSelect, getSelectBody, getSetOperationList, getStringList, getStringList, getValues, getWithItemsList, isOracleSiblings, orderByToString, orderByToString, setFetch, setForClause, setIsolation, setLimit, setLimitBy, setOffset, setOracleSiblings, setOrderByElements, setWithItemsList, withFetch, withIsolation, withLimit, withLimitBy, withOffset, withOrderByElements, withWithItemsList
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
Methods inherited from interface net.sf.jsqlparser.parser.ASTNodeAccess
getASTNode, setASTNode
-
Field Details
-
distinct
-
selectItems
-
intoTables
-
fromItem
-
lateralViews
-
joins
-
where
-
groupBy
-
having
-
qualify
-
optimizeFor
-
skip
-
mySqlHintStraightJoin
private boolean mySqlHintStraightJoin -
first
-
top
-
oracleHierarchical
-
oracleHint
-
forMode
-
forUpdateTable
-
skipLocked
private boolean skipLocked -
wait
-
mySqlSqlCalcFoundRows
private boolean mySqlSqlCalcFoundRows -
mySqlCacheFlag
-
forXmlPath
-
ksqlWindow
-
noWait
private boolean noWait -
emitChanges
private boolean emitChanges -
windowDefinitions
-
isUsingFinal
private boolean isUsingFinal- See Also:
-
isUsingOnly
private boolean isUsingOnly -
useWithNoLog
private boolean useWithNoLog -
intoTempTable
-
-
Constructor Details
-
PlainSelect
public PlainSelect()
-
-
Method Details
-
isUseBrackets
Deprecated. -
getFromItem
-
getIntoTables
-
getSelectItems
-
getSelectItem
-
getWhere
-
withFromItem
-
setFromItem
-
setIntoTables
-
withSelectItems
-
setSelectItems
-
addSelectItems
-
addSelectItems
-
addSelectItem
-
addSelectItem
-
setWhere
-
getLateralViews
-
setLateralViews
-
addLateralView
-
withLateralViews
-
getJoins
The list ofJoin
s- Returns:
- the list of
Join
s
-
getJoin
-
addJoins
-
withJoins
-
setJoins
-
isUsingFinal
public boolean isUsingFinal() -
setUsingFinal
public void setUsingFinal(boolean usingFinal) -
withUsingFinal
-
isUsingOnly
public boolean isUsingOnly() -
setUsingOnly
public void setUsingOnly(boolean usingOnly) -
withUsingOnly
-
isUseWithNoLog
public boolean isUseWithNoLog() -
setUseWithNoLog
public void setUseWithNoLog(boolean useWithNoLog) -
withUseWithNoLog
-
getIntoTempTable
-
setIntoTempTable
-
withIntoTempTable
-
accept
-
getOptimizeFor
-
setOptimizeFor
-
getTop
-
setTop
-
getSkip
-
setSkip
-
getMySqlHintStraightJoin
public boolean getMySqlHintStraightJoin() -
setMySqlHintStraightJoin
public void setMySqlHintStraightJoin(boolean mySqlHintStraightJoin) -
getFirst
-
setFirst
-
getDistinct
-
setDistinct
-
getHaving
-
setHaving
-
getQualify
-
setQualify
-
getGroupBy
A list ofExpression
s of the GROUP BY clause. It is null in case there is no GROUP BY clause- Returns:
- a list of
Expression
s
-
setGroupByElement
-
addGroupByColumnReference
-
getOracleHierarchical
-
setOracleHierarchical
-
getForMode
-
setForMode
-
getForUpdateTable
-
setForUpdateTable
-
getOracleHint
-
setOracleHint
-
setWait
Sets theWait
for this SELECT- Parameters:
wait
- theWait
for this SELECT
-
getWait
Returns the value of theWait
set for this SELECT- Returns:
- the value of the
Wait
set for this SELECT
-
getForXmlPath
-
setForXmlPath
-
getKsqlWindow
-
setKsqlWindow
-
setEmitChanges
public void setEmitChanges(boolean emitChanges) -
isEmitChanges
public boolean isEmitChanges() -
getWindowDefinitions
-
setWindowDefinitions
-
isSkipLocked
public boolean isSkipLocked() -
setSkipLocked
public void setSkipLocked(boolean skipLocked) -
appendSelectBodyTo
- Specified by:
appendSelectBodyTo
in classSelect
-
toString
-
withMySqlSqlCalcFoundRows
-
withMySqlSqlNoCache
-
setMySqlSqlCalcFoundRows
public void setMySqlSqlCalcFoundRows(boolean mySqlCalcFoundRows) -
setMySqlSqlCacheFlag
-
getMySqlSqlCalcFoundRows
public boolean getMySqlSqlCalcFoundRows() -
getMySqlSqlCacheFlag
-
setNoWait
public void setNoWait(boolean noWait) -
isNoWait
public boolean isNoWait() -
withDistinct
-
withIntoTables
-
withWhere
-
withOptimizeFor
-
withSkip
-
withMySqlHintStraightJoin
-
withFirst
-
withTop
-
withOracleHierarchical
-
withOracleHint
-
withOracleSiblings
- Overrides:
withOracleSiblings
in classSelect
-
withForMode
-
withForUpdateTable
-
withForXmlPath
-
withKsqlWindow
-
withNoWait
-
withSkipLocked
-
withHaving
-
withWait
-
addSelectItems
-
addIntoTables
-
addIntoTables
-
addJoins
-
getFromItem
-
getWhere
-
getHaving
-