db.sql.api.cmd.executor

接口 IQuery<SELF extends IQuery,TABLE extends ITable<TABLE,TABLE_FIELD>,TABLE_FIELD extends ITableField<TABLE_FIELD,TABLE>,COLUMN extends Cmd,V,CMD_FACTORY extends ICmdFactory<TABLE,TABLE_FIELD>,CONDITION_CHAIN extends IConditionChain<CONDITION_CHAIN,TABLE_FIELD,COLUMN,V>,WITH extends IWith<WITH>,SELECT extends ISelect<SELECT>,FROM extends IFrom,JOIN extends IJoin<JOIN,ON,TABLE,TABLE_FIELD,COLUMN,V,CONDITION_CHAIN>,ON extends IOn<ON,JOIN,TABLE,TABLE_FIELD,COLUMN,V,CONDITION_CHAIN>,JOINS extends Joins<JOIN>,WHERE extends IWhere<WHERE,TABLE_FIELD,COLUMN,V,CONDITION_CHAIN>,GROUPBY extends IGroupBy<GROUPBY,COLUMN>,HAVING extends IHaving<HAVING>,ORDERBY extends IOrderBy<ORDERBY>,LIMIT extends ILimit<LIMIT>,FORUPDATE extends IForUpdate<FORUPDATE>,IUNION extends IUnion>

所有超级接口:

Cmd, IBaseOrderByMethods, IBetweenGetterCompare<SELF>, IBetweenGetterPredicateCompare<SELF>, ICompare<SELF,COLUMN,V>, IConditionMethod<SELF,TABLE_FIELD,COLUMN,V,CONDITION_CHAIN>, IConditionMethods<SELF,COLUMN,V>, IEmptyGetterCompare<SELF>, IEqGetterCompare<SELF,V>, IEqGetterPredicateCompare<SELF,V>, IExecutor<SELF,TABLE,TABLE_FIELD>, IExistsMethod<SELF>, IForUpdateMethod<SELF>, IFromMethod<SELF,TABLE,TABLE_FIELD>, IGroupByCmdMethod<SELF,COLUMN>, IGroupByDatasetGetterMethod<SELF>, IGroupByDatasetMethod<SELF>, IGroupByDatasetMultiGetterMethod<SELF>, IGroupByGetterMethod<SELF,TABLE,TABLE_FIELD>, IGroupByMethod<SELF,TABLE,TABLE_FIELD,COLUMN>, IGroupByMethods<SELF,TABLE,TABLE_FIELD,COLUMN>, IGroupByMultiGetterMethod<SELF,TABLE,TABLE_FIELD>, IGteGetterCompare<SELF,V>, IGteGetterPredicateCompare<SELF,V>, IGtGetterCompare<SELF,V>, IGtGetterPredicateCompare<SELF,V>, IHavingAndMethod<SELF,TABLE,TABLE_FIELD>, IHavingDatasetAndMethod<SELF>, IHavingDatasetOrMethod<SELF>, IHavingMethod<SELF,TABLE,TABLE_FIELD,HAVING>, IHavingMethods<SELF,TABLE,TABLE_FIELD>, IHavingOrMethod<SELF,TABLE,TABLE_FIELD>, IInGetterCompare<SELF>, IInMethod<SELF,COLUMN>, IIsNotNullGetterCompare<SELF>, IIsNullGetterCompare<SELF>, IJoinMethod<SELF,ON>, ILikeGetterCompare<SELF>, ILikeGetterPredicateCompare<SELF>, ILimitMethod<SELF>, ILteGetterCompare<SELF,V>, ILteGetterPredicateCompare<SELF,V>, ILtGetterCompare<SELF,V>, ILtGetterPredicateCompare<SELF,V>, INeGetterCompare<SELF,V>, INeGetterPredicateCompare<SELF,V>, INotBetweenGetterCompare<SELF>, INotBetweenGetterPredicateCompare<SELF>, INotEmptyGetterCompare<SELF>, INotInGetterCompare<SELF>, INotInMethod<SELF,COLUMN>, INotLikeGetterCompare<SELF>, INotLikeGetterPredicateCompare<SELF>, IOrderByCmdMethod<SELF,COLUMN>, IOrderByDatasetGetterFunMethod<SELF>, IOrderByDatasetGetterMethod<SELF>, IOrderByDatasetMethod<SELF>, IOrderByDatasetMultiGetterFunMethod<SELF>, IOrderByDatasetMultiGetterMethod<SELF>, IOrderByGetterFunMethod<SELF,TABLE,TABLE_FIELD>, IOrderByGetterMethod<SELF,TABLE,TABLE_FIELD>, IOrderByMethod<SELF,TABLE,TABLE_FIELD,COLUMN>, IOrderByMethods<SELF,TABLE,TABLE_FIELD,COLUMN>, IOrderByMultiGetterFunMethod<SELF,TABLE,TABLE_FIELD>, IOrderByMultiGetterMethod<SELF,TABLE,TABLE_FIELD>, ISelectCmdMethod<SELF,COLUMN>, ISelectDatasetGetterMethod<SELF>, ISelectDatasetMethod<SELF>, ISelectDatasetMultiGetterMethod<SELF>, ISelectGetterMethod<SELF,TABLE,TABLE_FIELD>, ISelectMethod<SELF,TABLE,TABLE_FIELD,COLUMN>, ISelectMethods<SELF,TABLE,TABLE_FIELD,COLUMN>, ISelectMultiGetterMethod<SELF,TABLE,TABLE_FIELD>, IUnionMethod<SELF>, IWhereIgnoreMethod<SELF>, IWhereMethod<SELF,TABLE_FIELD,COLUMN,V,CONDITION_CHAIN>, IWithMethod<SELF>, Nested<SELF,CONDITION_CHAIN>

