Hibernate4 Blob Clob图片保存到数据库和读取

package com.amaker.test;

 

import java.io.FileInputStream;

import java.io.FileNotFoundException;

import java.io.FileOutputStream;

import java.io.IOException;

import java.io.InputStream;

import java.io.OutputStream;

import java.sql.Blob;

import java.sql.Clob;

 

import org.hibernate.*;

import org.hibernate.Transaction;

//importorg.hibernate.test.cache.infinispan.functional.entities.Name;

 

import com.amaker.bean.Contact;

import com.amaker.bean.Name;

import com.amaker.bean.Person;

import com.amaker.bean.Student1;

import com.amaker.util.HibernateUtil;

 

 

public classTest6 {

 

  public static void main(String[] args) {

   

   save();

   read();

  }

 

  //保存图片到数据库

  static void save(){

    HibernateUtilutil=new HibernateUtil();

    Sessionsession=util.getSession();

    Transactiontran=session.beginTransaction();

    Student1s=new Student1();

   

   

    try {

      InputStreamin=new FileInputStream("E:\\1.jpg");

      byte[] b = new byte[in.available()];  

      in.read(b);

      Blob  pic=session.getLobHelper().createBlob(b);

      Clobresume=session.getLobHelper().createClob("xxx");

        

      s.setPic(pic);

      s.setResume(resume);

      session.save(s);

      tran.commit();                                                                                                                                                                                                                                                         

    }catch(Exception e) {

      // TODO Auto-generated catch block

      e.printStackTrace();

      tran.rollback();

    }

    finally{

      session.close();

    }

   

   

  }

 

  //读取图片

  static void read(){

   

    HibernateUtilutil=new HibernateUtil();

    Sessionsession=util.getSession();

    Student1s=(Student1)session.get(Student1.class, new Integer(1));

    Blobpic=s.getPic();

    OutputStreamout=null;

    try {

      out=new FileOutputStream("E:\\2.jpg");

        byte[] b=pic.getBytes(1,(int)pic.length());

        out.write(b);

    }catch(Exception e) {

      // TODO Auto-generated catch block

      e.printStackTrace();

    }

    finally{

   

         session.close();

     

    }

   

  }

 

}