ASP中从数据库读取二进制文件数据代码 |
| 作者:佚名 来源:不详 更新:2006-8-25 21:05:35 错误报告 我要投稿 |
|
<% driver_name1="DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=D:\数据库\TREE.MDB" '根目录下数据库打开语句
dim search,rs,j search="select * from Files where ID=" & request.querystring("ID") set my_conn=server.CreateObject ("adodb.connection") my_conn.open driver_name1 set rs=Server.CreateObject("ADODB.Recordset") rs.Open search,my_conn,1,3 if rs.bof or rs.eof then response.write "错误:找不到该文件" response.end end if
'设置文件的大小及MIME类型 Function SetForDisplay(field, contentType) contentType = LCase(trim(contentType)) nFieldSize = field.ActualSize bytes = field.GetChunk(nFieldSize) Session("Bytes") = bytes Session("Type") = contentType End Function
SetForDisplay RS("File"),rs("FileType") 'Response.AddHeader "Content-Disposition", "attachment; filename=" & rs("FileName") response.contentType = Session("Type") response.BinaryWrite Session("Bytes") Session("Type") = "" Session("Bytes") = ""
set rs=nothing my_conn.close set my_conn=nothing %>
|
|
| 文章录入:skyuu 责任编辑:skyuu |
|
| 【字体:小 大】【发表评论】【加入收藏】【告诉好友】【打印此文】【关闭窗口】 |