阅读 193

Myabtis-Plus之QueryWrapper常用方法

AbstractWrapper 下的方法及使用

方法名 说明 使用
allEq(Map params) 全部 =(或个别 isNull) allEq(params,true)
eq = eq(“real_name”,“王昭君”)
ne <> ne(“nick_name”,“空想 4”)
gt > gt(“age”,21)
ge >= ge(“age”,22)
lt < lt(“age”,22)
le <= le(“age”,21")
between cloum between ? and ? between(“age”,0,21)
notBetween cloum between ? and ? notBetween(“age”,0,21)
like cloum like ‘% 王 %’ like(“real_name”,“王”)
notLike not like ‘% 王 %’ notLike(“real_name”,“王”)
likeLeft like ‘% 王’ likeLeft(“real_name”,“昭”)
likeRight like ‘王 %’ likeRight(“real_name”,“昭”)
isNull is null isNull(“gender”)
isNotNull is not null isNotNull(“gender”)
in in (1,2,3) in(“nick_name”,lists)
notIn age not in (1,2,3) notIn(“nick_name”,lists)
inSql age in (1,2,3,4,5,6) inSql(“nick_name”,"‘空想 4’,‘空想 5’,‘空想 6’")
notInSql age not in (1,2,3,4,5,6) notInSql(“nick_name”,"‘空想 4’,‘空想 5’,‘空想 6’")
groupBy group by id,name groupBy(“nick_name”,“age”)
orderByAsc order by id ASC,name ASC orderByAsc(“nick_name”,“age”)
orderByDesc order by id DESC,name DESC orderByDesc(“age”)
orderBy order by id ASC,name ASC orderBy(true,true,“age”)
having having sum(age) > 10 having(“sum(age) > 10”)
or id = 1 or name = ‘老王’ eq(“nick_name”,“空想 4”).or(i->i.eq(“age”,21) eq(“nick_name”,“空想 4”).or().eq(“nick_name”,“空想 5”)
and and (name = ‘李白’ and status <> ‘活着’) and(i->i.eq(“age”,21))
nested (name = ‘李白’ and status <> ‘活着’) nested(i->i.eq(“age”,21).eq(“nick_name”,“空想 4”))
apply id = 1 apply(“nick_name = ‘空想 4’”)
last 最后添加多个以最后的为准,有 sql 注入风险 last(“limit 1”)
exists 拼接 EXISTS (sql 语句) exists(“select id from table where age = 1”)
notExists 拼接 NOT EXISTS (sql 语句) notExists(“select id from table where age = 1”)

QueryWrapper

继承自 AbstractWrapper , 自身的内部属性 entity 也用于生成 where 条件
及 LambdaQueryWrapper, 可以通过 new QueryWrapper().lambda() 方法获取

方法名 说明 使用
select select(i -> i.getProperty().startsWith(“test”)) select(“id”, “name”, “age”)

UpdateWrapper

继承自 AbstractWrapper , 自身的内部属性 entity 也用于生成 where 条件
及 LambdaUpdateWrapper, 可以通过 new UpdateWrapper().lambda() 方法获取!

方法名 说明 使用
set set(“name”, “老李头”) set(“name”, “”)
setSql setSql(“name = ‘老李头’”) setSql(String sql)

参考于https://blog.csdn.net/qq_43399077/article/details/104061760

原文:https://www.cnblogs.com/yuyueq/p/14639016.html

文章分类
代码人生
版权声明:本站是系统测试站点,无实际运营。本文内容由互联网用户自发贡献,该文观点仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容, 请发送邮件至 gxwowoo@163.com 举报,一经查实,本站将立刻删除。
相关推荐