將oracle數(shù)據(jù)庫(kù)中hr方案下的testfileupload表中的文件下載至系統(tǒng)臨時(shí)目錄。
void downloadfile()
??{
???oracleconnection objocon = new oracleconnection("user id=system;data source=tsems;password=system");
???oraclecommand objocmd = new oraclecommand();
???objocmd.connection = objocon;
???objocmd.commandtext = "select * from hr.testfileupload where pkid='2006'";
???filestream objfs;
???binarywriter objbw;
???int buffersize = 260;
???byte [] outbyte = new byte[buffersize];
???long retval;
???long startindex = 0;
???string filename = "";
???objocon.open();
???oracledatareader objdr = objocmd.executereader(commandbehavior.sequentialaccess);
???objdr.read();
?? filename = objdr["filename"].tostring();
???objfs = new filestream(path.gettemppath()+filename, filemode.openorcreate,fileaccess.write);
???objbw = new binarywriter(objfs);
???startindex = 0;
???retval = objdr.getbytes(8, startindex, outbyte, 0, buffersize);
???while ( retval == buffersize)
???{
????objbw.write(outbyte);
????objbw.flush();
????startindex += buffersize;
????retval = objdr.getbytes(8, startindex, outbyte, 0, buffersize);
???}
???objbw.write(outbyte, 0, (int)retval -1);
???objbw.flush();
???objbw.close();
???objfs.close();
?? bjdr.close();
???objocon.close();
??}
網(wǎng)站運(yùn)營(yíng)seo文章大全提供全面的站長(zhǎng)運(yùn)營(yíng)經(jīng)驗(yàn)及seo技術(shù)!
