下載Oracle資料庫中的Blob二進位檔案,執行個體!

來源:互聯網
上載者:User
oracle|二進位|資料|資料庫|下載 將Oracle資料庫中HR方案下的TESTFILEUPLOAD表中的檔案下載至系統臨時目錄。

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



相關文章

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

聯繫我們

該頁面正文內容均來源於網絡整理,並不代表阿里雲官方的觀點,該頁面所提到的產品和服務也與阿里云無關,如果該頁面內容對您造成了困擾,歡迎寫郵件給我們,收到郵件我們將在5個工作日內處理。

如果您發現本社區中有涉嫌抄襲的內容,歡迎發送郵件至: info-contact@alibabacloud.com 進行舉報並提供相關證據,工作人員會在 5 個工作天內聯絡您,一經查實,本站將立刻刪除涉嫌侵權內容。