在Oracle下开发Java程序的经典问题解答

create table tb_file(name varchar(20),detail BLOB); 
con.setAutoCommit(false); 
stmt.executeUpdate("insert into tb_file values
(´aaa.gif´,empty_blob())");

rs = stmt.executeQuery
("select detail from tb_file
 where name=´aaa.gif´ 
for upfdate" ); 
if(rs.next()) 
{ 
Blob blob = rs.getBlob(1); 
BinaryOutputStream out = 
((oracle.sql.BLOB)blob).getBinaryOutputStream(); 
byte[] b = new byte
[((oracle.sql.BLOB)blob).getBufferSize]; 
InputStream fin = new FileInputStream(file); 
int len = 0; 
while( (len = fin.read(b)) != -1) 
out.write(b,0,len); 
fin.close(); 
out.close(); 
con.commit(); 
}

InputStream in = rs.getBinaryInputStream("detail");

Blob blob = rs.getBlob("detail"); 
in = blob.getBinaryStream();