所有已知子接口:

ISubQuery<SELF,TABLE,TABLE_FIELD,DATASET_FIELD,COLUMN,V,CMD_FACTORY,CONDITION_CHAIN,WITH,SELECT,FROM,JOIN,ON,JOINS,WHERE,GROUPBY,HAVING,ORDERBY,LIMIT,FORUPDATE,UNION>, IWithQuery<SELF,TABLE,TABLE_FIELD,DATASET_FIELD,COLUMN,V,CMD_FACTORY,CONDITION_CHAIN,WITH,RECURSIVE,SELECT,FROM,JOIN,ON,JOINS,WHERE,GROUPBY,HAVING,ORDERBY,LIMIT,FORUPDATE,UNION>

public interface IQuery<SELF extends IQuery,TABLE extends ITable<TABLE,TABLE_FIELD>,TABLE_FIELD extends ITableField<TABLE_FIELD,TABLE>,COLUMN extends Cmd,V,CMD_FACTORY extends ICmdFactory<TABLE,TABLE_FIELD>,CONDITION_CHAIN extends IConditionChain<CONDITION_CHAIN,TABLE_FIELD,COLUMN,V>,WITH extends IWith<WITH>,SELECT extends ISelect<SELECT>,FROM extends IFrom,JOIN extends IJoin<JOIN,ON,TABLE,TABLE_FIELD,COLUMN,V,CONDITION_CHAIN>,ON extends IOn<ON,JOIN,TABLE,TABLE_FIELD,COLUMN,V,CONDITION_CHAIN>,JOINS extends Joins<JOIN>,WHERE extends IWhere<WHERE,TABLE_FIELD,COLUMN,V,CONDITION_CHAIN>,GROUPBY extends IGroupBy<GROUPBY,COLUMN>,HAVING extends IHaving<HAVING>,ORDERBY extends IOrderBy<ORDERBY>,LIMIT extends ILimit<LIMIT>,FORUPDATE extends IForUpdate<FORUPDATE>,IUNION extends IUnion>
extends IWithMethod<SELF>, ISelectMethod<SELF,TABLE,TABLE_FIELD,COLUMN>, IFromMethod<SELF,TABLE,TABLE_FIELD>, IJoinMethod<SELF,ON>, IWhereMethod<SELF,TABLE_FIELD,COLUMN,V,CONDITION_CHAIN>, IGroupByMethod<SELF,TABLE,TABLE_FIELD,COLUMN>, IHavingMethod<SELF,TABLE,TABLE_FIELD,HAVING>, IOrderByMethod<SELF,TABLE,TABLE_FIELD,COLUMN>, ILimitMethod<SELF>, IForUpdateMethod<SELF>, IUnionMethod<SELF>, IExecutor<SELF,TABLE,TABLE_FIELD>

