用spring的hibernateTemplate操作mysql blob

在網上搜了很多文章，發現要配置很多東東，而且，配置了也要報錯，筆者發現一個無需特殊配置的方法，操作很簡單，廢話不多說，看代碼：

package com.czp.test;public class BlobTest { private int id; private Object obj;//這裡可以是任何對象 private byte[] bytes;  public byte[] getBytes() {return bytes;}public void setBytes(byte[] bytes) {this.bytes = bytes;}public int getId() {return id;}public void setId(int id) {this.id = id;}public Object getObj() {return obj;}public void setObj(Object obj) {this.obj = obj;} }
package com.czp.test;import java.io.File;import java.io.FileInputStream;import java.io.FileOutputStream;import java.io.ObjectInputStream;import java.io.ObjectOutputStream;import java.sql.Blob;import java.util.ArrayList;import java.util.List;import org.hibernate.Hibernate;import org.springframework.orm.hibernate3.support.HibernateDaoSupport;public class BlobDao extends HibernateDaoSupport{      /** * 儲存對象 * @param blobTest * @throws Exception */public void add(BlobTest blobTest) throws Exception{File file = File.createTempFile(blobTest.hashCode() + "", null);if (file != null) {ObjectOutputStream ob = new ObjectOutputStream(new FileOutputStream(file));ob.writeObject(blobTest.getObj());ob.flush();ob.close();ob = null;FileInputStream fis = new FileInputStream(file);byte[] b = new byte[fis.available()];fis.read(b);fis.close();blobTest.setBytes(b);this.getHibernateTemplate().save(blobTest);}}/** * 擷取對象 * @return * @throws Exception */@SuppressWarnings("unchecked")public List<BlobTest> getBlob() throws Exception{List<BlobTest> listtmp = new ArrayList<BlobTest>();List<BlobTest> list = this.getHibernateTemplate().loadAll(BlobTest.class);for (BlobTest blt : list) {Blob b = Hibernate.createBlob(blt.getBytes());ObjectInputStream ois = new ObjectInputStream(b.getBinaryStream());Object obj = ois.readObject();ois.close();ois = null;blt.setObj(obj);listtmp.add(blt);}return listtmp ;}}
hibernate spring的配置省略，只需要將BlobTest的bytes屬性在hibernate對應檔裡映射為:<property name="bytes" type="binary" not-null="true" column="`XXXX`"></property>即可