select count(*) as '总人数',sum(salary_sum) as '薪酬总额',first_kind_id as '一级机构',second_kind_id as '二级机构'
from human_file group by first_kind_id ,second_kind_id
怎么能这条sql返回的List遍历出来呢?
select count(*) as '总人数',sum(salary_sum) as '薪酬总额',first_kind_id as '一级机构',second_kind_id as '二级机构'
from human_file group by first_kind_id ,second_kind_id
怎么能这条sql返回的List遍历出来呢?
for (Object[] o : os) {
System.out.println("总人数:"+0[0].intValue()+"薪酬总额"+o[1].doubleValue+"一级机构"+o[2].toString()+"二级机构"+o[3].toString());
}