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

Interface Func<Children>

All Superinterfaces:

Serializable

All Known Implementing Classes:

KtAbstractLambdaWrapper, KtAbstractWrapper, KtDeleteJoinWrapper, KtLambdaWrapper, KtUpdateJoinWrapper

public interface Func<Children>
extends Serializable

将原来的泛型R改成KProperty<?>

copy Func

Method Summary

Modifier and Type	Method	Description
default Children	func(boolean condition, Consumer<Children> consumer)	消费函数
Children	func(boolean condition, Consumer<Children> consumer, Consumer<Children> consumerElse)
default Children	func(Consumer<Children> consumer)
Children	geSql(boolean condition, String alias, kotlin.reflect.KProperty<?> column, String inValue)	字段 >= ( sql语句 )
default Children	geSql(boolean condition, kotlin.reflect.KProperty<?> column, String inValue)
default Children	geSql(String alias, kotlin.reflect.KProperty<?> column, String inValue)
default Children	geSql(kotlin.reflect.KProperty<?> column, String inValue)
Children	groupBy(boolean condition, String alias, List<kotlin.reflect.KProperty<?>> columns)
Children	groupBy(boolean condition, String alias, kotlin.reflect.KProperty<?>... columns)	分组：GROUP BY 字段, ...
default Children	groupBy(boolean condition, List<kotlin.reflect.KProperty<?>> columns)
default Children	groupBy(boolean condition, kotlin.reflect.KProperty<?>... columns)
default Children	groupBy(String alias, List<kotlin.reflect.KProperty<?>> column)
default Children	groupBy(String alias, kotlin.reflect.KProperty<?>... columns)
default Children	groupBy(List<kotlin.reflect.KProperty<?>> column)
default Children	groupBy(kotlin.reflect.KProperty<?>... columns)
Children	gtSql(boolean condition, String alias, kotlin.reflect.KProperty<?> column, String inValue)	字段 > ( sql语句 )
default Children	gtSql(boolean condition, kotlin.reflect.KProperty<?> column, String inValue)
default Children	gtSql(String alias, kotlin.reflect.KProperty<?> column, String inValue)
default Children	gtSql(kotlin.reflect.KProperty<?> column, String inValue)
Children	having(boolean condition, String sqlHaving, Object... params)	HAVING ( sql语句 )
default Children	having(String sqlHaving, Object... params)
Children	in(boolean condition, String alias, kotlin.reflect.KProperty<?> column, Object... values)	字段 IN (v0, v1, ...)
Children	in(boolean condition, String alias, kotlin.reflect.KProperty<?> column, Collection<?> coll)	字段 IN (value.get(0), value.get(1), ...)
default Children	in(boolean condition, kotlin.reflect.KProperty<?> column, Object... values)
default Children	in(boolean condition, kotlin.reflect.KProperty<?> column, Collection<?> coll)
default Children	in(String alias, kotlin.reflect.KProperty<?> column, Object... values)
default Children	in(String alias, kotlin.reflect.KProperty<?> column, Collection<?> coll)
default Children	in(kotlin.reflect.KProperty<?> column, Object... values)
default Children	in(kotlin.reflect.KProperty<?> column, Collection<?> coll)
Children	inSql(boolean condition, String alias, kotlin.reflect.KProperty<?> column, String inValue)	字段 IN ( sql语句 )
default Children	inSql(boolean condition, kotlin.reflect.KProperty<?> column, String inValue)
default Children	inSql(String alias, kotlin.reflect.KProperty<?> column, String inValue)
default Children	inSql(kotlin.reflect.KProperty<?> column, String inValue)
Children	isNotNull(boolean condition, String alias, kotlin.reflect.KProperty<?> column)	字段 IS NOT NULL
default Children	isNotNull(boolean condition, kotlin.reflect.KProperty<?> column)
default Children	isNotNull(String alias, kotlin.reflect.KProperty<?> column)
default Children	isNotNull(kotlin.reflect.KProperty<?> column)
Children	isNull(boolean condition, String alias, kotlin.reflect.KProperty<?> column)	字段 IS NULL
default Children	isNull(boolean condition, kotlin.reflect.KProperty<?> column)
default Children	isNull(String alias, kotlin.reflect.KProperty<?> column)
default Children	isNull(kotlin.reflect.KProperty<?> column)
Children	leSql(boolean condition, String alias, kotlin.reflect.KProperty<?> column, String inValue)	字段 <= ( sql语句 )
default Children	leSql(boolean condition, kotlin.reflect.KProperty<?> column, String inValue)
default Children	leSql(String alias, kotlin.reflect.KProperty<?> column, String inValue)
default Children	leSql(kotlin.reflect.KProperty<?> column, String inValue)
Children	ltSql(boolean condition, String alias, kotlin.reflect.KProperty<?> column, String inValue)	字段 < ( sql语句 )
default Children	ltSql(boolean condition, kotlin.reflect.KProperty<?> column, String inValue)
default Children	ltSql(String alias, kotlin.reflect.KProperty<?> column, String inValue)
default Children	ltSql(kotlin.reflect.KProperty<?> column, String inValue)
Children	notIn(boolean condition, String alias, kotlin.reflect.KProperty<?> column, Object... values)	字段 NOT IN (v0, v1, ...)
Children	notIn(boolean condition, String alias, kotlin.reflect.KProperty<?> column, Collection<?> coll)	字段 NOT IN (value.get(0), value.get(1), ...)
default Children	notIn(boolean condition, kotlin.reflect.KProperty<?> column, Object... values)
default Children	notIn(boolean condition, kotlin.reflect.KProperty<?> column, Collection<?> coll)
default Children	notIn(String alias, kotlin.reflect.KProperty<?> column, Object... value)
default Children	notIn(String alias, kotlin.reflect.KProperty<?> column, Collection<?> coll)
default Children	notIn(kotlin.reflect.KProperty<?> column, Object... value)
default Children	notIn(kotlin.reflect.KProperty<?> column, Collection<?> coll)
Children	notInSql(boolean condition, String alias, kotlin.reflect.KProperty<?> column, String inValue)	字段 NOT IN ( sql语句 )
default Children	notInSql(boolean condition, kotlin.reflect.KProperty<?> column, String inValue)
default Children	notInSql(String alias, kotlin.reflect.KProperty<?> column, String inValue)
default Children	notInSql(kotlin.reflect.KProperty<?> column, String inValue)
Children	orderBy(boolean condition, boolean isAsc, String alias, kotlin.reflect.KProperty<?>... columns)	排序：ORDER BY 字段, ...
default Children	orderBy(boolean condition, boolean isAsc, kotlin.reflect.KProperty<?>... columns)
Children	orderByAsc(boolean condition, String alias, List<kotlin.reflect.KProperty<?>> columns)
default Children	orderByAsc(boolean condition, String alias, kotlin.reflect.KProperty<?>... columns)
default Children	orderByAsc(boolean condition, List<kotlin.reflect.KProperty<?>> columns)
default Children	orderByAsc(boolean condition, kotlin.reflect.KProperty<?>... columns)	排序：ORDER BY 字段, ...
default Children	orderByAsc(String alias, List<kotlin.reflect.KProperty<?>> columns)
default Children	orderByAsc(String alias, kotlin.reflect.KProperty<?> column)
default Children	orderByAsc(String alias, kotlin.reflect.KProperty<?>... columns)
default Children	orderByAsc(List<kotlin.reflect.KProperty<?>> columns)
default Children	orderByAsc(kotlin.reflect.KProperty<?> column)
default Children	orderByAsc(kotlin.reflect.KProperty<?>... columns)
Children	orderByDesc(boolean condition, String alias, List<kotlin.reflect.KProperty<?>> columns)
default Children	orderByDesc(boolean condition, String alias, kotlin.reflect.KProperty<?>... columns)
default Children	orderByDesc(boolean condition, List<kotlin.reflect.KProperty<?>> columns)
default Children	orderByDesc(boolean condition, kotlin.reflect.KProperty<?>... columns)	排序：ORDER BY 字段, ...
default Children	orderByDesc(String alias, List<kotlin.reflect.KProperty<?>> columns)
default Children	orderByDesc(String alias, kotlin.reflect.KProperty<?>... columns)
default Children	orderByDesc(List<kotlin.reflect.KProperty<?>> columns)
default Children	orderByDesc(kotlin.reflect.KProperty<?>... columns)