方法概要

限定符和类型	方法和说明
CMD_FACTORY	$()
FORUPDATE	$forUpdate()
<DATASET extends IDataset<DATASET,DATASET_FIELD>,DATASET_FIELD extends IDatasetField<DATASET_FIELD>> FROM	$from(IDataset<DATASET,DATASET_FIELD>... tables)
GROUPBY	$groupBy()
HAVING	$having()
<DATASET extends IDataset<DATASET,DATASET_FIELD>,DATASET_FIELD extends IDatasetField<DATASET_FIELD>> JOIN	$join(JoinMode mode, DATASET mainTable, DATASET secondTable)
LIMIT	$limit()
ORDERBY	$orderBy()
SELECT	$select()
WHERE	$where()
WITH	$with(IWithQuery withQuery)
default CONDITION_CHAIN	conditionChain()
<T> SELF	fetchFilter(Getter<T> getter, Consumer<WHERE> where)
default SELF	forUpdate(boolean wait)
default <DATASET extends IDataset<DATASET,DATASET_FIELD>,DATASET_FIELD extends IDatasetField<DATASET_FIELD>> SELF	from(IDataset<DATASET,DATASET_FIELD>... tables)
Map<String,Consumer<WHERE>>	getFetchFilters()
FORUPDATE	getForUpdate()
FROM	getFrom()
GROUPBY	getGroupBy()
JOINS	getJoins()
LIMIT	getLimit()
ORDERBY	getOrderBy()
SELECT	getSelect()
Unions	getUnions()
WHERE	getWhere()
default SELF	groupBy(COLUMN... columns)
default SELF	groupBy(COLUMN column)
default SELF	groupBy(List<COLUMN> columns)
default SELF	having(Consumer<HAVING> consumer)
default SELF	havingAnd(ICondition condition)
default SELF	havingOr(ICondition condition)
default SELF	join(Class mainTable, Class secondTable, BiConsumer<TABLE,ON> consumer)
default SELF	join(JoinMode mode, Class mainTable, Class secondTable, BiConsumer<TABLE,ON> consumer)
SELF	join(JoinMode mode, Class mainTable, int mainTableStorey, Class secondTable, int secondTableStorey, BiConsumer<TABLE,ON> consumer)
default SELF	limit(int limit)
default SELF	limit(int offset, int limit)
default SELF	orderBy(IOrderByDirection orderByDirection, Cmd column)
default SELF	select(Class entity, int storey)
default SELF	select(Cmd column)
default SELF	selectDistinct()
default <T> SELF	selectIgnore(Getter<T> column, int storey)
default SELF	where(Consumer<WHERE> whereConsumer)
default SELF	with(IWithQuery... withQuerys)

从接口继承的方法 db.sql.api.cmd.executor.method.ISelectMethod

select, select, select, select1, selectAll, selectAll, selectCount1, selectCountAll, selectIgnore, selectIgnore, selectIgnore

从接口继承的方法 db.sql.api.cmd.executor.method.selectMethod.ISelectMethods

select, select, select, select, select

从接口继承的方法 db.sql.api.cmd.executor.method.selectMethod.ISelectCmdMethod

select, select

从接口继承的方法 db.sql.api.cmd.executor.method.selectMethod.ISelectGetterMethod

select, select, select, select, select, select, select, select

从接口继承的方法 db.sql.api.cmd.executor.method.selectMethod.ISelectMultiGetterMethod

select, select, select, select, select, select

从接口继承的方法 db.sql.api.cmd.executor.method.selectMethod.ISelectDatasetMethod

select, select, select, select

