Package com.github.yulichang.extension.apt.interfaces

Interface QueryJoin<Children,Entity>

All Superinterfaces:

MPJBaseJoin<Entity>, StringJoin<Children,Entity>

All Known Implementing Classes:

AptAbstractWrapper, AptQueryWrapper

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

Author:

yulichang

Method Summary

Modifier and Type	Method	Description
default <T> Children	innerJoin(BaseColumn<T> clazz, Column left, Column right)	ignore 参考 left join
default <T> Children	innerJoin(BaseColumn<T> clazz, MFunction<AptAbstractWrapper<Entity,?>> function)	ignore 参考 left join
default <T> Children	join(String keyWord, BaseColumn<T> clazz, Column left, Column right)	自定义连表关键词 调用此方法 keyword 前后需要带空格 比如 " LEFT JOIN " " RIGHT JOIN "
<T> Children	join(String keyWord, BaseColumn<T> clazz, MFunction<AptAbstractWrapper<Entity,?>> function)	内部使用, 不建议直接调用
default <T> Children	leftJoin(BaseColumn<T> clazz, Column left, Column right)	left join
default <T> Children	leftJoin(BaseColumn<T> clazz, MFunction<AptAbstractWrapper<Entity,?>> function)	left join 多条件
default <T> Children	rightJoin(BaseColumn<T> clazz, Column left, Column right)	ignore 参考 left join
default <T> Children	rightJoin(BaseColumn<T> clazz, MFunction<AptAbstractWrapper<Entity,?>> function)	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 <T> Children leftJoin(BaseColumn<T> clazz,
 Column left,
 Column right)

left join

Parameters:

clazz - 关联的实体类

left - 条件

right - 条件

leftJoin

default <T> Children leftJoin(BaseColumn<T> clazz,
 MFunction<AptAbstractWrapper<Entity,?>> function)

left join 多条件

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

Parameters:

clazz - 关联实体类

function - 条件`

rightJoin

default <T> Children rightJoin(BaseColumn<T> clazz,
 Column left,
 Column right)

ignore 参考 left join

rightJoin

default <T> Children rightJoin(BaseColumn<T> clazz,
 MFunction<AptAbstractWrapper<Entity,?>> function)

ignore 参考 left join

innerJoin

default <T> Children innerJoin(BaseColumn<T> clazz,
 Column left,
 Column right)

ignore 参考 left join

innerJoin

default <T> Children innerJoin(BaseColumn<T> clazz,
 MFunction<AptAbstractWrapper<Entity,?>> function)

ignore 参考 left join

join

default <T> Children join(String keyWord,
 BaseColumn<T> clazz,
 Column left,
 Column right)

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

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

Parameters:

keyWord - 连表关键字

clazz - 连表实体类

left - 关联条件

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

join

<T> Children join(String keyWord,
 BaseColumn<T> clazz,
 MFunction<AptAbstractWrapper<Entity,?>> function)

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