數據庫腳本：
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
&
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
"
更多文章、技術交流、商務合作、聯系博主
微信掃碼或搜索：z360901061
微信掃一掃加我為好友
QQ號聯系： 360901061
您的支持是博主寫作最大的動力，如果您喜歡我的文章，感覺我的文章對您有幫助，請用微信掃描下面二維碼支持博主2元、5元、10元、20元等您想捐的金額吧，狠狠點擊下面給點支持吧，站長非常感激您！手機微信長按不能支付解決辦法：請將微信支付二維碼保存到相冊，切換到微信，然后點擊微信右上角掃一掃功能，選擇支付二維碼完成支付。
【本文對您有幫助就好】元
