Class SQLSelectQueryBlock

All Implemented Interfaces:
SQLDbTypedObject, SQLObject, SQLReplaceable, SQLSelectQuery
Direct Known Subclasses:
DB2SelectQueryBlock, MySqlSelectQueryBlock, OdpsSelectQueryBlock, OracleSelectQueryBlock, OscarSelectQueryBlock, PGSelectQueryBlock, SQLServerSelectQueryBlock

public class SQLSelectQueryBlock extends SQLSelectQueryBase implements SQLReplaceable, SQLDbTypedObject
  • Field Details

  • Constructor Details

    • SQLSelectQueryBlock

      public SQLSelectQueryBlock()
    • SQLSelectQueryBlock

      public SQLSelectQueryBlock(DbType dbType)
  • Method Details

    • getInto

      public SQLExprTableSource getInto()
    • setInto

      public void setInto(SQLExpr into)
    • setInto

      public void setInto(SQLExprTableSource into)
    • getGroupBy

      public SQLSelectGroupByClause getGroupBy()
    • setGroupBy

      public void setGroupBy(SQLSelectGroupByClause x)
    • getWindows

      public List<SQLWindow> getWindows()
    • addWindow

      public void addWindow(SQLWindow x)
    • getWhere

      public SQLExpr getWhere()
    • setWhere

      public void setWhere(SQLExpr x)
    • addWhere

      public void addWhere(SQLExpr condition)
    • addWhereForDynamicFilter

      public void addWhereForDynamicFilter(SQLExpr condition)
    • whereOr

      public void whereOr(SQLExpr condition)
    • addHaving

      public void addHaving(SQLExpr condition)
    • getOrderBy

      public SQLOrderBy getOrderBy()
    • setOrderBy

      public void setOrderBy(SQLOrderBy orderBy)
    • addOrderBy

      public void addOrderBy(SQLOrderBy orderBy)
    • addOrderBy

      public void addOrderBy(SQLSelectOrderByItem orderByItem)
    • containsOrderBy

      public boolean containsOrderBy(SQLSelectOrderByItem orderByItem)
    • addOrderBy

      public void addOrderBy(SQLExpr orderBy, SQLOrderingSpecification type)
    • addOrderBy

      public void addOrderBy(SQLExpr orderBy)
    • getOrderBySiblings

      public SQLOrderBy getOrderBySiblings()
    • setOrderBySiblings

      public void setOrderBySiblings(SQLOrderBy orderBySiblings)
    • getDistionOption

      public int getDistionOption()
    • setDistionOption

      public void setDistionOption(int distionOption)
    • setDistinct

      public void setDistinct()
    • isDistinct

      public boolean isDistinct()
    • getSelectList

      public List<SQLSelectItem> getSelectList()
    • getSelectItem

      public SQLSelectItem getSelectItem(int i)
    • addSelectItem

      public void addSelectItem(SQLSelectItem item)
    • addSelectItem

      public SQLSelectItem addSelectItem(SQLExpr expr)
    • addSelectItem

      public void addSelectItem(String selectItemExpr, String alias)
    • addSelectItem

      public void addSelectItem(SQLExpr expr, String alias)
    • hasSelectAggregation

      public boolean hasSelectAggregation()
    • getFrom

      public SQLTableSource getFrom()
    • setFrom

      public void setFrom(SQLExpr from)
    • setFrom

      public void setFrom(SQLTableSource from)
    • setFrom

      public void setFrom(SQLSelectQueryBlock queryBlock, String alias)
    • setFrom

      public void setFrom(SQLSelect select, String alias)
    • setFrom

      public void setFrom(String tableName, String alias)
    • isForUpdate

      public boolean isForUpdate()
    • setForUpdate

      public void setForUpdate(boolean forUpdate)
    • isNoWait

      public boolean isNoWait()
    • setNoWait

      public void setNoWait(boolean noWait)
    • isSkipLocked

      public boolean isSkipLocked()
    • setSkipLocked

      public void setSkipLocked(boolean skipLocked)
    • isForShare

      public boolean isForShare()
    • setForShare

      public void setForShare(boolean forShare)
    • getWaitTime

      public SQLExpr getWaitTime()
    • setWaitTime

      public void setWaitTime(SQLExpr waitTime)
    • getLimit

      public SQLLimit getLimit()
    • setLimit

      public void setLimit(SQLLimit limit)
    • mergeLimit

      public void mergeLimit(SQLLimit limit)
    • getFirst

      public SQLExpr getFirst()
    • setFirst

      public void setFirst(SQLExpr first)
    • getOffset

      public SQLExpr getOffset()
    • setOffset

      public void setOffset(SQLExpr offset)
    • isPrior

      public boolean isPrior()
    • setPrior

      public void setPrior(boolean prior)
    • getStartWith

      public SQLExpr getStartWith()
    • setStartWith

      public void setStartWith(SQLExpr startWith)
    • getConnectBy

      public SQLExpr getConnectBy()
    • setConnectBy

      public void setConnectBy(SQLExpr connectBy)
    • isNoCycle

      public boolean isNoCycle()
    • setNoCycle

      public void setNoCycle(boolean noCycle)
    • getDistributeBy

      public List<SQLSelectOrderByItem> getDistributeBy()
    • getDistributeByDirect

      public List<SQLSelectOrderByItem> getDistributeByDirect()
    • addDistributeBy

      public void addDistributeBy(SQLExpr x)
    • addDistributeBy

      public void addDistributeBy(SQLSelectOrderByItem item)
    • getSortBy

      public List<SQLSelectOrderByItem> getSortBy()
    • getSortByDirect

      public List<SQLSelectOrderByItem> getSortByDirect()
    • addSortBy

      public void addSortBy(SQLSelectOrderByItem item)
    • accept0

      protected void accept0(SQLASTVisitor visitor)
      Specified by:
      accept0 in class SQLObjectImpl
    • equals

      public boolean equals(Object o)
      Overrides:
      equals in class Object
    • hashCode

      public int hashCode()
      Overrides:
      hashCode in class Object
    • equalsForMergeJoin

      public boolean equalsForMergeJoin(SQLSelectQueryBlock that)
    • clone

      public SQLSelectQueryBlock clone()
      Specified by:
      clone in interface SQLObject
      Specified by:
      clone in interface SQLSelectQuery
      Specified by:
      clone in class SQLSelectQueryBase
    • getForUpdateOf

      public List<SQLExpr> getForUpdateOf()
    • getForUpdateOfSize

      public int getForUpdateOfSize()
    • cloneSelectListTo

      public void cloneSelectListTo(SQLSelectQueryBlock x)
    • cloneTo

      public void cloneTo(SQLSelectQueryBlock x)
    • findTableSource

      public SQLTableSource findTableSource(String alias)
    • findTableSourceWithColumn

      public SQLTableSource findTableSourceWithColumn(String column)
    • findTableSourceWithColumn

      public SQLTableSource findTableSourceWithColumn(long columnHash)
    • replace

      public boolean replace(SQLExpr expr, SQLExpr target)
      Specified by:
      replace in interface SQLReplaceable
    • findSelectItem

      public SQLSelectItem findSelectItem(String ident)
    • findSelectItem

      public SQLSelectItem findSelectItem(long identHash)
    • selectItemHasAllColumn

      public boolean selectItemHasAllColumn()
    • selectItemHasAllColumn

      public boolean selectItemHasAllColumn(boolean recursive)
    • findAllColumnSelectItem

      public SQLSelectItem findAllColumnSelectItem()
    • findColumn

      public SQLColumnDefinition findColumn(String columnName)
    • findColumn

      public SQLColumnDefinition findColumn(long columnNameHash)
    • resolveColum

      public SQLObject resolveColum(long columnNameHash)
    • addCondition

      public void addCondition(String conditionSql)
    • addCondition

      public void addCondition(SQLExpr expr)
    • removeCondition

      public boolean removeCondition(String conditionSql)
    • removeCondition

      public boolean removeCondition(SQLExpr condition)
    • limit

      public void limit(int rowCount, int offset)
    • getCachedSelectList

      public String getCachedSelectList()
    • setCachedSelectList

      public void setCachedSelectList(String cachedSelectList, long cachedSelectListHash)
    • getCachedSelectListHash

      public long getCachedSelectListHash()
    • getDbType

      public DbType getDbType()
      Specified by:
      getDbType in interface SQLDbTypedObject
    • setDbType

      public void setDbType(DbType dbType)
    • getHintsDirect

      public List<SQLCommentHint> getHintsDirect()
    • getHints

      public List<SQLCommentHint> getHints()
    • setHints

      public void setHints(List<SQLCommentHint> hints)
    • getHintsSize

      public int getHintsSize()
    • replaceInParent

      public boolean replaceInParent(SQLSelectQuery x)
    • getClusterBy

      public List<SQLSelectOrderByItem> getClusterBy()
    • getClusterByDirect

      public List<SQLSelectOrderByItem> getClusterByDirect()
    • addClusterBy

      public void addClusterBy(SQLSelectOrderByItem item)
    • computeSelecteListAlias

      public List<String> computeSelecteListAlias()
    • getMappJoinTableSources

      public List<SQLTableSource> getMappJoinTableSources()
    • clearMapJoinHint

      public boolean clearMapJoinHint()