很多时候因为需求写hql会比较复杂,常常返回不是理想的Domain object的list,而是其它object,或是一个数组的list集合,若是单一的object还好说,那么如何将这个object分解取出呢:)
a simpe sample:
[code]
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];
}
[/code]
:D
a simpe sample:
[code]
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];
}
[/code]
:D