Hibernate实现Oracle Blob/Clob类型数据读写

环境:Eclipse3.1+Hibernate2+Oracle 10g
说明:本例在使用Eclipse3.1通过一个Java项目来实现对Oracle中Blob/Clob类型数据的读写操作.
1.在oracle数据库中新建一个表,取名:BIGDATA,　sql语句如下:
  CREATE TABLE BIGDATA (id number NOT NULL,image blob,resume clob);//新建表
  ALTER TABLE BIGDATA ADD ( CONSTRAINT bigdata_pk PRIMARY KEY (id) USING INDEX );// 修改id为主键:

2.在Eclipse中新建一个java项目，取名:HibernateSample，项目中需要导入的jar文件可根据需要导入即可。
  新建一个源文件夹src,在src下新建一个包,取名bigDataAccess,在该包下新建一个类，取名DataModel.java,内容如下:
 package bigDataAccess;

import java.sql.Blob;
import java.sql.Clob;

public class DataModel {
 Long id;

 Blob image;

 Clob resume;

 public Long getId() {
  return id;
 }

 public void setId(Long id) {
  this.id = id;
 }

 public Blob getImage() {
  return image;
 }

 public void setImage(Blob image) {
  this.image = image;
 }

 public Clob getResume() {
  return resume;
 }

 public void setResume(Clob resume) {
  this.resume = resume;
 }
}

2.再在bigDataAccess包下新建一个类取名:HibernateUtil.java用于管理session,源代码如下:
package bigDataAccess;

import net.sf.hibernate.*;
import net.sf.hibernate.cfg.Configuration;

public class HibernateUtil {
 private static SessionFactory sessionFactory;

 public static final ThreadLocal session= new ThreadLocal();
 static {
  try {
   // 实例化一个SessionFactory对象 
   //System.out.println("通过静态模块创建一个SessionFactory");
   sessionFactory = new Configuration().configure()
     .buildSessionFactory();
  } catch (HibernateException ex) {
   throw new RuntimeException("Configuration problem:"
     + ex.getMessage(), ex);
  }
 } 
 public static Session currentSession() throws HibernateException {
  Session s = (Session) session.get();
  // 当原session为空或已关闭时,打一个新的Session
  if (s == null || !s.isOpen()) {
   s = sessionFactory.openSession();
   session.set(s);
  }
  return s;
 }

 public static void closeSession() throws HibernateException {
  Session s = (Session) session.get();  
  if (s != null) {
   s.close();
  }  
 }
}

2.在包bigDataAccess下新建映射文件bigDataAccess.hbm.xml,内容如下:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
    "-//Hibernate/Hibernate Mapping DTD 2.0//EN"
    "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd" >

<hibernate-mapping>
 <class name="bigDataAccess.DataModel" table="BIGDATA">
  <id name="id" type="long" column="ID">
   <generator class="increment" />
  </id>
  <property name="image"  type="java.sql.Blob"  column="image" />
  <property name="resume" type="java.sql.Clob"  column="resume" />
 </class>
</hibernate-mapping>
3.新建Hibernate配置文件于src目录下,hibernate.cfg.xml内容如下
 <?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD//EN"
                                         "http://hibernate.sourceforge.net/hibernate-configuration-2.0.dtd">

<hibernate-configuration>
 <session-factory>
  <property name="hibernate.connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
  <property name="hibernate.connection.url">jdbc:oracle:thin:@localhost:1521:orcl</property>
  <property name="hibernate.connection.username">work</property>
  <property name="hibernate.connection.password">caecaodb</property>
  <property name="hibernate.show_sql">true</property>
  <property name="dialect">net.sf.hibernate.dialect.OracleDialect</property>
<!--这句一定要加上，否则会报错，因为Oracle JDBC不允许流操作以批量方式进行，因此要关闭-->   
  <property name="hibernate.jdbc.batch_size">0</property>
  <mapping resource="bigDataAccess/bigDataAccess.hbm.xml"/>  
 </session-factory>
</hibernate-configuration>
4.在包bigDataAccess下新建一个带有main()函数的类，取名HibernateTest.java,源代码如下:
package bigDataAccess;
//注意要导入正确有包

public class HibernateTest{

 public HibernateTest() throws HibernateException, SQLException, IOException {
  doit();
 }

 public static void main(String[] args) throws HibernateException,
   SQLException, IOException {
  new HibernateTest();

 }

 public void doit() throws HibernateException, SQLException, IOException {

  // Blog,Clob类型数据读写---------write

  /*
   * Oracle Blob/Clob字段本身有一个游标(cursor),
   * JDBC通过游标对Blob/Clob字段进行操作，在Blob/Clob字段被创建之前，
   * 无法获得其游标句柄，因此必须首先创建一个空Blob/Clob字段，再从空这个空Blob/Clob字段获取游标，再写入要保存的数据
   */
  System.out.println("写入数据");
  Session session = HibernateUtil.currentSession();
  Transaction tx = session.beginTransaction();

  DataModel info = new DataModel();
  info.setImage(Hibernate.createBlob(new byte[1]));
  info.setResume(Hibernate.createClob(" "));// 这里的参数是一个空格
  session.save(info);
  session.flush();// 强制执行insert
  // 通过refresh方法，强制Hibernate执行select for update
  session.refresh(info, LockMode.UPGRADE);

  // 向Blog写入实际内容
  oracle.sql.BLOB blob = (oracle.sql.BLOB) info.getImage();
  FileInputStream imgis = new FileInputStream("d://image.jpg");//在d:/根目录下放一个image.jpg的文件
  OutputStream out = blob.getBinaryOutputStream();
  byte[] buf = new byte[10240];
  int len;
  while ((len = imgis.read(buf)) > 0) {
   out.write(buf, 0, len);
  }
  imgis.close();
  out.close();

  // 向Clob写入实际内容
  oracle.sql.CLOB clob = (oracle.sql.CLOB) info.getResume();
  Writer writer = clob.getCharacterOutputStream();
  writer.write("this is my resume");
  writer.close();

  session.save(info);
  tx.commit();
  //读取刚才写入数据库的数据
  System.out.println("读取数据");
  DataModel info1 = (DataModel) session
    .load(DataModel.class, new Long(1));
  Clob resume = info1.getResume();
  System.out.println("resume="
    + resume.getSubString(1, (int) resume.length()));

  Blob img = info1.getImage();
  InputStream is = img.getBinaryStream();
  FileOutputStream fos = new FileOutputStream("d://outimage.jpg");//读取到d:/outimage.jpg
  byte[] buf1 = new byte[10240];
  int len1;
  while ((len1 = is.read(buf1)) != -1) {
   fos.write(buf1, 0, len1);
  }
  fos.close();
  is.close();
  session.close();
}

右击HibernateTest.java，将其运行为java应用程序,查询bigdata表则会新增了一条记录，d:/有一个名为:outimage.jpg的文件，说明成功