oracle.dataaccess.client blob,下载ORACLE中BLOB内容到客户端 | 学步园

悠悠 2023-01-19 04:48 97阅读 0赞

private void downLoad(string id)

string fileName = Page.Request.PhysicalApplicationPath + "SystemManage\\\\SysFile\\\\" + DateTime.Now.ToString("yyyyMMddhhmmss") + ".zip";

OracleConnection conn = null;

string connString = System.Configuration.ConfigurationSettings.AppSettings\["ConnectionString"\].ToString();

using (conn = new OracleConnection(connString))

try

conn.Open();

OracleCommand cmd = conn.CreateCommand();

// 利用事务处理(必须)

OracleTransaction transaction = cmd.Connection.BeginTransaction();

cmd.Transaction = transaction;

// 根据查询语句获取对应的上传文件的BLOB信息

string sql = "select 上传文件 from 文件上传表 where 编号 = " + id;

cmd.CommandText = sql;

OracleDataReader dr = cmd.ExecuteReader();

dr.Read();

OracleLob tempLob = dr.GetOracleLob(0);

dr.Close();

// 读取 BLOB 中数据，写入到文件中

FileStream fs = new FileStream(fileName, FileMode.Create);

int length = 1048576;

byte\[\] Buffer = new byte\[length\];

int i;

while ((i = tempLob.Read(Buffer, 0, length)) > 0)

fs.Write(Buffer, 0, i);

fs.Close();

tempLob.Clone();

cmd.Parameters.Clear();

// 提交事务

transaction.Commit();

DownloadFile(fileName);

File.Delete(fileName);

catch (Exception ex)

throw ex;

finally

conn.Close();

///

/// 下载文件

///

/// 文件名称

public void DownloadFile(string fileName)

try

//by K 2010-08-13 下载超过100M的附件  需要用以下方法

System.IO.Stream iStream = null;

// Buffer to read 10K bytes in chunk:

byte\[\] buffer = new Byte\[10000\];

// Length of the file:

int length;

// Total bytes to read:

long dataToRead;

// Identify the file to download including its path.

string filepath = fileName;

// Identify the file name.

string filename = System.IO.Path.GetFileName(filepath);

try

// Open the file.

iStream = new System.IO.FileStream(filepath, System.IO.FileMode.Open,

System.IO.FileAccess.Read, System.IO.FileShare.Read);

// Total bytes to read:

dataToRead = iStream.Length;

Response.ContentType = "application/octet-stream";

Response.AddHeader("Content-Disposition", "attachment; filename=" + filename);

// Read the bytes.

while (dataToRead > 0)

// Verify that the client is connected.

if (Response.IsClientConnected)

// Read the data in buffer.

length = iStream.Read(buffer, 0, 10000);

// Write the data to the current output stream.

Response.OutputStream.Write(buffer, 0, length);

// Flush the data to the HTML output.

Response.Flush();

buffer = new Byte\[10000\];

dataToRead = dataToRead - length;

else

//prevent infinite loop if user disconnects

dataToRead = -1;

catch (Exception ex)

// Trap the error, if any.

Response.Write("Error : " + ex.Message);

finally

if (iStream != null)

//Close the file.

iStream.Close();

catch (Exception ex)

AppCode.CommonFunc.AlertScript("对不起，文件下载时出现错误！");

oracle.dataaccess.client blob,下载ORACLE中BLOB内容到客户端 | 学步园

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 Oracle BLOB类型进行插入

相关 Python将一个文件夹的文件装载到ORACLE数据库BLOB列,并将BLOB列下载到另一个文件夹

相关 oracle.dataaccess.client blob,下载ORACLE中BLOB内容到客户端 | 学步园

相关 Oracle中Blob转换成Clob

相关 oracle blob过滤

相关 java.sql.Blob与oracle.sql.BLOB问题

相关 BLOB

相关 Oracle BLOB类型进行插入

相关 Oracle blob 的整理

相关处理Blob类型数据，例如将对象保存到blob字段中