sql转 mybatis plus lamdba 表达式where lock_status = 0 or lock_status = 1 and lock_time now and err_msg is null or err_msg =
Lambda表达式:
QueryWrapper<Entity> queryWrapper = new QueryWrapper<>();
queryWrapper.lambda().and(
qw -> qw.eq(Entity::getLockStatus, "0")
.or()
.and(
qw1 -> qw1.eq(Entity::getLockStatus, "1")
.lt(Entity::getLockTime, LocalDateTime.now())
)
).and(
qw -> qw.isNull(Entity::getErrMsg)
.or()
.eq(Entity::getErrMsg, "")
);
其中,Entity为实体类名称。
原文地址: https://www.cveoy.top/t/topic/fFly 著作权归作者所有。请勿转载和采集!