将Oracle数据库中HR方案下
TESTFILEUPLOAD表中文件下载至系统临时目录
void downloadFile
??{
???OracleConnection objOcon =
OracleConnection("user id=system;Data Source=tsems;passWord=system");
???OracleCommand objOcmd =
OracleCommand;
???objOcmd.Connection = objOcon;
???objOcmd.CommandText = "SELECT * FROM HR.TESTFILEUPLOAD WHERE PKID='2006'";
???FileStream objFs;
???BinaryWriter objBw;
???
bufferSize = 260;
???
outByte = [bufferSize];
???long retval;
???long startIndex = 0;
???
fileName = "";
???objOcon.Open
;
???OracleDataReader objDr = objOcmd.ExecuteReader(CommandBehavior.SequentialAccess);
???objDr.Read
;
?? fileName = objDr["FILENAME"].
;
???objFs =
FileStream(Path.GetTempPath+fileName, FileMode.OpenOrCreate,FileAccess.Write);
???objBw =
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, (
)retval -1);
???objBw.Flush
;
???objBw.Close
;
???objFs.Close
;
?? bjDr.Close
;
???objOcon.Close
;
??}
最新评论