Page
<TestEntity> rpage
=
baseMapper
.selectPage(
new Page<>(pageBean
.getPageSize(), pageBean
.getPageNum()),
new QueryWrapper<TestEntity>()
.eq("siteid", siteid
)
.and(
wrapper
->
wrapper
.or()
.lt("createtime", updatetime
)
.or()
.lt("deletetime", updatetime
)
.or()
.lt("operatetime", updatetime
)
.or()
.lt("updatetime", updatetime
)));
and or 拼完后的结果是这样的:
new QueryWrapper<TestEntity>()
.eq("siteid", siteid
)
.and(
wrapper
->
wrapper
.or()
.lt("createtime", updatetime
)
.or()
.lt("deletetime", updatetime
)
.or()
.lt("operatetime", updatetime
)
.or()
.lt("updatetime", updatetime
)))
–>
SELECT
*
FROM
t
WHERE
useflag
= 1
AND (
siteid
=?
AND (
createtime
< ?
OR deletetime
< ?
OR operatetime
< ?
OR updatetime
< ?
))
转载请注明原文地址: https://lol.8miu.com/read-28412.html