Package com.github.yulichang.query

Class MPJQueryWrapper<T>

java.lang.Object

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

com.baomidou.mybatisplus.core.conditions.AbstractWrapper<T,String,MPJQueryWrapper<T>>

com.github.yulichang.query.MPJQueryWrapper<T>

All Implemented Interfaces:

com.baomidou.mybatisplus.core.conditions.interfaces.Compare<MPJQueryWrapper<T>,String>, com.baomidou.mybatisplus.core.conditions.interfaces.Func<MPJQueryWrapper<T>,String>, com.baomidou.mybatisplus.core.conditions.interfaces.Join<MPJQueryWrapper<T>>, com.baomidou.mybatisplus.core.conditions.interfaces.Nested<MPJQueryWrapper<T>,MPJQueryWrapper<T>>, com.baomidou.mybatisplus.core.conditions.ISqlSegment, com.baomidou.mybatisplus.core.conditions.query.Query<MPJQueryWrapper<T>,T,String>, MPJBaseJoin<T>, CompareIfExists<MPJQueryWrapper<T>,String>, StringJoin<MPJQueryWrapper<T>,T>, Chain<T>, Serializable

public class MPJQueryWrapper<T>
extends com.baomidou.mybatisplus.core.conditions.AbstractWrapper<T,String,MPJQueryWrapper<T>>
implements com.baomidou.mybatisplus.core.conditions.query.Query<MPJQueryWrapper<T>,T,String>, StringJoin<MPJQueryWrapper<T>,T>, Chain<T>, CompareIfExists<MPJQueryWrapper<T>,String>

copy QueryWrapper 推荐使用 JoinWrappers.<UserDO>query();构造

Author:

yulichang

See Also:

• JoinWrappers
• Serialized Form

Nested Class Summary

Nested classes/interfaces inherited from class com.baomidou.mybatisplus.core.conditions.AbstractWrapper

com.baomidou.mybatisplus.core.conditions.AbstractWrapper.DoSomething

Field Summary

Fields inherited from class com.baomidou.mybatisplus.core.conditions.AbstractWrapper

expression, lastSql, paramAlias, paramNameSeq, paramNameValuePairs, sqlComment, sqlFirst, typedThis

Constructor Summary

Constructors

Constructor	Description
MPJQueryWrapper()
MPJQueryWrapper(Class<T> clazz)
MPJQueryWrapper(T entity)
MPJQueryWrapper(T entity, Class<T> entityClass, AtomicInteger paramNameSeq, Map<String,Object> paramNameValuePairs, com.baomidou.mybatisplus.core.conditions.segments.MergeSegments mergeSegments, com.baomidou.mybatisplus.core.conditions.SharedString sqlSelect, com.baomidou.mybatisplus.core.conditions.SharedString from, com.baomidou.mybatisplus.core.conditions.SharedString lastSql, com.baomidou.mybatisplus.core.conditions.SharedString sqlComment, com.baomidou.mybatisplus.core.conditions.SharedString sqlFirst, List<String> selectColumns, List<String> ignoreColumns, boolean selectDistinct, BiPredicate<Object,IfExistsSqlKeyWordEnum> IfExists)	非对外公开的构造方法,只用于生产嵌套 sql

Method Summary

