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

<? 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 >

package ?Search.Clob_Blob;

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

public ? class ?TestCB? ... {
???? private ?String?id;? // 標(biāo)識id
???? private ?String?name;? // 學(xué)生姓名
???? 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;
????}
????
??
}

<? 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 >

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();
????????}
????????
????????

????}

}

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 "