从最上面查下去
ResourcesBooking 把它设置成Criteria criteria = this.getSession().createCriteria(ResourcesBooking.class);
criteria.create("resources","r");
criteria.add(Restrictions.in("r.字段", “值”));
criteria.add("r.libraryBranches.字段",值");
这样就是三个关系了
Criteria 换个思路以libraryBranches去查
举个例子
Class ResourcesBooking{
Integer id;
String bookingstartdate;
Set
}
Class Resource{
Integer id;
String resourcesno;
ResourcesBooking rs;
Set
}
Class LibraryBranche{
Integer id;
Resource rc;
String code;
}
String hql = “select ResourcesBooking from ResourcesBooking,Resource,LibraryBranche where ResourcesBooking.id = Resource.rs.id and Resource.id = LibraryBranche.rc.id and
ResourcesBooking.bookingstartdate = :0 and Resource.resourcesno = :1 and LibraryBranche.code = :2”;