Package com.github.yulichang.extension.apt

Class AptQueryWrapper<T>

java.lang.Object

com.baomidou.mybatisplus.core.conditions.Wrapper<T>

com.github.yulichang.extension.apt.JoinAbstractWrapper<T,Children>

com.github.yulichang.extension.apt.AptAbstractWrapper<T,AptQueryWrapper<T>>

com.github.yulichang.extension.apt.AptQueryWrapper<T>

All Implemented Interfaces:

com.baomidou.mybatisplus.core.conditions.interfaces.Nested<AptQueryWrapper<T>,AptQueryWrapper<T>>, com.baomidou.mybatisplus.core.conditions.ISqlSegment, Compare<AptQueryWrapper<T>>, CompareIfExists<AptQueryWrapper<T>>, Func<AptQueryWrapper<T>>, FuncLambda<AptQueryWrapper<T>>, OnCompare<AptQueryWrapper<T>>, Query<AptQueryWrapper<T>>, QueryJoin<AptQueryWrapper<T>,T>, QueryLabel<AptQueryWrapper<T>>, MPJBaseJoin<T>, StringJoin<AptQueryWrapper<T>,T>, Chain<T>, CompareStr<AptQueryWrapper<T>,String>, CompareStrIfExists<AptQueryWrapper<T>,String>, FuncStr<AptQueryWrapper<T>,String>, Join<AptQueryWrapper<T>>, SelectWrapper<T,AptQueryWrapper<T>>, Serializable

public class AptQueryWrapper<T>
extends AptAbstractWrapper<T,AptQueryWrapper<T>>
implements Query<AptQueryWrapper<T>>, QueryLabel<AptQueryWrapper<T>>, Chain<T>, SelectWrapper<T,AptQueryWrapper<T>>

Lambda 语法使用 Wrapper

Since:

1.5.0

Author:

yulichang

See Also:

• Serialized Form

Field Summary

Fields inherited from class com.github.yulichang.extension.apt.AptAbstractWrapper

alias, aptIndex, baseColumn, dynamicTableName, from, hasAlias, isMain, keyWord, logicDelType, logicSql, pageByMain, pageInfo, resultMap, resultMapCollection, subLogicSql, subTableAlias, tableFunc, tableIndex

Fields inherited from class com.github.yulichang.extension.apt.JoinAbstractWrapper

checkSqlInjection, expression, ifExists, index, joinClass, lastSql, onWrappers, paramAlias, paramNameSeq, paramNameValuePairs, sqlComment, sqlFirst, tableName, typedThis

Constructor Summary

Constructors

Modifier	Constructor	Description
	AptQueryWrapper(BaseColumn<T> baseColumn)	推荐使用此构造方法
	AptQueryWrapper(BaseColumn<T> baseColumn, T entity)
protected	AptQueryWrapper(T entity, BaseColumn<T> baseColumn, com.baomidou.mybatisplus.core.conditions.SharedString sqlSelect, AtomicInteger paramNameSeq, Map<String,Object> paramNameValuePairs, com.baomidou.mybatisplus.core.conditions.segments.MergeSegments mergeSegments, com.baomidou.mybatisplus.core.conditions.SharedString paramAlias, com.baomidou.mybatisplus.core.conditions.SharedString lastSql, com.baomidou.mybatisplus.core.conditions.SharedString sqlComment, com.baomidou.mybatisplus.core.conditions.SharedString sqlFirst, TableMap aptIndex, Integer index, String keyWord, Class<?> joinClass, String tableName, MBiPredicate<Object,IfExistsSqlKeyWordEnum> IfExists)	不建议直接 new 该实例，使用 JoinWrappers.lambda(UserDO.class)

Method Summary

