hibernate mysql 图片_eclipse使用hibernate保存图片到mysql数据库

1 数据持久类 Sudents.java package com.cn;

import java.sql.Blob;

public class Students { private String name;

private Blob picture;

public Blob getPicture() {

return picture;

}

public Students(String name, String pass) {

this.name = name;

this.pass = pass;

}

public String getName() {

return name;

}

public void setName(String name) {

this.name = name;

}

public String getPass() {

return pass;

}

public void setPass(String pass) {

this.pass = pass;

}

private String pass;

public Students() {

}

@Override

public String toString() {

return "Students [name=" + name + ", pass=" + pass + "]";

}

public void setPicture(Blob image) {

this.picture=image;

}

}

2测试类

import java.io.File; import java.io.FileInputStream; import java.io.FileOutputStream; import java.io.InputStream; import java.io.OutputStream; import java.sql.Blob;//如果使用java.mysql.Blob包出现问题，就用java.sql.Blob包 import java.sql.Connection; import java.sql.SQLException;

import org.hibernate.Hibernate; import org.hibernate.Session; import org.hibernate.SessionFactory; import org.hibernate.Transaction; import org.hibernate.cfg.Configuration; import org.hibernate.jdbc.Work; import org.hibernate.service.ServiceRegistry; import org.hibernate.service.ServiceRegistryBuilder;

import org.junit.After; import org.junit.Before;

public class Test { private SessionFactory sessionFactory; private Session session; private Transaction transaction; @Before public void init(){ Configuration config=new Configuration().configure(); //创建服务注册对象 ServiceRegistry serviceRegistry=new ServiceRegistryBuilder().applySettings(config.getProperties()).buildServiceRegistry(); //创建会话工厂对象 sessionFactory=config.buildSessionFactory(serviceRegistry); //会话对象 session=sessionFactory.openSession(); //启动事物 transaction=(Transaction) session.beginTransaction();

}

@After

public void destory(){

transaction.commit();

session.close();

sessionFactory.close();

}

@org.junit.Test

public void testReadPicture()throws Exception{

Students students=(Students) session.get(Students.class,"12");

//获得Blob对象

Blob b=students.getPicture();

//获得照片的输入流

InputStream input=b.getBinaryStream();

//创建输出流

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

//获得输出流

OutputStream out=new FileOutputStream(f);

//创建缓冲区

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

input.read(buff);

out.write(buff);

input.close();

out.close();

}

}