| 限定符和类型 | 方法和说明 |
|---|---|
AbstractUnion |
DefaultSqlContext.union(SelectDsl... select) |
AbstractUnion |
DefaultSqlContext.unionAll(SelectDsl... select) |
| 限定符和类型 | 方法和说明 |
|---|---|
AbstractColumnReference |
AbstractColumnReference.column(boolean isEffective,
SelectDsl nestedSelect,
String columnAlias)
条件性地添加一个嵌套查询列到当前查询中。
|
AbstractColumnReference |
ColumnReference.column(SelectDsl nestedSelect,
String columnAlias) |
abstract AbstractColumnReference |
AbstractColumnReference.column(SelectDsl nestedSelect,
String columnAlias)
添加一个嵌套查询列到当前查询中。
|
TableRelation<?> |
ColumnReference.from(SelectDsl nestedSelect,
String selectAlias) |
abstract TableRelation<?> |
AbstractColumnReference.from(SelectDsl nestedSelect,
String selectAlias)
设置嵌套查询作为主表。
|
TableRelation<?> |
ColumnReference.fromUnion(SelectDsl[] selectDsl,
String selectAlias) |
abstract TableRelation<?> |
AbstractColumnReference.fromUnion(SelectDsl[] selectDsl,
String selectAlias)
构建 UNION 查询的表关系。
|
TableRelation<?> |
ColumnReference.fromUnionAll(SelectDsl[] selectDsl,
String selectAlias) |
abstract TableRelation<?> |
AbstractColumnReference.fromUnionAll(SelectDsl[] selectDsl,
String selectAlias)
构建 UNION ALL 查询的表关系。
|
AbstractUnion |
SqlContext.union(SelectDsl... select)
构建扁平化 UNION 查询,将多个 SELECT 子句按
UNION 方式合并(自动去重)。 |
AbstractUnion |
SqlContext.unionAll(SelectDsl... select)
构建扁平化 UNION ALL 查询,将多个 SELECT 子句按
UNION ALL 方式合并(不去重)。 |
| 限定符和类型 | 方法和说明 |
|---|---|
ColumnArithmetic |
ColumnArithmetic.add(SelectDsl nestedSelect)
使用嵌套查询的结果与当前列相加。
|
ColumnArithmetic |
ColumnArithmetic.divide(SelectDsl nestedSelect)
使用嵌套查询的结果与当前列相除。
|
ColumnArithmetic |
ColumnArithmetic.multiply(SelectDsl nestedSelect)
使用嵌套查询的结果与当前列相乘。
|
ColumnArithmetic |
ColumnArithmetic.subtract(SelectDsl nestedSelect)
使用嵌套查询的结果从当前列中减去。
|
| 限定符和类型 | 方法和说明 |
|---|---|
AbstractColumFunction |
AbstractColumFunction.add(SelectDsl nestedSelect) |
AbstractColumFunction |
AbstractColumFunction.divide(SelectDsl nestedSelect) |
AbstractColumFunction |
AbstractColumFunction.multiply(SelectDsl nestedSelect) |
AbstractColumFunction |
AbstractColumFunction.subtract(SelectDsl nestedSelect) |
| 限定符和类型 | 方法和说明 |
|---|---|
default <T,F> C |
NestedCondition.andEqualTo(boolean isEffective,
Fn<T,F> fn,
SelectDsl nestedSelect)
根据条件添加等于条件,并且运算,右侧值来自嵌套查询。
|
<T,F> C |
NestedCondition.andEqualTo(Fn<T,F> fn,
SelectDsl nestedSelect)
添加等于条件,并且运算,右侧值来自嵌套查询。
|
default C |
NestedCondition.andExists(boolean isEffective,
SelectDsl nestedSelect)
根据条件添加 EXISTS 条件,并且运算,判断子查询是否存在。
|
C |
NestedCondition.andExists(SelectDsl nestedSelect)
添加 EXISTS 条件,并且运算,判断子查询是否存在。
|
default <T,F> C |
NestedCondition.andGreaterThan(boolean isEffective,
Fn<T,F> fn,
SelectDsl nestedSelect)
根据条件添加大于条件,并且运算,右侧值来自嵌套查询。
|
<T,F> C |
NestedCondition.andGreaterThan(Fn<T,F> fn,
SelectDsl nestedSelect)
添加大于条件,并且运算,右侧值来自嵌套查询。
|
default <T,F> C |
NestedCondition.andGreaterThanOrEqualTo(boolean isEffective,
Fn<T,F> fn,
SelectDsl nestedSelect)
根据条件添加大于等于条件,并且运算,右侧值来自嵌套查询。
|
<T,F> C |
NestedCondition.andGreaterThanOrEqualTo(Fn<T,F> fn,
SelectDsl nestedSelect)
添加大于等于条件,并且运算,右侧值来自嵌套查询。
|
default <T,F> C |
NestedCondition.andIn(boolean isEffective,
Fn<T,F> fn,
SelectDsl nestedSelect)
根据条件添加 IN 条件,并且运算,右侧值来自嵌套查询。
|
<T,F> C |
NestedCondition.andIn(Fn<T,F> fn,
SelectDsl nestedSelect)
添加 IN 条件,并且运算,右侧值来自嵌套查询。
|
default <T,F> C |
NestedCondition.andLessThan(boolean isEffective,
Fn<T,F> fn,
SelectDsl nestedSelect)
根据条件添加小于条件,并且运算,右侧值来自嵌套查询。
|
<T,F> C |
NestedCondition.andLessThan(Fn<T,F> fn,
SelectDsl nestedSelect)
添加小于条件,并且运算,右侧值来自嵌套查询。
|
default <T,F> C |
NestedCondition.andLessThanOrEqualTo(boolean isEffective,
Fn<T,F> fn,
SelectDsl nestedSelect)
根据条件添加小于等于条件,并且运算,右侧值来自嵌套查询。
|
<T,F> C |
NestedCondition.andLessThanOrEqualTo(Fn<T,F> fn,
SelectDsl nestedSelect)
添加小于等于条件,并且运算,右侧值来自嵌套查询。
|
default <T,F> C |
NestedCondition.andNotEqualTo(boolean isEffective,
Fn<T,F> fn,
SelectDsl nestedSelect)
根据条件添加不等于条件,并且运算,右侧值来自嵌套查询。
|
<T,F> C |
NestedCondition.andNotEqualTo(Fn<T,F> fn,
SelectDsl nestedSelect)
添加不等于条件,并且运算,右侧值来自嵌套查询。
|
default C |
NestedCondition.andNotExists(boolean isEffective,
SelectDsl nestedSelect)
根据条件添加 NOT EXISTS 条件,并且运算,判断子查询是否不存在。
|
C |
NestedCondition.andNotExists(SelectDsl nestedSelect)
添加 NOT EXISTS 条件,并且运算,判断子查询是否不存在。
|
default <T,F> C |
NestedCondition.andNotIn(boolean isEffective,
Fn<T,F> fn,
SelectDsl nestedSelect)
根据条件添加 NOT IN 条件,并且运算,右侧值来自嵌套查询。
|
<T,F> C |
NestedCondition.andNotIn(Fn<T,F> fn,
SelectDsl nestedSelect)
添加 NOT IN 条件,并且运算,右侧值来自嵌套查询。
|
default <T,F> C |
NestedCondition.orEqualTo(boolean isEffective,
Fn<T,F> fn,
SelectDsl nestedSelect)
根据条件添加等于条件(OR 运算),右侧值来自嵌套查询。
|
<T,F> C |
NestedCondition.orEqualTo(Fn<T,F> fn,
SelectDsl nestedSelect)
添加等于条件(OR 运算),右侧值来自嵌套查询。
|
default C |
NestedCondition.orExists(boolean isEffective,
SelectDsl nestedSelect)
根据条件添加 EXISTS 条件(OR 运算),判断子查询是否存在。
|
C |
NestedCondition.orExists(SelectDsl nestedSelect)
添加 EXISTS 条件(OR 运算),判断子查询是否存在。
|
default <T,F> C |
NestedCondition.orGreaterThan(boolean isEffective,
Fn<T,F> fn,
SelectDsl nestedSelect)
根据条件添加大于条件(OR 运算),右侧值来自嵌套查询。
|
<T,F> C |
NestedCondition.orGreaterThan(Fn<T,F> fn,
SelectDsl nestedSelect)
添加大于条件(OR 运算),右侧值来自嵌套查询。
|
default <T,F> C |
NestedCondition.orGreaterThanOrEqualTo(boolean isEffective,
Fn<T,F> fn,
SelectDsl nestedSelect)
根据条件添加大于等于条件(OR 运算),右侧值来自嵌套查询。
|
<T,F> C |
NestedCondition.orGreaterThanOrEqualTo(Fn<T,F> fn,
SelectDsl nestedSelect)
添加大于等于条件(OR 运算),右侧值来自嵌套查询。
|
default <T,F> C |
NestedCondition.orIn(boolean isEffective,
Fn<T,F> fn,
SelectDsl nestedSelect)
根据条件添加 IN 条件(OR 运算),右侧值来自嵌套查询。
|
<T,F> C |
NestedCondition.orIn(Fn<T,F> fn,
SelectDsl nestedSelect)
添加 IN 条件(OR 运算),右侧值来自嵌套查询。
|
default <T,F> C |
NestedCondition.orLessThan(boolean isEffective,
Fn<T,F> fn,
SelectDsl nestedSelect)
根据条件添加小于条件(OR 运算),右侧值来自嵌套查询。
|
<T,F> C |
NestedCondition.orLessThan(Fn<T,F> fn,
SelectDsl nestedSelect)
添加小于条件(OR 运算),右侧值来自嵌套查询。
|
default <T,F> C |
NestedCondition.orLessThanOrEqualTo(boolean isEffective,
Fn<T,F> fn,
SelectDsl nestedSelect)
根据条件添加小于等于条件(OR 运算),右侧值来自嵌套查询。
|
<T,F> C |
NestedCondition.orLessThanOrEqualTo(Fn<T,F> fn,
SelectDsl nestedSelect)
添加小于等于条件(OR 运算),右侧值来自嵌套查询。
|
default <T,F> C |
NestedCondition.orNotEqualTo(boolean isEffective,
Fn<T,F> fn,
SelectDsl nestedSelect)
根据条件添加不等于条件(OR 运算),右侧值来自嵌套查询。
|
<T,F> C |
NestedCondition.orNotEqualTo(Fn<T,F> fn,
SelectDsl nestedSelect)
添加不等于条件(OR 运算),右侧值来自嵌套查询。
|
default C |
NestedCondition.orNotExists(boolean isEffective,
SelectDsl nestedSelect)
根据条件添加 NOT EXISTS 条件(OR 运算),判断子查询是否不存在。
|
C |
NestedCondition.orNotExists(SelectDsl nestedSelect)
添加 NOT EXISTS 条件(OR 运算),判断子查询是否不存在。
|
default <T,F> C |
NestedCondition.orNotIn(boolean isEffective,
Fn<T,F> fn,
SelectDsl nestedSelect)
根据条件添加 NOT IN 条件(OR 运算),右侧值来自嵌套查询。
|
<T,F> C |
NestedCondition.orNotIn(Fn<T,F> fn,
SelectDsl nestedSelect)
添加 NOT IN 条件(OR 运算),右侧值来自嵌套查询。
|
| 限定符和类型 | 方法和说明 |
|---|---|
C |
HavingCondition.andEqualTo(AggregateFunction function,
SelectDsl nestedSelect) |
C |
HavingCondition.andGreaterThan(AggregateFunction function,
SelectDsl nestedSelect) |
C |
HavingCondition.andGreaterThanOrEqualTo(AggregateFunction function,
SelectDsl nestedSelect) |
C |
HavingCondition.andIn(AggregateFunction function,
SelectDsl nestedSelect) |
C |
HavingCondition.andLessThan(AggregateFunction function,
SelectDsl nestedSelect) |
C |
HavingCondition.andLessThanOrEqualTo(AggregateFunction function,
SelectDsl nestedSelect) |
C |
HavingCondition.andNotEqualTo(AggregateFunction function,
SelectDsl nestedSelect) |
C |
HavingCondition.andNotIn(AggregateFunction function,
SelectDsl nestedSelect) |
JoinCondition |
JoinCondition.innerJoin(SelectDsl nestedSelect,
String alias,
Consumer<GenericWhereCondition> onCondition)
构建一个 INNER JOIN 连接,用于将当前查询与子查询结果关联。
|
JoinCondition |
TableRelation.innerJoin(SelectDsl nestedSelect,
String alias,
Consumer<GenericWhereCondition> onCondition) |
default JoinCondition |
JoinCondition.innerJoinUnion(boolean isEffective,
SelectDsl[] selectDsls,
String alias,
Consumer<GenericWhereCondition> onCondition)
条件式 INNER JOIN UNION。
|
JoinCondition |
JoinCondition.innerJoinUnion(SelectDsl[] selectDsls,
String alias,
Consumer<GenericWhereCondition> onCondition)
INNER JOIN UNION 的核心实现。
|
JoinCondition |
TableRelation.innerJoinUnion(SelectDsl[] selectDsls,
String alias,
Consumer<GenericWhereCondition> onCondition) |
default JoinCondition |
JoinCondition.innerJoinUnionAll(boolean isEffective,
SelectDsl[] selectDsls,
String alias,
Consumer<GenericWhereCondition> onCondition)
条件式 INNER JOIN UNION ALL。
|
JoinCondition |
JoinCondition.innerJoinUnionAll(SelectDsl[] selectDsls,
String alias,
Consumer<GenericWhereCondition> onCondition)
INNER JOIN UNION ALL 的核心实现。
|
JoinCondition |
TableRelation.innerJoinUnionAll(SelectDsl[] selectDsls,
String alias,
Consumer<GenericWhereCondition> onCondition) |
default JoinCondition |
JoinCondition.join(boolean isEffective,
SelectDsl nestedSelect,
String alias,
Consumer<GenericWhereCondition> onCondition) |
default JoinCondition |
JoinCondition.join(SelectDsl nestedSelect,
String alias,
Consumer<GenericWhereCondition> onCondition)
使用嵌套查询的 INNER JOIN 方法。
|
default JoinCondition |
JoinCondition.joinUnion(boolean isEffective,
SelectDsl[] selectDsls,
String alias,
Consumer<GenericWhereCondition> onCondition)
条件式 INNER JOIN UNION。
|
default JoinCondition |
JoinCondition.joinUnion(SelectDsl[] selectDsls,
String alias,
Consumer<GenericWhereCondition> onCondition)
INNER JOIN UNION。
|
default JoinCondition |
JoinCondition.joinUnionAll(boolean isEffective,
SelectDsl[] selectDsls,
String alias,
Consumer<GenericWhereCondition> onCondition)
条件式 INNER JOIN UNION ALL。
|
default JoinCondition |
JoinCondition.joinUnionAll(SelectDsl[] selectDsls,
String alias,
Consumer<GenericWhereCondition> onCondition)
INNER JOIN UNION ALL。
|
default JoinCondition |
JoinCondition.leftJoin(boolean isEffective,
SelectDsl nestedSelect,
String alias,
Consumer<GenericWhereCondition> onCondition) |
JoinCondition |
JoinCondition.leftJoin(SelectDsl nestedSelect,
String alias,
Consumer<GenericWhereCondition> onCondition)
构建一个 LEFT JOIN 连接,用于将当前查询与子查询结果关联。
|
JoinCondition |
TableRelation.leftJoin(SelectDsl nestedSelect,
String alias,
Consumer<GenericWhereCondition> onCondition) |
default JoinCondition |
JoinCondition.leftJoinUnion(boolean isEffective,
SelectDsl[] selectDsls,
String alias,
Consumer<GenericWhereCondition> onCondition)
条件式 LEFT JOIN UNION。
|
JoinCondition |
JoinCondition.leftJoinUnion(SelectDsl[] selectDsls,
String alias,
Consumer<GenericWhereCondition> onCondition)
LEFT JOIN UNION 的核心实现。
|
JoinCondition |
TableRelation.leftJoinUnion(SelectDsl[] selectDsls,
String alias,
Consumer<GenericWhereCondition> onCondition) |
default JoinCondition |
JoinCondition.leftJoinUnionAll(boolean isEffective,
SelectDsl[] selectDsls,
String alias,
Consumer<GenericWhereCondition> onCondition)
条件式 LEFT JOIN UNION ALL。
|
JoinCondition |
JoinCondition.leftJoinUnionAll(SelectDsl[] selectDsls,
String alias,
Consumer<GenericWhereCondition> onCondition)
LEFT JOIN UNION ALL 的核心实现。
|
JoinCondition |
TableRelation.leftJoinUnionAll(SelectDsl[] selectDsls,
String alias,
Consumer<GenericWhereCondition> onCondition) |
C |
HavingCondition.orEqualTo(AggregateFunction function,
SelectDsl nestedSelect) |
C |
HavingCondition.orGreaterThan(AggregateFunction function,
SelectDsl nestedSelect) |
C |
HavingCondition.orGreaterThanOrEqualTo(AggregateFunction function,
SelectDsl nestedSelect) |
C |
HavingCondition.orIn(AggregateFunction function,
SelectDsl nestedSelect) |
C |
HavingCondition.orLessThan(AggregateFunction function,
SelectDsl nestedSelect) |
C |
HavingCondition.orLessThanOrEqualTo(AggregateFunction function,
SelectDsl nestedSelect) |
C |
HavingCondition.orNotEqualTo(AggregateFunction function,
SelectDsl nestedSelect) |
C |
HavingCondition.orNotIn(AggregateFunction function,
SelectDsl nestedSelect) |
void |
UnionSelect.parseSelectDsls(SelectDsl[] selects) |
default JoinCondition |
JoinCondition.rightJoin(boolean isEffective,
SelectDsl nestedSelect,
String alias,
Consumer<GenericWhereCondition> onCondition) |
JoinCondition |
JoinCondition.rightJoin(SelectDsl nestedSelect,
String alias,
Consumer<GenericWhereCondition> onCondition)
构建一个 RIGHT JOIN 连接,用于将当前查询与子查询结果关联。
|
JoinCondition |
TableRelation.rightJoin(SelectDsl nestedSelect,
String alias,
Consumer<GenericWhereCondition> onCondition) |
default JoinCondition |
JoinCondition.rightJoinUnion(boolean isEffective,
SelectDsl[] selectDsls,
String alias,
Consumer<GenericWhereCondition> onCondition)
条件式 RIGHT JOIN UNION。
|
JoinCondition |
JoinCondition.rightJoinUnion(SelectDsl[] selectDsls,
String alias,
Consumer<GenericWhereCondition> onCondition)
RIGHT JOIN UNION 的核心实现。
|
JoinCondition |
TableRelation.rightJoinUnion(SelectDsl[] selectDsls,
String alias,
Consumer<GenericWhereCondition> onCondition) |
default JoinCondition |
JoinCondition.rightJoinUnionAll(boolean isEffective,
SelectDsl[] selectDsls,
String alias,
Consumer<GenericWhereCondition> onCondition)
条件式 RIGHT JOIN UNION ALL。
|
JoinCondition |
JoinCondition.rightJoinUnionAll(SelectDsl[] selectDsls,
String alias,
Consumer<GenericWhereCondition> onCondition)
RIGHT JOIN UNION ALL 的核心实现。
|
JoinCondition |
TableRelation.rightJoinUnionAll(SelectDsl[] selectDsls,
String alias,
Consumer<GenericWhereCondition> onCondition) |
| 限定符和类型 | 方法和说明 |
|---|---|
SelectDsl |
NestedColumn.getNestedColumnReference() |
| 构造器和说明 |
|---|
NestedColumn(SelectDsl columnReferenceConsumer,
String alias) |
| 限定符和类型 | 方法和说明 |
|---|---|
SelectDsl |
NestedJoin.getNestedSelect() |
SelectDsl[] |
UnionJoin.getNestedSelects() |
| 构造器和说明 |
|---|
NestedJoin(JoinTableType joinTableType,
SelectDsl nestedSelect,
String tableAlias,
Consumer<GenericWhereCondition> onCondition) |
NestedJoin(SelectDsl nestedSelect,
String tableAlias) |
UnionJoin(JoinTableType joinTableType,
SelectDsl[] nestedSelects,
String tableAlias,
Consumer<GenericWhereCondition> onCondition,
UnionType unionType) |
UnionJoin(SelectDsl[] nestedSelects,
String tableAlias,
UnionType unionType) |
| 限定符和类型 | 方法和说明 |
|---|---|
static SqlStatementSelectWrapper |
SqlUtils.executeNestedSelect(NestedMeta nestedMeta,
SelectDsl nestedSelectConsumer) |
static SqlStatementSelectWrapper |
SqlUtils.executeNestedSelect(NestedMeta nestedMeta,
SelectDsl nestedSelectConsumer,
Map<String,TableAliasMapping> aliasTableMap) |
static SqlStatementSelectWrapper |
SqlUtils.executeNestedSelect(SelectDsl nestedSelectConsumer) |
Copyright © 2024–2026 Dynamic-SQL. All rights reserved.