hibernate mysql longblob_hibernate操作mysql的blob数据

最新推荐文章于 2022-09-25 19:54:02 发布

刘瑷

最新推荐文章于 2022-09-25 19:54:02 发布

阅读量170

点赞数

文章标签： hibernate mysql longblob

本文链接：https://blog.csdn.net/weixin_36326053/article/details/113567344

版权

这篇博客介绍了如何在Java中使用Hibernate框架来存储和读取MySQL中的LongBlob类型数据。通过创建Blobtest实体类，实现了从文件读取字节流存入数据库，以及从数据库读取Blob数据并写入到本地文件系统的操作。

摘要由CSDN通过智能技术生成

package hibernate;

import java.sql.Blob;

public class Blobtest implements java.io.Serializable {

private long id;

private Blob image;

public Blobtest() {

}

public Blobtest(Blob image) {

this.image = image;

}

public long getId() {

return this.id;

}

public void setId(long id) {

this.id = id;

}

public Blob getImage() {

return this.image;

}

public void setImage(Blob image) {

this.image = image;

}

} 测试写入数据：

package hibernate;

import java.io.FileInputStream;

import java.io.IOException;

import java.io.InputStream;

import org.hibernate.Hibernate;

import org.hibernate.Session;

import org.hibernate.Transaction;

public class Test {

public static void main(String[] args) throws IOException {

InputStream in = new FileInputStream("F:/lzx.jpg");

byte[] b = new byte[in.available()];

in.read(b);

in.close();

Blobtest blobTest=new Blobtest();

blobTest.setImage(Hibernate.createBlob(b));

Session session=HibernateUtil.currentSession();

Transaction tx=session.beginTransaction();

session.save(blobTest);

tx.commit();

System.out.print("success");

HibernateUtil.closeSession();

}

读出数据：

package hibernate;

import java.io.FileNotFoundException;

import java.io.FileOutputStream;

import java.io.IOException;

import java.io.OutputStream;

import java.sql.SQLException;

import org.hibernate.Session;

import org.hibernate.Transaction;

public class TestWrite { public static void main(String[] args) throws IOException, SQLException { Session session=HibernateUtil.currentSession(); Transaction tx=session.beginTransaction(); Blobtest blobTest = new Blobtest(); blobTest = (Blobtest) session.get(Blobtest.class, new Long(1)); System.out.println("qu chu shu ju"); OutputStream out = new FileOutputStream("F:/111.jpg"); out.write(blobTest.getImage().getBytes(1,(int) blobTest.getImage().length())); out.flush(); out.close(); HibernateUtil.closeSession(); } }