Interface Func<Children>

All Superinterfaces:
FuncWrapper<Children>, Serializable
All Known Implementing Classes:
DeleteJoinWrapper, JoinAbstractLambdaWrapper, JoinAbstractWrapper, MPJLambdaWrapper, UpdateJoinWrapper

public interface Func<Children> extends FuncWrapper<Children>
将原来的泛型R改成SFunction<R, ?>

copy Func

  • Method Summary

    Modifier and Type
    Method
    Description
    default <R> Children
    eqSql(boolean condition, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, String inValue)
     
    eqSql(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, String inValue)
    字段 <= ( sql语句 )
    default <R> Children
    eqSql(com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, String inValue)
     
    default <R> Children
    eqSql(String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, String inValue)
     
    default Children
    func(boolean condition, Consumer<Children> consumer)
    消费函数
    func(boolean condition, Consumer<Children> consumer, Consumer<Children> consumerElse)
     
    default Children
    func(Consumer<Children> consumer)
     
    default <R> Children
    geSql(boolean condition, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, String inValue)
     
    geSql(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, String inValue)
    字段 >= ( sql语句 )
    default <R> Children
    geSql(com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, String inValue)
     
    default <R> Children
    geSql(String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, String inValue)
     
    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(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(boolean condition, String alias, List<com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?>> columns)
     
    default <R> Children
    groupBy(boolean condition, List<com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?>> columns)
     
    default <R> Children
    groupBy(com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column)
     
    default <R> Children
    groupBy(com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?>... columns)
     
    default <R> Children
    groupBy(String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column)
     
    default <R> Children
    groupBy(String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?>... columns)
     
    default <R> Children
    groupBy(String alias, List<com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?>> column)
     
    default <R> Children
    groupBy(List<com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?>> column)
     
    default <R> Children
    gtSql(boolean condition, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, String inValue)
     
    gtSql(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, String inValue)
    字段 > ( sql语句 )
    default <R> Children
    gtSql(com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, String inValue)
     
    default <R> Children
    gtSql(String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, String inValue)
     
    having(boolean condition, String sqlHaving, Object... params)
    HAVING ( sql语句 )
    default Children
    having(String sqlHaving, Object... params)
     
    default <R> Children
    in(boolean condition, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, Object... values)
     
    default <R> Children
    in(boolean condition, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, Collection<?> coll)
     
    in(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, Object... values)
    字段 IN (v0, v1, ...)
    in(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, Collection<?> coll)
    字段 IN (value.get(0), value.get(1), ...)
    default <R> Children
    in(com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, Object... values)
     
    default <R> Children
    in(com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, Collection<?> coll)
     
    default <R> Children
    in(String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, Object... values)
     
    default <R> Children
    in(String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, Collection<?> coll)
     
    default <R> Children
    inSql(boolean condition, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, String inValue)
     
    inSql(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, String inValue)
    字段 IN ( sql语句 )
    default <R> Children
    inSql(com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, String inValue)
     
    default <R> Children
    inSql(String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, String inValue)
     
    default <R> Children
    isNotNull(boolean condition, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column)
     
    isNotNull(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column)
    字段 IS NOT NULL
    default <R> Children
    isNotNull(com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column)
     
    default <R> Children
    isNotNull(String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column)
     
    default <R> Children
    isNull(boolean condition, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column)
     
    isNull(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column)
    字段 IS NULL
    default <R> Children
    isNull(com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column)
     
    default <R> Children
    isNull(String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column)
     
    default <R> Children
    leSql(boolean condition, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, String inValue)
     
    leSql(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, String inValue)
    字段 <= ( sql语句 )
    default <R> Children
    leSql(com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, String inValue)
     
    default <R> Children
    leSql(String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, String inValue)
     
    default <R> Children
    ltSql(boolean condition, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, String inValue)
     
    ltSql(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, String inValue)
    字段 < ( sql语句 )
    default <R> Children
    ltSql(com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, String inValue)
     
    default <R> Children
    ltSql(String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, String inValue)
     
    default <R> Children
    notIn(boolean condition, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, Object... values)
     
    default <R> Children
    notIn(boolean condition, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, Collection<?> coll)
     
    notIn(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, Object... values)
    字段 NOT IN (v0, v1, ...)
    notIn(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> Children
    notIn(com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, Object... values)
     
    default <R> Children
    notIn(com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, Collection<?> coll)
     
    default <R> Children
    notIn(String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, Object... values)
     
    default <R> Children
    notIn(String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, Collection<?> coll)
     
    default <R> Children
    notInSql(boolean condition, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, String inValue)
     
    notInSql(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, String inValue)
    字段 NOT IN ( sql语句 )
    default <R> Children
    notInSql(com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, String inValue)
     
    default <R> Children
    notInSql(String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, String inValue)
     
    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(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> Children
    orderByAsc(boolean condition, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?>... columns)
    排序:ORDER BY 字段, ...
    default <R> Children
    orderByAsc(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?>... columns)
     
    orderByAsc(boolean condition, String alias, List<com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?>> columns)
     
    default <R> Children
    orderByAsc(boolean condition, List<com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?>> columns)
     
    default <R> Children
    orderByAsc(com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column)
     
    default <R> Children
    orderByAsc(com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?>... columns)
     
    default <R> Children
    orderByAsc(String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column)
     
    default <R> Children
    orderByAsc(String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?>... columns)
     
    default <R> Children
    orderByAsc(String alias, List<com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?>> columns)
     
    default <R> Children
    orderByAsc(List<com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?>> columns)
     
    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 字段, ...
    default <R> Children
    orderByDesc(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?>... columns)
     
    orderByDesc(boolean condition, String alias, List<com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?>> columns)
     
    default <R> Children
    orderByDesc(boolean condition, List<com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?>> columns)
     
    default <R> Children
    orderByDesc(com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column)
     
    default <R> Children
    orderByDesc(com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?>... columns)
     
    default <R> Children
    orderByDesc(String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column)
     
    default <R> Children
    orderByDesc(String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?>... columns)
     
    default <R> Children
    orderByDesc(String alias, List<com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?>> columns)
     
    default <R> Children
    orderByDesc(List<com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?>> columns)
     

    Methods inherited from interface com.github.yulichang.wrapper.interfaces.FuncWrapper

    exists, exists, in, in, in, in, isNotNull, isNotNull, isNotNull, isNotNull, isNull, isNull, isNull, isNull, notExists, notExists, notIn, notIn, notIn, notIn
  • Method Details

    • isNull

      default <R> Children isNull(com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column)
    • isNull

      default <R> Children isNull(String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column)
    • 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

      default <R> Children isNotNull(com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column)
    • isNotNull

      default <R> Children isNotNull(String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column)
    • 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

      default <R> Children in(com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, Object... values)
    • in

      default <R> Children in(String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, Object... values)
    • in

      default <R> Children in(boolean condition, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, Object... values)
    • 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

      default <R> Children notIn(com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, Object... values)
    • notIn

      default <R> Children notIn(String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, Object... values)
    • notIn

      default <R> Children notIn(boolean condition, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, Object... values)
    • 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

      default <R> Children inSql(com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, String inValue)
    • inSql

      default <R> Children inSql(String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, String inValue)
    • inSql

      default <R> Children inSql(boolean condition, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, String inValue)
    • 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

      default <R> Children notInSql(com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, String inValue)
    • notInSql

      default <R> Children notInSql(String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, String inValue)
    • notInSql

      default <R> Children notInSql(boolean condition, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, String inValue)
    • 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

      default <R> Children gtSql(com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, String inValue)
    • gtSql

      default <R> Children gtSql(String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, String inValue)
    • gtSql

      default <R> Children gtSql(boolean condition, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, String inValue)
    • 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

      default <R> Children geSql(com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, String inValue)
    • geSql

      default <R> Children geSql(String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, String inValue)
    • geSql

      default <R> Children geSql(boolean condition, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, String inValue)
    • 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

      default <R> Children ltSql(com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, String inValue)
    • ltSql

      default <R> Children ltSql(String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, String inValue)
    • ltSql

      default <R> Children ltSql(boolean condition, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, String inValue)
    • 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

      default <R> Children leSql(com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, String inValue)
    • leSql

      default <R> Children leSql(String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, String inValue)
    • leSql

      default <R> Children leSql(boolean condition, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, String inValue)
    • 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

      default <R> Children eqSql(com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, String inValue)
    • eqSql

      default <R> Children eqSql(String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, String inValue)
    • eqSql

      default <R> Children eqSql(boolean condition, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, String inValue)
    • 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

      default <R> Children groupBy(com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column)
    • groupBy

      default <R> Children groupBy(String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column)
    • groupBy

      default <R> Children groupBy(List<com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?>> column)
    • groupBy

      default <R> Children groupBy(String alias, List<com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?>> column)
    • groupBy

      default <R> Children groupBy(boolean condition, List<com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?>> columns)
    • groupBy

      <R> Children groupBy(boolean condition, String alias, List<com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?>> columns)
    • groupBy

      default <R> Children groupBy(com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?>... columns)
    • groupBy

      default <R> Children groupBy(String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?>... columns)
    • 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

      default <R> Children orderByAsc(String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column)
    • orderByAsc

      default <R> Children orderByAsc(List<com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?>> columns)
    • orderByAsc

      default <R> Children orderByAsc(String alias, List<com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?>> columns)
    • orderByAsc

      default <R> Children orderByAsc(boolean condition, List<com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?>> columns)
    • orderByAsc

      <R> Children orderByAsc(boolean condition, String alias, List<com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?>> columns)
    • orderByAsc

      default <R> Children orderByAsc(com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?>... columns)
    • orderByAsc

      default <R> Children orderByAsc(String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?>... columns)
    • orderByAsc

      default <R> Children orderByAsc(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?>... columns)
    • 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

      default <R> Children orderByDesc(String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column)
    • orderByDesc

      default <R> Children orderByDesc(List<com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?>> columns)
    • orderByDesc

      default <R> Children orderByDesc(String alias, List<com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?>> columns)
    • orderByDesc

      default <R> Children orderByDesc(boolean condition, List<com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?>> columns)
    • orderByDesc

      <R> Children orderByDesc(boolean condition, String alias, List<com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?>> columns)
    • orderByDesc

      default <R> Children orderByDesc(com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?>... columns)
    • orderByDesc

      default <R> Children orderByDesc(String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?>... columns)
    • orderByDesc

      default <R> Children orderByDesc(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R,?>... columns)
    • 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

      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)