如果有这样一个POJO名为Person:
它有非集合属性,还有集合属性
比如
private long id;
private String name;
private List<Hobby> hobbies= new AutoPopulatingList<Hobby>(Hobby.class);
POJO名为Hobby有以下属性:
private long sid:
private String hobbyName;
如果想查询姓名(name)为"张三",且爱好是"篮球"的所有符合条件的人
就需要用到子查询语句:
Hql="From Person p where name = :name and hobbies.hobbyName in (select h.hobbyName from Hobby h where hobbyName = :hobbyName);
Query q = sessionFactory.getCurrentSession().createQuery(Hql);
/*绑定查询条件变量*/
q.setString("name",name);
q.setString("hobbyName","hobbyName");
List<Hobby> list = q.list();
这样就可以得出想要的查询结果了。
但是,这种方式仅限hibernate 3.2.2版本以前,版本以后都会出现
org.hibernate.QueryException: illegal attempt to dereference collection
错误,推荐用以下方法写
/
Hql="From Person p where name = :name and hobbies.hobbyName exists (select 1 from Hobby h where hobbyName = :hobbyName);
完美运行