Method Details

isNull

default Children isNull(kotlin.reflect.KProperty<?> column)

isNull

default Children isNull(String alias,
 kotlin.reflect.KProperty<?> column)

isNull

default Children isNull(boolean condition,
 kotlin.reflect.KProperty<?> column)

isNull

Children isNull(boolean condition,
 String alias,
 kotlin.reflect.KProperty<?> column)

字段 IS NULL

例: isNull("name")

Parameters:

condition - 执行条件

column - 字段

Returns:

children

isNotNull

default Children isNotNull(kotlin.reflect.KProperty<?> column)

isNotNull

default Children isNotNull(String alias,
 kotlin.reflect.KProperty<?> column)

isNotNull

default Children isNotNull(boolean condition,
 kotlin.reflect.KProperty<?> column)

isNotNull

Children isNotNull(boolean condition,
 String alias,
 kotlin.reflect.KProperty<?> column)

字段 IS NOT NULL

例: isNotNull("name")

Parameters:

condition - 执行条件

column - 字段

Returns:

children

in

default Children in(kotlin.reflect.KProperty<?> column,
 Collection<?> coll)

in

default Children in(String alias,
 kotlin.reflect.KProperty<?> column,
 Collection<?> coll)

in

default Children in(boolean condition,
 kotlin.reflect.KProperty<?> column,
 Collection<?> coll)