从接口继承的方法 db.sql.api.cmd.executor.method.selectMethod.ISelectDatasetGetterMethod

select, select, select, select

从接口继承的方法 db.sql.api.cmd.executor.method.selectMethod.ISelectDatasetMultiGetterMethod

select, select, select

从接口继承的方法 db.sql.api.cmd.executor.method.IFromMethod

from, from, from, from, from, fromEntityIntercept

从接口继承的方法 db.sql.api.cmd.executor.method.IJoinMethod

join, join, join, join, join, join, join, join, join, join, join, join, join, join, joinEntityIntercept

从接口继承的方法 db.sql.api.cmd.executor.method.IWhereMethod

forSearch, ignoreEmptyInCondition, ignoreNullValueInCondition, trimStringInCondition

从接口继承的方法 db.sql.api.cmd.executor.method.IConditionMethod

and, and, and, and, and, and, and, and, andNested, between, between, empty, empty, eq, eq, eq, exists, gt, gt, gt, gte, gte, gte, in, in, in, in, in, in, isNotNull, isNotNull, isNull, isNull, like, like, lt, lt, lt, lte, lte, lte, ne, ne, ne, notBetween, notBetween, notEmpty, notEmpty, notExists, notIn, notIn, notIn, notIn, notIn, notIn, notLike, notLike, or, or, or, or, or, or, or, or, orNested

从接口继承的方法 db.sql.api.cmd.executor.method.condition.ICompare

like, notLike

从接口继承的方法 db.sql.api.cmd.executor.method.condition.compare.IEqGetterCompare

eq, eq, eq, eq, eq, eq

从接口继承的方法 db.sql.api.cmd.executor.method.condition.compare.IEqGetterPredicateCompare

eq, eq

从接口继承的方法 db.sql.api.cmd.executor.method.condition.compare.INeGetterCompare

ne, ne, ne, ne, ne, ne

从接口继承的方法 db.sql.api.cmd.executor.method.condition.compare.INeGetterPredicateCompare

ne, ne

从接口继承的方法 db.sql.api.cmd.executor.method.condition.compare.IGtGetterCompare

gt, gt, gt, gt, gt, gt

从接口继承的方法 db.sql.api.cmd.executor.method.condition.compare.IGtGetterPredicateCompare

gt, gt

从接口继承的方法 db.sql.api.cmd.executor.method.condition.compare.IGteGetterCompare

gte, gte, gte, gte, gte, gte

从接口继承的方法 db.sql.api.cmd.executor.method.condition.compare.IGteGetterPredicateCompare

gte, gte

从接口继承的方法 db.sql.api.cmd.executor.method.condition.compare.ILtGetterCompare

lt, lt, lt, lt, lt, lt

从接口继承的方法 db.sql.api.cmd.executor.method.condition.compare.ILtGetterPredicateCompare

lt, lt

从接口继承的方法 db.sql.api.cmd.executor.method.condition.compare.ILteGetterCompare

lte, lte, lte, lte, lte, lte

从接口继承的方法 db.sql.api.cmd.executor.method.condition.compare.ILteGetterPredicateCompare

lte, lte

从接口继承的方法 db.sql.api.cmd.executor.method.condition.compare.ILikeGetterCompare

like, like, like, like, like, like, like

从接口继承的方法 db.sql.api.cmd.executor.method.condition.compare.ILikeGetterPredicateCompare

like, like, like, like

从接口继承的方法 db.sql.api.cmd.executor.method.condition.compare.INotLikeGetterCompare

notLike, notLike, notLike, notLike, notLike, notLike, notLike

从接口继承的方法 db.sql.api.cmd.executor.method.condition.compare.INotLikeGetterPredicateCompare

notLike, notLike, notLike, notLike

从接口继承的方法 db.sql.api.cmd.executor.method.condition.compare.IBetweenGetterCompare

between, between, between

从接口继承的方法 db.sql.api.cmd.executor.method.condition.compare.IBetweenGetterPredicateCompare

between, between

从接口继承的方法 db.sql.api.cmd.executor.method.condition.compare.INotBetweenGetterCompare

