Interface Query<Children>
- All Superinterfaces:
Serializable
- All Known Implementing Classes:
AptQueryWrapper
参考
Query- Author:
- yulichang
-
Method Summary
Modifier and TypeMethodDescriptionselect sql 片段<E> Childrendefault ChildrenString 查询default <E> ChildrenselectAll(BaseColumn<E> baseColumn) 查询实体类全部字段default <E> ChildrenselectAll(BaseColumn<E> baseColumn, Column... exclude) 查询实体类全部字段default <X> Childrenignoredefault Children别名查询default <E> ChildrenString 查询default <X> ChildrenselectAs(String index, Column column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> alias) String 查询default <E> ChildrenselectAsClass(BaseColumn<E> baseColumn, Class<?> tag) default ChildrenMIN()default <X> Childrendefault Childrendefault ChildrenselectCount(Column column) COUNT()default <X> ChildrenselectCount(Column column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> alias) default ChildrenselectCount(Column column, String alias) default <E> ChildrenselectFilter(BaseColumn<E> baseColumn, Predicate<SelectCache> predicate) 过滤查询的字段信息default ChildrenselectFunc(BaseFuncEnum funcEnum, Column column) default <X> ChildrenselectFunc(BaseFuncEnum funcEnum, Column column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> alias) default ChildrenselectFunc(BaseFuncEnum funcEnum, Column column, String alias) 聚合函数查询default <S> ChildrenselectFunc(String sql, MFunction<AptConsumer> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<S, ?> alias) selectFunc(String sql, MFunction<AptConsumer> column, String alias) default ChildrenLEN()default <X> Childrendefault Childrendefault ChildrenMAX()default <X> Childrendefault Childrendefault ChildrenMIN()default <X> Childrendefault Childrendefault ChildrenSUM()default <X> Childrendefault Children
-
Method Details
-
getSelectColum
-
getChildren
Children getChildren() -
selectFilter
过滤查询的字段信息例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
-
select
String 查询- Parameters:
columns- 列
-
selectAs
default <E> Children selectAs(String column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<E, ?> alias) String 查询- Parameters:
column- 列
-
selectAs
default <X> Children selectAs(String index, Column column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> alias) String 查询- Parameters:
column- 列
-
selectAsClass
-
selectAs
default <X> Children selectAs(Column column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> alias) ignore -
selectAs
别名查询 -
selectAll
查询实体类全部字段 -
selectAll
查询实体类全部字段- Parameters:
baseColumn- 查询的实体类exclude- 排除字段
-
getSqlSelect
String getSqlSelect()select sql 片段 -
selectFunc
聚合函数查询wrapper.selectFunc(() -> "COUNT(%s)", "t.id", "total");
lambda wrapper.selectFunc(() -> "COUNT(%s)", UserDO::getId, UserDTO::getTotal);
- Parameters:
funcEnum- 函数枚举DefaultFuncEnumcolumn- 函数作用的字段alias- 别名
-
selectFunc
default <X> Children selectFunc(BaseFuncEnum funcEnum, Column column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> alias) -
selectFunc
-
selectFunc
-
selectFunc
default <S> Children selectFunc(String sql, MFunction<AptConsumer> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<S, ?> alias) -
selectSum
SUM() -
selectSum
-
selectSum
-
selectCount
COUNT() -
selectCount
-
selectCount
-
selectMax
MAX() -
selectMax
-
selectMax
-
selectMin
MIN() -
selectMin
-
selectMin
-
selectAvg
MIN() -
selectAvg
-
selectAvg
-
selectLen
LEN() -
selectLen
-
selectLen
-