Package com.github.yulichang.extension.kt.interfaces

Interface QueryJoin<Children,Entity>

All Superinterfaces:

MPJBaseJoin<Entity>, StringJoin<Children,Entity>

All Known Implementing Classes:

KtAbstractLambdaWrapper, KtDeleteJoinWrapper, KtLambdaWrapper, KtUpdateJoinWrapper

public interface QueryJoin<Children,Entity>
extends MPJBaseJoin<Entity>, StringJoin<Children,Entity>

Author:

yulichang

Method Summary

Modifier and Type	Method	Description
default Children	fullJoin(Class<?> clazz, MFunction<KtAbstractLambdaWrapper<?,?>> function)	ignore 参考 left join
default Children	fullJoin(Class<?> clazz, String alias, MFunction<KtAbstractLambdaWrapper<?,?>> function)	ignore 参考 left join
default Children	fullJoin(Class<?> clazz, String alias, BiConsumer<KtAbstractLambdaWrapper<?,?>,Children> consumer)	ignore 参考 left join
default Children	fullJoin(Class<?> clazz, String alias, kotlin.reflect.KProperty<?> left, String rightAlias, kotlin.reflect.KProperty<?> right)	ignore 参考 left join
default Children	fullJoin(Class<?> clazz, String alias, kotlin.reflect.KProperty<?> left, kotlin.reflect.KProperty<?> right)	ignore 参考 left join
default Children	fullJoin(Class<?> clazz, String alias, kotlin.reflect.KProperty<?> left, kotlin.reflect.KProperty<?> right, MFunction<Children> ext)	ignore 参考 left join
default Children	fullJoin(Class<?> clazz, BiConsumer<KtAbstractLambdaWrapper<?,?>,Children> consumer)	ignore 参考 left join
default Children	fullJoin(Class<?> clazz, kotlin.reflect.KProperty<?> left, String rightAlias, kotlin.reflect.KProperty<?> right)	ignore 参考 left join
default Children	fullJoin(Class<?> clazz, kotlin.reflect.KProperty<?> left, kotlin.reflect.KProperty<?> right)	ignore 参考 left join
default Children	fullJoin(Class<?> clazz, kotlin.reflect.KProperty<?> left, kotlin.reflect.KProperty<?> right, MFunction<Children> ext)	ignore 参考 left join
default Children	innerJoin(Class<?> clazz, MFunction<KtAbstractLambdaWrapper<?,?>> function)	ignore 参考 left join
default Children	innerJoin(Class<?> clazz, String alias, MFunction<KtAbstractLambdaWrapper<?,?>> function)	ignore 参考 left join
default Children	innerJoin(Class<?> clazz, String alias, BiConsumer<KtAbstractLambdaWrapper<?,?>,Children> consumer)	ignore 参考 left join
default Children	innerJoin(Class<?> clazz, String alias, kotlin.reflect.KProperty<?> left, String rightAlias, kotlin.reflect.KProperty<?> right)	ignore 参考 left join
default Children	innerJoin(Class<?> clazz, String alias, kotlin.reflect.KProperty<?> left, kotlin.reflect.KProperty<?> right)	ignore 参考 left join
default Children	innerJoin(Class<?> clazz, String alias, kotlin.reflect.KProperty<?> left, kotlin.reflect.KProperty<?> right, MFunction<Children> ext)	ignore 参考 left join
default Children	innerJoin(Class<?> clazz, BiConsumer<KtAbstractLambdaWrapper<?,?>,Children> consumer)	ignore 参考 left join
default Children	innerJoin(Class<?> clazz, kotlin.reflect.KProperty<?> left, String rightAlias, kotlin.reflect.KProperty<?> right)	ignore 参考 left join
default Children	innerJoin(Class<?> clazz, kotlin.reflect.KProperty<?> left, kotlin.reflect.KProperty<?> right)	ignore 参考 left join
default Children	innerJoin(Class<?> clazz, kotlin.reflect.KProperty<?> left, kotlin.reflect.KProperty<?> right, MFunction<Children> ext)	ignore 参考 left join
default Children	join(String keyWord, Class<?> clazz, MFunction<KtAbstractLambdaWrapper<?,?>> function)	自定义连表关键词
default Children	join(String keyWord, Class<?> clazz, String alias, MFunction<KtAbstractLambdaWrapper<?,?>> function)	自定义连表关键词
Children	join(String keyWord, Class<?> clazz, String alias, BiConsumer<KtAbstractLambdaWrapper<?,?>,Children> consumer)	内部使用, 不建议直接调用
default <T, X> Children	join(String keyWord, Class<?> clazz, String alias, kotlin.reflect.KProperty<?> left, String rightAlias, kotlin.reflect.KProperty<?> right)	ignore
default <T, X> Children	join(String keyWord, Class<?> clazz, String alias, kotlin.reflect.KProperty<?> left, kotlin.reflect.KProperty<?> right)	自定义连表关键词 调用此方法 keyword 前后需要带空格 比如 " LEFT JOIN " " RIGHT JOIN "
default Children	join(String keyWord, Class<?> clazz, String alias, kotlin.reflect.KProperty<?> left, kotlin.reflect.KProperty<?> right, MFunction<Children> ext)	自定义连表关键词
default Children	join(String keyWord, Class<?> clazz, BiConsumer<KtAbstractLambdaWrapper<?,?>,Children> consumer)	内部使用, 不建议直接调用
default Children	join(String keyWord, Class<?> clazz, kotlin.reflect.KProperty<?> left, String rightAlias, kotlin.reflect.KProperty<?> right)	ignore
default Children	join(String keyWord, Class<?> clazz, kotlin.reflect.KProperty<?> left, kotlin.reflect.KProperty<?> right)	自定义连表关键词 调用此方法 keyword 前后需要带空格 比如 " LEFT JOIN " " RIGHT JOIN "
default Children	join(String keyWord, Class<?> clazz, kotlin.reflect.KProperty<?> left, kotlin.reflect.KProperty<?> right, MFunction<Children> ext)	自定义连表关键词
default Children	leftJoin(Class<?> clazz, MFunction<KtAbstractLambdaWrapper<?,?>> function)	left join 多条件
default Children	leftJoin(Class<?> clazz, String alias, MFunction<KtAbstractLambdaWrapper<?,?>> function)	left join 多条件
default Children	leftJoin(Class<?> clazz, String alias, BiConsumer<KtAbstractLambdaWrapper<?,?>,Children> consumer)	left join 多条件
default Children	leftJoin(Class<?> clazz, String alias, kotlin.reflect.KProperty<?> left, String rightAlias, kotlin.reflect.KProperty<?> right)	left join
default Children	leftJoin(Class<?> clazz, String alias, kotlin.reflect.KProperty<?> left, kotlin.reflect.KProperty<?> right)	left join
default Children	leftJoin(Class<?> clazz, String alias, kotlin.reflect.KProperty<?> left, kotlin.reflect.KProperty<?> right, MFunction<Children> ext)	left join
default Children	leftJoin(Class<?> clazz, BiConsumer<KtAbstractLambdaWrapper<?,?>,Children> consumer)	left join 多条件
default Children	leftJoin(Class<?> clazz, kotlin.reflect.KProperty<?> left, String rightAlias, kotlin.reflect.KProperty<?> right)	left join
default Children	leftJoin(Class<?> clazz, kotlin.reflect.KProperty<?> left, kotlin.reflect.KProperty<?> right)	left join
default Children	leftJoin(Class<?> clazz, kotlin.reflect.KProperty<?> left, kotlin.reflect.KProperty<?> right, MFunction<Children> ext)	left join
default Children	rightJoin(Class<?> clazz, MFunction<KtAbstractLambdaWrapper<?,?>> function)	ignore 参考 left join
default Children	rightJoin(Class<?> clazz, String alias, MFunction<KtAbstractLambdaWrapper<?,?>> function)	ignore 参考 left join
default Children	rightJoin(Class<?> clazz, String alias, BiConsumer<KtAbstractLambdaWrapper<?,?>,Children> consumer)	ignore 参考 left join
default Children	rightJoin(Class<?> clazz, String alias, kotlin.reflect.KProperty<?> left, String rightAlias, kotlin.reflect.KProperty<?> right)	ignore 参考 left join
default Children	rightJoin(Class<?> clazz, String alias, kotlin.reflect.KProperty<?> left, kotlin.reflect.KProperty<?> right)	ignore 参考 left join
default Children	rightJoin(Class<?> clazz, String alias, kotlin.reflect.KProperty<?> left, kotlin.reflect.KProperty<?> right, MFunction<Children> ext)	ignore 参考 left join
default Children	rightJoin(Class<?> clazz, BiConsumer<KtAbstractLambdaWrapper<?,?>,Children> consumer)	ignore 参考 left join
default Children	rightJoin(Class<?> clazz, kotlin.reflect.KProperty<?> left, String rightAlias, kotlin.reflect.KProperty<?> right)	ignore 参考 left join
default Children	rightJoin(Class<?> clazz, kotlin.reflect.KProperty<?> left, kotlin.reflect.KProperty<?> right)	ignore 参考 left join
default Children	rightJoin(Class<?> clazz, kotlin.reflect.KProperty<?> left, kotlin.reflect.KProperty<?> right, MFunction<Children> ext)	ignore 参考 left join

