Package com.alibaba.druid.sql.builder.impl

Class SQLSelectBuilderImpl

java.lang.Object

com.alibaba.druid.sql.builder.impl.SQLSelectBuilderImpl

All Implemented Interfaces:

SQLSelectBuilder

public class SQLSelectBuilderImpl
extends Object
implements SQLSelectBuilder

Constructor Summary

Constructors

Constructor	Description
SQLSelectBuilderImpl(DbType dbType)
SQLSelectBuilderImpl(SQLSelectStatement stmt, DbType dbType)
SQLSelectBuilderImpl(String sql, DbType dbType)

Method Summary

Modifier and Type	Method	Description
protected SQLSelectGroupByClause	createGroupBy()
protected SQLOrderBy	createOrderBy()
protected SQLSelect	createSelect()
protected SQLSelectQuery	createSelectQueryBlock()
SQLSelectBuilderImpl	from(String table)
SQLSelectBuilderImpl	from(String table, String alias)
protected SQLSelectQueryBlock	getQueryBlock()
SQLSelect	getSQLSelect()
SQLSelectStatement	getSQLSelectStatement()
SQLSelectBuilderImpl	groupBy(String expr)
SQLSelectBuilderImpl	having(String expr)
SQLSelectBuilderImpl	into(String expr)
SQLSelectBuilderImpl	limit(int rowCount)
SQLSelectBuilderImpl	limit(int rowCount, int offset)
SQLSelectBuilderImpl	orderBy(String... columns)
SQLSelectBuilderImpl	select(String... columns)
SQLSelectBuilderImpl	selectWithAlias(String column, String alias)
String	toString()
SQLSelectBuilderImpl	where(String expr)
SQLSelectBuilderImpl	whereAnd(String expr)
SQLSelectBuilderImpl	whereOr(String expr)

Methods inherited from class java.lang.Object

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

Constructor Detail

SQLSelectBuilderImpl

public SQLSelectBuilderImpl(DbType dbType)

SQLSelectBuilderImpl

public SQLSelectBuilderImpl(String sql,
                            DbType dbType)

SQLSelectBuilderImpl

public SQLSelectBuilderImpl(SQLSelectStatement stmt,
                            DbType dbType)

Method Detail

getSQLSelect

public SQLSelect getSQLSelect()

getSQLSelectStatement

public SQLSelectStatement getSQLSelectStatement()

Specified by:

getSQLSelectStatement in interface SQLSelectBuilder

select

public SQLSelectBuilderImpl select(String... columns)

Specified by:

select in interface SQLSelectBuilder

selectWithAlias

public SQLSelectBuilderImpl selectWithAlias(String column,
                                            String alias)

Specified by:

selectWithAlias in interface SQLSelectBuilder

from

public SQLSelectBuilderImpl from(String table)

Specified by:

from in interface SQLSelectBuilder

from

public SQLSelectBuilderImpl from(String table,
                                 String alias)

Specified by:

from in interface SQLSelectBuilder

orderBy

public SQLSelectBuilderImpl orderBy(String... columns)

Specified by:

orderBy in interface SQLSelectBuilder

groupBy

public SQLSelectBuilderImpl groupBy(String expr)

Specified by:

groupBy in interface SQLSelectBuilder

having

public SQLSelectBuilderImpl having(String expr)

Specified by:

having in interface SQLSelectBuilder

into

public SQLSelectBuilderImpl into(String expr)

Specified by:

into in interface SQLSelectBuilder

where

public SQLSelectBuilderImpl where(String expr)

Specified by:

where in interface SQLSelectBuilder

whereAnd

public SQLSelectBuilderImpl whereAnd(String expr)

Specified by:

whereAnd in interface SQLSelectBuilder

whereOr

public SQLSelectBuilderImpl whereOr(String expr)

Specified by:

whereOr in interface SQLSelectBuilder

limit

public SQLSelectBuilderImpl limit(int rowCount)

Specified by:

limit in interface SQLSelectBuilder

limit

public SQLSelectBuilderImpl limit(int rowCount,
                                  int offset)

Specified by:

limit in interface SQLSelectBuilder

getQueryBlock

protected SQLSelectQueryBlock getQueryBlock()

createSelect

protected SQLSelect createSelect()

createSelectQueryBlock

protected SQLSelectQuery createSelectQueryBlock()

createOrderBy

protected SQLOrderBy createOrderBy()

createGroupBy

protected SQLSelectGroupByClause createGroupBy()

toString

public String toString()

Specified by:

toString in interface SQLSelectBuilder

Overrides:

toString in class Object