@Test

public void TestWriteBlob() throws Exception{

Students s = new Students(1, "張山豐", "男", new Date(), "武當");

File f=new File("C:/Users/Administrator/Pictures/Saved Pictures"+File.separator+"美食.jpg");

//獲得該文件的輸入流

InputStream input=new FileInputStream(f);//字節流

//創建一個Blob對象

Blob image=Hibernate.getLobCreator(session).createBlob(input, input.available());

//設置照片屬性

s.setPicture(image);

//保存

session.save(s);

}

public void TestReadBlob() throws Exception{

System.out.println("11111");

Students s=(Students)session.get(Students.class, 1);

//獲得Blob對象

Blob image=s.getPicture();

//獲得照片的輸入流

InputStream input =image.getBinaryStream();

// System.out.println("input"+input);

//創建輸出流

File f=new File("C:"+File.separator+"desc.jpg");

//獲得輸出流

OutputStream output=new FileOutputStream(f);

//創建緩沖區

byte[] buff=new byte[input.available()];

input.read(buff);//讀到緩存區

output.write(buff);

input.close();

output.close();

}