需要的jar包
使用ojdbc6.jar
在/META-INF/MANIFEST.MF里可以看到Specification-Version: 4.0
建表
create sequence seq_blobmodel_id start with 1 increment by 1 nocache;create table blobmodel( blobid number(10) primary key not null, image blob);
1 /** 2 * 将图片文件存入数据库 3 * @throws SQLException 4 * @throws IOException 5 */ 6 public int writeBlob(String path) throws SQLException, IOException{ 7 int result = 0; 8 String sql = "insert into blobmodel(blobid,image) values(seq_blobmodel_id.nextval,?)"; 9 //1.创建Blob10 Blob image = DBHelper.getConnection().createBlob();11 //2.将流放入blob12 OutputStream out = image.setBinaryStream(1);13 //3.读取图片,并写入输出流14 FileInputStream fis = new FileInputStream(path);15 byte []buf = new byte[1024];16 int len = 0;17 while((len=fis.read(buf))!=-1){18 out.write(buf, 0, len);19 }20 result = DBHelper.executeUpdate2(sql, new Object[]{image});//自己简单封装了jdbc操作21 22 fis.close();23 out.close();24 return result;25 }
将文件从数据库中读出
/** * 将数据库中的图片文件读出来 * @throws SQLException * @throws IOException */ public void readBlob() throws SQLException, IOException{ String sql = "select image from blobmodel where blobid=?"; DBHelper.getConnection();// ResultSet rs = DBHelper.executeQuery(sql, new Object[]{1}); while(rs.next()){ Blob image = rs.getBlob(1); InputStream is = image.getBinaryStream(); BufferedInputStream bis = new BufferedInputStream(is); String path = "img/"+new Date().getTime()+".jpg";//指定输出的目录为项目下的img文件夹 BufferedOutputStream bos = new BufferedOutputStream(new FileOutputStream(path)); byte []buf = new byte[1024]; int len = 0; while((len=bis.read(buf))!=-1){ bos.write(buf,0,len); } bos.close(); bis.close(); } }
原标题:使用JDBC4.0处理Oracle中BLOB类型的数据
关键词:oracle