使用JDBC4.0處理Oracle中BLOB類型的數據

需要的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.創建Blob
10         Blob image = DBHelper.getConnection().createBlob();
11         //2.將流放入blob
12         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();
        }
    }