Hibernate读写Clob和Blob类型字段

数据库脚本：

create   table  testcb(id  varchar ( 32 )  primary   key ,name  varchar ( 32 ),photo blob,description  text );

 Hibernate.cfg.xml

 

<? xml version='1.0' encoding='UTF-8' ?>
<! DOCTYPE hibernate-configuration PUBLIC
          "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
          "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd" >

<!--  Generated by MyEclipse Hibernate Tools.                    -->
< hibernate-configuration >

< session-factory >
     < property  name ="connection.username" > root </ property >
     < property  name ="connection.url" >
        jdbc:mysql://localhost:3306/schoolproject?characterEncoding=gb2312 &amp; useUnicode=true
     </ property >
     < property  name ="dialect" >
        org.hibernate.dialect.MySQLDialect
     </ property >
     < property  name ="myeclipse.connection.profile" > mysql </ property >
     < property  name ="connection.password" > 1234 </ property >
     < property  name ="connection.driver_class" >
        com.mysql.jdbc.Driver
     </ property >
     < property  name ="hibernate.dialect" >
        org.hibernate.dialect.MySQLDialect
     </ property >
     < property  name ="hibernate.show_sql" > true </ property >
     < property  name ="current_session_context_class" > thread </ property >
     < mapping  resource ="Search/Clob_Blob/TestCB.hbm.xml"   />

</ session-factory >

</ hibernate-configuration >

 

POJO：

 

package  Search.Clob_Blob;

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

public   class  TestCB  ... {
    private String id; //标识id
    private String name; //学生姓名
    private Blob photo;
    private Clob description;
    public String getId() ...{
        return id;
    }
    public void setId(String id) ...{
        this.id = id;
    }
    public String getName() ...{
        return name;
    }
    public void setName(String name) ...{
        this.name = name;
    }
    public Blob getPhoto() ...{
        return photo;
    }
    public void setPhoto(Blob photo) ...{
        this.photo = photo;
    }
    public Clob getDescription() ...{
        return description;
    }
    public void setDescription(Clob description) ...{
        this.description = description;
    }
    
  
}

 

TestCB.hbm.xml

 

<? xml version="1.0" encoding="utf-8" ?>
<! DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd" >
<!--  
    Mapping file autogenerated by MyEclipse - Hibernate Tools
-->
< hibernate-mapping  package ="Search.fetch"   >
   
     < class  name ="Search.Clob_Blob.TestCB"  table ="testcb"  lazy ="true" >
        < id  name ="id"  column ="id"  unsaved-value ="null" >
          < generator  class ="uuid.hex" ></ generator >
        </ id >

        < property  name ="name"  column ="name"  type ="string" ></ property >
        < property  name ="photo"  column ="photo"  type ="blob" ></ property >
        < property  name ="description"  column ="description"  type ="clob" ></ property >
      
       </ class >
</ hibernate-mapping >

 

准备一个图片sample.jpg放在Clob_Blob包下

 

写Blob和Clob测试代码：

 

package  Search.Clob_Blob;

import  java.io.File;
import  java.io.FileInputStream;
import  java.io.FileNotFoundException;
import  java.io.IOException;
import  java.sql.Blob;
import  java.sql.Clob;

import  org.hibernate.Hibernate;
import  org.hibernate.Session;
import  org.hibernate.SessionFactory;
import  org.hibernate.Transaction;
import  org.hibernate.cfg.Configuration;

public   class  Test  ... {


    public static void main(String[] args) ...{
        String filePath=System.getProperty("user.dir")+File.separator+"src/Search/Clob_Blob"+File.separator+"hibernate.cfg.xml";
        File file=new File(filePath);
        SessionFactory sessionFactory=new Configuration().configure(file).buildSessionFactory();
        Session session=sessionFactory.openSession();
        Transaction tx=session.beginTransaction();
        try ...{
            String imgPath=System.getProperty("user.dir")+File.separator+"src/Search/Clob_Blob"+File.separator+"sample.jpg";
            FileInputStream fis=new FileInputStream(imgPath);
            Blob photo=Hibernate.createBlob(fis);
            Clob description=Hibernate.createClob("this is description");
            TestCB testcb=new TestCB();
            testcb.setName("tom1");
            testcb.setPhoto(photo);
            testcb.setDescription(description);
            session.save(testcb);
            tx.commit();
        } catch (FileNotFoundException e) ...{
            e.printStackTrace();
        } catch (IOException e) ...{

            e.printStackTrace();
        }
        
        

    }

}

、

运行后，在mysql客户端中可以看到已经成功保存：

运行读取测试代码：

 

package  Search.Clob_Blob;

import  java.io.BufferedReader;
import  java.io.File;
import  java.io.FileOutputStream;
import  java.io.IOException;
import  java.io.InputStream;
import  java.io.Reader;
import  java.sql.Blob;
import  java.sql.Clob;
import  java.sql.SQLException;

import  org.hibernate.Session;
import  org.hibernate.SessionFactory;
import  org.hibernate.Transaction;
import  org.hibernate.cfg.Configuration;

public   class  TestRead  ... {


    public static void main(String[] args) ...{
        String filePath=System.getProperty("user.dir")+File.separator+"src/Search/Clob_Blob"+File.separator+"hibernate.cfg.xml";
        File file=new File(filePath);
        SessionFactory sessionFactory=new Configuration().configure(file).buildSessionFactory();
        Session session=sessionFactory.openSession();
        Transaction tx=session.beginTransaction();
        
        //读取clob和blob
        String imgPath=System.getProperty("user.dir")+File.separator+"src/Search/Clob_Blob"+File.separator+"sampleread.jpg";
        TestCB testcb=(TestCB)session.get(TestCB.class, "1");
        Blob photo=testcb.getPhoto();
        Clob description=testcb.getDescription();
        try ...{
            StringBuffer buffer=new StringBuffer();
            Reader reader=(Reader)description.getCharacterStream();
            BufferedReader breader=new BufferedReader(reader);
            char[] b = new char[60000];//每次获取60K

            //将Clob解析成String
            int i = 0;
            while((i = breader.read(b)) != -1)
            ...{
                buffer.append(b,0,i);
            }

            System.out.println(buffer.toString());
            
            //将Blob还原成文件
            FileOutputStream fos=new FileOutputStream(imgPath);
            InputStream  fis1=(InputStream)photo.getBinaryStream();
            byte[] b1 = new byte[60];//每次获取60K
            int i1 = 0;
            while((i1=fis1.read(b1))!=-1)...{
               fos.write(b1);
            }
    
        } catch (SQLException e) ...{
            e.printStackTrace();
        } catch (IOException e) ...{
            e.printStackTrace();
        }
        tx.commit();
        
        

    }

}

 

结果：

Hibernate: select testcb0_.id as id0_0_, testcb0_.name as name0_0_, testcb0_.photo as photo0_0_, testcb0_.description as descript4_0_0_ from testcb testcb0_ where testcb0_.id=?
this is description

红色部分为解析的Clob,同时在Clob_Blob下可以看到生成的sampleread.jpg