使用 hibernate 存取大对象数据类型（clob和blob）

1、create table books(ID number(20,0),PHOTO BLOB,DESCRIPTIONS CLOB);

id     该表的主键。    number类型。
photo     代表图书的图片， blob类型。
description     图书的描述， clob类型。

2、
   使用 hibernate3 往 book 表插入Clob,Blob数据

实体映射文件和实体类代码，直接帖实现代码：
package com;

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

/**
 * Books entity.
 *
 * @author MyEclipse Persistence Tools
 */

public class Books implements java.io.Serializable {

    // Fields    

    private int id;

    private Blob photo;

    private Clob descriptions;

    // Constructors

    /** default constructor */
    public Books() {
    }

    /** full constructor */
    public Books(Blob photo, Clob descriptions) {
        this.photo = photo;
        this.descriptions = descriptions;
    }

    // Property accessors

    public long getId() {
        return this.id;
    }

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

    public Blob getPhoto() {
        return this.photo;
    }

    public void setPhoto(Blob photo) {
        this.photo = photo;
    }

    public Clob getDescriptions() {
        return this.descriptions;
    }

    public void setDescriptions(Clob descriptions) {
        this.descriptions = descriptions;
    }

}


<?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 Persistence Tools
-->
<hibernate-mapping>
    <class name="com.lyj.Books" table="BOOKS" schema="DC40TRUST_TEST">
        <id name="id" type="integer">
            <column name="ID" precision="20" scale="0" />
                <generator class="sequence">
                  <param name="sequence">sqn_books</param>
                </generator>
        </id>
        <property name="photo" type="blob">
            <column name="PHOTO" />
        </property>
        <property name="descriptions" type="clob">
            <column name="DESCRIPTIONS" />
        </property>
    </class>
</hibernate-mapping>

复制代码

import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStream;
import java.sql.Blob;
import java.sql.Clob;
import org.hibernate.Hibernate;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;

import com.lyj.Books;

public class Client {

    public static void main(String[] args) throws IOException {
        //得到session
        Configuration cfg = new Configuration().configure();
        SessionFactory sf = cfg.buildSessionFactory();
        Session session = sf.openSession();
        //得到图片的blob
        InputStream in = new FileInputStream("C:\\123.jpg");
        Blob blob = Hibernate.createBlob(in);
        //得到简介的clob
        Clob clob = Hibernate.createClob("这是一本书和详细描述。#（*&#@￥%（*&@￥）（@#￥#￥");
        //创建图书对象
        Books book = new Books();
        //book.setId(book.);
        book.setPhoto(blob);
        book.setDescriptions(clob);
        //存进数据库
        session.beginTransaction();
        session.save(book);
        session.getTransaction().commit();
        session.close();
    }

}