Modifier and Type	Method	Description
void	addLabel(Label<?> label, boolean isCollection)
void	clear()
AptQueryWrapper<T>	distinct()	sql去重 select distinct
AptQueryWrapper<T>	getChildren()
List<Select>	getSelectColum()
boolean	getSelectDistinct()
String	getSqlSelect()	查询条件 SQL 片段
String	getUnionSql()
protected AptQueryWrapper<T>	instance()	用于生成嵌套 sql
protected AptQueryWrapper<T>	instance(Integer index, String keyWord, Class<?> joinClass, String tableName)
protected AptQueryWrapper<T>	instanceEmpty()
final AptQueryWrapper<T>	select(Column... columns)	设置查询字段
AptQueryWrapper<T>	selectAll()	查询主表全部字段
final <E> AptQueryWrapper<T>	selectAll(BaseColumn<E> baseColumn, Column... exclude)	查询实体类全部字段
AptQueryWrapper<T>	selectFunc(String sql, MFunction<AptConsumer> column, String alias)
<E, F> AptQueryWrapper<T>	selectSub(BaseColumn<E> baseColumn, Consumer<AptQueryWrapper<E>> consumer, com.baomidou.mybatisplus.core.toolkit.support.SFunction<F,?> alias)
<E, F> AptQueryWrapper<T>	selectSub(BaseColumn<E> baseColumn, Consumer<AptQueryWrapper<E>> consumer, String alias)	子查询
<U> AptQueryWrapper<T>	union(BaseColumn<U> baseColumn, Consumer<AptQueryWrapper<U>> consumer)	union
<U> AptQueryWrapper<T>	unionAll(BaseColumn<U> baseColumn, Consumer<AptQueryWrapper<U>> consumer)	union

Methods inherited from class com.github.yulichang.extension.apt.AptAbstractWrapper

checkJoinTable, columnsToString, columnToString, disableLogicDel, disableSubLogicDel, enableLogicDel, enableSubLogicDel, getCache, getFrom, getLogicSql, getPageInfo, getSubLogicSql, getTableName, getTableNameEnc, initNeed, isUseAnnotationOrderBy, join, join, logicDelToOn, logicDelToWhere, pageByMain, pageByMain, setTableName

Methods inherited from class com.github.yulichang.extension.apt.JoinAbstractWrapper

addCondition, addCondition, addCondition, addNestedCondition, allEqStr, allEqStr, and, and, appendSqlSegments, apply, applyFunc, applyFunc, around, between, between, checkSqlInjection, clone, columnSqlInjectFilter, columnsToString, columnsToString, columnsToString, columnToSqlSegment, columnToSqlSegment, columnToString, comment, eq, eq, eq, eqSql, eqSql, exists, first, formatParam, formatSqlMaybeWithParam, func, ge, ge, ge, geSql, geSql, getEntity, getEntityClass, getExpression, getParamAlias, getSqlComment, getSqlFirst, getSqlSegment, groupBy, groupBy, groupBy, groupBy, groupBy, groupBy, groupByLambda, groupByStr, gt, gt, gt, gtSql, gtSql, having, in, in, in, in, inExpression, inExpression, inSql, inSql, isNotNull, isNotNull, isNull, isNull, last, le, le, le, leSql, leSql, like, like, likeLeft, likeLeft, likeRight, likeRight, likeValue, likeValue, lt, lt, lt, ltSql, ltSql, maybeDo, ne, ne, ne, nested, not, not, notBetween, notBetween, notExists, notIn, notIn, notIn, notIn, notInSql, notInSql, notLike, notLike, notLikeLeft, notLikeLeft, notLikeRight, notLikeRight, or, or, orderBy, orderBy, orderBy, orderBy, orderByAsc, orderByAsc, orderByAsc, orderByAscLambda, orderByDesc, orderByDesc, orderByDesc, orderByDescLambda, orderByStr, setEntity, setEntityClass, setIfExists, setIfExists, setParamAlias, toChildren, toChildren

Methods inherited from class com.baomidou.mybatisplus.core.conditions.Wrapper

getCustomSqlSegment, getSqlSet, getTargetSql, isEmptyOfEntity, isEmptyOfNormal, isEmptyOfWhere, isNonEmptyOfEntity, isNonEmptyOfNormal, isNonEmptyOfWhere, nonEmptyOfEntity, nonEmptyOfNormal, nonEmptyOfWhere

Methods inherited from class java.lang.Object

equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

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

count, first, first, getEntityClass, isResultMapCollection, list, list, mapFirst, mapList, mapOne, mapPage, one, one, page, page

Methods inherited from interface com.github.yulichang.extension.apt.interfaces.Compare

between, eq, ge, gt, le, like, likeLeft, likeRight, lt, ne, notBetween, notLike, notLikeLeft, notLikeRight

Methods inherited from interface com.github.yulichang.extension.apt.interfaces.CompareIfExists

