Question

hibernate 遍历createSQLQuery的结果集 sql语句中含有函数

select AVG(comment_score ) as total_score ,AVG(comment_test ) as test_score,AVG(comment_env ) as env_score, AVG(comment_ser ) as ser_score from dzdp_comments where merchant_id =1
List list =session.createSQLQuery(sql).addScalar("total_score",Hibernate.INTEGER).list();
现在我要显示list中的数据 total_score，env_score，ser_score如何遍历

Answer 1

List<Object[]> list =session.createSQLQuery(sql).addScalar("total_score",Hibernate.INTEGER).list();

然后遍历 list
for(Object[] obj:list){
obj[0] 就是 total_score

obj[1] 就是env_score

obj[2] 就是ser_score

}