写入二进制
PreparedStatement ps=null;
String sql="insert into blob_text(big_text) values(?)"; //Blob类型,放置图片,压缩包
ps=conn.prepareStatement(sql);
File file=new File("file.jpg");
InputStream in=new BufferedInputStream(new FileInputStream(file));
ps.setBinaryStream(1,in,(int)file.length());
int i=ps.executeUpdate();
读取文本文件
File file=new File("read.jpg");
Blob blob=rs.getBlob(1);
InputStream in=blob.getBInaryStream();
//in=rs.getBinaryStream(1);
OutputStream out=new BufferedOutputStream(new FileOutputStream(file));
byte[] buff=new byt[1024];
for(int i=0;(i=in.read(buff))>0;){
out.write(buff,0,i);
}
out.close();
in.close()
jdbc二进制处理
最新推荐文章于 2016-07-30 16:44:13 发布