eqIfExists, geIfExists, getIfExists, gtIfExists, leIfExists, likeIfExists, likeLeftIfExists, likeRightIfExists, ltIfExists, neIfExists, notLikeIfExists, notLikeLeftIfExists, notLikeRightIfExists

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

allEqStr, allEqStr, allEqStr, allEqStr, between, eq, ge, gt, le, like, likeLeft, likeRight, lt, ne, notBetween, notLike, notLikeLeft, notLikeRight

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

eqIfExists, geIfExists, getIfExists, gtIfExists, leIfExists, likeIfExists, likeLeftIfExists, likeRightIfExists, ltIfExists, neIfExists, notLikeIfExists, notLikeLeftIfExists, notLikeRightIfExists

Methods inherited from interface com.github.yulichang.extension.apt.interfaces.Func

eqSql, func, func, geSql, groupBy, groupBy, groupBy, gtSql, having, in, in, inSql, isNotNull, isNull, leSql, ltSql, notIn, notIn, notInSql, orderByAsc, orderByAsc, orderByAsc, orderByAsc, orderByDesc, orderByDesc, orderByDesc, orderByDesc

Methods inherited from interface com.github.yulichang.extension.apt.interfaces.FuncLambda

groupBy, groupByLambda, orderByAsc, orderByAscLambda, orderByDesc, orderByDescLambda

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

eqSql, geSql, groupBy, groupBy, groupByStr, gtSql, in, in, inSql, isNotNull, isNull, leSql, ltSql, notIn, notIn, notInSql, orderByAsc, orderByAsc, orderByAsc, orderByAsc, orderByAscStr, orderByAscStr, orderByDesc, orderByDesc, orderByDesc, orderByDesc, orderByDescStr, orderByDescStr

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

apply, around, comment, exists, first, last, notExists, or

Methods inherited from interface com.github.yulichang.interfaces.MPJBaseJoin

getDeleteLogicSql, getDeleteSql

Methods inherited from interface com.baomidou.mybatisplus.core.conditions.interfaces.Nested

and, nested, not, or

Methods inherited from interface com.github.yulichang.extension.apt.interfaces.OnCompare

eq, ge, gt, le, lt, ne

Methods inherited from interface com.github.yulichang.extension.apt.interfaces.Query

select, selectAll, selectAs, selectAs, selectAs, selectAs, selectAsClass, selectAvg, selectAvg, selectAvg, selectCount, selectCount, selectCount, selectFilter, selectFunc, selectFunc, selectFunc, selectFunc, selectLen, selectLen, selectLen, selectMax, selectMax, selectMax, selectMin, selectMin, selectMin, selectSum, selectSum, selectSum

Methods inherited from interface com.github.yulichang.extension.apt.interfaces.QueryJoin

innerJoin, innerJoin, join, leftJoin, leftJoin, rightJoin, rightJoin

Methods inherited from interface com.github.yulichang.extension.apt.interfaces.QueryLabel

selectAssociation, selectAssociation, selectAssociation, selectCollection, selectCollection, selectCollection

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

doFill, getAlias, getEntityClass, getFrom, getPageInfo, getResultMapMybatisLabel, getSelectColumns, isPageByMain, isResultMap, isResultMapCollection, setEntityClass

Methods inherited from interface com.github.yulichang.query.interfaces.StringJoin

fullJoin, fullJoin, fullJoin, fullJoin, innerJoin, innerJoin, innerJoin, innerJoin, join, leftJoin, leftJoin, leftJoin, leftJoin, rightJoin, rightJoin, rightJoin, rightJoin

Constructor Details

AptQueryWrapper

public AptQueryWrapper(BaseColumn<T> baseColumn)

推荐使用此构造方法

AptQueryWrapper

public AptQueryWrapper(BaseColumn<T> baseColumn,
 T entity)

AptQueryWrapper

