<% 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 %>
|