下面学习一下对象类型:
第一行是字节数组,第二,三行是大文本类型,第四行是二进制类型,如音频,视频,图片
Mysql不支持标准的sql的CLOB类型。在Mysql中用TEXT(短),MEDIUMTEXT(中),LONGTEXT(长)(三种都表示超过255的长文本)
下面以存储图片讲解二进制类型 给Student类添加图片属性 private Blob picture;//照片,同时添加get set方法
import java.sql.Blob;
import java.util.Date;
public class Student {
private int id;
private String name;
private Date birthday;
private String address;
private Blob picture;//照片
public Student() {
}
public Student(int id, String name, Date birthday, String address) {
// super();
this.id = id;
this.name = name;
this.birthday = birthday;
this.address = address;
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public Date getBirthday() {
return birthday;
}
public void setBirthday(Date birthday) {
this.birthday = birthday;
}
public String getAddress() {
return address;
}
public void setAddress(String address) {
this.address = address;
}
@Override
public String toString() {
return "Student [id=" + id + ", name=" + name + ", birthday=" + birthday + ", address=" + address + "]";
}
public Blob getPicture() {
return picture;
}
public void setPicture(Blob picture) {
this.picture = picture;
}
}
删除映射文件然后重新生成
添加测试方法
@Test
public void testWriteBlob() throws IOException{
Student s = new Student(1, "小郑", new Date(), "北京海淀区");
//先获得照片文件
File f = new File("f:"+File.separator+"test.jpg");//图片路径
//获得文件输入流
InputStream input = new FileInputStream(f);
//创建Blob对象
Blob image = Hibernate.getLobCreator(session).createBlob(input, input.available());//第二个参数input.available()是输入流的长度
//设置照片属性
s.setPicture(image);
session.save(s);
}
运行创建表成功
但是保存内容失败(出现以下错误,没有这个错误的请跳过)
这个是mysql驱动版本问题出现以上错误,自行下载mysql-connector-java-bin5.1.7版本进行替换,可解决问题。
参考http://stackoverflow.com/questions/15855222/java-lang-abstractmethoderror-com-mysql-jdbc-preparedstatement-setblobiljava-i
解决后运行保存成功
下面从数据库读取保存的图片
测试方法
@Test
public void testReadBlob() throws Exception{
//从数据库获取保存的图片
Student s = (Student) session.get(Student.class, 1);
Blob image = s.getPicture();
//获取照片输入流
InputStream input = image.getBinaryStream();
//创建输出流
File f = new File("f:"+File.separator+"outtest.jpg");
//获取输出流
OutputStream output = new FileOutputStream(f);
//创建缓冲区
byte[] buff = new byte[input.available()];
input.read(buff);
output.write(buff);
input.close();
output.close();
}
读取成功,可以试一下