Methods inherited from interface com.github.yulichang.interfaces.MPJBaseJoin

getDeleteLogicSql, getDeleteSql, getUnionSql

Methods inherited from interface com.github.yulichang.query.interfaces.StringJoin

fullJoin, fullJoin, fullJoin, fullJoin, innerJoin, innerJoin, innerJoin, innerJoin, join, join, leftJoin, leftJoin, leftJoin, leftJoin, rightJoin, rightJoin, rightJoin, rightJoin

Method Details

leftJoin

default Children leftJoin(Class<?> clazz,
 kotlin.reflect.KProperty<?> left,
 kotlin.reflect.KProperty<?> right)

left join

Parameters:

clazz - 关联的实体类

left - 条件

right - 条件

leftJoin

default Children leftJoin(Class<?> clazz,
 kotlin.reflect.KProperty<?> left,
 String rightAlias,
 kotlin.reflect.KProperty<?> right)

left join

Parameters:

clazz - 关联的实体类

left - 条件

right - 条件

leftJoin

default Children leftJoin(Class<?> clazz,
 MFunction<KtAbstractLambdaWrapper<?,?>> function)

left join 多条件

例 leftJoin(UserDO.class, on -> on.eq(UserDO::getId,UserAddressDO::getUserId).le().gt()...)

