| 程序包 | 说明 |
|---|---|
| com.dynamic.sql.core.dml.select |
| 限定符和类型 | 类和说明 |
|---|---|
class |
TableRelation<R>
表关联关系
|
| 限定符和类型 | 方法和说明 |
|---|---|
default JoinCondition |
JoinCondition.crossJoin(boolean isEffective,
Class<?> clazz) |
default JoinCondition |
JoinCondition.crossJoin(boolean isEffective,
CteTable cte)
已过时。
|
JoinCondition |
JoinCondition.crossJoin(Class<?> clazz)
构建一个 CROSS JOIN 连接,用于将当前查询与另一个表关联。
|
JoinCondition |
TableRelation.crossJoin(Class<?> clazz) |
JoinCondition |
JoinCondition.crossJoin(CteTable cte)
已过时。
|
JoinCondition |
TableRelation.crossJoin(CteTable cte) |
default JoinCondition |
JoinCondition.fullJoin(boolean isEffective,
Class<?> clazz,
Consumer<GenericWhereCondition> onCondition) |
default JoinCondition |
JoinCondition.fullJoin(boolean isEffective,
Class<?> clazz,
String alias,
Consumer<GenericWhereCondition> onCondition) |
default JoinCondition |
JoinCondition.fullJoin(boolean isEffective,
CteTable cte,
Consumer<GenericWhereCondition> onCondition)
已过时。
|
JoinCondition |
JoinCondition.fullJoin(Class<?> clazz,
Consumer<GenericWhereCondition> onCondition)
构建一个 FULL JOIN 连接,用于将当前查询与另一个表关联。
|
JoinCondition |
TableRelation.fullJoin(Class<?> clazz,
Consumer<GenericWhereCondition> onCondition) |
JoinCondition |
JoinCondition.fullJoin(Class<?> clazz,
String alias,
Consumer<GenericWhereCondition> onCondition)
构建一个 FULL JOIN 连接,用于将当前查询与另一个表关联。
|
JoinCondition |
TableRelation.fullJoin(Class<?> clazz,
String alias,
Consumer<GenericWhereCondition> onCondition) |
JoinCondition |
JoinCondition.fullJoin(CteTable cte,
Consumer<GenericWhereCondition> onCondition)
已过时。
|
JoinCondition |
TableRelation.fullJoin(CteTable cte,
Consumer<GenericWhereCondition> onCondition) |
default JoinCondition |
JoinCondition.innerJoin(boolean isEffective,
Class<?> clazz,
Consumer<GenericWhereCondition> onCondition) |
JoinCondition |
JoinCondition.innerJoin(Class<?> clazz,
Consumer<GenericWhereCondition> onCondition)
构建一个 INNER JOIN 连接,用于将当前查询与另一个表关联。
|
JoinCondition |
TableRelation.innerJoin(Class<?> clazz,
Consumer<GenericWhereCondition> onCondition) |
JoinCondition |
JoinCondition.innerJoin(Class<?> clazz,
String alias,
Consumer<GenericWhereCondition> onCondition)
构建一个 INNER JOIN 连接,用于将当前查询与另一个表关联。
|
JoinCondition |
TableRelation.innerJoin(Class<?> clazz,
String alias,
Consumer<GenericWhereCondition> onCondition) |
JoinCondition |
JoinCondition.innerJoin(CteTable cte,
Consumer<GenericWhereCondition> onCondition)
已过时。
|
JoinCondition |
TableRelation.innerJoin(CteTable cte,
Consumer<GenericWhereCondition> onCondition) |
JoinCondition |
JoinCondition.innerJoin(SelectDsl nestedSelect,
String alias,
Consumer<GenericWhereCondition> onCondition)
构建一个 INNER JOIN 连接,用于将当前查询与子查询结果关联。
|
JoinCondition |
TableRelation.innerJoin(SelectDsl nestedSelect,
String alias,
Consumer<GenericWhereCondition> onCondition) |
JoinCondition |
JoinCondition.innerJoin(Supplier<TableFunction> tableFunction,
String alias,
Consumer<GenericWhereCondition> onCondition)
构建一个 INNER JOIN 连接,用于将当前查询与表函数的结果关联。
|
JoinCondition |
TableRelation.innerJoin(Supplier<TableFunction> tableFunction,
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,
Class<?> clazz,
Consumer<GenericWhereCondition> onCondition) |
default JoinCondition |
JoinCondition.join(boolean isEffective,
Class<?> clazz,
String alias,
Consumer<GenericWhereCondition> onCondition) |
default JoinCondition |
JoinCondition.join(boolean isEffective,
CteTable cte,
Consumer<GenericWhereCondition> onCondition)
已过时。
|
default JoinCondition |
JoinCondition.join(boolean isEffective,
SelectDsl nestedSelect,
String alias,
Consumer<GenericWhereCondition> onCondition) |
default JoinCondition |
JoinCondition.join(boolean isEffective,
Supplier<TableFunction> tableFunction,
String alias) |
default JoinCondition |
JoinCondition.join(boolean isEffective,
Supplier<TableFunction> tableFunction,
String alias,
Consumer<GenericWhereCondition> onCondition)
条件式 JOIN:当 isEffective 为 true 时执行 JOIN,否则忽略该 JOIN。
|
default JoinCondition |
JoinCondition.join(Class<?> clazz,
Consumer<GenericWhereCondition> onCondition)
INNER JOIN 的别名方法。
|
default JoinCondition |
JoinCondition.join(Class<?> clazz,
String alias,
Consumer<GenericWhereCondition> onCondition)
INNER JOIN 的别名方法,允许指定表别名。
|
default JoinCondition |
JoinCondition.join(CteTable cte,
Consumer<GenericWhereCondition> onCondition)
已过时。
|
default JoinCondition |
JoinCondition.join(SelectDsl nestedSelect,
String alias,
Consumer<GenericWhereCondition> onCondition)
使用嵌套查询的 INNER JOIN 方法。
|
default JoinCondition |
JoinCondition.join(Supplier<TableFunction> tableFunction,
String alias)
使用表函数进行 INNER JOIN。
|
default JoinCondition |
JoinCondition.join(Supplier<TableFunction> tableFunction,
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,
Class<?> clazz,
Consumer<GenericWhereCondition> onCondition) |
default JoinCondition |
JoinCondition.leftJoin(boolean isEffective,
Class<?> clazz,
String alias,
Consumer<GenericWhereCondition> onCondition) |
default JoinCondition |
JoinCondition.leftJoin(boolean isEffective,
CteTable cte,
Consumer<GenericWhereCondition> onCondition)
已过时。
|
default JoinCondition |
JoinCondition.leftJoin(boolean isEffective,
SelectDsl nestedSelect,
String alias,
Consumer<GenericWhereCondition> onCondition) |
default JoinCondition |
JoinCondition.leftJoin(boolean isEffective,
Supplier<TableFunction> tableFunction,
String alias,
Consumer<GenericWhereCondition> onCondition) |
JoinCondition |
JoinCondition.leftJoin(Class<?> clazz,
Consumer<GenericWhereCondition> onCondition)
构建一个 LEFT JOIN 连接,用于将当前查询与另一个表关联。
|
JoinCondition |
TableRelation.leftJoin(Class<?> clazz,
Consumer<GenericWhereCondition> onCondition) |
JoinCondition |
JoinCondition.leftJoin(Class<?> clazz,
String alias,
Consumer<GenericWhereCondition> onCondition)
构建一个 LEFT JOIN 连接,用于将当前查询与另一个表关联。
|
JoinCondition |
TableRelation.leftJoin(Class<?> clazz,
String alias,
Consumer<GenericWhereCondition> onCondition) |
JoinCondition |
JoinCondition.leftJoin(CteTable cte,
Consumer<GenericWhereCondition> onCondition)
已过时。
|
JoinCondition |
TableRelation.leftJoin(CteTable cte,
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) |
JoinCondition |
JoinCondition.leftJoin(Supplier<TableFunction> tableFunction,
String alias,
Consumer<GenericWhereCondition> onCondition)
构建一个 LEFT JOIN 连接,用于将当前查询与表函数的结果关联。
|
JoinCondition |
TableRelation.leftJoin(Supplier<TableFunction> tableFunction,
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) |
default JoinCondition |
JoinCondition.rightJoin(boolean isEffective,
Class<?> clazz,
Consumer<GenericWhereCondition> onCondition) |
default JoinCondition |
JoinCondition.rightJoin(boolean isEffective,
Class<?> clazz,
String alias,
Consumer<GenericWhereCondition> onCondition) |
default JoinCondition |
JoinCondition.rightJoin(boolean isEffective,
CteTable cte,
Consumer<GenericWhereCondition> onCondition)
已过时。
|
default JoinCondition |
JoinCondition.rightJoin(boolean isEffective,
SelectDsl nestedSelect,
String alias,
Consumer<GenericWhereCondition> onCondition) |
default JoinCondition |
JoinCondition.rightJoin(boolean isEffective,
Supplier<TableFunction> tableFunction,
String alias,
Consumer<GenericWhereCondition> onCondition) |
JoinCondition |
JoinCondition.rightJoin(Class<?> clazz,
Consumer<GenericWhereCondition> onCondition)
构建一个 RIGHT JOIN 连接,用于将当前查询与另一个表关联。
|
JoinCondition |
TableRelation.rightJoin(Class<?> clazz,
Consumer<GenericWhereCondition> onCondition) |
JoinCondition |
JoinCondition.rightJoin(Class<?> clazz,
String alias,
Consumer<GenericWhereCondition> onCondition)
构建一个 RIGHT JOIN 连接,用于将当前查询与另一个表关联。
|
JoinCondition |
TableRelation.rightJoin(Class<?> clazz,
String alias,
Consumer<GenericWhereCondition> onCondition) |
JoinCondition |
JoinCondition.rightJoin(CteTable cte,
Consumer<GenericWhereCondition> onCondition)
已过时。
|
JoinCondition |
TableRelation.rightJoin(CteTable cte,
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) |
JoinCondition |
JoinCondition.rightJoin(Supplier<TableFunction> tableFunction,
String alias,
Consumer<GenericWhereCondition> onCondition)
构建一个 RIGHT JOIN 连接,用于将当前查询与表函数的结果关联。
|
JoinCondition |
TableRelation.rightJoin(Supplier<TableFunction> tableFunction,
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) |
Copyright © 2024–2026 Dynamic-SQL. All rights reserved.