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

最新推荐文章于 2024-08-20 10:54:35 发布

weixin_33802505

最新推荐文章于 2024-08-20 10:54:35 发布

阅读量169

点赞数

文章标签：数据库 java 开发工具

原文链接：https://my.oschina.net/u/2511906/blog/841606

版权

2019独角兽企业重金招聘Python工程师标准>>>

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();
}

}

转载于:https://my.oschina.net/u/2511906/blog/841606