亚洲免费在线-亚洲免费在线播放-亚洲免费在线观看-亚洲免费在线观看视频-亚洲免费在线看-亚洲免费在线视频

Hibernate讀寫Clob和Blob類型字段

系統(tǒng) 1760 0

數(shù)據(jù)庫腳本:

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

????
??
}

?

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 >

?

準(zhǔn)備一個(gè)圖片sample.jpg放在Clob_Blob包下

?

寫B(tài)lob和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();
????????}

????????
????????

????}


}


、

運(yùn)行后,在mysql客戶端中可以看到已經(jīng)成功保存:

Hibernate讀寫Clob和Blob類型字段

運(yùn)行讀取測試代碼:

?

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 "

Hibernate讀寫Clob和Blob類型字段


更多文章、技術(shù)交流、商務(wù)合作、聯(lián)系博主

微信掃碼或搜索:z360901061

微信掃一掃加我為好友

QQ號聯(lián)系: 360901061

您的支持是博主寫作最大的動(dòng)力,如果您喜歡我的文章,感覺我的文章對您有幫助,請用微信掃描下面二維碼支持博主2元、5元、10元、20元等您想捐的金額吧,狠狠點(diǎn)擊下面給點(diǎn)支持吧,站長非常感激您!手機(jī)微信長按不能支付解決辦法:請將微信支付二維碼保存到相冊,切換到微信,然后點(diǎn)擊微信右上角掃一掃功能,選擇支付二維碼完成支付。

【本文對您有幫助就好】

您的支持是博主寫作最大的動(dòng)力,如果您喜歡我的文章,感覺我的文章對您有幫助,請用微信掃描上面二維碼支持博主2元、5元、10元、自定義金額等您想捐的金額吧,站長會(huì)非常 感謝您的哦?。。?/p>

發(fā)表我的評論
最新評論 總共0條評論
主站蜘蛛池模板: 日韩中文字幕一在线 | 免费看一级做a爰片久久 | 亚洲欧美视频二区 | 久草热久草在线 | jiucao视频在线观看 | 国产剧情一区二区 | 成人网欧美亚洲影视图片 | 日韩v在线 | 久草免费在线观看视频 | 色偷偷尼玛图亚洲综合 | 国产综合视频 | 久久久久中文字幕 | 狠狠色丁婷婷综合久久 | 99热网站| 久久久综合香蕉尹人综合网 | 曰韩毛片| 精品久久久中文字幕 | 91尤物在线播放 | 四虎永久免费地址 | 精品的一区二区三区 | 国产成人精品视频免费大全 | 国产野花视频天堂视频免费 | 中文字幕精品在线观看 | 一级高清毛片免费a级高清毛片 | 欧美13一14周岁a在线播放 | 一级毛片大全免费播放 | 国产成人久久 | 亚洲国产男人本色在线观看的a站 | 亚洲综合色婷婷 | 国产尤物视频 | 亚洲视频一区在线播放 | 婷婷亚洲综合一区二区 | 在线久综合色手机在线播放 | 中文字幕色婷婷在线精品中 | 久久综合九色综合97婷婷群聊 | 不卡的在线视频免费观看 | 久久久精品视频免费观看 | 久久青青草原精品影院 | 欧美大片毛片大片 | 爱爱的免费视频 | 五月天婷婷免费视频 |