如何使用Hibernate的HQL和Criteria api表达此查询？
选择CITIES。*来自CITIES的CITIES.STATE_ID（来自STATES WHATES STATES.COUNTRY_ID = 78的STATES.STATE_ID）
编辑：
这是课程
Country.java
Integer id;
String name;
Integer id;
Integer countryId;
String name;
Integer id;
Integer stateId;
String name;
没有找到相关结果
已邀请:
2 个回复
钨蜡唤喉晤
DetachedCriteria ownerCriteria = DetachedCriteria.forClass(State.class); ownerCriteria.setProjection(Property.forName("id")); ownerCriteria.add(Restrictions.eq("countryId", countryParam)); Criteria criteria = getSession().createCriteria(City.class); criteria.add(Property.forName("stateId").in(ownerCriteria));物崎巩
ICriteria crit = session.CreateCriteria <City>(); crit.CreateAlias ("State", "s"); crit.CreateAlias ("s.Country", "cntry"); crit.Add (Expression.Eq ("cntry.Id", 78)); var results = crit.List<City>();