(註意:在執行上述sql之前,必須將連接設置為不自動提交:conn . set auto commit(false);)
最後,分離blob字段:
//取出blob字段
string SQL = " select ANNEX from market _ info _ collect _ t where info _ id = ' "
+ infoId +" '用於更新";
語句stt = null
STT = conn . create statement();
RS = STT . execute query(SQL);
if (rs.next()) {
blob =(Oracle . SQL . blob)RS . get blob(" ANNEX ");
outStream = blob . getbinaryoutputstream();
instream = my file . get contentstream();
byte[]data = new byte[instream . available()];
instream.read(數據);
outStream.write(data,0,data . length);
}
instream . close();
out stream . flush();
out stream . close();
上面這段是我之前寫過的壹部分代碼。請看看,希望對妳有幫助。。。