Package com.github.yulichang.wrapper.interfaces

Interface Query<Children>

All Superinterfaces:
Serializable
All Known Implementing Classes:
MPJLambdaWrapper
public interface Query<Children> extends Serializable
参考 Query
Author:
yulichang

  • Method Summary

    Modifier and Type
    Method
    Description
    String
    getAlias()
     
    Children
    getChildren()
     
    Integer
    getIndex()
     
    List<Select>
    getSelectColum()
     
    String
    getSqlSelect()
    select sql 片段
    boolean
    isHasAlias()
     
    <E> Children
    select(com.baomidou.mybatisplus.core.toolkit.support.SFunction<E,?>... columns)
     
    default <E> Children
    select(Class<E> entityClass, Predicate<com.baomidou.mybatisplus.core.metadata.TableFieldInfo> predicate)
    Deprecated.
    default Children
    select(String... columns)
    String 查询
    default Children
    selectAll(Class<?> clazz)
    查询实体类全部字段
    default Children
    selectAll(Class<?> clazz, String prefix)
    查询实体类全部字段
    default <E> Children
    selectAll(Class<E> clazz, com.baomidou.mybatisplus.core.toolkit.support.SFunction<E,?>... exclude)
    查询实体类全部字段
    default <E> Children
    selectAll(Class<E> clazz, String prefix, com.baomidou.mybatisplus.core.toolkit.support.SFunction<E,?>... exclude)
    查询实体类全部字段
    default <S, X> Children
    selectAs(com.baomidou.mybatisplus.core.toolkit.support.SFunction<S,?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X,?> alias)
    ignore
    default <S> Children
    selectAs(com.baomidou.mybatisplus.core.toolkit.support.SFunction<S,?> column, String alias)
    别名查询
    default <E> Children
    selectAs(String column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<E,?> alias)
    String 查询
    default <E, X> Children
    selectAs(String index, com.baomidou.mybatisplus.core.toolkit.support.SFunction<E,?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X,?> alias)
    String 查询
    default <E> Children
    selectAsClass(Class<E> source, Class<?> tag)
    说明： 比如我们需要查询用户表有10个字段，然而我们只需要3个就够了，用mybatis-plus提供的select
    default <S> Children
    selectAvg(com.baomidou.mybatisplus.core.toolkit.support.SFunction<S,?> column)
    MIN()
    default <S, X> Children
    selectAvg(com.baomidou.mybatisplus.core.toolkit.support.SFunction<S,?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X,?> alias)
     
    default <S> Children
    selectAvg(com.baomidou.mybatisplus.core.toolkit.support.SFunction<S,?> column, String alias)
     
    default <S> Children
    selectCount(com.baomidou.mybatisplus.core.toolkit.support.SFunction<S,?> column)
    COUNT()
    default <S, X> Children
    selectCount(com.baomidou.mybatisplus.core.toolkit.support.SFunction<S,?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X,?> alias)
     
    default <S> Children
    selectCount(com.baomidou.mybatisplus.core.toolkit.support.SFunction<S,?> column, String alias)
     
    default <X> Children
    selectCount(Object column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X,?> alias)
     
    default Children
    selectCount(Object column, String alias)
     
    default <E> Children
    selectFilter(Class<E> entityClass, Predicate<SelectCache> predicate)
    过滤查询的字段信息
    default <S> Children
    selectFunc(BaseFuncEnum funcEnum, com.baomidou.mybatisplus.core.toolkit.support.SFunction<S,?> column)
     
    default <S, X> Children
    selectFunc(BaseFuncEnum funcEnum, com.baomidou.mybatisplus.core.toolkit.support.SFunction<S,?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X,?> alias)
     
    default <S> Children
    selectFunc(BaseFuncEnum funcEnum, com.baomidou.mybatisplus.core.toolkit.support.SFunction<S,?> column, String alias)
     
    default <X> Children
    selectFunc(BaseFuncEnum funcEnum, Object column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X,?> alias)
     
    default Children
    selectFunc(BaseFuncEnum funcEnum, Object column, String alias)
    聚合函数查询
    default <S> Children
    selectFunc(BaseFuncEnum funcEnum, String index, com.baomidou.mybatisplus.core.toolkit.support.SFunction<S,?> column)
     
    default <S, X> Children
    selectFunc(BaseFuncEnum funcEnum, String index, com.baomidou.mybatisplus.core.toolkit.support.SFunction<S,?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X,?> alias)
     
    default <S> Children
    selectFunc(BaseFuncEnum funcEnum, String index, com.baomidou.mybatisplus.core.toolkit.support.SFunction<S,?> column, String alias)
     
    default <S> Children
    selectFunc(String sql, MFunction<FuncConsumer> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<S,?> alias)
     
    Children
    selectFunc(String sql, MFunction<FuncConsumer> column, String alias)
     
    default <S> Children
    selectLen(com.baomidou.mybatisplus.core.toolkit.support.SFunction<S,?> column)
    LEN()
    default <S, X> Children
    selectLen(com.baomidou.mybatisplus.core.toolkit.support.SFunction<S,?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X,?> alias)
     
    default <S> Children
    selectLen(com.baomidou.mybatisplus.core.toolkit.support.SFunction<S,?> column, String alias)
     
    default <S> Children
    selectMax(com.baomidou.mybatisplus.core.toolkit.support.SFunction<S,?> column)
    MAX()
    default <S, X> Children
    selectMax(com.baomidou.mybatisplus.core.toolkit.support.SFunction<S,?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X,?> alias)
     
    default <S> Children
    selectMax(com.baomidou.mybatisplus.core.toolkit.support.SFunction<S,?> column, String alias)
     
    default <S> Children
    selectMin(com.baomidou.mybatisplus.core.toolkit.support.SFunction<S,?> column)
    MIN()
    default <S, X> Children
    selectMin(com.baomidou.mybatisplus.core.toolkit.support.SFunction<S,?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X,?> alias)
     
    default <S> Children
    selectMin(com.baomidou.mybatisplus.core.toolkit.support.SFunction<S,?> column, String alias)
     
    default <S> Children
    selectSum(com.baomidou.mybatisplus.core.toolkit.support.SFunction<S,?> column)
    SUM()
    default <S, X> Children
    selectSum(com.baomidou.mybatisplus.core.toolkit.support.SFunction<S,?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X,?> alias)
     
    default <S> Children
    selectSum(com.baomidou.mybatisplus.core.toolkit.support.SFunction<S,?> column, String alias)
     

  • Method Details

    • getSelectColum

      List<Select> getSelectColum()

    • getChildren

      Children getChildren()

    • getIndex

      Integer getIndex()

    • isHasAlias

      boolean isHasAlias()

    • getAlias

      String getAlias()

    • select

      @Deprecated default <E> Children select(Class<E> entityClass, Predicate<com.baomidou.mybatisplus.core.metadata.TableFieldInfo> predicate)
      Deprecated.
      过滤查询的字段信息(主键除外!) 推荐使用 selectFilter(Class, Predicate) 含主键
      Parameters:
      predicate - 过滤方式
      Returns:
      children
      See Also:

    • selectFilter

      default <E> Children selectFilter(Class<E> entityClass, Predicate<SelectCache> predicate)
      过滤查询的字段信息

      例1: 只要 java 字段名以 "test" 开头的 -> select(i -> i.getProperty().startsWith("test"))

      例2: 只要 java 字段属性是 CharSequence 类型的 -> select(TableFieldInfo::isCharSequence)

      例3: 只要 java 字段没有填充策略的 -> select(i -> i.getFieldFill() == FieldFill.DEFAULT)

      例4: 要全部字段 -> select(i -> true)

      例5: 只要主键字段 -> select(i -> false)

      Parameters:
      predicate - 过滤方式
      Returns:
      children

    • select

      <E> Children select(com.baomidou.mybatisplus.core.toolkit.support.SFunction<E,?>... columns)

    • select

      default Children select(String... columns)
      String 查询
      Parameters:
      columns - 列

    • selectAs

      default <E> Children selectAs(String column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<E,?> alias)
      String 查询
      Parameters:
      column - 列

    • selectAs

      default <E, X> Children selectAs(String index, com.baomidou.mybatisplus.core.toolkit.support.SFunction<E,?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X,?> alias)
      String 查询
      Parameters:
      column - 列

    • selectAsClass

      default <E> Children selectAsClass(Class<E> source, Class<?> tag)
      说明： 比如我们需要查询用户表有10个字段，然而我们只需要3个就够了，用mybatis-plus提供的select

      需要一个属性一个属性填入很不优雅，现在我们可以用selectAsClass(UserDO.class, UserVo.class)

      即可按所需的UserVo返回，前提是UserVo.class中的属性必须是UserDO.class中存在的

      Parameters:
      source - 数据源实体类
      tag - 目标类
      Returns:
      children

    • selectAs

      default <S, X> Children selectAs(com.baomidou.mybatisplus.core.toolkit.support.SFunction<S,?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X,?> alias)
      ignore

    • selectAs

      default <S> Children selectAs(com.baomidou.mybatisplus.core.toolkit.support.SFunction<S,?> column, String alias)
      别名查询

    • selectAll

      default Children selectAll(Class<?> clazz)
      查询实体类全部字段

    • selectAll

      default Children selectAll(Class<?> clazz, String prefix)
      查询实体类全部字段

    • selectAll

      default <E> Children selectAll(Class<E> clazz, com.baomidou.mybatisplus.core.toolkit.support.SFunction<E,?>... exclude)
      查询实体类全部字段
      Parameters:
      clazz - 查询的实体类
      exclude - 排除字段

    • selectAll

      default <E> Children selectAll(Class<E> clazz, String prefix, com.baomidou.mybatisplus.core.toolkit.support.SFunction<E,?>... exclude)
      查询实体类全部字段
      Parameters:
      clazz - 查询的实体类
      exclude - 排除字段

    • getSqlSelect

      String getSqlSelect()
      select sql 片段

    • selectFunc

      default Children selectFunc(BaseFuncEnum funcEnum, Object column, String alias)
      聚合函数查询

      wrapper.selectFunc(() -> "COUNT(%s)", "t.id", "total");

      lambda wrapper.selectFunc(() -> "COUNT(%s)", UserDO::getId, UserDTO::getTotal);

      Parameters:
      funcEnum - 函数枚举 DefaultFuncEnum
      column - 函数作用的字段
      alias - 别名

    • selectFunc

      default <S> Children selectFunc(BaseFuncEnum funcEnum, com.baomidou.mybatisplus.core.toolkit.support.SFunction<S,?> column, String alias)

    • selectFunc

      default <S> Children selectFunc(BaseFuncEnum funcEnum, String index, com.baomidou.mybatisplus.core.toolkit.support.SFunction<S,?> column, String alias)

    • selectFunc

      default <S, X> Children selectFunc(BaseFuncEnum funcEnum, com.baomidou.mybatisplus.core.toolkit.support.SFunction<S,?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X,?> alias)

    • selectFunc

      default <S, X> Children selectFunc(BaseFuncEnum funcEnum, String index, com.baomidou.mybatisplus.core.toolkit.support.SFunction<S,?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X,?> alias)

    • selectFunc

      default <S> Children selectFunc(BaseFuncEnum funcEnum, com.baomidou.mybatisplus.core.toolkit.support.SFunction<S,?> column)

    • selectFunc

      default <S> Children selectFunc(BaseFuncEnum funcEnum, String index, com.baomidou.mybatisplus.core.toolkit.support.SFunction<S,?> column)

    • selectFunc

      default <X> Children selectFunc(BaseFuncEnum funcEnum, Object column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X,?> alias)

    • selectFunc

      Children selectFunc(String sql, MFunction<FuncConsumer> column, String alias)

    • selectFunc

      default <S> Children selectFunc(String sql, MFunction<FuncConsumer> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<S,?> alias)

    • selectSum

      default <S> Children selectSum(com.baomidou.mybatisplus.core.toolkit.support.SFunction<S,?> column)
      SUM()

    • selectSum

      default <S, X> Children selectSum(com.baomidou.mybatisplus.core.toolkit.support.SFunction<S,?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X,?> alias)

    • selectSum

      default <S> Children selectSum(com.baomidou.mybatisplus.core.toolkit.support.SFunction<S,?> column, String alias)

    • selectCount

      default <S> Children selectCount(com.baomidou.mybatisplus.core.toolkit.support.SFunction<S,?> column)
      COUNT()

    • selectCount

      default <X> Children selectCount(Object column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X,?> alias)

    • selectCount

      default Children selectCount(Object column, String alias)

    • selectCount

      default <S, X> Children selectCount(com.baomidou.mybatisplus.core.toolkit.support.SFunction<S,?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X,?> alias)

    • selectCount

      default <S> Children selectCount(com.baomidou.mybatisplus.core.toolkit.support.SFunction<S,?> column, String alias)

    • selectMax

      default <S> Children selectMax(com.baomidou.mybatisplus.core.toolkit.support.SFunction<S,?> column)
      MAX()

    • selectMax

      default <S, X> Children selectMax(com.baomidou.mybatisplus.core.toolkit.support.SFunction<S,?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X,?> alias)

    • selectMax

      default <S> Children selectMax(com.baomidou.mybatisplus.core.toolkit.support.SFunction<S,?> column, String alias)

    • selectMin

      default <S> Children selectMin(com.baomidou.mybatisplus.core.toolkit.support.SFunction<S,?> column)
      MIN()

    • selectMin

      default <S, X> Children selectMin(com.baomidou.mybatisplus.core.toolkit.support.SFunction<S,?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X,?> alias)

    • selectMin

      default <S> Children selectMin(com.baomidou.mybatisplus.core.toolkit.support.SFunction<S,?> column, String alias)

    • selectAvg

      default <S> Children selectAvg(com.baomidou.mybatisplus.core.toolkit.support.SFunction<S,?> column)
      MIN()

    • selectAvg

      default <S, X> Children selectAvg(com.baomidou.mybatisplus.core.toolkit.support.SFunction<S,?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X,?> alias)

    • selectAvg

      default <S> Children selectAvg(com.baomidou.mybatisplus.core.toolkit.support.SFunction<S,?> column, String alias)

    • selectLen

      default <S> Children selectLen(com.baomidou.mybatisplus.core.toolkit.support.SFunction<S,?> column)
      LEN()

    • selectLen

      default <S, X> Children selectLen(com.baomidou.mybatisplus.core.toolkit.support.SFunction<S,?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X,?> alias)

    • selectLen

      default <S> Children selectLen(com.baomidou.mybatisplus.core.toolkit.support.SFunction<S,?> column, String alias)