mybatis自动生成的Example如何使用or

最新推荐文章于 2024-07-10 14:02:35 发布

Away946

最新推荐文章于 2024-07-10 14:02:35 发布

阅读量1.1k

点赞数 1

文章标签： mybatis java

本文链接：https://blog.csdn.net/Away946/article/details/133994484

版权

where (条件1 and 条件2) or (条件3)

//条件1 and 条件2
hrmResumeExample.createCriteria()
.andNameEqualTo(user.get1())
.andPhoneEqualTo(user.get2());

//or (条件3 and 条件n)
hrmResumeExample.or(
hrmResumeExample.createCriteria()
.andTokenEqualTo(user.get3()));

where (条件1 and 条件2) and (条件3 or 条件4)

//条件1 and 条件2
example.createCriteria()
        .andEqualTo("isDeleted",IsDeleted.NOT_DELETED))
        .andEqualTo("parentId", projectCatalogEntity.getParentId());
//and (条件3 or 条件4)
example.and(example.createCriteria()
        .andEqualTo("name", projectCatalogEntity.getName())
        .orEqualTo("code", projectCatalogEntity.getCode()));