Complete example of processing 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.exe cute ("insert into testblob values (empty_blob ())");
ResultSet rset = stmt.exe cuteQuery ("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 ());