Interface Func<Children>
- All Superinterfaces:
FuncWrapper<Children>,Serializable
- All Known Implementing Classes:
DeleteJoinWrapper,JoinAbstractLambdaWrapper,JoinAbstractWrapper,MPJLambdaWrapper,UpdateJoinWrapper
copy Func
-
Method Summary
Modifier and TypeMethodDescriptiondefault <R> ChildreneqSql(boolean condition, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, String inValue) <R> ChildreneqSql(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, String inValue) 字段 <= ( sql语句 )default <R> Childrendefault <R> ChildreneqSql(String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, String inValue) default Children消费函数default Childrendefault <R> ChildrengeSql(boolean condition, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, String inValue) <R> ChildrengeSql(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, String inValue) 字段 >= ( sql语句 )default <R> Childrendefault <R> ChildrengeSql(String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, String inValue) default <R> ChildrengroupBy(boolean condition, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?>... columns) <R> ChildrengroupBy(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?>... columns) 分组:GROUP BY 字段, ...<R> ChildrengroupBy(boolean condition, String alias, List<com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?>> columns) default <R> ChildrengroupBy(boolean condition, List<com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?>> columns) default <R> ChildrengroupBy(com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column) default <R> ChildrengroupBy(com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?>... columns) default <R> Childrendefault <R> ChildrengroupBy(String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?>... columns) default <R> Childrendefault <R> Childrendefault <R> ChildrengtSql(boolean condition, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, String inValue) <R> ChildrengtSql(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, String inValue) 字段 > ( sql语句 )default <R> Childrendefault <R> ChildrengtSql(String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, String inValue) HAVING ( sql语句 )default Childrendefault <R> Childrenin(boolean condition, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, Object... values) default <R> Childrenin(boolean condition, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, Collection<?> coll) <R> Childrenin(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, Object... values) 字段 IN (v0, v1, ...)<R> Childrenin(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, Collection<?> coll) 字段 IN (value.get(0), value.get(1), ...)default <R> Childrendefault <R> Childrenin(com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, Collection<?> coll) default <R> Childrenin(String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, Object... values) default <R> Childrenin(String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, Collection<?> coll) default <R> ChildreninSql(boolean condition, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, String inValue) <R> ChildreninSql(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, String inValue) 字段 IN ( sql语句 )default <R> Childrendefault <R> ChildreninSql(String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, String inValue) default <R> ChildrenisNotNull(boolean condition, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column) <R> ChildrenisNotNull(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column) 字段 IS NOT NULLdefault <R> ChildrenisNotNull(com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column) default <R> Childrendefault <R> ChildrenisNull(boolean condition, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column) <R> ChildrenisNull(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column) 字段 IS NULLdefault <R> ChildrenisNull(com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column) default <R> Childrendefault <R> ChildrenleSql(boolean condition, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, String inValue) <R> ChildrenleSql(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, String inValue) 字段 <= ( sql语句 )default <R> Childrendefault <R> ChildrenleSql(String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, String inValue) default <R> ChildrenltSql(boolean condition, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, String inValue) <R> ChildrenltSql(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, String inValue) 字段 < ( sql语句 )default <R> Childrendefault <R> ChildrenltSql(String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, String inValue) default <R> ChildrennotIn(boolean condition, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, Object... values) default <R> ChildrennotIn(boolean condition, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, Collection<?> coll) <R> ChildrennotIn(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, Object... values) 字段 NOT IN (v0, v1, ...)<R> ChildrennotIn(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, Collection<?> coll) 字段 NOT IN (value.get(0), value.get(1), ...)default <R> Childrendefault <R> ChildrennotIn(com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, Collection<?> coll) default <R> ChildrennotIn(String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, Object... values) default <R> ChildrennotIn(String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, Collection<?> coll) default <R> ChildrennotInSql(boolean condition, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, String inValue) <R> ChildrennotInSql(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, String inValue) 字段 NOT IN ( sql语句 )default <R> Childrendefault <R> ChildrennotInSql(String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, String inValue) default <R> ChildrenorderBy(boolean condition, boolean isAsc, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?>... columns) <R> ChildrenorderBy(boolean condition, boolean isAsc, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?>... columns) 排序:ORDER BY 字段, ...default <R> ChildrenorderByAsc(boolean condition, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?>... columns) 排序:ORDER BY 字段, ...default <R> ChildrenorderByAsc(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?>... columns) <R> ChildrenorderByAsc(boolean condition, String alias, List<com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?>> columns) default <R> ChildrenorderByAsc(boolean condition, List<com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?>> columns) default <R> ChildrenorderByAsc(com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column) default <R> ChildrenorderByAsc(com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?>... columns) default <R> ChildrenorderByAsc(String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column) default <R> ChildrenorderByAsc(String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?>... columns) default <R> ChildrenorderByAsc(String alias, List<com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?>> columns) default <R> ChildrenorderByAsc(List<com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?>> columns) default <R> ChildrenorderByDesc(boolean condition, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?>... columns) 排序:ORDER BY 字段, ...default <R> ChildrenorderByDesc(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?>... columns) <R> ChildrenorderByDesc(boolean condition, String alias, List<com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?>> columns) default <R> ChildrenorderByDesc(boolean condition, List<com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?>> columns) default <R> ChildrenorderByDesc(com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column) default <R> ChildrenorderByDesc(com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?>... columns) default <R> ChildrenorderByDesc(String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column) default <R> ChildrenorderByDesc(String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?>... columns) default <R> ChildrenorderByDesc(String alias, List<com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?>> columns) default <R> ChildrenorderByDesc(List<com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?>> columns)
-
Method Details
-
isNull
-
isNull
-
isNull
default <R> Children isNull(boolean condition, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column) -
isNull
<R> Children isNull(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column) 字段 IS NULL例: isNull("name")
- Parameters:
condition- 执行条件column- 字段- Returns:
- children
-
isNotNull
-
isNotNull
-
isNotNull
default <R> Children isNotNull(boolean condition, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column) -
isNotNull
<R> Children isNotNull(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column) 字段 IS NOT NULL例: isNotNull("name")
- Parameters:
condition- 执行条件column- 字段- Returns:
- children
-
in
default <R> Children in(com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, Collection<?> coll) -
in
default <R> Children in(String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, Collection<?> coll) -
in
default <R> Children in(boolean condition, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, Collection<?> coll) -
in
<R> Children in(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<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
-
in
-
in
-
in
<R> Children in(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<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 <R> Children notIn(com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, Collection<?> coll) -
notIn
default <R> Children notIn(String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, Collection<?> coll) -
notIn
default <R> Children notIn(boolean condition, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, Collection<?> coll) -
notIn
<R> Children notIn(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<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
-
notIn
-
notIn
-
notIn
<R> Children notIn(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, Object... values) 字段 NOT IN (v0, v1, ...)例: notIn("id", 1, 2, 3, 4, 5)
- Parameters:
condition- 执行条件column- 字段values- 数据数组- Returns:
- children
-
inSql
-
inSql
-
inSql
-
inSql
<R> Children inSql(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<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
-
notInSql
-
notInSql
-
notInSql
-
notInSql
<R> Children notInSql(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<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
-
gtSql
-
gtSql
-
gtSql
-
gtSql
<R> Children gtSql(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<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语句 ---> 1,2,3,4,5,6 或者 select id from table where id < 3- Returns:
- children
-
geSql
-
geSql
-
geSql
-
geSql
<R> Children geSql(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<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语句 ---> 1,2,3,4,5,6 或者 select id from table where id < 3- Returns:
- children
-
ltSql
-
ltSql
-
ltSql
-
ltSql
<R> Children ltSql(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<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语句 ---> 1,2,3,4,5,6 或者 select id from table where id < 3- Returns:
- children
-
leSql
-
leSql
-
leSql
-
leSql
<R> Children leSql(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<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语句 ---> 1,2,3,4,5,6 或者 select id from table where id < 3- Returns:
- children
-
eqSql
-
eqSql
-
eqSql
-
eqSql
<R> Children eqSql(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<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语句 ---> 1,2,3,4,5,6 或者 select id from table where id < 3- Returns:
- children
-
groupBy
-
groupBy
-
groupBy
-
groupBy
-
groupBy
-
groupBy
-
groupBy
default <R> Children groupBy(com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?>... columns) -
groupBy
-
groupBy
default <R> Children groupBy(boolean condition, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?>... columns) -
groupBy
<R> Children groupBy(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?>... columns) 分组:GROUP BY 字段, ...例: groupBy("id", "name")
- Parameters:
condition- 执行条件column- 单个字段columns- 字段数组- Returns:
- children
-
orderByAsc
default <R> Children orderByAsc(com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column) -
orderByAsc
-
orderByAsc
-
orderByAsc
-
orderByAsc
-
orderByAsc
-
orderByAsc
default <R> Children orderByAsc(com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?>... columns) -
orderByAsc
-
orderByAsc
-
orderByAsc
default <R> Children orderByAsc(boolean condition, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?>... columns) 排序:ORDER BY 字段, ... ASC例: orderByAsc("id", "name")
- Parameters:
condition- 执行条件column- 单个字段columns- 字段数组- Returns:
- children
-
orderByDesc
default <R> Children orderByDesc(com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column) -
orderByDesc
-
orderByDesc
-
orderByDesc
-
orderByDesc
-
orderByDesc
-
orderByDesc
default <R> Children orderByDesc(com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?>... columns) -
orderByDesc
-
orderByDesc
-
orderByDesc
default <R> Children orderByDesc(boolean condition, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?>... columns) 排序:ORDER BY 字段, ... DESC例: orderByDesc("id", "name")
- Parameters:
condition- 执行条件column- 单个字段columns- 字段数组- Returns:
- children
-
orderBy
default <R> Children orderBy(boolean condition, boolean isAsc, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?>... columns) -
orderBy
<R> Children orderBy(boolean condition, boolean isAsc, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?>... columns) 排序:ORDER BY 字段, ...例: orderBy(true, "id", "name")
- Parameters:
condition- 执行条件isAsc- 是否是 ASC 排序column- 单个字段columns- 字段数组- Returns:
- children
-
having
-
having
HAVING ( sql语句 )例1: having("sum(age) > 10")
例2: having("sum(age) > {0}", 10)
- Parameters:
condition- 执行条件sqlHaving- sql 语句params- 参数数组- Returns:
- children
-
func
-
func
消费函数- Parameters:
consumer- 消费函数- Returns:
- children
- Since:
- 3.3.1
-
func
-