Hql结果不是理想的Domain object时

很多时候因为需求写hql会比较复杂，常常返回不是理想的Domain object的list，而是其它object,或是一个数组的list集合，若是单一的object还好说，那么如何将这个object分解取出呢:)
a simpe sample:

Iterator it = session.createQuery("select c.id, c.name, count(o)"
+" from Customer c join c.orders o group by c.id").list().iterator();
		while(it.hasNext())
		{
			Object[] pair = (Object[])it.next();
			Long id = (Long)pair[0];
			String name = (String)pair[1];
			Integer count = (Integer)pair[2];
		}

评论

1 楼 colin4k 2007-11-27  

Iterator<TestObj> it = session.createQuery("select new com.test.TestObj(c.id, c.name, count(o))"  
+" from Customer c join c.orders o group by c.id").list().iterator();   
        while(it.hasNext())   
        {   
            TestObj obj = it.next();   
        }