notBetween, notBetween, notBetween

从接口继承的方法 db.sql.api.cmd.executor.method.condition.compare.INotBetweenGetterPredicateCompare

notBetween, notBetween

从接口继承的方法 db.sql.api.cmd.executor.method.condition.compare.IIsNullGetterCompare

isNull, isNull

从接口继承的方法 db.sql.api.cmd.executor.method.condition.compare.IIsNotNullGetterCompare

isNotNull, isNotNull

从接口继承的方法 db.sql.api.cmd.executor.method.condition.compare.IEmptyGetterCompare

empty, empty, empty

从接口继承的方法 db.sql.api.cmd.executor.method.condition.compare.INotEmptyGetterCompare

notEmpty, notEmpty, notEmpty

从接口继承的方法 db.sql.api.cmd.executor.method.condition.compare.IInGetterCompare

in, in, in, in, in, in, in, in, in

从接口继承的方法 db.sql.api.cmd.executor.method.condition.compare.INotInGetterCompare

notIn, notIn, notIn, notIn, notIn, notIn, notIn, notIn, notIn

从接口继承的方法 db.sql.api.cmd.executor.method.condition.IExistsMethod

exists, notExists

从接口继承的方法 db.sql.api.cmd.executor.method.groupByMethod.IGroupByMethods

groupBy, groupBy, groupBy, groupBy, groupBy

从接口继承的方法 db.sql.api.cmd.executor.method.groupByMethod.IGroupByGetterMethod

groupBy, groupBy, groupBy, groupBy, groupBy, groupBy, groupBy, groupBy

从接口继承的方法 db.sql.api.cmd.executor.method.groupByMethod.IGroupByMultiGetterMethod

groupBy, groupBy, groupBy, groupBy, groupBy, groupBy

从接口继承的方法 db.sql.api.cmd.executor.method.groupByMethod.IGroupByDatasetMethod

groupBy, groupBy, groupBy, groupBy

从接口继承的方法 db.sql.api.cmd.executor.method.groupByMethod.IGroupByDatasetGetterMethod

groupBy, groupBy, groupBy, groupBy

从接口继承的方法 db.sql.api.cmd.executor.method.groupByMethod.IGroupByDatasetMultiGetterMethod

groupBy, groupBy, groupBy

从接口继承的方法 db.sql.api.cmd.executor.method.havingMethod.IHavingMethods

having, having, having, having, having, having, having, having, having, having, having, having, having, having

从接口继承的方法 db.sql.api.cmd.executor.method.havingMethod.IHavingAndMethod

havingAnd, havingAnd, havingAnd, havingAnd, havingAnd, havingAnd, havingAnd

从接口继承的方法 db.sql.api.cmd.executor.method.havingMethod.IHavingDatasetAndMethod

havingAnd, havingAnd, havingAnd, havingAnd, havingAnd, havingAnd

从接口继承的方法 db.sql.api.cmd.executor.method.havingMethod.IHavingOrMethod

havingOr, havingOr, havingOr, havingOr, havingOr, havingOr, havingOr

从接口继承的方法 db.sql.api.cmd.executor.method.havingMethod.IHavingDatasetOrMethod

havingOr, havingOr, havingOr, havingOr, havingOr, havingOr

从接口继承的方法 db.sql.api.cmd.executor.method.orderByMethod.IOrderByMethods

orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderByDesc, orderByDesc, orderByDesc, orderByDesc

从接口继承的方法 db.sql.api.cmd.executor.method.orderByMethod.IOrderByCmdMethod

orderBy, orderBy, orderBy, orderBy, orderBy, orderByDesc, orderByDesc, orderByDesc

从接口继承的方法 db.sql.api.cmd.executor.method.orderByMethod.IOrderByGetterMethod

orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderByDesc, orderByDesc, orderByDesc, orderByDesc

从接口继承的方法 db.sql.api.cmd.executor.method.orderByMethod.IOrderByGetterFunMethod

orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderByDesc, orderByDesc, orderByDesc, orderByDesc

