----------------------------------------------------------------------------dao--------------------------------------------------------------------------
/**
* 返回需要的属性值
*
* @return 返回一个集合
*/
@SuppressWarnings("unchecked")
public List<List<? extends Object>> findProperties()
{
return (List<List<? extends Object>>)ht.execute(new HibernateCallback()
{
public Object doInHibernate(Session session)
throws HibernateException,
SQLException
{
// 我想得到 usertable的id,userName 和 depttable的name属性值
String hql =
"select new list(u.id,u.userName,d.name) from User u join u.dept d ";
return session.createQuery(hql).list();
}
});
}
-------------------------------------------------------------------------测试代码(Service层省略)---------------------------------------------------------------------------------------------------------
// 通过hql返回一些属性
List<List<? extends Object>> list = userService.findProperties();
for (int i = 0; i < list.size(); i++)
{
for (Object str : list.get(i))
{
System.out.println(str);
}
System.out.println("-----------------------------------");
}