在Oracle下开发JAVA程序的问题解答

create table tb_file(name varchar(20),detail long row);

File file = new File("aaa.gif"); 
int fileLength =(int) file.length(); 
InputStream fin = new FileInputStream(file); 
PreparedStatement pstmt = con.prepareStatement
("insert into tb_file values(´aaa.gif´,?)"); 
pstmt.setBinaryStream (1, fin, fileLength); 
pstmt.executeUpdate();

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();