从接口继承的方法 db.sql.api.cmd.executor.method.orderByMethod.IOrderByMultiGetterMethod

orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderByDesc, orderByDesc, orderByDesc, orderByDesc

从接口继承的方法 db.sql.api.cmd.executor.method.orderByMethod.IOrderByMultiGetterFunMethod

orderBy, orderBy, orderBy, orderBy, orderByDesc, orderByDesc

从接口继承的方法 db.sql.api.cmd.executor.method.orderByMethod.IOrderByDatasetMethod

orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderBy, orderByDesc, orderByDesc, orderByDesc, orderByDesc

从接口继承的方法 db.sql.api.cmd.executor.method.orderByMethod.IOrderByDatasetGetterMethod

orderBy, orderBy, orderBy, orderBy, orderByDesc, orderByDesc

从接口继承的方法 db.sql.api.cmd.executor.method.orderByMethod.IOrderByDatasetGetterFunMethod

orderBy, orderBy, orderBy, orderBy, orderByDesc, orderByDesc

从接口继承的方法 db.sql.api.cmd.executor.method.orderByMethod.IOrderByDatasetMultiGetterMethod

orderBy, orderBy, orderBy, orderByDesc, orderByDesc

从接口继承的方法 db.sql.api.cmd.executor.method.orderByMethod.IOrderByDatasetMultiGetterFunMethod

orderBy, orderBy, orderBy, orderBy, orderByDesc, orderByDesc

从接口继承的方法 db.sql.api.cmd.executor.method.IForUpdateMethod

forUpdate

从接口继承的方法 db.sql.api.cmd.executor.method.IUnionMethod

union, unionAll

从接口继承的方法 db.sql.api.cmd.executor.IExecutor

cmds, cmdSorts, comparator, connect, connect, selectorExecute, sortedCmds, sql, sql, sql

从接口继承的方法 db.sql.api.Cmd

contain

方法详细资料

$

CMD_FACTORY $()

$with

WITH $with(IWithQuery withQuery)

$select

SELECT $select()

$from

<DATASET extends IDataset<DATASET,DATASET_FIELD>,DATASET_FIELD extends IDatasetField<DATASET_FIELD>> FROM $from(IDataset<DATASET,DATASET_FIELD>... tables)

$join

<DATASET extends IDataset<DATASET,DATASET_FIELD>,DATASET_FIELD extends IDatasetField<DATASET_FIELD>> JOIN $join(JoinMode mode,
                                                                                                                DATASET mainTable,
                                                                                                                DATASET secondTable)

$where

WHERE $where()

$groupBy

GROUPBY $groupBy()

$having

HAVING $having()

$orderBy

ORDERBY $orderBy()

$limit

LIMIT $limit()

$forUpdate

FORUPDATE $forUpdate()

fetchFilter

<T> SELF fetchFilter(Getter<T> getter,
                     Consumer<WHERE> where)

with

default SELF with(IWithQuery... withQuerys)

指定者:

with 在接口中 IWithMethod<SELF extends IQuery>

select

default SELF select(Cmd column)

指定者:

select 在接口中 ISelectCmdMethod<SELF extends IQuery,COLUMN extends Cmd>

select

default SELF select(Class entity,
                    int storey)

指定者:

select 在接口中 ISelectMethod<SELF extends IQuery,TABLE extends ITable<TABLE,TABLE_FIELD>,TABLE_FIELD extends ITableField<TABLE_FIELD,TABLE>,COLUMN extends Cmd>

selectDistinct

default SELF selectDistinct()

指定者:

selectDistinct 在接口中 ISelectMethod<SELF extends IQuery,TABLE extends ITable<TABLE,TABLE_FIELD>,TABLE_FIELD extends ITableField<TABLE_FIELD,TABLE>,COLUMN extends Cmd>

selectIgnore

default <T> SELF selectIgnore(Getter<T> column,
                              int storey)

指定者:

selectIgnore 在接口中 ISelectMethod<SELF extends IQuery,TABLE extends ITable<TABLE,TABLE_FIELD>,TABLE_FIELD extends ITableField<TABLE_FIELD,TABLE>,COLUMN extends Cmd>

