herbernate 批量更新

最新推荐文章于 2021-01-19 07:58:16 发布

mazhenxing0805

最新推荐文章于 2021-01-19 07:58:16 发布

阅读量453

点赞数

分类专栏：工作文章标签： 20180425

本文链接：https://blog.csdn.net/mazhenxing0805/article/details/80082792

版权

工作专栏收录该内容

8 篇文章 0 订阅

订阅专栏

Session session = null;
try {
   session = getSession();
   String hqlUpdate = "update com.xes.jzh.core.domain.ClassGroup set is_cancel_stick = :isCancelStick, update_time = :updateTime where group_id = :groupId";
   ClassGroup obj = null;
   for (int i = 0; i < list.size(); i++) {
      obj = list.get(i);
      obj.setIsCancelStick("1");
      session.createQuery(hqlUpdate)
            .setString( "isCancelStick", "1" )
            .setString( "updateTime", System.currentTimeMillis()+"" )
            .setString( "groupId", obj.getGroupId())
            .executeUpdate();
      if (i % 20 == 0) {
         session.flush();
         session.clear();
      }
   }
   session.flush();
   session.clear();
} catch (Exception e) {
   session.getTransaction().rollback();
   throw new RuntimeException(e);

} finally {
   closeSession(session);
}