com.github.braisdom.objsql.sql

类 Select<T>

java.lang.Object

com.github.braisdom.objsql.sql.AbstractExpression

com.github.braisdom.objsql.sql.Select<T>

所有已实现的接口:

ComparableExpression, Dataset, Expression, Sqlizable

public class Select<T>
extends AbstractExpression
implements Dataset

字段概要

字段

限定符和类型	字段和说明
protected Dataset[]	fromDatasets
protected Expression[]	groupByExpressions
protected Expression	havingExpression
protected List<JoinExpression>	joinExpressions
protected int	limit
protected int	offset
protected Expression[]	orderByExpressions
protected Map<String,Expression>	projectionMaps
protected List<Expression>	projections
protected Dataset[]	unionAllDatasets
protected Dataset[]	unionDatasets
protected LogicalExpression	whereExpression

构造器概要

构造器

构造器和说明
Select()
Select(Dataset dataset)

方法概要

限定符和类型	方法和说明
Expression	col(String alias)
List<T>	execute(DatabaseType databaseType, Class<T> domainClass)
Select	from(Dataset... datasets)
Select	fullJoin(Dataset dataset, LogicalExpression onExpression)
Expression	getProjection(String alias)
Select	groupBy(Expression... expressions)
Select	having(Expression expression)
Select	innerJoin(Dataset dataset, LogicalExpression onExpression)
Select	leftOuterJoin(Dataset dataset, LogicalExpression onExpression)
Select	limit(int limit)
Select	offset(int offset)
Select	orderBy(Expression... expressions)
String	prettyFormat(DatabaseType databaseType)
protected void	processFrom(ExpressionContext expressionContext, StringBuilder sql)
protected void	processGroupBy(ExpressionContext expressionContext, StringBuilder sql)
protected void	processJoins(ExpressionContext expressionContext, StringBuilder sql)
protected void	processOrderBy(ExpressionContext expressionContext, StringBuilder sql)
protected void	processProjections(ExpressionContext expressionContext, StringBuilder sql)
protected void	processUnion(ExpressionContext expressionContext, StringBuilder sql)
protected void	processWhere(ExpressionContext expressionContext, StringBuilder sql)
Select	project(Expression... projections)
Select	rightOuterJoin(Dataset dataset, LogicalExpression onExpression)
String	toSql(ExpressionContext expressionContext)
Select	union(Dataset... datasets)
Select	unionAll(Dataset... datasets)
Select	where(LogicalExpression expression)

从类继承的方法 com.github.braisdom.objsql.sql.AbstractExpression

as, div, eq, ge, getAlias, gt, le, lt, minus, ne, ne2, plus, processDataset, rem, setAlias, times

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

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

从接口继承的方法 com.github.braisdom.objsql.sql.Dataset

getAlias

从接口继承的方法 com.github.braisdom.objsql.sql.Expression

as, div, div, div, div, div, div, div, minus, minus, minus, minus, minus, minus, minus, plus, plus, plus, plus, plus, plus, plus, rem, rem, rem, rem, rem, rem, rem, times, times, times, times, times, times, times

从接口继承的方法 com.github.braisdom.objsql.sql.ComparableExpression

eq, eq, eq, eq, eq, eq, eq, ge, ge, ge, ge, ge, ge, ge, gt, gt, gt, gt, gt, gt, gt, le, le, le, le, le, le, le, lt, lt, lt, lt, lt, lt, lt, ne, ne, ne, ne, ne, ne, ne, ne2, ne2, ne2, ne2, ne2, ne2, ne2

字段详细资料

projections

protected List<Expression> projections

projectionMaps

protected Map<String,Expression> projectionMaps

fromDatasets

protected Dataset[] fromDatasets

whereExpression

protected LogicalExpression whereExpression

joinExpressions

protected List<JoinExpression> joinExpressions

groupByExpressions

protected Expression[] groupByExpressions

havingExpression

protected Expression havingExpression

orderByExpressions

protected Expression[] orderByExpressions

limit

protected int limit

offset

protected int offset

unionDatasets

protected Dataset[] unionDatasets

unionAllDatasets

protected Dataset[] unionAllDatasets

构造器详细资料

Select

public Select()

Select

public Select(Dataset dataset)

方法详细资料

project

public Select project(Expression... projections)

col

public Expression col(String alias)

getProjection

public Expression getProjection(String alias)

from

public Select from(Dataset... datasets)

where

public Select where(LogicalExpression expression)

leftOuterJoin

public Select leftOuterJoin(Dataset dataset,
                            LogicalExpression onExpression)

rightOuterJoin

public Select rightOuterJoin(Dataset dataset,
                             LogicalExpression onExpression)

innerJoin

public Select innerJoin(Dataset dataset,
                        LogicalExpression onExpression)

fullJoin

public Select fullJoin(Dataset dataset,
                       LogicalExpression onExpression)

groupBy

public Select groupBy(Expression... expressions)

having

public Select having(Expression expression)

orderBy

public Select orderBy(Expression... expressions)

limit

public Select limit(int limit)

offset

public Select offset(int offset)

union

public Select union(Dataset... datasets)

unionAll

public Select unionAll(Dataset... datasets)

prettyFormat

public String prettyFormat(DatabaseType databaseType)
                    throws SQLSyntaxException

抛出:

SQLSyntaxException

execute

public List<T> execute(DatabaseType databaseType,
                       Class<T> domainClass)
                throws SQLException,
                       SQLSyntaxException

抛出:

SQLException

SQLSyntaxException

toSql

public String toSql(ExpressionContext expressionContext)
             throws SQLSyntaxException

指定者:

toSql 在接口中 Sqlizable

抛出:

SQLSyntaxException

processProjections

protected void processProjections(ExpressionContext expressionContext,
                                  StringBuilder sql)
                           throws SQLSyntaxException

抛出:

SQLSyntaxException

processFrom

protected void processFrom(ExpressionContext expressionContext,
                           StringBuilder sql)
                    throws SQLSyntaxException

抛出:

SQLSyntaxException

processWhere

protected void processWhere(ExpressionContext expressionContext,
                            StringBuilder sql)
                     throws SQLSyntaxException

抛出:

SQLSyntaxException

processJoins

protected void processJoins(ExpressionContext expressionContext,
                            StringBuilder sql)
                     throws SQLSyntaxException

抛出:

SQLSyntaxException

processGroupBy

protected void processGroupBy(ExpressionContext expressionContext,
                              StringBuilder sql)
                       throws SQLSyntaxException

抛出:

SQLSyntaxException

processOrderBy

protected void processOrderBy(ExpressionContext expressionContext,
                              StringBuilder sql)
                       throws SQLSyntaxException

抛出:

SQLSyntaxException

processUnion

protected void processUnion(ExpressionContext expressionContext,
                            StringBuilder sql)
                     throws SQLSyntaxException

抛出:

SQLSyntaxException