mybatis-plus常用的构造条件写法
|
setSqlSelect
|
设置 SELECT 查询字段
|
|
where
|
WHERE 语句，拼接 + WHERE 条件
|
|
and
|
AND 语句，拼接 + AND 字段=值
|
|
andNew
|
AND 语句，拼接 + AND (字段=值)
|
|
or
|
OR 语句，拼接 + OR 字段=值
|
|
orNew
|
OR 语句，拼接 + OR (字段=值)
|
|
eq
|
等于=
|
|
allEq
|
基于 map 内容等于=
|
|
ne
|
不等于<>
|
|
gt
|
大于>
|
|
ge
|
大于等于>=
|
|
lt
|
小于<
|
|
le
|
小于等于<=
|
|
like
|
模糊查询 LIKE
|
|
notLike
|
模糊查询 NOT LIKE
|
|
in
|
IN 查询
|
|
notIn
|
NOT IN 查询
|
|
isNull
|
NULL 值查询
|
|
isNotNull
|
IS NOT NULL
|
|
groupBy
|
分组 GROUP BY
|
|
having
|
HAVING 关键词
|
|
orderBy
|
排序 ORDER BY
|
|
orderAsc
|
ASC 排序 ORDER BY
|
|
orderDesc
|
DESC 排序 ORDER BY
|
|
exists
|
EXISTS 条件语句
|
|
notExists
|
NOT EXISTS 条件语句
|
|
between
|
BETWEEN 条件语句
|
|
notBetween
|
NOT BETWEEN 条件语句
|
|
addFilter
|
自由拼接 SQL
|
|
last
|
拼接在最后，例如：last(“LIMIT 1”)
|
mybatis-plus 官网文档: https://mp.baomidou.com/guide/page.html
