有關hibernate中用distinct傳回值總結

1.如果查詢單個欄位返回String型

直接用list.get(i)即是返回的那個欄位值

 

2.多個返回Object[]型，已經過測試
Session session = sessionFactory.openSession();
String hql = "select distinct d.username,d.address from Demo d ";
Query query = session.createQuery(hql);
List l = query.list();
for (Iterator it = l.iterator(); it.hasNext();) {
Object[] d=(Object[])it.next();
System.out.println(d[0]);
System.out.println(d[1]);
}