com.github.houbb.sql.builder.core.support.querier.builder.select

类 SelectBuilder

java.lang.Object

com.github.houbb.sql.builder.core.support.querier.builder.QueryBuilder

com.github.houbb.sql.builder.core.support.querier.builder.select.SelectBuilder

直接已知子类:

AfterJoinBuilder, AfterLimitBuilder, AfterSelectBuilder, BeforeLimitBuilder, FinalBuilder

public abstract class SelectBuilder
extends QueryBuilder

字段概要

从类继承的字段 com.github.houbb.sql.builder.core.support.querier.builder.QueryBuilder

syntaxProvider

构造器概要

构造器

限定符	构造器和说明
protected	SelectBuilder(SelectBuilder parent)
protected	SelectBuilder(SyntaxProvider syntaxProvider)

方法概要

限定符和类型	方法和说明
protected void	addJoin(Join join)
protected void	addSelectColumns(String... columns)
protected void	andHaving(String condition)
protected void	andWhere(String condition)
String	build()
protected String	createAlias(String value, String alias)
protected String	getFrom()
protected String	getGroupBy()
protected String	getHaving()
protected List<Join>	getJoins()
protected Integer	getLimit()
protected Integer	getOffset()
protected String	getOrderBy()
protected OrderType	getOrderType()
protected List<String>	getSelectColumns()
protected SelectType	getSelectType()
protected String	getWhere()
protected void	orHaving(String condition)
protected void	orWhere(String condition)
static AfterSelectBuilder	select(SyntaxProvider syntaxProvider, String... columns)
static AfterSelectBuilder.Aliasable	select(SyntaxProvider syntaxProvider, String column)
protected void	setFrom(String table)
protected void	setGroupBy(String... columns)
protected void	setHaving(String condition)
protected void	setLimit(int limit)
protected void	setOffset(int offset)
protected void	setOrderBy(String... columns)
protected void	setOrderType(OrderType type)
protected void	setSelectType(SelectType type)
protected void	setWhere(String condition)

从类继承的方法 com.github.houbb.sql.builder.core.support.querier.builder.QueryBuilder

getSqlValidator, getSyntaxProvider, setSqlValidator, valid

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

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

构造器详细资料

SelectBuilder

protected SelectBuilder(SyntaxProvider syntaxProvider)

SelectBuilder

protected SelectBuilder(SelectBuilder parent)

方法详细资料

addSelectColumns

protected void addSelectColumns(String... columns)

setSelectType

protected void setSelectType(SelectType type)

setFrom

protected void setFrom(String table)

addJoin

protected void addJoin(Join join)

setWhere

protected void setWhere(String condition)

andWhere

protected void andWhere(String condition)

orWhere

protected void orWhere(String condition)

setGroupBy

protected void setGroupBy(String... columns)

setHaving

protected void setHaving(String condition)

andHaving

protected void andHaving(String condition)

orHaving

protected void orHaving(String condition)

setOrderBy

protected void setOrderBy(String... columns)

setOrderType

protected void setOrderType(OrderType type)

setLimit

protected void setLimit(int limit)

setOffset

protected void setOffset(int offset)

createAlias

protected String createAlias(String value,
                             String alias)

build

public String build()

指定者:

build 在类中 QueryBuilder

select

public static AfterSelectBuilder select(SyntaxProvider syntaxProvider,
                                        String... columns)

select

public static AfterSelectBuilder.Aliasable select(SyntaxProvider syntaxProvider,
                                                  String column)

getSelectColumns

protected List<String> getSelectColumns()

getSelectType

protected SelectType getSelectType()

getFrom

protected String getFrom()

getJoins

protected List<Join> getJoins()

getWhere

protected String getWhere()

getGroupBy

protected String getGroupBy()

getHaving

protected String getHaving()

getOrderBy

protected String getOrderBy()

getOrderType

protected OrderType getOrderType()

getLimit

protected Integer getLimit()

getOffset

protected Integer getOffset()