in

Children in(boolean condition,
 String alias,
 kotlin.reflect.KProperty<?> column,
 Collection<?> coll)

字段 IN (value.get(0), value.get(1), ...)

例: in("id", Arrays.asList(1, 2, 3, 4, 5))

注意！集合为空若存在逻辑错误，请在 condition 条件中判断

如果集合为 empty 则不会进行 sql 拼接

Parameters:

condition - 执行条件

column - 字段

coll - 数据集合

Returns:

children

in

default Children in(kotlin.reflect.KProperty<?> column,
 Object... values)

in

default Children in(String alias,
 kotlin.reflect.KProperty<?> column,
 Object... values)

in

default Children in(boolean condition,
 kotlin.reflect.KProperty<?> column,
 Object... values)

in

Children in(boolean condition,
 String alias,
 kotlin.reflect.KProperty<?> column,
 Object... values)

字段 IN (v0, v1, ...)

例: in("id", 1, 2, 3, 4, 5)

注意！数组为空若存在逻辑错误，请在 condition 条件中判断

如果动态数组为 empty 则不会进行 sql 拼接

Parameters:

condition - 执行条件

column - 字段

values - 数据数组

Returns:

children

notIn

default Children notIn(kotlin.reflect.KProperty<?> column,
 Collection<?> coll)

notIn

default Children notIn(String alias,
 kotlin.reflect.KProperty<?> column,
 Collection<?> coll)

notIn

default Children notIn(boolean condition,
 kotlin.reflect.KProperty<?> column,
 Collection<?> coll)

notIn

Children notIn(boolean condition,
 String alias,
 kotlin.reflect.KProperty<?> column,
 Collection<?> coll)

字段 NOT IN (value.get(0), value.get(1), ...)

例: notIn("id", Arrays.asList(1, 2, 3, 4, 5))

Parameters:

condition - 执行条件

column - 字段

coll - 数据集合

Returns:

children

notIn

default Children notIn(kotlin.reflect.KProperty<?> column,
 Object... value)

notIn

default Children notIn(String alias,
 kotlin.reflect.KProperty<?> column,
 Object... value)

notIn

default Children notIn(boolean condition,
 kotlin.reflect.KProperty<?> column,
 Object... values)

notIn

Children notIn(boolean condition,
 String alias,
 kotlin.reflect.KProperty<?> column,
 Object... values)

字段 NOT IN (v0, v1, ...)

例: notIn("id", 1, 2, 3, 4, 5)

Parameters:

condition - 执行条件

column - 字段

values - 数据数组

Returns:

children

inSql

default Children inSql(kotlin.reflect.KProperty<?> column,
 String inValue)

inSql

default Children inSql(String alias,
 kotlin.reflect.KProperty<?> column,
 String inValue)

inSql

default Children inSql(boolean condition,
 kotlin.reflect.KProperty<?> column,
 String inValue)

inSql

Children inSql(boolean condition,
 String alias,
 kotlin.reflect.KProperty<?> column,
 String inValue)