Modifier and Type	Method	Description
MPJQueryWrapper<T>	checkSqlInjection()	开启检查 SQL 注入
void	clear()
protected String	columnToString(String column)
MPJQueryWrapper<T>	disableLogicDel()	关闭主表逻辑删除
MPJQueryWrapper<T>	distinct()	sql去重 select distinct
MPJQueryWrapper<T>	enableLogicDel()	启用主表逻辑删除
Class<T>	getEntityClass()
String	getFrom()
boolean	getLogicSql()	逻辑删除
boolean	getSelectDistinct()
com.baomidou.mybatisplus.core.conditions.SharedString	getSqlFirstField()
String	getSqlSelect()
String	getSubLogicSql()	逻辑删除
String	getTableName(String tableName)
String	getTableNameEnc(String tableName)
protected MPJQueryWrapper<T>	instance()	用于生成嵌套 sql
boolean	isResultMapCollection()
MPJQueryWrapper<T>	join(String keyWord, boolean condition, String joinSql, Object... params)
MPJLambdaQueryWrapper<T>	lambda()	返回一个支持 lambda 函数写法的 wrapper
protected final String	mpjFormatSqlMaybeWithParam(String sqlStr, Object... params)
MPJQueryWrapper<T>	select(boolean condition, List<String> columns)
MPJQueryWrapper<T>	select(Class<T> entityClass, Predicate<com.baomidou.mybatisplus.core.metadata.TableFieldInfo> predicate)	此方法只能用于主表 不含主键
MPJQueryWrapper<T>	select(String... columns)
final MPJQueryWrapper<T>	selectAll(Class<?> clazz, String as)	查询指定实体全部字段
final MPJQueryWrapper<T>	selectAll(Class<T> clazz)	查询主表全部字段
MPJQueryWrapper<T>	selectIgnore(String... columns)	忽略查询字段
MPJQueryWrapper<T>	setAlias(String alias)	设置主表别名 如果要用，请最先调用，
MPJQueryWrapper<T>	setEntityClass(Class<T> entityClass)
MPJQueryWrapper<T>	setIfExists(BiPredicate<Object,IfExistsSqlKeyWordEnum> IfExists)
MPJQueryWrapper<T>	setIfExists(Predicate<Object> IfExists)
MPJQueryWrapper<T>	setTableName(Function<String,String> func)	动态表名

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

addCondition, addNestedCondition, allEq, allEq, and, and, appendSqlSegments, apply, between, clone, columnsToString, columnsToString, columnToSqlSegment, comment, doGroupBy, doOrderBy, eq, eqSql, exists, first, formatParam, formatSqlMaybeWithParam, func, ge, geSql, getEntity, getExpression, getParamAlias, getParamNameValuePairs, getSqlComment, getSqlFirst, getSqlSegment, groupBy, groupBy, groupBy, groupBy, gt, gtSql, having, in, in, inExpression, inExpression, initNeed, inSql, isNotNull, isNull, isUseAnnotationOrderBy, last, le, leSql, like, likeLeft, likeRight, likeValue, lt, ltSql, maybeDo, ne, nested, not, not, notBetween, notExists, notIn, notIn, notInSql, notLike, notLikeLeft, notLikeRight, or, or, orderBy, orderBy, orderBy, orderBy, setEntity, setParamAlias

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, list, list, mapFirst, mapList, mapOne, mapPage, one, one, page, page

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

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

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

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

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

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

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

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

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

getDeleteLogicSql, getDeleteSql, getUnionSql

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

and, nested, not, or

Methods inherited from interface com.baomidou.mybatisplus.core.conditions.query.Query

select, select, select

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

MPJQueryWrapper

public MPJQueryWrapper()

MPJQueryWrapper

public MPJQueryWrapper(Class<T> clazz)

MPJQueryWrapper

public MPJQueryWrapper(T entity)

MPJQueryWrapper

public MPJQueryWrapper(T entity,
 Class<T> entityClass,
 AtomicInteger paramNameSeq,
 Map<String,Object> paramNameValuePairs,
 com.baomidou.mybatisplus.core.conditions.segments.MergeSegments mergeSegments,
 com.baomidou.mybatisplus.core.conditions.SharedString sqlSelect,
 com.baomidou.mybatisplus.core.conditions.SharedString from,
 com.baomidou.mybatisplus.core.conditions.SharedString lastSql,
 com.baomidou.mybatisplus.core.conditions.SharedString sqlComment,
 com.baomidou.mybatisplus.core.conditions.SharedString sqlFirst,
 List<String> selectColumns,
 List<String> ignoreColumns,
 boolean selectDistinct,
 BiPredicate<Object,IfExistsSqlKeyWordEnum> IfExists)

非对外公开的构造方法,只用于生产嵌套 sql

Parameters:

entityClass - 本不应该需要的

Method Details

checkSqlInjection

public MPJQueryWrapper<T> checkSqlInjection()

开启检查 SQL 注入

setIfExists

public MPJQueryWrapper<T> setIfExists(BiPredicate<Object,IfExistsSqlKeyWordEnum> IfExists)

setIfExists

public MPJQueryWrapper<T> setIfExists(Predicate<Object> IfExists)

columnToString

protected String columnToString(String column)

Overrides:

columnToString in class com.baomidou.mybatisplus.core.conditions.AbstractWrapper<T,String,MPJQueryWrapper<T>>

distinct

