Class Select
java.lang.Object
net.sf.jsqlparser.parser.ASTNodeAccessImpl
net.sf.jsqlparser.statement.select.Select
- All Implemented Interfaces:
Serializable
,Expression
,Model
,ASTNodeAccess
,Statement
- Direct Known Subclasses:
ParenthesedSelect
,PlainSelect
,SetOperationList
,TableStatement
,Values
- See Also:
-
Field Summary
FieldsModifier and TypeFieldDescription(package private) Fetch
(package private) ForClause
(package private) WithIsolation
(package private) Limit
(package private) Limit
(package private) Offset
(package private) boolean
(package private) List
<OrderByElement> -
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionvoid
accept
(ExpressionVisitor expressionVisitor) abstract void
accept
(SelectVisitor selectVisitor) void
accept
(StatementVisitor statementVisitor) addOrderByElements
(Collection<? extends OrderByElement> orderByElements) addOrderByElements
(OrderByElement... orderByElements) addWithItemsList
(Collection<? extends WithItem> withItemsList) addWithItemsList
(WithItem... withItemsList) abstract StringBuilder
appendSelectBodyTo
(StringBuilder builder) static StringBuilder
appendStringListTo
(StringBuilder builder, List<?> list, boolean useComma, boolean useBrackets) Append the toString out put of the objects in the List (that can be comma separated).appendTo
(StringBuilder builder) <E extends Select>
EgetFetch()
static String
getFormattedList
(List<?> list, String expression) static String
getFormattedList
(List<?> list, String expression, boolean useComma, boolean useBrackets) getLimit()
Deprecated.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.boolean
static String
orderByToString
(boolean oracleSiblings, List<OrderByElement> orderByElements) static String
orderByToString
(List<OrderByElement> orderByElements) void
setForClause
(ForClause forClause) void
setIsolation
(WithIsolation isolation) void
void
setLimitBy
(Limit limitBy) void
void
setOracleSiblings
(boolean oracleSiblings) void
setOrderByElements
(List<OrderByElement> orderByElements) void
setWithItemsList
(List<WithItem> withItemsList) toString()
withIsolation
(WithIsolation isolation) <E extends Select>
EwithLimitBy
(Class<E> type, Limit limitBy) withOffset
(Offset offset) withOracleSiblings
(boolean oracleSiblings) withOrderByElements
(List<OrderByElement> orderByElements) withWithItemsList
(List<WithItem> withItemsList) 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
-
withItemsList
-
limitBy
Limit limitBy -
limit
Limit limit -
offset
Offset offset -
fetch
Fetch fetch -
isolation
WithIsolation isolation -
oracleSiblings
boolean oracleSiblings -
forClause
ForClause forClause -
orderByElements
List<OrderByElement> orderByElements
-
-
Constructor Details
-
Select
public Select()
-
-
Method Details
-
orderByToString
-
orderByToString
-
getFormattedList
-
getFormattedList
-
getStringList
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 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 methodsuseComma
- true if the list has to be comma separateduseBrackets
- true if the list has to be enclosed in brackets- Returns:
- comma separated list of the elements in the list
-
appendStringListTo
public static StringBuilder appendStringListTo(StringBuilder builder, List<?> list, boolean useComma, boolean useBrackets) Append 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 methodsuseComma
- true if the list has to be comma separateduseBrackets
- true if the list has to be enclosed in brackets- Returns:
- comma separated list of the elements in the list
-
getWithItemsList
-
setWithItemsList
-
withWithItemsList
-
addWithItemsList
-
addWithItemsList
-
isOracleSiblings
public boolean isOracleSiblings() -
setOracleSiblings
public void setOracleSiblings(boolean oracleSiblings) -
withOracleSiblings
-
getForClause
-
setForClause
-
getOrderByElements
-
setOrderByElements
-
withOrderByElements
-
addOrderByElements
-
addOrderByElements
-
getLimit
-
setLimit
-
withLimit
-
getLimitBy
-
setLimitBy
-
withLimitBy
-
getOffset
-
setOffset
-
withOffset
-
getFetch
-
setFetch
-
withFetch
-
getIsolation
-
setIsolation
-
withIsolation
-
appendSelectBodyTo
-
appendTo
- Overrides:
appendTo
in classASTNodeAccessImpl
-
toString
-
accept
-
accept
-
accept
- Specified by:
accept
in interfaceExpression
-
getSelectBody
Deprecated. -
getValues
-
getPlainSelect
-
getSetOperationList
-
as
-