hibernate如何多函数查询
Query query=session.createSQLQuery("select count(*), sum(age)from stu ");
List list=new ArrayList();
list=query.list();
for (Iterator iterator = list.iterator(); iterator.hasNext();) {
Object[] object = (Object[]) iterator.next();
System.out.println(object[0]+" "+object[1]);
}
请问这样获取2个函数的值有什么不对吗?为什么得到的是2个重复的值,坐等高人指点!
[解决办法]
我把你的代码考下来测试了一下,你那个迭代遍历
for (Iterator iterator = list.iterator(); iterator.hasNext();) {
好像有点问题吧
Iterator iterator=list.iterator();
while(iterator.hasNext()){
//System.out.println(iterator.next());
Object[] object =(Object[]) iterator.next();
System.out.println(object[0]+" "+object[1]+" "+object[2]);
}