protected AptQueryWrapper(T entity,
 BaseColumn<T> baseColumn,
 com.baomidou.mybatisplus.core.conditions.SharedString sqlSelect,
 AtomicInteger paramNameSeq,
 Map<String,Object> paramNameValuePairs,
 com.baomidou.mybatisplus.core.conditions.segments.MergeSegments mergeSegments,
 com.baomidou.mybatisplus.core.conditions.SharedString paramAlias,
 com.baomidou.mybatisplus.core.conditions.SharedString lastSql,
 com.baomidou.mybatisplus.core.conditions.SharedString sqlComment,
 com.baomidou.mybatisplus.core.conditions.SharedString sqlFirst,
 TableMap aptIndex,
 Integer index,
 String keyWord,
 Class<?> joinClass,
 String tableName,
 MBiPredicate<Object,IfExistsSqlKeyWordEnum> IfExists)

不建议直接 new 该实例，使用 JoinWrappers.lambda(UserDO.class)

Method Details

distinct

public AptQueryWrapper<T> distinct()

sql去重 select distinct

getSelectColum

public List<Select> getSelectColum()

Specified by:

getSelectColum in interface Query<T>

addLabel

public void addLabel(Label<?> label,
 boolean isCollection)

Specified by:

addLabel in interface QueryLabel<T>

getChildren

public AptQueryWrapper<T> getChildren()

Specified by:

getChildren in interface Query<T>

Specified by:

getChildren in interface QueryLabel<T>

select

public final AptQueryWrapper<T> select(Column... columns)

设置查询字段

Specified by:

select in interface Query<T>

Parameters:

columns - 字段数组

Returns:

children

selectAll

public final <E> AptQueryWrapper<T> selectAll(BaseColumn<E> baseColumn,
 Column... exclude)

查询实体类全部字段

Specified by:

selectAll in interface Query<T>

Parameters:

baseColumn - 查询的实体类

exclude - 排除字段

selectAll

public AptQueryWrapper<T> selectAll()

查询主表全部字段

需要使用 使用 JoinWrappers.lambda(clazz) 或者 new MPJLambdaQueryWrapper<<(clazz) 构造

Specified by:

selectAll in interface SelectWrapper<T,AptQueryWrapper<T>>

Returns:

children

selectFunc

public AptQueryWrapper<T> selectFunc(String sql,
 MFunction<AptConsumer> column,
 String alias)

Specified by:

selectFunc in interface Query<T>

selectSub

public <E,
F> AptQueryWrapper<T> selectSub(BaseColumn<E> baseColumn,
 Consumer<AptQueryWrapper<E>> consumer,
 com.baomidou.mybatisplus.core.toolkit.support.SFunction<F,?> alias)

selectSub

public <E,
F> AptQueryWrapper<T> selectSub(BaseColumn<E> baseColumn,
 Consumer<AptQueryWrapper<E>> consumer,
 String alias)

子查询

union

public <U> AptQueryWrapper<T> union(BaseColumn<U> baseColumn,
 Consumer<AptQueryWrapper<U>> consumer)

union

例： wrapper.union(UserDO.class, union -> union.selectAll(UserDO.class))

Parameters:

baseColumn - union语句的主表类型

Since:

1.4.8

unionAll

public <U> AptQueryWrapper<T> unionAll(BaseColumn<U> baseColumn,
 Consumer<AptQueryWrapper<U>> consumer)

union

例： wrapper.unionAll(UserDO.class, union -> union.selectAll(UserDO.class))

Parameters:

baseColumn - union语句的主表类型

Since:

1.4.8

getSqlSelect

public String getSqlSelect()

查询条件 SQL 片段

Specified by:

getSqlSelect in interface Query<T>

Overrides:

getSqlSelect in class com.baomidou.mybatisplus.core.conditions.Wrapper<T>

getUnionSql

public String getUnionSql()

Specified by:

getUnionSql in interface MPJBaseJoin<T>

getSelectDistinct

public boolean getSelectDistinct()

instance

protected AptQueryWrapper<T> instance()

用于生成嵌套 sql

故 sqlSelect 不向下传递

Specified by:

instance in class JoinAbstractWrapper<T,AptQueryWrapper<T>>

instanceEmpty

protected AptQueryWrapper<T> instanceEmpty()

Specified by:

instanceEmpty in class JoinAbstractWrapper<T,AptQueryWrapper<T>>

instance

protected AptQueryWrapper<T> instance(Integer index,
 String keyWord,
 Class<?> joinClass,
 String tableName)

Specified by:

instance in class JoinAbstractWrapper<T,AptQueryWrapper<T>>

clear

public void clear()

Overrides:

clear in class AptAbstractWrapper<T,AptQueryWrapper<T>>