DetachedCriteria queryCriteria = DetachedCriteria.forClass(Rsvmain.class);
if (ObjectUtils.isNotEmpty(query.getUnitinfoName())) {
DetachedCriteria unitinfo = DetachedCriteria.forClass(Unitinfo.class);
unitinfo.add(Restrictions.like("unitnm", "%" + query.getUnitinfoName() + "%"));
unitinfo.setProjection(Property.forName("id"));
queryCriteria.add(Property.forName("unitinfoId").in(unitinfo));
}
if (ObjectUtils.isNotEmpty(query.getMemberName())) {
DetachedCriteria member = DetachedCriteria.forClass(Member.class);
member.add(Restrictions.disjunction()
.add(Restrictions.like("lastnm", "%" + query.getMemberName() + "%"))
.add(Restrictions.like("firstnm", "%" + query.getMembe
DetachedCriteria 实现多表关联,检索条件
最新推荐文章于 2021-05-21 12:24:48 发布