net.ymate.platform.persistence.jdbc.query

Class AbstractQueryBuilder<RESULT,QUERY_BUILDER extends AbstractQueryBuilder>

java.lang.Object

net.ymate.platform.persistence.jdbc.query.QueryHandleAdapter<T>

net.ymate.platform.persistence.jdbc.query.Query<QUERY_BUILDER>

net.ymate.platform.persistence.jdbc.query.AbstractQueryBuilder<RESULT,QUERY_BUILDER>

Direct Known Subclasses:

QueryBuilder

public abstract class AbstractQueryBuilder<RESULT,QUERY_BUILDER extends AbstractQueryBuilder>
extends Query<QUERY_BUILDER>

Since:

2.1.0

Author:

刘镇 (suninformation@163.com) on 2021/01/13 23:38

Nested Class Summary

Nested classes/interfaces inherited from class net.ymate.platform.persistence.jdbc.query.Query

Query.Executor<T>

Field Summary

Fields inherited from class net.ymate.platform.persistence.jdbc.query.Query

LINE_END_FLAG

Constructor Summary

Constructors

Constructor and Description
AbstractQueryBuilder()
AbstractQueryBuilder(IDatabase owner)
AbstractQueryBuilder(IDatabase owner, String dataSourceName)

Method Summary

Modifier and Type	Method and Description
BatchSQL	batch()
BatchSQL	batch(Delete delete)
BatchSQL	batch(Insert insert)
BatchSQL	batch(String batchSql)
BatchSQL	batch(Update update)
RESULT	build()
protected void	build(RESULT result)
Cond	cond()
Delete	delete()
Delete	delete(Class<? extends IEntity> entityClass)
Delete	delete(Class<? extends IEntity> entityClass, String alias)
Delete	delete(String tableName)
Delete	delete(String tableName, boolean safePrefix)
Delete	delete(String prefix, Class<? extends IEntity> entityClass)
Delete	delete(String prefix, Class<? extends IEntity> entityClass, String alias)
Delete	delete(String tableName, String alias)
Delete	delete(String tableName, String alias, boolean safePrefix)
Delete	delete(String prefix, String tableName, String alias)
<T extends IEntity> EntitySQL<T>	entity(Class<T> entityClass)
String	field(String prefix, String field)
String	field(String prefix, String field, String alias)
FieldCondition	fieldCond(String fieldName)
FieldCondition	fieldCond(String prefix, String fieldName)
Fields	fields(Collection<String> fields)
Fields	fields(String... fields)
Fields	fieldsWrap(Collection<String> fields)
Fields	fieldsWrap(String... fields)
String	fieldWrap(String prefix, String field)
String	fieldWrap(String prefix, String field, String alias)
GroupBy	groupBy()
GroupBy	groupBy(Cond having)
GroupBy	groupBy(Fields fields)
GroupBy	groupBy(Fields fields, boolean wrapIdentifier)
GroupBy	groupBy(String field)
GroupBy	groupBy(String field, boolean wrapIdentifier)
GroupBy	groupBy(String prefix, Fields fields)
GroupBy	groupBy(String prefix, Fields fields, boolean wrapIdentifier)
GroupBy	groupBy(String prefix, String field)
GroupBy	groupBy(String prefix, String field, boolean wrapIdentifier)
Join	inner(Select select)
Join	inner(String from)
Join	inner(String from, boolean safePrefix)
Join	inner(String prefix, String from)
Join	inner(String prefix, String from, boolean safePrefix)
Insert	insert(Class<? extends IEntity> entityClass)
Insert	insert(IEntity<?> entity)
Insert	insert(String tableName)
Insert	insert(String tableName, boolean safePrefix)
Insert	insert(String prefix, Class<? extends IEntity> entityClass)
Join	left(Select select)
Join	left(String from)
Join	left(String from, boolean safePrefix)
Join	left(String prefix, String from)
Join	left(String prefix, String from, boolean safePrefix)
Like	like(String originStr)
OrderBy	orderBy()
Page	page()
Page	page(Integer page)
Page	pageIfNeed(Integer page, Integer pageSize)
Params	params(Collection<?> params)
Params	params(Object... params)
Join	right(Select select)
Join	right(String from)
Join	right(String from, boolean safePrefix)
Join	right(String prefix, String from)
Join	right(String prefix, String from, boolean safePrefix)
Select	select()
Select	select(Class<? extends IEntity> entityClass)
Select	select(Class<? extends IEntity> entityClass, String alias)
Select	select(IFunction func)
Select	select(IFunction func, String alias)
Select	select(Select select)
Select	select(String from)
Select	select(String from, boolean safePrefix)
Select	select(String prefix, Class<? extends IEntity> entityClass)
Select	select(String prefix, Class<? extends IEntity> entityClass, String alias)
Select	select(String from, String alias)
Select	select(String from, String alias, boolean safePrefix)
Select	select(String prefix, String from, String alias)
SQL	sql(Delete delete)
SQL	sql(Insert insert)
SQL	sql(Select select)
SQL	sql(String sql)
SQL	sql(String expressionSqlStr, Map<String,Object> params)
SQL	sql(Update update)
Union	union(Select select)
Update	update()
Update	update(Class<? extends IEntity> entityClass)
Update	update(String tableName)
Update	update(String tableName, boolean safePrefix)
Update	update(String prefix, Class<? extends IEntity> entityClass)
Update	update(String prefix, Class<? extends IEntity> entityClass, String alias)
Update	update(String tableName, String alias)
Update	update(String tableName, String alias, boolean safePrefix)
Update	update(String prefix, String tableName, String alias)
Update	update(String prefix, String tableName, String alias, boolean safePrefix)
Where	where()
Where	where(Cond cond)
Where	where(String whereCond)

