Package com.github.yulichang.wrapper.interfaces

Interface FuncStr<Children,R>

All Superinterfaces:

Serializable

All Known Implementing Classes:

AptAbstractWrapper, AptQueryWrapper, DeleteJoinWrapper, JoinAbstractLambdaWrapper, JoinAbstractWrapper, JoinAbstractWrapper, KtAbstractLambdaWrapper, KtAbstractWrapper, KtDeleteJoinWrapper, KtLambdaWrapper, KtUpdateJoinWrapper, MPJLambdaWrapper, UpdateJoinWrapper

public interface FuncStr<Children,R>
extends Serializable

copy Func

Since:

1.3.12

Method Summary

Modifier and Type	Method	Description
Children	eqSql(boolean condition, R column, String inValue)	字段 = ( sql语句 )
default Children	eqSql(R column, String inValue)	ignore
Children	geSql(boolean condition, R column, String inValue)	字段 >= ( sql语句 )
default Children	geSql(R column, String inValue)	ignore
Children	groupBy(boolean condition, R column)	分组：GROUP BY 字段, ...
Children	groupBy(boolean condition, R column, R... columns)	分组：GROUP BY 字段, ...
default Children	groupBy(R column)
default Children	groupBy(R column, R... columns)
Children	groupByStr(boolean condition, List<R> columns)	分组：GROUP BY 字段, ...
default Children	groupByStr(List<R> columns)
Children	gtSql(boolean condition, R column, String inValue)	字段 > ( sql语句 )
default Children	gtSql(R column, String inValue)	ignore
Children	in(boolean condition, R column, Object... values)	字段 IN (v0, v1, ...)
Children	in(boolean condition, R column, Collection<?> coll)	字段 IN (value.get(0), value.get(1), ...)
default Children	in(R column, Object... values)	ignore
default Children	in(R column, Collection<?> coll)	ignore
Children	inSql(boolean condition, R column, String inValue)	字段 IN ( sql语句 )
default Children	inSql(R column, String inValue)	ignore
Children	isNotNull(boolean condition, R column)	字段 IS NOT NULL
default Children	isNotNull(R column)	ignore
Children	isNull(boolean condition, R column)	字段 IS NULL
default Children	isNull(R column)	ignore
Children	leSql(boolean condition, R column, String inValue)	字段 <= ( sql语句 )
default Children	leSql(R column, String inValue)	ignore
Children	ltSql(boolean condition, R column, String inValue)	字段 < ( sql语句 )
default Children	ltSql(R column, String inValue)	ignore
Children	notIn(boolean condition, R column, Object... values)	字段 NOT IN (v0, v1, ...)
Children	notIn(boolean condition, R column, Collection<?> coll)	字段 NOT IN (value.get(0), value.get(1), ...)
default Children	notIn(R column, Object... value)	ignore
default Children	notIn(R column, Collection<?> coll)	ignore
Children	notInSql(boolean condition, R column, String inValue)	字段 NOT IN ( sql语句 )
default Children	notInSql(R column, String inValue)	ignore
Children	orderBy(boolean condition, boolean isAsc, R column)	排序：ORDER BY 字段, ...
Children	orderBy(boolean condition, boolean isAsc, R column, R... columns)	排序：ORDER BY 字段, ...
default Children	orderByAsc(boolean condition, R column)	排序：ORDER BY 字段, ...
default Children	orderByAsc(boolean condition, R column, R... columns)	排序：ORDER BY 字段, ...
default Children	orderByAsc(R column)
default Children	orderByAsc(R column, R... columns)
default Children	orderByAscStr(boolean condition, List<R> columns)	排序：ORDER BY 字段, ...
default Children	orderByAscStr(List<R> columns)
default Children	orderByDesc(boolean condition, R column)	排序：ORDER BY 字段, ...
default Children	orderByDesc(boolean condition, R column, R... columns)	排序：ORDER BY 字段, ...
default Children	orderByDesc(R column)
default Children	orderByDesc(R column, R... columns)
default Children	orderByDescStr(boolean condition, List<R> columns)	排序：ORDER BY 字段, ...
default Children	orderByDescStr(List<R> columns)
Children	orderByStr(boolean condition, boolean isAsc, List<R> columns)	排序：ORDER BY 字段, ...

Method Details

isNull

default Children isNull(R column)

ignore

isNull

Children isNull(boolean condition,
 R column)

字段 IS NULL

例: isNull("name")

Parameters:

condition - 执行条件

column - 字段

Returns:

children

isNotNull

default Children isNotNull(R column)

ignore

isNotNull

Children isNotNull(boolean condition,
 R column)

