hql查询返回对象问题，高手进

[Rainet_yang]

hibernate如何使用sql返回对象？如下面一条sql，我想获取对象，下面的不对，请问有什么方式吗？

String hql = "select d.* from department as d where departmentid not in (select distinct parentdepartmentid from department where parentdepartmentid is not null) and departmentid <> 1";

List<Department> department = session.createSQLQuery(hql).list();


我想在同一张表中过滤掉部分数据！是根据departmentid和parentdepartmentid这两个字段。

能把这sql转换成hql语句吗？

Exception：
java.lang.ClassCastException: [Ljava.lang.Object; cannot be cast to com.chuntsuan.vo.Department；

[rucypli]

不清楚hql

[关键我是洛哥]

String hql = "select d.* from department as d where d.departmentid not in (select distinct de.parentdepartmentid from department de where de.parentdepartmentid is not null) and d.departmentid <> 1";

[wms821]

String hql = "select d from com.chuntsuan.vo.Department d where d.departmentid not in (select distinct d2.parentdepartmentid from com.chuntsuan.vo.Department d2 where d2.parentdepartmentid is not null) and d.departmentid <> 1";

[di_wq]

String hql = "select d from com.chuntsuan.vo.Department d where d.departmentid not in (select distinct d2.parentdepartmentid from com.chuntsuan.vo.Department d2 where d2.parentdepartmentid is not null) and d.departmentid <> 1";