org.tinygroup.jsqlparser.statement.select

Class PlainSelect

java.lang.Object

org.tinygroup.jsqlparser.statement.select.PlainSelect

All Implemented Interfaces:

Serializable, SelectBody

public class PlainSelect
extends Object
implements SelectBody

The core of a "SELECT" statement (no UNION, no ORDER BY)

See Also:

Serialized Form

Constructor Summary

Constructors

Constructor and Description
PlainSelect()

Method Summary

Modifier and Type	Method and Description
void	accept(SelectVisitor selectVisitor)
void	addSelectItems(SelectItem... items)
Distinct	getDistinct()
Fetch	getFetch()
static String	getFormatedList(List<?> list, String expression)
static String	getFormatedList(List<?> list, String expression, boolean useComma, boolean useBrackets)
FromItem	getFromItem() The FromItem in this query
List<Expression>	getGroupByColumnReferences() A list of Expressions of the GROUP BY clause.
Expression	getHaving()
List<Table>	getIntoTables()
List<Join>	getJoins() The list of Joins
Limit	getLimit()
Offset	getOffset()
OracleHierarchicalExpression	getOracleHierarchical()
List<OrderByElement>	getOrderByElements()
List<SelectItem>	getSelectItems() The SelectItems in this query (for example the A,B,C in "SELECT A,B,C")
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()
Expression	getWhere()
boolean	isForUpdate()
boolean	isOracleSiblings()
static String	orderByToString(boolean oracleSiblings, List<OrderByElement> orderByElements)
static String	orderByToString(List<OrderByElement> orderByElements)
void	setDistinct(Distinct distinct)
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	setTop(Top top)
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

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

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)

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)

getTop

public Top getTop()

setTop

public void setTop(Top top)

getDistinct

public Distinct getDistinct()

setDistinct

public void setDistinct(Distinct distinct)

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)

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