首页 > 其他 > 详细

循环中不要放入openSession()

时间:2015-05-21 01:20:36      阅读:270      评论:0      收藏:0      [点我收藏+]
for(Shop s:list) {
            System.out.println(s.getName());
            String sql="select shopId,sum(ele_bank+ele_card+water_card+water_bank+coal_card+coal_bank) as zonghe ,sum(sale_bank+sale_card) as  sale,sum(cigarette_card+cigarette_bank)  as bacco, sum(yidong_card+yidong_bank+dianxin_card+dianxin_bank)  as recharge from hs_shop_items  where  record_time like ‘%2013-12-12%‘ and shopId="+s.getId();
            Session officeSession=officeSessionFactory.openSession();
            officeSession.beginTransaction();
            SQLQuery queryOffice=officeSession.createSQLQuery(sql);
            List<ShopTransDTO>  r=queryOffice.addEntity(ShopTransDTO.class).list();
            res.add(r.get(0));
        }

如上图中的

1
2
Session officeSession=officeSessionFactory.openSession();
            officeSession.beginTransaction();

这个部分放在循环中是错误的

循环中不要放入openSession()

原文:http://www.cnblogs.com/toSeeMyDream/p/4518604.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!