Methods inherited from class net.ymate.platform.persistence.jdbc.query.Query

build, build, buildSafeTableName, buildSafeTableName, checkFieldExcluded, dataSourceName, dataSourceName, defaultTablePrefix, dialect, dialect, owner, shardingable, shardingable, shardingRule, shardingRule, wrapIdentifierField, wrapIdentifierField, wrapIdentifierField, wrapIdentifierFields

Methods inherited from class net.ymate.platform.persistence.jdbc.query.QueryHandleAdapter

getExpressionStr, queryHandler, queryHandler

Methods inherited from class java.lang.Object

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

Constructor Detail

AbstractQueryBuilder

public AbstractQueryBuilder()

AbstractQueryBuilder

public AbstractQueryBuilder(IDatabase owner)

AbstractQueryBuilder

public AbstractQueryBuilder(IDatabase owner,
                            String dataSourceName)

Method Detail

build

public RESULT build()

build

protected void build(RESULT result)

sql

public SQL sql(String sql)

sql

public SQL sql(Select select)

sql

public SQL sql(Insert insert)

sql

public SQL sql(Update update)

sql

public SQL sql(Delete delete)

sql

public SQL sql(String expressionSqlStr,
               Map<String,Object> params)

entity

public <T extends IEntity> EntitySQL<T> entity(Class<T> entityClass)

batch

public BatchSQL batch(String batchSql)

batch

public BatchSQL batch()

batch

public BatchSQL batch(Insert insert)

batch

public BatchSQL batch(Update update)

batch

public BatchSQL batch(Delete delete)

select

public Select select()

select

public Select select(Select select)

select

public Select select(Class<? extends IEntity> entityClass)

select

public Select select(String prefix,
                     Class<? extends IEntity> entityClass)

select

public Select select(Class<? extends IEntity> entityClass,
                     String alias)

select

public Select select(String prefix,
                     Class<? extends IEntity> entityClass,
                     String alias)

select

public Select select(String prefix,
                     String from,
                     String alias)

select

public Select select(String from,
                     String alias)

select

public Select select(String from,
                     String alias,
                     boolean safePrefix)

select

public Select select(String from)

select

public Select select(String from,
                     boolean safePrefix)

select

public Select select(IFunction func)

select

public Select select(IFunction func,
                     String alias)

update

public Update update()

update

public Update update(String prefix,
                     Class<? extends IEntity> entityClass,
                     String alias)

update

public Update update(String prefix,
                     Class<? extends IEntity> entityClass)