字段 IS NOT NULL

例: isNotNull("name")

Parameters:

condition - 执行条件

column - 字段

Returns:

children

in

default Children in(R column,
 Collection<?> coll)

ignore

in

Children in(boolean condition,
 R 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(R column,
 Object... values)

ignore

in

Children in(boolean condition,
 R 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(R column,
 Collection<?> coll)

ignore

notIn

Children notIn(boolean condition,
 R 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(R column,
 Object... value)

ignore

notIn

Children notIn(boolean condition,
 R column,
 Object... values)

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

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

Parameters:

condition - 执行条件

column - 字段

values - 数据数组

Returns:

children

inSql

default Children inSql(R column,
 String inValue)

ignore

inSql

Children inSql(boolean condition,
 R 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

gtSql

Children gtSql(boolean condition,
 R 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

gtSql

default Children gtSql(R column,
 String inValue)

ignore

geSql

Children geSql(boolean condition,
 R 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

geSql

default Children geSql(R column,
 String inValue)

ignore

ltSql

Children ltSql(boolean condition,
 R 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

ltSql

default Children ltSql(R column,
 String inValue)

ignore

leSql

Children leSql(boolean condition,
 R 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

eqSql

default Children eqSql(R column,
 String inValue)

ignore

eqSql

Children eqSql(boolean condition,
 R column,
 String inValue)

字段 = ( sql语句 )

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

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

Parameters:

condition - 执行条件

column - 字段

inValue - sql语句

Returns:

children

leSql

default Children leSql(R column,
 String inValue)

ignore

notInSql

default Children notInSql(R column,
 String inValue)

ignore

notInSql

Children notInSql(boolean condition,
 R 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

groupBy

Children groupBy(boolean condition,
 R column)

分组：GROUP BY 字段, ...

例: groupBy("id")

Parameters:

condition - 执行条件

column - 单个字段

Returns:

children

groupBy

default Children groupBy(R column)

groupByStr

Children groupByStr(boolean condition,
 List<R> columns)

分组：GROUP BY 字段, ...

例: groupBy(Arrays.asList("id", "name"))

Parameters:

condition - 执行条件

columns - 字段数组

Returns:

children

groupByStr

default Children groupByStr(List<R> columns)

groupBy

default Children groupBy(R column,
 R... columns)

groupBy

Children groupBy(boolean condition,
 R column,
 R... columns)

分组：GROUP BY 字段, ...

orderByAsc

default Children orderByAsc(boolean condition,
 R column)

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

例: orderByAsc(true, "id")

Parameters:

condition - 执行条件

column - 单个字段

Returns:

children

orderByAsc

default Children orderByAsc(R column)

orderByAscStr

default Children orderByAscStr(boolean condition,
 List<R> columns)

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

例: orderByAsc(true, Arrays.asList("id", "name"))

Parameters:

condition - 执行条件

columns - 字段数组

Returns:

children

orderByAscStr

default Children orderByAscStr(List<R> columns)

orderByAsc

default Children orderByAsc(R column,
 R... columns)

orderByAsc

default Children orderByAsc(boolean condition,
 R column,
 R... columns)

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

orderByDesc

default Children orderByDesc(boolean condition,
 R column)

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

例: orderByDesc(true, "id")

Parameters:

condition - 执行条件

column - 字段

Returns:

children

orderByDesc

default Children orderByDesc(R column)

orderByDescStr

default Children orderByDescStr(boolean condition,
 List<R> columns)

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

例: orderByDesc(true, Arrays.asList("id", "name"))

Parameters:

condition - 执行条件

columns - 字段列表

Returns:

children

orderByDescStr

default Children orderByDescStr(List<R> columns)

orderByDesc

default Children orderByDesc(R column,
 R... columns)

orderByDesc

default Children orderByDesc(boolean condition,
 R column,
 R... columns)

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

orderBy

Children orderBy(boolean condition,
 boolean isAsc,
 R column)

排序：ORDER BY 字段, ...

例: orderBy(true, "id")

Parameters:

condition - 执行条件

isAsc - 是否是 ASC 排序

column - 单个字段

Returns:

children

orderByStr

Children orderByStr(boolean condition,
 boolean isAsc,
 List<R> columns)

排序：ORDER BY 字段, ...

例: orderBy(true, Arrays.asList("id", "name"))

Parameters:

condition - 执行条件

isAsc - 是否是 ASC 排序

columns - 字段列表

Returns:

children

orderBy

Children orderBy(boolean condition,
 boolean isAsc,
 R column,
 R... columns)

排序：ORDER BY 字段, ...