from

default <DATASET extends IDataset<DATASET,DATASET_FIELD>,DATASET_FIELD extends IDatasetField<DATASET_FIELD>> SELF from(IDataset<DATASET,DATASET_FIELD>... tables)

指定者:

from 在接口中 IFromMethod<SELF extends IQuery,TABLE extends ITable<TABLE,TABLE_FIELD>,TABLE_FIELD extends ITableField<TABLE_FIELD,TABLE>>

join

default SELF join(Class mainTable,
                  Class secondTable,
                  BiConsumer<TABLE,ON> consumer)

join

default SELF join(JoinMode mode,
                  Class mainTable,
                  Class secondTable,
                  BiConsumer<TABLE,ON> consumer)

join

SELF join(JoinMode mode,
          Class mainTable,
          int mainTableStorey,
          Class secondTable,
          int secondTableStorey,
          BiConsumer<TABLE,ON> consumer)

where

default SELF where(Consumer<WHERE> whereConsumer)

groupBy

default SELF groupBy(COLUMN column)

指定者:

groupBy 在接口中 IGroupByCmdMethod<SELF extends IQuery,COLUMN extends Cmd>

groupBy

default SELF groupBy(COLUMN... columns)

指定者:

groupBy 在接口中 IGroupByCmdMethod<SELF extends IQuery,COLUMN extends Cmd>

groupBy

default SELF groupBy(List<COLUMN> columns)

指定者:

groupBy 在接口中 IGroupByCmdMethod<SELF extends IQuery,COLUMN extends Cmd>

having

default SELF having(Consumer<HAVING> consumer)

指定者:

having 在接口中 IHavingMethod<SELF extends IQuery,TABLE extends ITable<TABLE,TABLE_FIELD>,TABLE_FIELD extends ITableField<TABLE_FIELD,TABLE>,HAVING extends IHaving<HAVING>>

havingAnd

default SELF havingAnd(ICondition condition)

指定者:

havingAnd 在接口中 IHavingAndMethod<SELF extends IQuery,TABLE extends ITable<TABLE,TABLE_FIELD>,TABLE_FIELD extends ITableField<TABLE_FIELD,TABLE>>

havingOr

default SELF havingOr(ICondition condition)

指定者:

havingOr 在接口中 IHavingOrMethod<SELF extends IQuery,TABLE extends ITable<TABLE,TABLE_FIELD>,TABLE_FIELD extends ITableField<TABLE_FIELD,TABLE>>

orderBy

default SELF orderBy(IOrderByDirection orderByDirection,
                     Cmd column)

指定者:

orderBy 在接口中 IOrderByCmdMethod<SELF extends IQuery,COLUMN extends Cmd>

limit

default SELF limit(int limit)

指定者:

limit 在接口中 ILimitMethod<SELF extends IQuery>

limit

default SELF limit(int offset,
                   int limit)

指定者:

limit 在接口中 ILimitMethod<SELF extends IQuery>

forUpdate

default SELF forUpdate(boolean wait)

指定者:

forUpdate 在接口中 IForUpdateMethod<SELF extends IQuery>

getSelect

SELECT getSelect()

getWhere

WHERE getWhere()

getFrom

FROM getFrom()

getJoins

JOINS getJoins()

getGroupBy

GROUPBY getGroupBy()

getOrderBy

ORDERBY getOrderBy()

getLimit

LIMIT getLimit()

getForUpdate

FORUPDATE getForUpdate()

getUnions

Unions getUnions()

conditionChain

default CONDITION_CHAIN conditionChain()

指定者:

conditionChain 在接口中 IConditionMethod<SELF extends IQuery,TABLE_FIELD extends ITableField<TABLE_FIELD,TABLE>,COLUMN extends Cmd,V,CONDITION_CHAIN extends IConditionChain<CONDITION_CHAIN,TABLE_FIELD,COLUMN,V>>

getFetchFilters

Map<String,Consumer<WHERE>> getFetchFilters()