MyBatis-Plus 基础+进阶+实战 之 灵活使用lambda 构造sql 条件
MyBatis-Plus 基础+进阶+实战 之 灵活使用lambda 构造sql 条件
AI码师
发布于 2022-09-19 11:57:29
发布于 2022-09-19 11:57:29
B站、西瓜 有完整配套视频，免费观看
=
eq
eq(R column, Object val)
eq(boolean condition, R column, Object val)
alleq
allEq(Map<R, V> params)
allEq(Map<R, V> params, boolean null2IsNull)
allEq(boolean condition, Map<R, V> params, boolean null2IsNull)
!=
ne(R column, Object val)
ne(boolean condition, R column, Object val)
>
gt(R column, Object val)
gt(boolean condition, R column, Object val)
>=
ge(R column, Object val)
ge(boolean condition, R column, Object val)
<
lt(R column, Object val)
lt(boolean condition, R column, Object val)
<=
le(R column, Object val)
le(boolean condition, R column, Object val)
between
between(R column, Object val1, Object val2)
between(boolean condition, R column, Object val1, Object val2)
not Between
notBetween(R column, Object val1, Object val2)
notBetween(boolean condition, R column, Object val1, Object val2)
like
like %%
like(R column, Object val)
like(boolean condition, R column, Object val)
like %{param}
likeLeft(R column, Object val)
likeLeft(boolean condition, R column, Object val)
like {param}%
likeRight(R column, Object val)
likeRight(boolean condition, R column, Object val)
is null
isNull(R column)
isNull(boolean condition, R column)
is not null
isNotNull(R column)
isNotNull(boolean condition, R column)
in
in(R column, Collection<?> value)
in(boolean condition, R column, Collection<?> value)
not in
notIn(R column, Collection<?> value)
notIn(boolean condition, R column, Collection<?> value)
group by
groupBy(R... columns)
groupBy(boolean condition, R... columns)
order by ... asc/desc
orderByAsc(R... columns)
orderByAsc(boolean condition, R... columns)
orderByDesc(R... columns)
orderByDesc(boolean condition, R... columns)
orderBy(boolean condition, boolean isAsc, R... columns)
and
and(Consumer<Param> consumer)
and(boolean condition, Consumer<Param> consumer)
or
普通or
or()
or(boolean condition)
嵌套or
or(Consumer<Param> consumer)
or(boolean condition, Consumer<Param> consumer
成长心路 | 优质书单 | 面试资料
牛人故事 | 前沿技术 | 视频教程
本文参与 腾讯云自媒体分享计划，分享自微信公众号。
原始发表：2022-07-24，如有侵权请联系 cloudcommunity@tencent.com 删除
评论
登录后参与评论
推荐阅读
目录