字段 IN ( sql语句 )

!! sql 注入方式的 in 方法 !!

例1: inSql("id", "1, 2, 3, 4, 5, 6")

例2: inSql("id", "select id from table where id < 3")

Parameters:

condition - 执行条件

column - 字段

inValue - sql语句

Returns:

children

notInSql

default Children notInSql(kotlin.reflect.KProperty<?> column,
 String inValue)

notInSql

default Children notInSql(String alias,
 kotlin.reflect.KProperty<?> column,
 String inValue)

notInSql

default Children notInSql(boolean condition,
 kotlin.reflect.KProperty<?> column,
 String inValue)

notInSql

Children notInSql(boolean condition,
 String alias,
 kotlin.reflect.KProperty<?> column,
 String inValue)

字段 NOT IN ( sql语句 )

!! sql 注入方式的 not in 方法 !!

例1: notInSql("id", "1, 2, 3, 4, 5, 6")

例2: notInSql("id", "select id from table where id < 3")

Parameters:

condition - 执行条件

column - 字段

inValue - sql语句 ---> 1,2,3,4,5,6 或者 select id from table where id < 3

Returns:

children

gtSql

default Children gtSql(kotlin.reflect.KProperty<?> column,
 String inValue)

gtSql

default Children gtSql(String alias,
 kotlin.reflect.KProperty<?> column,
 String inValue)

gtSql

default Children gtSql(boolean condition,
 kotlin.reflect.KProperty<?> column,
 String inValue)

gtSql

Children gtSql(boolean condition,
 String alias,
 kotlin.reflect.KProperty<?> column,
 String inValue)

字段 > ( sql语句 )

例1: gtSql("id", "1, 2, 3, 4, 5, 6")

例1: gtSql("id", "select id from table where name = 'JunJun'")

Parameters:

condition - 执行条件

column - 字段

inValue - sql语句

Returns:

children

geSql

default Children geSql(kotlin.reflect.KProperty<?> column,
 String inValue)

geSql

default Children geSql(String alias,
 kotlin.reflect.KProperty<?> column,
 String inValue)

geSql

default Children geSql(boolean condition,
 kotlin.reflect.KProperty<?> column,
 String inValue)

geSql

Children geSql(boolean condition,
 String alias,
 kotlin.reflect.KProperty<?> column,
 String inValue)

字段 >= ( sql语句 )

例1: geSql("id", "1, 2, 3, 4, 5, 6")

例1: geSql("id", "select id from table where name = 'JunJun'")

Parameters:

condition - 执行条件

column - 字段

inValue - sql语句

Returns:

children

ltSql

default Children ltSql(kotlin.reflect.KProperty<?> column,
 String inValue)

ltSql

default Children ltSql(String alias,
 kotlin.reflect.KProperty<?> column,
 String inValue)

ltSql

default Children ltSql(boolean condition,
 kotlin.reflect.KProperty<?> column,
 String inValue)

ltSql

Children ltSql(boolean condition,
 String alias,
 kotlin.reflect.KProperty<?> column,
 String inValue)

字段 < ( sql语句 )

例1: ltSql("id", "1, 2, 3, 4, 5, 6")

例1: ltSql("id", "select id from table where name = 'JunJun'")

Parameters:

condition - 执行条件

column - 字段

inValue - sql语句

Returns:

children

leSql

default Children leSql(kotlin.reflect.KProperty<?> column,
 String inValue)

leSql

default Children leSql(String alias,
 kotlin.reflect.KProperty<?> column,
 String inValue)

leSql

default Children leSql(boolean condition,
 kotlin.reflect.KProperty<?> column,
 String inValue)

leSql

Children leSql(boolean condition,
 String alias,
 kotlin.reflect.KProperty<?> column,
 String inValue)

字段 <= ( sql语句 )

例1: leSql("id", "1, 2, 3, 4, 5, 6")

例1: leSql("id", "select id from table where name = 'JunJun'")

Parameters:

condition - 执行条件

column - 字段

inValue - sql语句

Returns:

children

groupBy

default Children groupBy(List<kotlin.reflect.KProperty<?>> column)

groupBy

default Children groupBy(String alias,
 List<kotlin.reflect.KProperty<?>> column)

groupBy

