Class JoinAbstractWrapper<T,Children extends JoinAbstractWrapper<T,Children>>
- All Implemented Interfaces:
com.baomidou.mybatisplus.core.conditions.ISqlSegment,Compare<Children>,CompareIfExists<Children>,CompareStr<Children,,String> CompareStrIfExists<Children,,String> CompareWrapper<Children>,Func<Children>,FuncStr<Children,,String> FuncWrapper<Children>,Join<Children>,Nested<Children,,Children> OnCompare<Children>,Serializable
- Direct Known Subclasses:
JoinAbstractLambdaWrapper
AbstractWrapper- Author:
- yulichang
- See Also:
-
Field Summary
FieldsModifier and TypeFieldDescriptionprotected String主表别名protected boolean检查 SQL 注入过滤protected com.baomidou.mybatisplus.core.conditions.segments.MergeSegmentsprotected MBiPredicate<Object,IfExistsSqlKeyWordEnum> IfExists 策略protected Integer表别名protected boolean主表wrapperprotected boolean是否是OnWrapperprotected Class<?>连表实体类 on 条件 func 使用protected com.baomidou.mybatisplus.core.conditions.SharedStringON sql wrapper集合protected com.baomidou.mybatisplus.core.conditions.SharedString其他protected AtomicInteger必要度量protected com.baomidou.mybatisplus.core.conditions.SharedStringSQL注释protected com.baomidou.mybatisplus.core.conditions.SharedStringSQL起始语句protected String副表别名protected TableList关联的表protected String连表表名protected final Children占位符 -
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionprotected ChildrenaddCondition(boolean condition, String column, com.baomidou.mybatisplus.core.enums.SqlKeyword sqlKeyword, Object val) protected <X,R> Children addCondition(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, com.baomidou.mybatisplus.core.enums.SqlKeyword sqlKeyword, Class<R> clazz, MPJLambdaWrapper<R> val) protected <X> ChildrenaddCondition(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, com.baomidou.mybatisplus.core.enums.SqlKeyword sqlKeyword, Object val) 普通查询条件protected <X,S> Children addCondition(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, com.baomidou.mybatisplus.core.enums.SqlKeyword sqlKeyword, String rightAlias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<S, ?> val) protected ChildrenaddNestedCondition(boolean condition, Consumer<Children> consumer) 多重嵌套查询条件<X,V> Children allEq(boolean condition, BiPredicate<com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?>, V> filter, Map<com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?>, V> params, boolean null2IsNull) 字段过滤接口,传入多参数时允许对参数进行过滤<X,V> Children allEq(boolean condition, Map<com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?>, V> params, boolean null2IsNull) map 所有非空属性等于 =<V> ChildrenallEqStr(boolean condition, BiPredicate<String, V> filter, Map<String, V> params, boolean null2IsNull) 字段过滤接口,传入多参数时允许对参数进行过滤<V> Childrenmap 所有非空属性等于 =protected Childrenand(boolean condition) 内部自用AND 嵌套protected voidappendSqlSegments(com.baomidou.mybatisplus.core.conditions.ISqlSegment... sqlSegments) 添加 where 片段拼接 sqlapplyFunc(boolean condition, String applySql, MFunction<FuncConsumer> consumerFunction, Object... values) applyFunc(String applySql, MFunction<FuncConsumer> consumerFunction, Object... values) sql 起始句 和介绍语句(会拼接在SQL语句的起始处和结束处)<X> Childrenbetween(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, Object val1, Object val2) BETWEEN 值1 AND 值2BETWEEN 值1 AND 值2开启检查 SQL 注入voidclear()clone()protected <X> com.baomidou.mybatisplus.core.toolkit.support.SFunction<X,?> columnSqlInjectFilter(com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column) 字段 SQL 注入过滤处理,子类重写实现过滤逻辑<X> StringcolumnsToString(Integer index, PrefixEnum prefixEnum, String alias, boolean orderBy, List<X> columns) protected StringcolumnsToString(String... columns) protected StringcolumnsToString(List<String> columns) protected final <X> com.baomidou.mybatisplus.core.conditions.ISqlSegmentcolumnToSqlSegment(Integer index, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, boolean orderBy) 获取 columnNameprotected final com.baomidou.mybatisplus.core.conditions.ISqlSegmentcolumnToSqlSegment(String column) protected final <X> com.baomidou.mybatisplus.core.conditions.ISqlSegmentcolumnToSqlSegmentS(Integer index, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, boolean isJoin) protected abstract <X> StringcolumnToString(Integer index, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, boolean isJoin, PrefixEnum prefixEnum, boolean orderBy) 获取 columnNameprotected StringcolumnToString(String column) sql 注释(会拼接在 sql 的最后面)<R,S> Children eq(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, String rightAlias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<S, ?> val) 等于 =<X,Y> Children eq(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, Class<Y> clazz, MFunction<MPJLambdaWrapper<Y>> wrapper) 等于 =<X> Childreneq(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, Object val) 等于 =等于 =<R> ChildreneqSql(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, String inValue) 字段 <= ( sql语句 )字段 = ( sql语句 )<X> Childrenexists(boolean condition, Class<X> clazz, MFunction<MPJLambdaWrapper<X>> wrapper) 拼接 EXISTS ( sql语句 )sql 起始句(会拼接在SQL语句的起始处)protected final StringformatParam(String mapping, Object param) 处理入参protected final StringformatSqlMaybeWithParam(String sqlStr, Object... params) 格式化 sqlprotected <E> MPJLambdaWrapper<E>fromInstance(Class<E> clazz) <R,S> Children ge(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, String rightAlias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<S, ?> val) 大于等于 >=<X,Y> Children ge(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, Class<Y> clazz, MFunction<MPJLambdaWrapper<Y>> wrapper) 大于等于 >=<X> Childrenge(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, Object val) 大于等于 >=大于等于 >=<X> ChildrengeSql(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, String inValue) 字段 >= ( sql语句 )字段 >= ( sql语句 )com.baomidou.mybatisplus.core.conditions.segments.MergeSegmentsfinal <R> ChildrengroupBy(boolean condition, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?>... columns) 分组:GROUP BY 字段, ...final <X> ChildrengroupBy(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?>... columns) 分组:GROUP BY 字段, ...分组:GROUP BY 字段, ...<R> ChildrengroupBy(boolean condition, String alias, List<com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?>> columns) final <R> ChildrengroupBy(com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?>... columns) final <R> ChildrengroupBy(String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?>... columns) groupByStr(boolean condition, List<String> columns) 分组:GROUP BY 字段, ...<R,S> Children gt(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, String rightAlias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<S, ?> val) 大于 ><X,Y> Children gt(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, Class<Y> clazz, MFunction<MPJLambdaWrapper<Y>> wrapper) 大于 ><X> Childrengt(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, Object val) 大于 >大于 ><X> ChildrengtSql(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, String inValue) 字段 > ( sql语句 )字段 > ( sql语句 )HAVING ( sql语句 )<X,Y> Children in(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, Class<Y> clazz, MFunction<MPJLambdaWrapper<Y>> wrapper) <X> Childrenin(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, Object... values) 字段 IN (v0, v1, ...)<X> Childrenin(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, Collection<?> coll) 字段 IN (value.get(0), value.get(1), ...)字段 IN (v0, v1, ...)in(boolean condition, String column, Collection<?> coll) 字段 IN (value.get(0), value.get(1), ...)protected com.baomidou.mybatisplus.core.conditions.ISqlSegmentinExpression(Object[] values) 获取in表达式 包含括号protected com.baomidou.mybatisplus.core.conditions.ISqlSegmentinExpression(Collection<?> value) 获取in表达式 包含括号<X> ChildreninSql(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, String inValue) 字段 IN ( sql语句 )字段 IN ( sql语句 )protected abstract Childreninstance()子类返回一个自己的新对象protected abstract Childrenprotected abstract Children字段 IS NOT NULL<X> ChildrenisNotNull(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column) 字段 IS NOT NULL<X> ChildrenisNotNull(boolean condition, String alias, Class<X> clazz, MFunction<MPJLambdaWrapper<X>> wrapper) 字段 IS NULL<X> ChildrenisNull(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column) 字段 IS NULL<X> ChildrenisNull(boolean condition, String alias, Class<X> clazz, MFunction<MPJLambdaWrapper<X>> wrapper) 无视优化规则直接拼接到 sql 的最后(有sql注入的风险,请谨慎使用)<R,S> Children le(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, String rightAlias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<S, ?> val) 小于等于 <=<X,Y> Children le(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, Class<Y> clazz, MFunction<MPJLambdaWrapper<Y>> wrapper) 小于等于 <=<X> Childrenle(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, Object val) 小于等于 <=小于等于 <=<X> ChildrenleSql(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, String inValue) 字段 <= ( sql语句 )字段 <= ( sql语句 )<X> Childrenlike(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, Object val) LIKE '%值%'LIKE '%值%'<X> ChildrenlikeLeft(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, Object val) LIKE '%值'LIKE '%值'<X> ChildrenlikeRight(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, Object val) LIKE '值%'LIKE '值%'protected <X> ChildrenlikeValue(boolean condition, com.baomidou.mybatisplus.core.enums.SqlKeyword keyword, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, Object val, com.baomidou.mybatisplus.core.enums.SqlLike sqlLike) 内部自用protected ChildrenlikeValue(boolean condition, com.baomidou.mybatisplus.core.enums.SqlKeyword keyword, String column, Object val, com.baomidou.mybatisplus.core.enums.SqlLike sqlLike) <R,S> Children lt(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, String rightAlias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<S, ?> val) 小于 <<X,Y> Children lt(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, Class<Y> clazz, MFunction<MPJLambdaWrapper<Y>> wrapper) 小于 <<X> Childrenlt(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, Object val) 小于 <小于 <<X> ChildrenltSql(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, String inValue) 字段 < ( sql语句 )字段 < ( sql语句 )protected final ChildrenmaybeDo(boolean condition, DoSomething something) 函数化的做事<R,S> Children ne(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, String rightAlias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<S, ?> val) 不等于 <><X,Y> Children ne(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, Class<Y> clazz, MFunction<MPJLambdaWrapper<Y>> wrapper) 不等于 <><X> Childrenne(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, Object val) 不等于 <>不等于 <>正常嵌套 不带 AND 或者 ORprotected Childrennot(boolean condition) 内部自用not嵌套<X> ChildrennotBetween(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, Object val1, Object val2) NOT BETWEEN 值1 AND 值2notBetween(boolean condition, String column, Object val1, Object val2) NOT BETWEEN 值1 AND 值2<X> ChildrennotExists(boolean condition, Class<X> clazz, MFunction<MPJLambdaWrapper<X>> wrapper) 拼接 NOT EXISTS ( sql语句 )<X,Y> Children notIn(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, Class<Y> clazz, MFunction<MPJLambdaWrapper<Y>> wrapper) <X> ChildrennotIn(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, Object... values) 字段 NOT IN (v0, v1, ...)<X> ChildrennotIn(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, Collection<?> coll) 字段 NOT IN (value.get(0), value.get(1), ...)字段 NOT IN (v0, v1, ...)notIn(boolean condition, String column, Collection<?> coll) 字段 NOT IN (value.get(0), value.get(1), ...)<X> ChildrennotInSql(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, String inValue) 字段 NOT IN ( sql语句 )字段 NOT IN ( sql语句 )<X> ChildrennotLike(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, Object val) NOT LIKE '%值%'NOT LIKE '%值%'<R> ChildrennotLikeLeft(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, Object val) LIKE '%值'notLikeLeft(boolean condition, String column, Object val) LIKE '%值'<R> ChildrennotLikeRight(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, Object val) LIKE '值%'notLikeRight(boolean condition, String column, Object val) LIKE '值%'or(boolean condition) 拼接 OROR 嵌套final <R> ChildrenorderBy(boolean condition, boolean isAsc, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?>... columns) 排序:ORDER BY 字段, ...final <X> ChildrenorderBy(boolean condition, boolean isAsc, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?>... columns) 排序:ORDER BY 字段, ...final Children排序:ORDER BY 字段, ...final <R> ChildrenorderByAsc(boolean condition, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?>... columns) 排序:ORDER BY 字段, ...final <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) final <R> ChildrenorderByAsc(com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?>... columns) final <R> ChildrenorderByAsc(String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?>... columns) final <R> ChildrenorderByDesc(boolean condition, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?>... columns) 排序:ORDER BY 字段, ...final <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) final <R> ChildrenorderByDesc(com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?>... columns) final <R> ChildrenorderByDesc(String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?>... columns) orderByStr(boolean condition, boolean isAsc, List<String> columns) 排序:ORDER BY 字段, ...setEntityClass(Class<T> entityClass) setIfExists(MBiPredicate<Object, IfExistsSqlKeyWordEnum> IfExists) setIfExists(Predicate<Object> IfExists) 设置 IfExists .IfExists(val -> val !setParamAlias(String paramAlias) 参数别名设置,初始化时优先设置该值、重复设置异常protected <E> MPJLambdaWrapper<E>subInstance(Class<E> clazz) protected <E> MPJLambdaWrapper<E>subInstance(Class<E> clazz, String st) Methods inherited from class com.baomidou.mybatisplus.core.conditions.Wrapper
getCustomSqlSegment, getSqlSelect, getSqlSet, getTargetSql, isEmptyOfEntity, isEmptyOfNormal, isEmptyOfWhere, isNonEmptyOfEntity, isNonEmptyOfNormal, isNonEmptyOfWhere, nonEmptyOfEntity, nonEmptyOfNormal, nonEmptyOfWhereMethods inherited from class java.lang.Object
equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, waitMethods inherited from interface com.github.yulichang.wrapper.interfaces.Compare
allEq, allEq, allEq, allEq, between, between, between, eq, eq, eq, ge, ge, ge, gt, gt, gt, le, le, le, like, like, like, likeLeft, likeLeft, likeLeft, likeRight, likeRight, likeRight, lt, lt, lt, ne, ne, ne, notBetween, notBetween, notBetween, notLike, notLike, notLike, notLikeLeft, notLikeLeft, notLikeLeft, notLikeRight, notLikeRight, notLikeRightMethods inherited from interface com.github.yulichang.wrapper.interfaces.CompareIfExists
eqIfExists, eqIfExists, geIfExists, geIfExists, getIfExists, gtIfExists, gtIfExists, leIfExists, leIfExists, likeIfExists, likeIfExists, likeLeftIfExists, likeLeftIfExists, likeRightIfExists, likeRightIfExists, ltIfExists, ltIfExists, neIfExists, neIfExists, notLikeIfExists, notLikeIfExists, notLikeLeftIfExists, notLikeLeftIfExists, notLikeRightIfExists, notLikeRightIfExistsMethods 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, notLikeRightMethods inherited from interface com.github.yulichang.wrapper.interfaces.CompareStrIfExists
eqIfExists, geIfExists, getIfExists, gtIfExists, leIfExists, likeIfExists, likeLeftIfExists, likeRightIfExists, ltIfExists, neIfExists, notLikeIfExists, notLikeLeftIfExists, notLikeRightIfExistsMethods inherited from interface com.github.yulichang.wrapper.interfaces.CompareWrapper
eq, eq, eq, ge, ge, ge, gt, gt, gt, le, le, le, lt, lt, lt, ne, ne, neMethods inherited from interface com.github.yulichang.wrapper.interfaces.Func
eqSql, eqSql, eqSql, func, func, geSql, geSql, geSql, groupBy, groupBy, groupBy, groupBy, groupBy, gtSql, gtSql, gtSql, having, in, in, in, in, in, in, inSql, inSql, inSql, isNotNull, isNotNull, isNotNull, isNull, isNull, isNull, leSql, leSql, leSql, ltSql, ltSql, ltSql, notIn, notIn, notIn, notIn, notIn, notIn, notInSql, notInSql, notInSql, orderByAsc, orderByAsc, orderByAsc, orderByAsc, orderByAsc, orderByDesc, orderByDesc, orderByDesc, orderByDesc, orderByDescMethods 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, orderByDescStrMethods inherited from interface com.github.yulichang.wrapper.interfaces.FuncWrapper
exists, in, in, in, isNotNull, isNotNull, isNotNull, isNull, isNull, isNull, notExists, notIn, notIn, notInMethods inherited from interface com.github.yulichang.wrapper.interfaces.Join
apply, around, comment, exists, first, last, notExists, or
-
Field Details
-
alias
主表别名 -
subTableAlias
副表别名 -
typedThis
占位符 -
index
表别名 -
paramNameSeq
必要度量 -
paramNameValuePairs
-
paramAlias
protected com.baomidou.mybatisplus.core.conditions.SharedString paramAlias其他 -
lastSql
protected com.baomidou.mybatisplus.core.conditions.SharedString lastSql -
sqlComment
protected com.baomidou.mybatisplus.core.conditions.SharedString sqlCommentSQL注释 -
sqlFirst
protected com.baomidou.mybatisplus.core.conditions.SharedString sqlFirstSQL起始语句 -
onWrappers
ON sql wrapper集合 -
expression
protected com.baomidou.mybatisplus.core.conditions.segments.MergeSegments expression -
joinClass
连表实体类 on 条件 func 使用 -
tableName
连表表名 -
isMain
protected boolean isMain主表wrapper -
isOn
protected boolean isOn是否是OnWrapper -
tableList
关联的表 -
checkSqlInjection
protected boolean checkSqlInjection检查 SQL 注入过滤 -
ifExists
IfExists 策略
-
-
Constructor Details
-
JoinAbstractWrapper
public JoinAbstractWrapper()
-
-
Method Details
-
getEntity
- Specified by:
getEntityin classcom.baomidou.mybatisplus.core.conditions.Wrapper<T>
-
setEntity
-
getEntityClass
-
setEntityClass
-
subInstance
-
fromInstance
-
subInstance
-
checkSqlInjection
开启检查 SQL 注入 -
setIfExists
-
setIfExists
设置 IfExists .IfExists(val -> val != null && StrUtils.isNotBlank(val))- Parameters:
IfExists- 判断- Returns:
- Children
-
allEq
public <X,V> Children allEq(boolean condition, Map<com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?>, V> params, boolean null2IsNull) Description copied from interface:Comparemap 所有非空属性等于 = -
allEq
public <X,V> Children allEq(boolean condition, BiPredicate<com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?>, V> filter, Map<com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?>, V> params, boolean null2IsNull) Description copied from interface:Compare字段过滤接口,传入多参数时允许对参数进行过滤 -
eq
public <X> Children eq(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, Object val) Description copied from interface:Compare等于 = -
eq
public <X,Y> Children eq(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, Class<Y> clazz, MFunction<MPJLambdaWrapper<Y>> wrapper) Description copied from interface:CompareWrapper等于 =- Specified by:
eqin interfaceCompareWrapper<T>- Parameters:
condition- 执行条件column- 字段wrapper- 值- Returns:
- children
-
ne
public <X> Children ne(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, Object val) Description copied from interface:Compare不等于 <> -
ne
public <X,Y> Children ne(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, Class<Y> clazz, MFunction<MPJLambdaWrapper<Y>> wrapper) Description copied from interface:CompareWrapper不等于 <>- Specified by:
nein interfaceCompareWrapper<T>- Parameters:
condition- 执行条件alias- 字段别名column- 字段wrapper- 值- Returns:
- children
-
gt
public <X> Children gt(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, Object val) Description copied from interface:Compare大于 > -
gt
public <X,Y> Children gt(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, Class<Y> clazz, MFunction<MPJLambdaWrapper<Y>> wrapper) Description copied from interface:CompareWrapper大于 >- Specified by:
gtin interfaceCompareWrapper<T>- Parameters:
condition- 执行条件column- 字段wrapper- 值- Returns:
- children
-
ge
public <X> Children ge(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, Object val) Description copied from interface:Compare大于等于 >= -
ge
public <X,Y> Children ge(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, Class<Y> clazz, MFunction<MPJLambdaWrapper<Y>> wrapper) Description copied from interface:CompareWrapper大于等于 >=- Specified by:
gein interfaceCompareWrapper<T>- Parameters:
condition- 执行条件column- 字段wrapper- 值- Returns:
- children
-
lt
public <X> Children lt(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, Object val) Description copied from interface:Compare小于 < -
lt
public <X,Y> Children lt(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, Class<Y> clazz, MFunction<MPJLambdaWrapper<Y>> wrapper) Description copied from interface:CompareWrapper小于 <- Specified by:
ltin interfaceCompareWrapper<T>- Parameters:
condition- 执行条件column- 字段wrapper- 值- Returns:
- children
-
le
public <X> Children le(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, Object val) Description copied from interface:Compare小于等于 <= -
le
public <X,Y> Children le(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, Class<Y> clazz, MFunction<MPJLambdaWrapper<Y>> wrapper) Description copied from interface:CompareWrapper小于等于 <=- Specified by:
lein interfaceCompareWrapper<T>- Parameters:
condition- 执行条件column- 字段wrapper- 值- Returns:
- children
-
like
public <X> Children like(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, Object val) Description copied from interface:CompareLIKE '%值%' -
notLike
public <X> Children notLike(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, Object val) Description copied from interface:CompareNOT LIKE '%值%' -
likeLeft
public <X> Children likeLeft(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, Object val) Description copied from interface:CompareLIKE '%值' -
notLikeLeft
public <R> Children notLikeLeft(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, Object val) Description copied from interface:CompareLIKE '%值'- Specified by:
notLikeLeftin interfaceCompare<T>- Parameters:
condition- 执行条件column- 字段val- 值- Returns:
- children
-
likeRight
public <X> Children likeRight(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, Object val) Description copied from interface:CompareLIKE '值%' -
notLikeRight
public <R> Children notLikeRight(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, Object val) Description copied from interface:CompareLIKE '值%'- Specified by:
notLikeRightin interfaceCompare<T>- Parameters:
condition- 执行条件column- 字段val- 值- Returns:
- children
-
between
public <X> Children between(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, Object val1, Object val2) Description copied from interface:CompareBETWEEN 值1 AND 值2 -
notBetween
public <X> Children notBetween(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, Object val1, Object val2) Description copied from interface:CompareNOT BETWEEN 值1 AND 值2- Specified by:
notBetweenin interfaceCompare<T>- Parameters:
condition- 执行条件column- 字段val1- 值1val2- 值2- Returns:
- children
-
and
Description copied from interface:NestedAND 嵌套例: and(i -> i.eq("name", "李白").ne("status", "活着"))
-
or
Description copied from interface:NestedOR 嵌套例: or(i -> i.eq("name", "李白").ne("status", "活着"))
-
nested
Description copied from interface:Nested正常嵌套 不带 AND 或者 OR例: nested(i -> i.eq("name", "李白").ne("status", "活着"))
-
not
Description copied from interface:Nestednot嵌套例: not(i -> i.eq("name", "李白").ne("status", "活着"))
-
or
Description copied from interface:Join拼接 OR -
apply
Description copied from interface:Join拼接 sql!! 会有 sql 注入风险 !!
例1: apply("id = 1")
例2: apply("date_format(dateColumn,'%Y-%m-%d') = '2008-08-08'")
例3: apply("date_format(dateColumn,'%Y-%m-%d') = {0}", LocalDate.now())
-
applyFunc
public Children applyFunc(String applySql, MFunction<FuncConsumer> consumerFunction, Object... values) -
applyFunc
public Children applyFunc(boolean condition, String applySql, MFunction<FuncConsumer> consumerFunction, Object... values) -
last
Description copied from interface:Join无视优化规则直接拼接到 sql 的最后(有sql注入的风险,请谨慎使用)例: last("limit 1")
注意只能调用一次,多次调用以最后一次为准
-
comment
Description copied from interface:Joinsql 注释(会拼接在 sql 的最后面) -
first
Description copied from interface:Joinsql 起始句(会拼接在SQL语句的起始处) -
around
Description copied from interface:Joinsql 起始句 和介绍语句(会拼接在SQL语句的起始处和结束处) -
exists
Description copied from interface:Join拼接 EXISTS ( sql语句 )!! sql 注入方法 !!
例: exists("select id from table where age = 1")
-
exists
public <X> Children exists(boolean condition, Class<X> clazz, MFunction<MPJLambdaWrapper<X>> wrapper) - Specified by:
existsin interfaceFuncWrapper<T>
-
notExists
Description copied from interface:Join拼接 NOT EXISTS ( sql语句 )!! sql 注入方法 !!
例: notExists("select id from table where age = 1")
-
notExists
public <X> Children notExists(boolean condition, Class<X> clazz, MFunction<MPJLambdaWrapper<X>> wrapper) - Specified by:
notExistsin interfaceFuncWrapper<T>
-
isNull
public <X> Children isNull(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column) Description copied from interface:Func字段 IS NULL例: isNull("name")
-
isNull
public <X> Children isNull(boolean condition, String alias, Class<X> clazz, MFunction<MPJLambdaWrapper<X>> wrapper) - Specified by:
isNullin interfaceFuncWrapper<T>
-
isNotNull
public <X> Children isNotNull(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column) Description copied from interface:Func字段 IS NOT NULL例: isNotNull("name")
-
isNotNull
public <X> Children isNotNull(boolean condition, String alias, Class<X> clazz, MFunction<MPJLambdaWrapper<X>> wrapper) - Specified by:
isNotNullin interfaceFuncWrapper<T>
-
in
public <X> Children in(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, Collection<?> coll) Description copied from interface:Func字段 IN (value.get(0), value.get(1), ...)例: in("id", Arrays.asList(1, 2, 3, 4, 5))
- 注意!集合为空若存在逻辑错误,请在 condition 条件中判断
- 如果集合为 empty 则不会进行 sql 拼接
-
in
public <X,Y> Children in(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, Class<Y> clazz, MFunction<MPJLambdaWrapper<Y>> wrapper) - Specified by:
inin interfaceFuncWrapper<T>
-
in
public <X> Children in(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, Object... values) Description copied from interface:Func字段 IN (v0, v1, ...)例: in("id", 1, 2, 3, 4, 5)
- 注意!数组为空若存在逻辑错误,请在 condition 条件中判断
- 如果动态数组为 empty 则不会进行 sql 拼接
-
notIn
public <X> Children notIn(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, Collection<?> coll) Description copied from interface:Func字段 NOT IN (value.get(0), value.get(1), ...)例: notIn("id", Arrays.asList(1, 2, 3, 4, 5))
-
notIn
public <X,Y> Children notIn(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, Class<Y> clazz, MFunction<MPJLambdaWrapper<Y>> wrapper) - Specified by:
notInin interfaceFuncWrapper<T>
-
notIn
public <X> Children notIn(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, Object... values) Description copied from interface:Func字段 NOT IN (v0, v1, ...)例: notIn("id", 1, 2, 3, 4, 5)
-
inSql
public <X> Children inSql(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, String inValue) Description copied from interface:Func字段 IN ( sql语句 )!! sql 注入方式的 in 方法 !!
例1: inSql("id", "1, 2, 3, 4, 5, 6")
例2: inSql("id", "select id from table where id < 3")
-
notInSql
public <X> Children notInSql(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, String inValue) Description copied from interface:Func字段 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")
-
gtSql
public <X> Children gtSql(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, String inValue) Description copied from interface:Func字段 > ( sql语句 )例1: gtSql("id", "1, 2, 3, 4, 5, 6")
例1: gtSql("id", "select id from table where name = 'JunJun'")
-
geSql
public <X> Children geSql(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, String inValue) Description copied from interface:Func字段 >= ( sql语句 )例1: geSql("id", "1, 2, 3, 4, 5, 6")
例1: geSql("id", "select id from table where name = 'JunJun'")
-
ltSql
public <X> Children ltSql(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, String inValue) Description copied from interface:Func字段 < ( sql语句 )例1: ltSql("id", "1, 2, 3, 4, 5, 6")
例1: ltSql("id", "select id from table where name = 'JunJun'")
-
leSql
public <X> Children leSql(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, String inValue) Description copied from interface:Func字段 <= ( sql语句 )例1: leSql("id", "1, 2, 3, 4, 5, 6")
例1: leSql("id", "select id from table where name = 'JunJun'")
-
eqSql
public <R> Children eqSql(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, String inValue) Description copied from interface:Func字段 <= ( sql语句 )例1: leSql("id", "1, 2, 3, 4, 5, 6")
例1: leSql("id", "select id from table where name = 'JunJun'")
-
groupBy
-
groupBy
@SafeVarargs public final <R> Children groupBy(com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?>... columns) -
groupBy
@SafeVarargs public final <R> Children groupBy(String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?>... columns) -
groupBy
@SafeVarargs public final <R> Children groupBy(boolean condition, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?>... columns) -
groupBy
@SafeVarargs public final <X> Children groupBy(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?>... columns) Description copied from interface:Func分组:GROUP BY 字段, ...例: groupBy("id", "name")
-
orderByAsc
public <R> Children orderByAsc(boolean condition, String alias, List<com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?>> columns) - Specified by:
orderByAscin interfaceFunc<T>
-
orderByAsc
@SafeVarargs public final <R> Children orderByAsc(com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?>... columns) - Specified by:
orderByAscin interfaceFunc<T>
-
orderByAsc
@SafeVarargs public final <R> Children orderByAsc(String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?>... columns) - Specified by:
orderByAscin interfaceFunc<T>
-
orderByAsc
@SafeVarargs public final <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) - Specified by:
orderByAscin interfaceFunc<T>
-
orderByAsc
@SafeVarargs public final <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")
- Specified by:
orderByAscin interfaceFunc<T>- Parameters:
condition- 执行条件column- 单个字段columns- 字段数组- Returns:
- children
-
orderByDesc
public <R> Children orderByDesc(boolean condition, String alias, List<com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?>> columns) - Specified by:
orderByDescin interfaceFunc<T>
-
orderByDesc
@SafeVarargs public final <R> Children orderByDesc(com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?>... columns) - Specified by:
orderByDescin interfaceFunc<T>
-
orderByDesc
@SafeVarargs public final <R> Children orderByDesc(String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?>... columns) - Specified by:
orderByDescin interfaceFunc<T>
-
orderByDesc
@SafeVarargs public final <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) - Specified by:
orderByDescin interfaceFunc<T>
-
orderByDesc
@SafeVarargs public final <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")
- Specified by:
orderByDescin interfaceFunc<T>- Parameters:
condition- 执行条件column- 单个字段columns- 字段数组- Returns:
- children
-
orderBy
@SafeVarargs public final <X> Children orderBy(boolean condition, boolean isAsc, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?>... columns) Description copied from interface:Func排序:ORDER BY 字段, ...例: orderBy(true, "id", "name")
-
orderBy
@SafeVarargs public final <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) -
columnSqlInjectFilter
protected <X> com.baomidou.mybatisplus.core.toolkit.support.SFunction<X,?> columnSqlInjectFilter(com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column) 字段 SQL 注入过滤处理,子类重写实现过滤逻辑- Parameters:
column- 字段内容
-
having
Description copied from interface:FuncHAVING ( sql语句 )例1: having("sum(age) > 10")
例2: having("sum(age) > {0}", 10)
-
func
-
not
内部自用NOT 关键词
-
and
内部自用拼接 AND
-
likeValue
protected <X> Children likeValue(boolean condition, com.baomidou.mybatisplus.core.enums.SqlKeyword keyword, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, Object val, com.baomidou.mybatisplus.core.enums.SqlLike sqlLike) 内部自用拼接 LIKE 以及 值
-
likeValue
-
addCondition
protected <X> Children addCondition(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, com.baomidou.mybatisplus.core.enums.SqlKeyword sqlKeyword, Object val) 普通查询条件- Parameters:
condition- 是否执行column- 属性sqlKeyword- SQL 关键词val- 条件值
-
addCondition
protected <X,R> Children addCondition(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, com.baomidou.mybatisplus.core.enums.SqlKeyword sqlKeyword, Class<R> clazz, MPJLambdaWrapper<R> val) -
addCondition
-
addCondition
-
addNestedCondition
多重嵌套查询条件- Parameters:
condition- 查询条件值
-
instance
子类返回一个自己的新对象 -
instanceEmpty
-
instance
-
formatSqlMaybeWithParam
格式化 sql支持 "{0}" 这种,或者 "sql {0} sql" 这种
- Parameters:
sqlStr- 可能是sql片段params- 参数- Returns:
- sql片段
-
formatParam
处理入参- Parameters:
mapping- 例如: "javaType=int,jdbcType=NUMERIC,typeHandler=xxx.xxx.MyTypeHandler" 这种param- 参数- Returns:
- value
-
maybeDo
函数化的做事- Parameters:
condition- 做不做something- 做什么- Returns:
- Children
-
inExpression
获取in表达式 包含括号- Parameters:
value- 集合
-
inExpression
获取in表达式 包含括号- Parameters:
values- 数组
-
clear
public void clear()- Specified by:
clearin classcom.baomidou.mybatisplus.core.conditions.Wrapper<T>
-
appendSqlSegments
protected void appendSqlSegments(com.baomidou.mybatisplus.core.conditions.ISqlSegment... sqlSegments) 添加 where 片段- Parameters:
sqlSegments- ISqlSegment 数组
-
getSqlSegment
- Specified by:
getSqlSegmentin interfacecom.baomidou.mybatisplus.core.conditions.ISqlSegment
-
getSqlComment
- Overrides:
getSqlCommentin classcom.baomidou.mybatisplus.core.conditions.Wrapper<T>
-
getSqlFirst
- Overrides:
getSqlFirstin classcom.baomidou.mybatisplus.core.conditions.Wrapper<T>
-
getExpression
public com.baomidou.mybatisplus.core.conditions.segments.MergeSegments getExpression()- Specified by:
getExpressionin classcom.baomidou.mybatisplus.core.conditions.Wrapper<T>
-
getParamAlias
-
setParamAlias
参数别名设置,初始化时优先设置该值、重复设置异常- Parameters:
paramAlias- 参数别名- Returns:
- Children
-
columnToSqlSegment
protected final <X> com.baomidou.mybatisplus.core.conditions.ISqlSegment columnToSqlSegment(Integer index, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, boolean orderBy) 获取 columnName -
columnToSqlSegmentS
-
columnToSqlSegment
protected final com.baomidou.mybatisplus.core.conditions.ISqlSegment columnToSqlSegment(String column) -
columnToString
protected abstract <X> String columnToString(Integer index, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<X, ?> column, boolean isJoin, PrefixEnum prefixEnum, boolean orderBy) 获取 columnName -
columnToString
-
columnsToString
-
columnsToString
-
columnsToString
public <X> String columnsToString(Integer index, PrefixEnum prefixEnum, String alias, boolean orderBy, List<X> columns) -
clone
-
eq
public <R,S> Children eq(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, String rightAlias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<S, ?> val) Description copied from interface:OnCompare等于 = -
ne
public <R,S> Children ne(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, String rightAlias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<S, ?> val) Description copied from interface:OnCompare不等于 <> -
gt
public <R,S> Children gt(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, String rightAlias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<S, ?> val) Description copied from interface:OnCompare大于 > -
ge
public <R,S> Children ge(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, String rightAlias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<S, ?> val) Description copied from interface:OnCompare大于等于 >= -
lt
public <R,S> Children lt(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, String rightAlias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<S, ?> val) Description copied from interface:OnCompare小于 < -
le
public <R,S> Children le(boolean condition, String alias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<R, ?> column, String rightAlias, com.baomidou.mybatisplus.core.toolkit.support.SFunction<S, ?> val) Description copied from interface:OnCompare小于等于 <= -
allEqStr
Description copied from interface:CompareStrmap 所有非空属性等于 =- Specified by:
allEqStrin interfaceCompareStr<T,Children extends JoinAbstractWrapper<T, Children>> - Parameters:
condition- 执行条件params- map 类型的参数, key 是字段名, value 是字段值null2IsNull- 是否参数为 null 自动执行 isNull 方法, false 则忽略这个字段\- Returns:
- children
-
allEqStr
public <V> Children allEqStr(boolean condition, BiPredicate<String, V> filter, Map<String, V> params, boolean null2IsNull) Description copied from interface:CompareStr字段过滤接口,传入多参数时允许对参数进行过滤- Specified by:
allEqStrin interfaceCompareStr<T,Children extends JoinAbstractWrapper<T, Children>> - Parameters:
condition- 执行条件filter- 返回 true 来允许字段传入比对条件中params- map 类型的参数, key 是字段名, value 是字段值null2IsNull- 是否参数为 null 自动执行 isNull 方法, false 则忽略这个字段- Returns:
- children
-
eq
Description copied from interface:CompareStr等于 =- Specified by:
eqin interfaceCompareStr<T,Children extends JoinAbstractWrapper<T, Children>> - Parameters:
condition- 执行条件column- 字段val- 值- Returns:
- children
-
ne
Description copied from interface:CompareStr不等于 <>- Specified by:
nein interfaceCompareStr<T,Children extends JoinAbstractWrapper<T, Children>> - Parameters:
condition- 执行条件column- 字段val- 值- Returns:
- children
-
gt
Description copied from interface:CompareStr大于 >- Specified by:
gtin interfaceCompareStr<T,Children extends JoinAbstractWrapper<T, Children>> - Parameters:
condition- 执行条件column- 字段val- 值- Returns:
- children
-
ge
Description copied from interface:CompareStr大于等于 >=- Specified by:
gein interfaceCompareStr<T,Children extends JoinAbstractWrapper<T, Children>> - Parameters:
condition- 执行条件column- 字段val- 值- Returns:
- children
-
lt
Description copied from interface:CompareStr小于 <- Specified by:
ltin interfaceCompareStr<T,Children extends JoinAbstractWrapper<T, Children>> - Parameters:
condition- 执行条件column- 字段val- 值- Returns:
- children
-
le
Description copied from interface:CompareStr小于等于 <=- Specified by:
lein interfaceCompareStr<T,Children extends JoinAbstractWrapper<T, Children>> - Parameters:
condition- 执行条件column- 字段val- 值- Returns:
- children
-
like
Description copied from interface:CompareStrLIKE '%值%'- Specified by:
likein interfaceCompareStr<T,Children extends JoinAbstractWrapper<T, Children>> - Parameters:
condition- 执行条件column- 字段val- 值- Returns:
- children
-
notLike
Description copied from interface:CompareStrNOT LIKE '%值%'- Specified by:
notLikein interfaceCompareStr<T,Children extends JoinAbstractWrapper<T, Children>> - Parameters:
condition- 执行条件column- 字段val- 值- Returns:
- children
-
likeLeft
Description copied from interface:CompareStrLIKE '%值'- Specified by:
likeLeftin interfaceCompareStr<T,Children extends JoinAbstractWrapper<T, Children>> - Parameters:
condition- 执行条件column- 字段val- 值- Returns:
- children
-
notLikeLeft
Description copied from interface:CompareStrLIKE '%值'- Specified by:
notLikeLeftin interfaceCompareStr<T,Children extends JoinAbstractWrapper<T, Children>> - Parameters:
condition- 执行条件column- 字段val- 值- Returns:
- children
-
likeRight
Description copied from interface:CompareStrLIKE '值%'- Specified by:
likeRightin interfaceCompareStr<T,Children extends JoinAbstractWrapper<T, Children>> - Parameters:
condition- 执行条件column- 字段val- 值- Returns:
- children
-
notLikeRight
Description copied from interface:CompareStrLIKE '值%'- Specified by:
notLikeRightin interfaceCompareStr<T,Children extends JoinAbstractWrapper<T, Children>> - Parameters:
condition- 执行条件column- 字段val- 值- Returns:
- children
-
between
Description copied from interface:CompareStrBETWEEN 值1 AND 值2- Specified by:
betweenin interfaceCompareStr<T,Children extends JoinAbstractWrapper<T, Children>> - Parameters:
condition- 执行条件column- 字段val1- 值1val2- 值2- Returns:
- children
-
notBetween
Description copied from interface:CompareStrNOT BETWEEN 值1 AND 值2- Specified by:
notBetweenin interfaceCompareStr<T,Children extends JoinAbstractWrapper<T, Children>> - Parameters:
condition- 执行条件column- 字段val1- 值1val2- 值2- Returns:
- children
-
isNull
Description copied from interface:FuncStr字段 IS NULL例: isNull("name")
-
isNotNull
Description copied from interface:FuncStr字段 IS NOT NULL例: isNotNull("name")
-
in
Description copied from interface:FuncStr字段 IN (value.get(0), value.get(1), ...)例: in("id", Arrays.asList(1, 2, 3, 4, 5))
- 注意!集合为空若存在逻辑错误,请在 condition 条件中判断
- 如果集合为 empty 则不会进行 sql 拼接
-
in
Description copied from interface:FuncStr字段 IN (v0, v1, ...)例: in("id", 1, 2, 3, 4, 5)
- 注意!数组为空若存在逻辑错误,请在 condition 条件中判断
- 如果动态数组为 empty 则不会进行 sql 拼接
-
notIn
Description copied from interface:FuncStr字段 NOT IN (value.get(0), value.get(1), ...)例: notIn("id", Arrays.asList(1, 2, 3, 4, 5))
-
notIn
Description copied from interface:FuncStr字段 NOT IN (v0, v1, ...)例: notIn("id", 1, 2, 3, 4, 5)
-
inSql
Description copied from interface:FuncStr字段 IN ( sql语句 )!! sql 注入方式的 in 方法 !!
例1: inSql("id", "1, 2, 3, 4, 5, 6")
例2: inSql("id", "select id from table where id < 3")
-
gtSql
Description copied from interface:FuncStr字段 > ( sql语句 )例1: gtSql("id", "1, 2, 3, 4, 5, 6")
例1: gtSql("id", "select id from table where name = 'JunJun'")
-
geSql
Description copied from interface:FuncStr字段 >= ( sql语句 )例1: geSql("id", "1, 2, 3, 4, 5, 6")
例1: geSql("id", "select id from table where name = 'JunJun'")
-
ltSql
Description copied from interface:FuncStr字段 < ( sql语句 )例1: ltSql("id", "1, 2, 3, 4, 5, 6")
例1: ltSql("id", "select id from table where name = 'JunJun'")
-
leSql
Description copied from interface:FuncStr字段 <= ( sql语句 )例1: leSql("id", "1, 2, 3, 4, 5, 6")
例1: leSql("id", "select id from table where name = 'JunJun'")
-
eqSql
Description copied from interface:FuncStr字段 = ( sql语句 )例1: eqSql("id", "1, 2, 3, 4, 5, 6")
例1: eqSql("id", "select id from table where name = 'JunJun'")
-
notInSql
Description copied from interface:FuncStr字段 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")
-
groupBy
Description copied from interface:FuncStr分组:GROUP BY 字段, ... -
orderBy
Description copied from interface:FuncStr排序:ORDER BY 字段, ... -
groupBy
Description copied from interface:FuncStr分组:GROUP BY 字段, ...例: groupBy("id")
-
groupByStr
Description copied from interface:FuncStr分组:GROUP BY 字段, ...例: groupBy(Arrays.asList("id", "name"))
- Specified by:
groupByStrin interfaceFuncStr<T,Children extends JoinAbstractWrapper<T, Children>> - Parameters:
condition- 执行条件columns- 字段数组- Returns:
- children
-
orderBy
Description copied from interface:FuncStr排序:ORDER BY 字段, ...例: orderBy(true, "id")
-
orderByStr
Description copied from interface:FuncStr排序:ORDER BY 字段, ...例: orderBy(true, Arrays.asList("id", "name"))
- Specified by:
orderByStrin interfaceFuncStr<T,Children extends JoinAbstractWrapper<T, Children>> - Parameters:
condition- 执行条件isAsc- 是否是 ASC 排序columns- 字段列表- Returns:
- children
-