批量写入含Clob类型的数据_clob怎么批量编辑-优快云博客

本文介绍了一个使用Hibernate框架批量插入工作计划的方法。通过遍历列表并为每个元素创建对应的实体对象，利用BeanUtils复制属性值，并处理了备注字段的CLOB类型存储问题。文章详细展示了如何在事务控制下进行数据库操作，确保数据的一致性和完整性。

public void insertWorkProjects(List<WorkProjectVO> listWorkProject)
   throws CustomException {
  Session session = null;
  Transaction transaction = null;
  try {
   session = HibernateSessionFactory.getSession();
   transaction = session.beginTransaction();
   //循环保存工作计划的每条任务
   for(int i=0;i<listWorkProject.size();i++){
    WorkProjectVO workProjectVO = listWorkProject.get(i);
    WorkProject workProject = new WorkProject();
    BeanUtils.copyProperties(workProject, workProjectVO);
    //空格
    workProject.setRemark(Hibernate.createClob(" "));
    session.save(workProject);
    // 调用flush方法，强制Hibernate立即执行insert sql
    session.flush();
    // 通过refresh方法，强制Hibernate执行select for update
    session.refresh(workProject, LockMode.UPGRADE);
    // 向Clob写入实际内容#
    SerializableClob cb = (SerializableClob)workProject.getRemark();
    java.sql.Clob wrapClob = cb.getWrappedClob();
    if(wrapClob instanceof oracle.sql.CLOB){
     oracle.sql.CLOB clob=(oracle.sql.CLOB) wrapClob;
     java.io.Writer writer = clob.getCharacterOutputStream();
     writer.write(workProjectVO.getRemarkStr());
     writer.close();
    }

    session.save(workProject);
   }
   transaction.commit();
  } catch (HibernateException e) {
   sysLogger.error(e.getMessage());
   if (null != transaction) {
    transaction.rollback();
   }
   throw new CustomException(e, msgBaseHibernateDAO001);
  } catch (CustomException e) {
   sysLogger.error(e.getMessage());
   if (null != transaction) {
    transaction.rollback();
   }
   throw e;
  } catch (Exception e) {
   sysLogger.error(e.getMessage());
   if (null != transaction) {
    transaction.rollback();
   }
   throw new CustomException(e, msgBaseHibernateDAO001);
  } finally {
   if (null != session) {
    HibernateSessionFactory.closeSession();
   }
  }
}