Parameters:

clazz - 关联实体类

function - 条件`

leftJoin

default Children leftJoin(Class<?> clazz,
 kotlin.reflect.KProperty<?> left,
 kotlin.reflect.KProperty<?> right,
 MFunction<Children> ext)

left join

Parameters:

clazz - 关联的实体类

left - 条件

right - 条件

leftJoin

default Children leftJoin(Class<?> clazz,
 BiConsumer<KtAbstractLambdaWrapper<?,?>,Children> consumer)

left join 多条件

例 leftJoin(UserDO.class, on -> on.eq(UserDO::getId,UserAddressDO::getUserId).le().gt()...)

Parameters:

clazz - 关联实体类

consumer - 条件

leftJoin

default Children leftJoin(Class<?> clazz,
 String alias,
 kotlin.reflect.KProperty<?> left,
 kotlin.reflect.KProperty<?> right)

left join

Parameters:

clazz - 关联的实体类

left - 条件

right - 条件

leftJoin

default Children leftJoin(Class<?> clazz,
 String alias,
 kotlin.reflect.KProperty<?> left,
 String rightAlias,
 kotlin.reflect.KProperty<?> right)

left join

Parameters:

clazz - 关联的实体类

left - 条件

right - 条件

leftJoin

default Children leftJoin(Class<?> clazz,
 String alias,
 MFunction<KtAbstractLambdaWrapper<?,?>> function)

left join 多条件

例 leftJoin(UserDO.class, on -> on.eq(UserDO::getId,UserAddressDO::getUserId).le().gt()...)

Parameters:

clazz - 关联实体类

function - 条件

leftJoin

default Children leftJoin(Class<?> clazz,
 String alias,
 kotlin.reflect.KProperty<?> left,
 kotlin.reflect.KProperty<?> right,
 MFunction<Children> ext)

left join

Parameters:

clazz - 关联的实体类

left - 条件

right - 条件

leftJoin

default Children leftJoin(Class<?> clazz,
 String alias,
 BiConsumer<KtAbstractLambdaWrapper<?,?>,Children> consumer)

left join 多条件

例 leftJoin(UserDO.class, on -> on.eq(UserDO::getId,UserAddressDO::getUserId).le().gt()...)

Parameters:

clazz - 关联实体类

consumer - 条件

rightJoin

default Children rightJoin(Class<?> clazz,
 kotlin.reflect.KProperty<?> left,
 kotlin.reflect.KProperty<?> right)

ignore 参考 left join

rightJoin

default Children rightJoin(Class<?> clazz,
 kotlin.reflect.KProperty<?> left,
 String rightAlias,
 kotlin.reflect.KProperty<?> right)

ignore 参考 left join

rightJoin

default Children rightJoin(Class<?> clazz,
 MFunction<KtAbstractLambdaWrapper<?,?>> function)

ignore 参考 left join

rightJoin

default Children rightJoin(Class<?> clazz,
 kotlin.reflect.KProperty<?> left,
 kotlin.reflect.KProperty<?> right,
 MFunction<Children> ext)

ignore 参考 left join

rightJoin

default Children rightJoin(Class<?> clazz,
 BiConsumer<KtAbstractLambdaWrapper<?,?>,Children> consumer)

ignore 参考 left join

rightJoin

default Children rightJoin(Class<?> clazz,
 String alias,
 kotlin.reflect.KProperty<?> left,
 kotlin.reflect.KProperty<?> right)

ignore 参考 left join

rightJoin

default Children rightJoin(Class<?> clazz,
 String alias,
 kotlin.reflect.KProperty<?> left,
 String rightAlias,
 kotlin.reflect.KProperty<?> right)

ignore 参考 left join

rightJoin

default Children rightJoin(Class<?> clazz,
 String alias,
 MFunction<KtAbstractLambdaWrapper<?,?>> function)

ignore 参考 left join

rightJoin

default Children rightJoin(Class<?> clazz,
 String alias,
 kotlin.reflect.KProperty<?> left,
 kotlin.reflect.KProperty<?> right,
 MFunction<Children> ext)

ignore 参考 left join

rightJoin

default Children rightJoin(Class<?> clazz,
 String alias,
 BiConsumer<KtAbstractLambdaWrapper<?,?>,Children> consumer)

ignore 参考 left join

innerJoin

default Children innerJoin(Class<?> clazz,
 kotlin.reflect.KProperty<?> left,
 kotlin.reflect.KProperty<?> right)

ignore 参考 left join

innerJoin

default Children innerJoin(Class<?> clazz,
 kotlin.reflect.KProperty<?> left,
 String rightAlias,
 kotlin.reflect.KProperty<?> right)

ignore 参考 left join

innerJoin

default Children innerJoin(Class<?> clazz,
 MFunction<KtAbstractLambdaWrapper<?,?>> function)

ignore 参考 left join

innerJoin

default Children innerJoin(Class<?> clazz,
 kotlin.reflect.KProperty<?> left,
 kotlin.reflect.KProperty<?> right,
 MFunction<Children> ext)

ignore 参考 left join

innerJoin

default Children innerJoin(Class<?> clazz,
 BiConsumer<KtAbstractLambdaWrapper<?,?>,Children> consumer)

ignore 参考 left join

innerJoin

default Children innerJoin(Class<?> clazz,
 String alias,
 kotlin.reflect.KProperty<?> left,
 kotlin.reflect.KProperty<?> right)

ignore 参考 left join

innerJoin

default Children innerJoin(Class<?> clazz,
 String alias,
 kotlin.reflect.KProperty<?> left,
 String rightAlias,
 kotlin.reflect.KProperty<?> right)

ignore 参考 left join

innerJoin

default Children innerJoin(Class<?> clazz,
 String alias,
 MFunction<KtAbstractLambdaWrapper<?,?>> function)

ignore 参考 left join

innerJoin

default Children innerJoin(Class<?> clazz,
 String alias,
 kotlin.reflect.KProperty<?> left,
 kotlin.reflect.KProperty<?> right,
 MFunction<Children> ext)

ignore 参考 left join

innerJoin

default Children innerJoin(Class<?> clazz,
 String alias,
 BiConsumer<KtAbstractLambdaWrapper<?,?>,Children> consumer)

ignore 参考 left join

fullJoin

default Children fullJoin(Class<?> clazz,
 kotlin.reflect.KProperty<?> left,
 kotlin.reflect.KProperty<?> right)

ignore 参考 left join

fullJoin

default Children fullJoin(Class<?> clazz,
 kotlin.reflect.KProperty<?> left,
 String rightAlias,
 kotlin.reflect.KProperty<?> right)

ignore 参考 left join

fullJoin

default Children fullJoin(Class<?> clazz,
 MFunction<KtAbstractLambdaWrapper<?,?>> function)

ignore 参考 left join

fullJoin

default Children fullJoin(Class<?> clazz,
 kotlin.reflect.KProperty<?> left,
 kotlin.reflect.KProperty<?> right,
 MFunction<Children> ext)

ignore 参考 left join

fullJoin

default Children fullJoin(Class<?> clazz,
 BiConsumer<KtAbstractLambdaWrapper<?,?>,Children> consumer)

ignore 参考 left join

fullJoin

default Children fullJoin(Class<?> clazz,
 String alias,
 kotlin.reflect.KProperty<?> left,
 kotlin.reflect.KProperty<?> right)

ignore 参考 left join

fullJoin

default Children fullJoin(Class<?> clazz,
 String alias,
 kotlin.reflect.KProperty<?> left,
 String rightAlias,
 kotlin.reflect.KProperty<?> right)

ignore 参考 left join

fullJoin

default Children fullJoin(Class<?> clazz,
 String alias,
 MFunction<KtAbstractLambdaWrapper<?,?>> function)

ignore 参考 left join

fullJoin

default Children fullJoin(Class<?> clazz,
 String alias,
 kotlin.reflect.KProperty<?> left,
 kotlin.reflect.KProperty<?> right,
 MFunction<Children> ext)

ignore 参考 left join

fullJoin

default Children fullJoin(Class<?> clazz,
 String alias,
 BiConsumer<KtAbstractLambdaWrapper<?,?>,Children> consumer)

ignore 参考 left join

join

default Children join(String keyWord,
 Class<?> clazz,
 kotlin.reflect.KProperty<?> left,
 kotlin.reflect.KProperty<?> right)

自定义连表关键词 调用此方法 keyword 前后需要带空格 比如 " LEFT JOIN " " RIGHT JOIN "

查询基类 可以直接调用此方法实现以上所有功能

Parameters:

keyWord - 连表关键字

clazz - 连表实体类

left - 关联条件

right - 扩展 用于关联表的 select 和 where

join

default Children join(String keyWord,
 Class<?> clazz,
 kotlin.reflect.KProperty<?> left,
 String rightAlias,
 kotlin.reflect.KProperty<?> right)

ignore

join

default Children join(String keyWord,
 Class<?> clazz,
 MFunction<KtAbstractLambdaWrapper<?,?>> function)

自定义连表关键词

例 leftJoin(UserDO.class, on -> on.eq(UserDO::getId,UserAddressDO::getUserId).le().gt()...)

Parameters:

clazz - 关联实体类

function - 条件

join

default Children join(String keyWord,
 Class<?> clazz,
 kotlin.reflect.KProperty<?> left,
 kotlin.reflect.KProperty<?> right,
 MFunction<Children> ext)

自定义连表关键词

Parameters:

clazz - 关联的实体类

left - 条件

right - 条件

join

default <T,
X> Children join(String keyWord,
 Class<?> clazz,
 String alias,
 kotlin.reflect.KProperty<?> left,
 kotlin.reflect.KProperty<?> right)

自定义连表关键词 调用此方法 keyword 前后需要带空格 比如 " LEFT JOIN " " RIGHT JOIN "

查询基类 可以直接调用此方法实现以上所有功能

Parameters:

keyWord - 连表关键字

clazz - 连表实体类

left - 关联条件

right - 扩展 用于关联表的 select 和 where

join

default <T,
X> Children join(String keyWord,
 Class<?> clazz,
 String alias,
 kotlin.reflect.KProperty<?> left,
 String rightAlias,
 kotlin.reflect.KProperty<?> right)

ignore

join

default Children join(String keyWord,
 Class<?> clazz,
 String alias,
 MFunction<KtAbstractLambdaWrapper<?,?>> function)

自定义连表关键词

例 leftJoin(UserDO.class, on -> on.eq(UserDO::getId,UserAddressDO::getUserId).le().gt()...)

Parameters:

clazz - 关联实体类

function - 条件

join

default Children join(String keyWord,
 Class<?> clazz,
 String alias,
 kotlin.reflect.KProperty<?> left,
 kotlin.reflect.KProperty<?> right,
 MFunction<Children> ext)

自定义连表关键词

Parameters:

clazz - 关联的实体类

left - 条件

right - 条件

join

default Children join(String keyWord,
 Class<?> clazz,
 BiConsumer<KtAbstractLambdaWrapper<?,?>,Children> consumer)

内部使用, 不建议直接调用

join

Children join(String keyWord,
 Class<?> clazz,
 String alias,
 BiConsumer<KtAbstractLambdaWrapper<?,?>,Children> consumer)

内部使用, 不建议直接调用