Hibernate读写SQL-Server二进制文件

这个例子是使用Spring整合Hibernate的。

通过对表反转（reverse）生成实体bean，保存二进制文件使用这个类：java.sql.Blob

 

package com.entity; import java.sql.Blob; import java.util.Date; import java.util.HashSet; import java.util.Set; public class Zb implements java.io.Serializable { // Fields private String zbId; private String zbProjectName; private Blob zbFile;//保存二进制文件 private Date zbFinalTime; private String zbState; private Set tbs = new HashSet(0); // Constructors /** default constructor */ public Zb() { } /** minimal constructor */ public Zb(String zbProjectName, Date zbFinalTime) { this.zbProjectName = zbProjectName; this.zbFinalTime = zbFinalTime; } /** full constructor */ public Zb(String zbProjectName, Blob zbFile, Date zbFinalTime, String zbState, Set tbs) { this.zbProjectName = zbProjectName; this.zbFile = zbFile; this.zbFinalTime = zbFinalTime; this.zbState = zbState; this.tbs = tbs; } // Property accessors public String getZbId() { return this.zbId; } public void setZbId(String zbId) { this.zbId = zbId; } public String getZbProjectName() { return this.zbProjectName; } public void setZbProjectName(String zbProjectName) { this.zbProjectName = zbProjectName; } public Blob getZbFile() { return this.zbFile; } public void setZbFile(Blob zbFile) { this.zbFile = zbFile; } public Date getZbFinalTime() { return this.zbFinalTime; } public void setZbFinalTime(Date zbFinalTime) { this.zbFinalTime = zbFinalTime; } public String getZbState() { return this.zbState; } public void setZbState(String zbState) { this.zbState = zbState; } public Set getTbs() { return this.tbs; } public void setTbs(Set tbs) { this.tbs = tbs; } }

 

修改Zb.hbm.xml的type为java.sql.Blob

<property name="zbFile" type="java.sql.Blob"> <column name="zb_file" /> </property>

 

最后写个main方法来调用下面2个方法。

保存二进制文件的添加方法

static void addZB() { Zb zbBean = new Zb(); zbBean.setZbId(getZBId(new Date(), "000")); zbBean.setZbProjectName("聪海飞行安全管理系统"); zbBean.setZbFinalTime(new Date()); zbBean.setZbState("招标中"); FileInputStream fis = null; DataInputStream dis = null; BufferedInputStream bin = null; File f = new File("d://aaa.doc"); try { fis = new FileInputStream(f); dis = new DataInputStream(fis); bin = new BufferedInputStream(dis); // int i = -1; // while ((i = bin.read()) != -1) { // System.out.print((char) i); // } zbBean.setZbFile(Hibernate.createBlob(bin)); } catch (FileNotFoundException e) { e.printStackTrace(); } catch (IOException e) { e.printStackTrace(); } // zbDao.save(zbBean); }

 

读取二进制文件的读取方法

static void red() { Zb zbBean = zbDao.findById("ZB20090812000"); if (zbBean != null) { Blob file = zbBean.getZbFile(); DataInputStream dis = null; FileOutputStream fop = null; DataOutputStream out = null; BufferedInputStream bin = null; BufferedOutputStream bos = null; try { InputStream is = file.getBinaryStream(); dis = new DataInputStream(is); bin = new BufferedInputStream(dis); fop = new FileOutputStream("d://bbb.doc"); out = new DataOutputStream(fop); bos = new BufferedOutputStream(out); byte[] buf = new byte[1]; int len = 0; while ((len = bin.read(buf)) != -1) { bos.write(buf, 0, len); } bin.close(); bos.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (FileNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (IOException e) { // TODO Auto-generated catch block e.printStackTrace(); } } else { System.out.println("zbBean = null"); } }