com.sh.common.parser.sql.statement.select

类 PlainSelect

java.lang.Object

com.sh.common.parser.sql.statement.select.PlainSelect

所有已实现的接口:

SelectBody

public class PlainSelect
extends java.lang.Object
implements SelectBody

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

Title:首亨软件 - TSS/CRM等

从以下版本开始:

2014年4月3日

版本:

3.0

作者:

江兴春

构造器概要

构造器

构造器和说明
PlainSelect()

方法概要

限定符和类型	方法和说明
void	accept(SelectVisitor selectVisitor)
Distinct	getDistinct()
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)
FromItem	getFromItem() The FromItem in this query
java.util.List	getGroupByColumnReferences() A list of Expressions of the GROUP BY clause.
Expression	getHaving()
Table	getInto()
java.util.List	getJoins() The list of Joins
Limit	getLimit()
java.util.List	getOrderByElements()
java.util.List	getSelectItems() The SelectItems in this query (for example the A,B,C in "SELECT A,B,C")
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()
Expression	getWhere()
static java.lang.String	orderByToString(java.util.List orderByElements)
void	setDistinct(Distinct distinct)
void	setFromItem(FromItem item)
void	setGroupByColumnReferences(java.util.List list)
void	setHaving(Expression expression)
void	setInto(Table table)
void	setJoins(java.util.List list)
void	setLimit(Limit limit)
void	setOrderByElements(java.util.List orderByElements)
void	setSelectItems(java.util.List list)
void	setTop(Top top)
void	setWhere(Expression where)
java.lang.String	toString()

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

equals, getClass, hashCode, notify, notifyAll, wait, wait, wait

构造器详细资料

PlainSelect

public PlainSelect()

方法详细资料

getFromItem

public FromItem getFromItem()

The FromItem in this query

返回:

the FromItem

getInto

public Table getInto()

getSelectItems

public java.util.List 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)

setInto

public void setInto(Table table)

setSelectItems

public void setSelectItems(java.util.List list)

setWhere

public void setWhere(Expression where)

getJoins

public java.util.List getJoins()

The list of Joins

返回:

the list of Joins

setJoins

public void setJoins(java.util.List list)

accept

public void accept(SelectVisitor selectVisitor)

指定者:

accept 在接口中 SelectBody

getOrderByElements

public java.util.List getOrderByElements()

setOrderByElements

public void setOrderByElements(java.util.List orderByElements)

getLimit

public Limit getLimit()

setLimit

public void setLimit(Limit limit)

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 java.util.List 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 list)

toString

public java.lang.String toString()

覆盖:

toString 在类中 java.lang.Object

orderByToString

public static java.lang.String orderByToString(java.util.List 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