1、数据库字段
MySql Blob字段,默认非空
表:attendance
字段:ATTEND_IMAGE longblob
2、图片利用HIbernate从文件存储到MySql
FileInputStream fileInputStream = new FileInputStream("e://1.gif");
Blob blob = Hibernate.createBlob(fileInputStream);//创建Blob变量 java.sql.Blob;
AttendanceDAO attendanceDAO = new AttendanceDAO();
Attendance attendance = new Attendance();
attendance.setAttendImage(blob);
attendanceDAO.save(attendance);
3、从MySql取出Blob图片保存到磁盘
Attendance attendance = new AttendanceDAO().findById(4);
InputStream inputStream = attendance.getAttendImage().getBinaryStream();//获取IO流
FileOutputStream fileOutputStream = new FileOutputStream("c://pic.gif");
byte[] buf = new byte[1024];
int len = 0;
while((len=inputStream.read(buf))!=-1){
fileOutputStream.write(buf,0,len);//写
}
inputStream.close();
fileOutputStream.close(
MySql Blob Hibernate 存取
最新推荐文章于 2021-03-23 22:53:38 发布