mysql blob取值_mysql存取blob类型数据

最新推荐文章于 2024-10-08 22:43:34 发布

你也太可爱了吧

最新推荐文章于 2024-10-08 22:43:34 发布

阅读量480

点赞数

文章标签： mysql blob取值

本文链接：https://blog.csdn.net/weixin_30289299/article/details/113127552

版权

该博客展示了如何使用Java的PreparedStatement和Blob接口在MySQL中插入和查询Blob类型的文件数据。通过FileInputStream读取文件，然后利用Blob的setBlob方法将文件内容存储到数据库，再通过getBinaryStream方法读取并保存到本地文件系统。

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

packageblobtest;importjava.io.BufferedInputStream;importjava.io.BufferedOutputStream;importjava.io.File;importjava.io.FileInputStream;importjava.io.FileNotFoundException;importjava.io.FileOutputStream;importjava.io.IOException;importjava.io.InputStream;importjava.sql.Blob;importjava.sql.Connection;importjava.sql.PreparedStatement;importjava.sql.ResultSet;importjava.sql.SQLException;importjava.sql.Statement;public classReadWriteBlobwithMysql

{privateConnection con;privateStatement stmt;publicStatement getStmt()

{returnstmt;

}public voidsetStmt(Statement stmt)

{this.stmt =stmt;

}publicResultSet getRs()

{returnrs;

}public voidsetRs(ResultSet rs)

{this.rs =rs;

}

ResultSet rs;publicConnection getCon()

{returncon;

}public voidsetCon(Connection con)

{this.con =con;

}public void insert(Connection con) throwsSQLException

{

String fileName= "E:\\JavaProject\\HelloWorld\\src\\blobtest\\test.html";

File file= newFile(fileName);try{

FileInputStream fis= newFileInputStream(file);

String sql= "insert into blobtest values(‘12‘,‘0000‘,‘平安银行‘,?)";

PreparedStatement prest=con.prepareStatement(sql);

prest.setBlob(1, fis, file.length());

prest.execute();

}catch(FileNotFoundException e)

{//TODO Auto-generated catch block

e.printStackTrace();

}

}public void queryBlob(String id, Connection con) throwsIOException

{

String fileName= "E:\\JavaProject\\HelloWorld\\src\\blobtest\\test1.html";

String sql= "select * from blobtest where primary_id= ?";try{

PreparedStatement prest=con.prepareStatement(sql);

prest.setString(1, id);

ResultSet rs=prest.executeQuery();while(rs.next())

{

Blob bl= rs.getBlob("blob_data");//数据保存在表的blob_data字段中，这里取出这里保存的数据。

InputStream is = bl.getBinaryStream(); //查看blob,可以通过流的形式取出来。注意一定要是用流的方式读取出来

BufferedInputStream buffis = newBufferedInputStream(is);//保存到buffout

BufferedOutputStream buffout = new BufferedOutputStream(newFileOutputStream(fileName));byte[] buf = new byte[1024];int len = buffis.read(buf, 0, 1024);while (len > 0)

{

buffout.write(buf);

len= buffis.read(buf, 0, 1024);

}

buffout.flush();

buffout.close();

buffis.close();

}

}catch(SQLException e)

{//TODO Auto-generated catch block

e.printStackTrace();

}