SQLQuery返回的查询结果为Objecg[],我们要做的就是解析
Session session = getHibernateTemplate().getSessionFactory().openSession();
SQLQuery query2 = session.createSQLQuery("select sum(daypro_num),avg(daypro_num) from daypro_kissfly where prolineid =" + proline.getProlineid());
List messlist =query2.list();
System.out.println("哈哈:" + messlist.get(0));
for(Object obj : messlist){
if(obj instanceof Object[]){
Object[] array = (Object[]) obj;
System.out.println("查询到的求和字段为:" + array[0]);
System.out.println("查询到的均值字段为:" + array[1]);
messMap.put("sum", array[0]);
messMap.put("avg", array[1]);
}
}
session.close();