Object[] Select cont(*) from table Object[] group by

最新推荐文章于 2023-09-05 14:49:35 发布

tanzongbiao

最新推荐文章于 2023-09-05 14:49:35 发布

阅读量446

点赞数

分类专栏： Java 文章标签： Object[]

本文链接：https://blog.csdn.net/tanzongbiao/article/details/82527731

版权

Java 专栏收录该内容

183 篇文章 4 订阅

订阅专栏

String hql = "select count(examineid),subjectType " +
        " from StdExamineRecord " +
        " where enableflag=1 " +
        " group by subjectType "
        ;
List<Object[]> list = this.find(hql);
if(list != null && list.size() > 0){
    Object[] obj = null;
    for(int i=0; i<list.size(); i++){
        obj = list.get(i);
        if("科目一".equals(obj[1])){
            std.setSumPass(Integer.parseInt(obj[0].toString()));
            stdAll.setSumPass(stdAll.getSumPass() + std.getSumPass());
        }
    }
}

List<Object[]> list = workinghoursCostConfigRepo.findDefaultClassOfPrice(
        mySvc.getCurrentEmployee().getAppid());
if(list != null && list.size() > 0){
    Object[] obj = null;
    for(int i=0; i<list.size(); i++) {
        obj = list.get(i);
        System.out.println(obj[0] + " " + obj[1]);

        if ("A00级车".equals(obj[0])) {
            wcc.setClassOfPriceA00(obj[1].toString());
        }
    }
}