default Children groupBy(boolean condition,
 List<kotlin.reflect.KProperty<?>> columns)

groupBy

Children groupBy(boolean condition,
 String alias,
 List<kotlin.reflect.KProperty<?>> columns)

groupBy

default Children groupBy(kotlin.reflect.KProperty<?>... columns)

groupBy

default Children groupBy(String alias,
 kotlin.reflect.KProperty<?>... columns)

groupBy

default Children groupBy(boolean condition,
 kotlin.reflect.KProperty<?>... columns)

groupBy

Children groupBy(boolean condition,
 String alias,
 kotlin.reflect.KProperty<?>... columns)

分组：GROUP BY 字段, ...

例: groupBy("id", "name")

Parameters:

condition - 执行条件

columns - 字段数组

Returns:

children

orderByAsc

default Children orderByAsc(kotlin.reflect.KProperty<?> column)

orderByAsc

default Children orderByAsc(String alias,
 kotlin.reflect.KProperty<?> column)

orderByAsc

default Children orderByAsc(List<kotlin.reflect.KProperty<?>> columns)

orderByAsc

default Children orderByAsc(String alias,
 List<kotlin.reflect.KProperty<?>> columns)

orderByAsc

default Children orderByAsc(boolean condition,
 List<kotlin.reflect.KProperty<?>> columns)

orderByAsc

Children orderByAsc(boolean condition,
 String alias,
 List<kotlin.reflect.KProperty<?>> columns)

orderByAsc

default Children orderByAsc(kotlin.reflect.KProperty<?>... columns)

orderByAsc

default Children orderByAsc(String alias,
 kotlin.reflect.KProperty<?>... columns)

orderByAsc

default Children orderByAsc(boolean condition,
 kotlin.reflect.KProperty<?>... columns)

排序：ORDER BY 字段, ... ASC

例: orderByAsc("id", "name")

Parameters:

condition - 执行条件

columns - 字段数组

Returns:

children

orderByAsc

default Children orderByAsc(boolean condition,
 String alias,
 kotlin.reflect.KProperty<?>... columns)

orderByDesc

default Children orderByDesc(List<kotlin.reflect.KProperty<?>> columns)

orderByDesc

default Children orderByDesc(String alias,
 List<kotlin.reflect.KProperty<?>> columns)

orderByDesc

default Children orderByDesc(boolean condition,
 List<kotlin.reflect.KProperty<?>> columns)

orderByDesc

Children orderByDesc(boolean condition,
 String alias,
 List<kotlin.reflect.KProperty<?>> columns)

orderByDesc

default Children orderByDesc(kotlin.reflect.KProperty<?>... columns)

orderByDesc

default Children orderByDesc(String alias,
 kotlin.reflect.KProperty<?>... columns)

orderByDesc

default Children orderByDesc(boolean condition,
 kotlin.reflect.KProperty<?>... columns)

排序：ORDER BY 字段, ... DESC

例: orderByDesc("id", "name")

Parameters:

condition - 执行条件

columns - 字段数组

Returns:

children

orderByDesc

default Children orderByDesc(boolean condition,
 String alias,
 kotlin.reflect.KProperty<?>... columns)

orderBy

default Children orderBy(boolean condition,
 boolean isAsc,
 kotlin.reflect.KProperty<?>... columns)

orderBy

Children orderBy(boolean condition,
 boolean isAsc,
 String alias,
 kotlin.reflect.KProperty<?>... columns)

排序：ORDER BY 字段, ...

例: orderBy(true, "id", "name")

Parameters:

condition - 执行条件

isAsc - 是否是 ASC 排序

columns - 字段数组

Returns:

children

having

default Children having(String sqlHaving,
 Object... params)

having

Children having(boolean condition,
 String sqlHaving,
 Object... params)

HAVING ( sql语句 )

例1: having("sum(age) > 10")

例2: having("sum(age) > {0}", 10)

Parameters:

condition - 执行条件

sqlHaving - sql 语句

params - 参数数组

Returns:

children

func

default Children func(Consumer<Children> consumer)

func

default Children func(boolean condition,
 Consumer<Children> consumer)

消费函数

Parameters:

consumer - 消费函数

Returns:

children

Since:

3.3.1

func

Children func(boolean condition,
 Consumer<Children> consumer,
 Consumer<Children> consumerElse)