Hibernate关联查询返回实体类
宗轩浚兮 2007-04-23 04:27:20 大家好,我在做jsf+hibernate项目时遇到一个问题:
我需要查询两个关联表的某些字段,然后在jsf中的dataModel中显示。但是大家知道,当我用"select u.name,
a.apptime,a.requesttime from Appointment as a, Users u"
+ " order by a.apptime desc"的HQL进行查询的话,返回的时Object[],所以在不能直接放在JSF中的
dataModel中取类的属性。而用"select new Appointment(a.id,
a.apptime,a.requestime) from Appointment as a"
+ " order by a.apptime desc" 进行对象查询可以返回实体类,但是我需要的Users里面的属性就取不到了. 如
果类似这样写的话"select new Appointment(a.id, a.apptime,a.requestime), new
Users(u.name) from Appointment as a"
+ " order by a.apptime desc" 会报语法错误,错误为"unexpected token: , near
line 1, column 87 [select new Appointment(a.id, a.users, a.apptime,
a.requesttime, a.apptype, a.appstate), new Users(u.name) from
managedservice.model.entityobjects.Appointment as a order by a.apptime
desc]"
不知道各位高手有什么办法将这样的查询返回成实体类,以便在前台页面上dataModel中直接使用.
如果是object[]的话,有什么样的办法可以解析它,然后在前台的dataModel中进行调用呢?
这个问题困绕我几天了。希望能得到解答.谢谢!