update

public Update update(Class<? extends IEntity> entityClass)

update

public Update update(String prefix,
                     String tableName,
                     String alias)

update

public Update update(String prefix,
                     String tableName,
                     String alias,
                     boolean safePrefix)

update

public Update update(String tableName,
                     String alias)

update

public Update update(String tableName,
                     String alias,
                     boolean safePrefix)

update

public Update update(String tableName)

update

public Update update(String tableName,
                     boolean safePrefix)

insert

public Insert insert(String prefix,
                     Class<? extends IEntity> entityClass)

insert

public Insert insert(IEntity<?> entity)

insert

public Insert insert(Class<? extends IEntity> entityClass)

insert

public Insert insert(String tableName)

insert

public Insert insert(String tableName,
                     boolean safePrefix)

delete

public Delete delete()

delete

public Delete delete(Class<? extends IEntity> entityClass)

delete

public Delete delete(String prefix,
                     Class<? extends IEntity> entityClass)

delete

public Delete delete(Class<? extends IEntity> entityClass,
                     String alias)

delete

public Delete delete(String prefix,
                     Class<? extends IEntity> entityClass,
                     String alias)

delete

public Delete delete(String prefix,
                     String tableName,
                     String alias)

delete

public Delete delete(String tableName,
                     String alias)

delete

public Delete delete(String tableName,
                     String alias,
                     boolean safePrefix)

delete

public Delete delete(String tableName)

delete

public Delete delete(String tableName,
                     boolean safePrefix)

cond

public Cond cond()

fieldCond

public FieldCondition fieldCond(String prefix,
                                String fieldName)

fieldCond

public FieldCondition fieldCond(String fieldName)

groupBy

public GroupBy groupBy()

groupBy

public GroupBy groupBy(Cond having)

groupBy

public GroupBy groupBy(String prefix,
                       String field)

groupBy

public GroupBy groupBy(String prefix,
                       String field,
                       boolean wrapIdentifier)

groupBy

public GroupBy groupBy(String field)

groupBy

public GroupBy groupBy(String field,
                       boolean wrapIdentifier)

groupBy

public GroupBy groupBy(Fields fields)

groupBy

public GroupBy groupBy(Fields fields,
                       boolean wrapIdentifier)

groupBy

public GroupBy groupBy(String prefix,
                       Fields fields)

groupBy

public GroupBy groupBy(String prefix,
                       Fields fields,
                       boolean wrapIdentifier)

orderBy

public OrderBy orderBy()

inner

public Join inner(Select select)

inner

public Join inner(String from)

inner

public Join inner(String from,
                  boolean safePrefix)

inner

public Join inner(String prefix,
                  String from)

inner

public Join inner(String prefix,
                  String from,
                  boolean safePrefix)

left

public Join left(Select select)

left

public Join left(String from)

left

public Join left(String from,
                 boolean safePrefix)

left

public Join left(String prefix,
                 String from)

left

public Join left(String prefix,
                 String from,
                 boolean safePrefix)

right

public Join right(Select select)

right

public Join right(String from)

right

public Join right(String from,
                  boolean safePrefix)

right

public Join right(String prefix,
                  String from)

right

public Join right(String prefix,
                  String from,
                  boolean safePrefix)

union

public Union union(Select select)

like

public Like like(String originStr)

where

public Where where()

where

public Where where(String whereCond)

where

public Where where(Cond cond)

field

public String field(String prefix,
                    String field,
                    String alias)

field

public String field(String prefix,
                    String field)

fields

public Fields fields(String... fields)

fields

public Fields fields(Collection<String> fields)

fieldWrap

public String fieldWrap(String prefix,
                        String field,
                        String alias)

fieldWrap

public String fieldWrap(String prefix,
                        String field)

fieldsWrap

public Fields fieldsWrap(String... fields)

fieldsWrap

public Fields fieldsWrap(Collection<String> fields)

params

public Params params(Object... params)

params

public Params params(Collection<?> params)

page

public Page page()

page

public Page page(Integer page)

pageIfNeed

public Page pageIfNeed(Integer page,
                       Integer pageSize)