如何利用jdbc操作二进制数据

Oracle数据库提供了一个表示二进制数据的类 oracle.sql.BLOB.可以通过这个类来操作二进制对象。

 

1.在jdbc中读取，写入二进制文件的bean

package com.ch13;
import java.sql.*;
import javax.sql.*;

import com.util.DatabaseConn;

import java.io.*;
import oracle.jdbc.driver.OracleResultSet;
import oracle.sql.BLOB;
public class BlobBean
{

   Connection conn ;
   /**
    *
    */
   public BlobBean()throws Exception
   {
    DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
        conn = DriverManager.getConnection("jdbc:oracle:thin:@xx.xx.xx.xx:1521:XE", "user", "pass");
    }
   
    /**
     *
     */
 public void addBlob(String fileName)throws Exception
 {
        // conn = DatabaseConn.getConnection();
         conn.setAutoCommit(false);
            Statement stmt = conn.createStatement();
            stmt.execute("insert into blobtable values (empty_blob())");
            ResultSet rset = stmt.executeQuery("SELECT blobvalue FROM blobtable FOR UPDATE");
            BLOB blob = null;
            while (rset.next()) {
                blob = ((OracleResultSet) rset).getBLOB(1);
                System.out.println(blob.length());
            }
            File binaryFile = new File(fileName);
            System.out.println(fileName+"'s length = " + binaryFile.length());
            FileInputStream instream = new FileInputStream(binaryFile);
            OutputStream outstream = blob.getBinaryOutputStream();
            int chunk = blob.getChunkSize();
            System.out.println("chunk size = " + chunk);
            byte[] buffer = new byte[chunk];
            int length = -1;
            while ((length = instream.read(buffer)) != -1)
                outstream.write(buffer, 0, length);
            instream.close();
            outstream.close();
            conn.commit();

        }
       
        /**
         *
         */
     public void readBlob(String fileName)throws Exception
   {
        
         conn.setAutoCommit(false);
            Statement stmt = conn.createStatement();
            ResultSet rset = stmt.executeQuery("SELECT blobvalue FROM blobtable");
            BLOB blob = null;
            while (rset.next()) {
                blob = ((OracleResultSet) rset).getBLOB(1);
                System.out.println(blob.length());
            }

            FileOutputStream file_out = new FileOutputStream(new File(fileName));
            InputStream blob_in = blob.getBinaryStream();
            int temp;
            while((temp=blob_in.read())!=-1)
            file_out.write(temp);
          
            file_out.close();
            blob_in.close();
            conn.commit();
        }         
        
}

  

 

测试jsp画面

 <%@ page contentType="text/html; charset=gb2312" %>
<jsp:useBean id="blobtest" class="com.ch13.BlobBean" scope="page"/>
<%
try
{
  blobtest.addBlob("c://blobData.xls");
  blobtest.readBlob("c://blobData2.xls");
  out.println("sucess!");
 }
 catch(Exception e)
 {
  out.println(e);
  e.printStackTrace();
 }
%>

3.

http://localhost/JSPTEST2/jsp/ch13/blobtest.jsp

 

sucess!