处理blob的完整例子

import oracle.jdbc.driver.OracleResultSet;
import oracle.sql.BLOB;
import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.ResultSet;
import java.io.*;
import java.sql.Statement;
public class testBlob {
    public static void main(String args[]) {
        try {
            DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
            Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@java:1521:eteda", "system", "manager");
            conn.setAutoCommit(false);
            Statement stmt = conn.createStatement();
            stmt.execute("insert into testblob values (empty_blob())");
            ResultSet rset = stmt.executeQuery("SELECT tt FROM testblob FOR UPDATE");
            BLOB blob = null;
            while (rset.next()) {
                blob = ((OracleResultSet) rset).getBLOB(1);
                System.out.println(blob.length());
            }
            File binaryFile = new File("c:meilin.xml");
            System.out.println("meilin.xml length = " + binaryFile.length());