public MPJQueryWrapper<T> distinct()

sql去重 select distinct

select

public MPJQueryWrapper<T> select(String... columns)

Specified by:

select in interface com.baomidou.mybatisplus.core.conditions.query.Query<MPJQueryWrapper<T>,T,String>

select

public MPJQueryWrapper<T> select(boolean condition,
 List<String> columns)

Specified by:

select in interface com.baomidou.mybatisplus.core.conditions.query.Query<MPJQueryWrapper<T>,T,String>

selectIgnore

public MPJQueryWrapper<T> selectIgnore(String... columns)

忽略查询字段

用法: selectIgnore("t.id","t.sex","a.area")

Since:

1.1.3

select

public MPJQueryWrapper<T> select(Class<T> entityClass,
 Predicate<com.baomidou.mybatisplus.core.metadata.TableFieldInfo> predicate)

此方法只能用于主表 不含主键

Specified by:

select in interface com.baomidou.mybatisplus.core.conditions.query.Query<MPJQueryWrapper<T>,T,String>

Parameters:

entityClass - 主表class

predicate - 条件lambda

selectAll

public final MPJQueryWrapper<T> selectAll(Class<T> clazz)

查询主表全部字段

Parameters:

clazz - 主表class

selectAll

public final MPJQueryWrapper<T> selectAll(Class<?> clazz,
 String as)

查询指定实体全部字段

Parameters:

as - 实体对应的别名

getSqlSelect

public String getSqlSelect()

Specified by:

getSqlSelect in interface com.baomidou.mybatisplus.core.conditions.query.Query<MPJQueryWrapper<T>,T,String>

Overrides:

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

getSelectDistinct

public boolean getSelectDistinct()

getFrom

public String getFrom()

setAlias

public MPJQueryWrapper<T> setAlias(String alias)

设置主表别名 如果要用，请最先调用，

 正例  new QueryWrapper().setAlias("a").selectAll(UserDO.class)....
 反例  new QueryWrapper().selectAll(UserDO.class).setAlias("a")....
 

Parameters:

alias - 主表别名

getSubLogicSql

public String getSubLogicSql()

逻辑删除

disableLogicDel

public MPJQueryWrapper<T> disableLogicDel()

关闭主表逻辑删除

enableLogicDel

public MPJQueryWrapper<T> enableLogicDel()

启用主表逻辑删除

getLogicSql

public boolean getLogicSql()

逻辑删除

setTableName

public MPJQueryWrapper<T> setTableName(Function<String,String> func)

动态表名

如果主表需要动态表名

getTableName

public String getTableName(String tableName)

getTableNameEnc

public String getTableNameEnc(String tableName)

lambda

public MPJLambdaQueryWrapper<T> lambda()

返回一个支持 lambda 函数写法的 wrapper

getEntityClass

public Class<T> getEntityClass()

Specified by:

getEntityClass in interface Chain<T>

Overrides:

getEntityClass in class com.baomidou.mybatisplus.core.conditions.AbstractWrapper<T,String,MPJQueryWrapper<T>>

isResultMapCollection

public boolean isResultMapCollection()

Specified by:

isResultMapCollection in interface Chain<T>

setEntityClass

public MPJQueryWrapper<T> setEntityClass(Class<T> entityClass)

Overrides:

setEntityClass in class com.baomidou.mybatisplus.core.conditions.AbstractWrapper<T,String,MPJQueryWrapper<T>>

getSqlFirstField

public com.baomidou.mybatisplus.core.conditions.SharedString getSqlFirstField()

instance

protected MPJQueryWrapper<T> instance()

用于生成嵌套 sql

故 sqlSelect selectColumn ignoreColumns from不向下传递

Specified by:

instance in class com.baomidou.mybatisplus.core.conditions.AbstractWrapper<T,String,MPJQueryWrapper<T>>

clear

public void clear()

Overrides:

clear in class com.baomidou.mybatisplus.core.conditions.AbstractWrapper<T,String,MPJQueryWrapper<T>>

join

public MPJQueryWrapper<T> join(String keyWord,
 boolean condition,
 String joinSql,
 Object... params)

Specified by:

join in interface StringJoin<MPJQueryWrapper<T>,T>

mpjFormatSqlMaybeWithParam

protected final String mpjFormatSqlMaybeWithParam(String sqlStr,
 Object... params)