多表单域无组件文件上传的例子

最近经常有人问到这类问题,在此转贴一下,内容:

1。数据库表结构(Access):
UserID:Text(保存上传文件的用户ID)
FileContentType:Text(用来保存上传文件的类型,eg:"Application/msword",主要用来使用户能正确下载此文件)
FileContent:OLE Object(保存文件数据)

2。HTML文件
muploadfile.htm

1<form action="muploadfile.asp" enctype="multipart/form-data" method="post" name="upload_file">
2<input name="UserID" type="hidden" value="abc"/>
3<input name="FileUploadStart" type="hidden"/> '这里用来表示开始文件数据上传   
4File to send: <br/>
5<input name="file_up" size="30" type="file"/><br/>
6<input name="file_up" size="30" type="file"/><br/>
7<input name="FileUploadEnd" type="hidden"/> '这里用来表示文件数据结束   
8<input type="submit" value="Submit"/>
9</form>

3。ASP文件
muploadfile.asp

  1   
  2Response.Expires=0   
  3Function bin2str(binstr)   
  4Dim varlen,clow,ccc,skipflag   
  5  
  6skipflag=0   
  7ccc = ""   
  8If Not IsNull(binstr) Then   
  9varlen=LenB(binstr)   
 10For i=1 To varlen   
 11If skipflag=0 Then   
 12clow = MidB(binstr,i,1)   
 13If AscB(clow) > 127 Then   
 14ccc =ccc & Chr(AscW(MidB(binstr,i+1,1) & clow))   
 15skipflag=1   
 16Else   
 17ccc = ccc & Chr(AscB(clow))   
 18End If   
 19Else   
 20skipflag=0   
 21End If   
 22Next   
 23End If   
 24bin2str = ccc   
 25End Function   
 26  
 27  
 28varByteCount = Request.TotalBytes   
 29bnCRLF = chrB( 13 ) & chrB( 10 )   
 30binHTTPHeader=Request.BinaryRead(varByteCount)   
 31Divider = LEFTB( binHTTPHeader, INSTRB( binHTTPHeader, bnCRLF ) - 1 )   
 32  
 33'开始读非文件域的数据   
 34Do while lenB(binHTTPHeader)>46   
 35  
 36binHeaderData = LeftB(binHTTPHeader, INSTRB( binHTTPHeader, bnCRLF & bnCRLF )-1)   
 37strHeaderData=bin2str(binHeaderData)   
 38  
 39lngFieldNameStart=Instr(strHeaderData,"name="&chr(34))+Len("name="&chr(34))   
 40lngFieldNameEnd=Instr(lngFieldNameStart,strHeaderData,chr(34))   
 41  
 42  
 43strFieldName=Mid(strHeaderData,lngFieldNameStart,lngFieldNameEnd-lngFieldNameStart)   
 44strFieldName=Trim(strFieldName)   
 45strFieldName=Replace(strFieldName,vbcrlf,vbnullstring)   
 46  
 47'判断文件数据时候开始   
 48If strComp(strFieldName,"FileUploadStart",1)=0 Then   
 49binHTTPHeader=MIDB(binHTTPHeader,INSTRB( DataStart + 1, binHTTPHeader, divider ))   
 50exit do   
 51End if   
 52  
 53DataStart = INSTRB( binHTTPHeader, bnCRLF & bnCRLF ) + 4   
 54DataEnd = INSTRB( DataStart + 1, binHTTPHeader, divider ) - DataStart   
 55  
 56binFieldValue=MIDB( binHTTPHeader, DataStart, DataEnd )   
 57strFieldValue=bin2str(binFieldValue)   
 58strFieldValue=Trim(strFieldValue)   
 59strFieldValue=Replace(strFieldValue,vbcrlf,vbnullstring)   
 60  
 61'非文件上传域变量赋值   
 62execute strFieldName&"="""&strFieldValue&""""   
 63  
 64  
 65binHTTPHeader=MIDB(binHTTPHeader,INSTRB( DataStart + 1, binHTTPHeader, divider ))   
 66  
 67loop   
 68  
 69'开始处理文件数据   
 70Do while lenB(binHTTPHeader)>46   
 71  
 72  
 73binHeaderData = LeftB(binHTTPHeader, INSTRB( binHTTPHeader, bnCRLF & bnCRLF )-1)   
 74  
 75strHeaderData=bin2str(binHeaderData)   
 76  
 77'读取上传文件的Content-Type   
 78lngFileContentTypeStart=Instr(strHeaderData,"Content-Type:")+Len("Content-Type:")   
 79strFileContentType=Trim(Mid(strHeaderData,lngFileContentTypeStart))   
 80strFileContentType=Replace(strFileContentType,vbCRLF,vbNullString)   
 81  
 82'读取上传的文件名   
 83lngFileNameStart=Instr(strHeaderData,"filename="&chr(34))+Len("filename="&chr(34))   
 84lngFileNameEnd=Instr(lngFileNameStart,strHeaderData,chr(34))   
 85strFileName=Mid(strHeaderData,lngFileNameStart,lngFileNameEnd-lngFileNameStart)   
 86strFileName=Trim(strFileName)   
 87strFileName=Replace(strFileName,vbCRLF,vbNullString)   
 88  
 89'读取上传文件数据   
 90DataStart = INSTRB( binHTTPHeader, bnCRLF & bnCRLF ) + 4   
 91DataEnd = INSTRB( DataStart + 1, binHTTPHeader, divider ) - DataStart   
 92  
 93If strFileName<>"" Then   
 94  
 95binFieldValue=MIDB( binHTTPHeader, DataStart, DataEnd )   
 96  
 97'将上传的文件写入数据库   
 98set conn = Server.CreateObject("ADODB.Connection")   
 99conn.Open "DSN=abc"   
100  
101SQL="select * from User_File"   
102set rs=server.CreateObject("ADODB.Recordset")   
103rs.Open sql,conn,3,3   
104rs.addnew   
105rs("UserID")=UserID   
106rs("FileContentType")=strFileContentType   
107rs("FileContent").AppendChunk binFieldValue   
108rs.update   
109rs.close   
110set rs=Nothing   
111conn.Close   
112set conn=Nothing   
113  
114End if   
115  
116binHTTPHeader=MIDB(binHTTPHeader,INSTRB( DataStart + 1, binHTTPHeader, divider ))   
117  
118loop   

4。下载用户上传的文件

 1   
 2Response.Buffer = true   
 3Response.Clear   
 4  
 5UserID=request("UserID")   
 6  
 7Set conn=server.createobject("adodb.connection")   
 8set rs=server.createobject("adodb.recordset")   
 9conn.open "DSN=UploadFile"   
10rs.open "select * from User_File where UserID='"&UserID&"'",conn,3,3   
11Response.ContentType = rs("FileContentType")   
12  
13lngOffset=0   
14conChunkSize=1024   
15lngPictSize=rs("FileContent").ActualSize   
16Do While lngOffset < lngPictSize   
17varChunk = rs("FileContent").GetChunk(conChunkSize)   
18Response.BinaryWrite varChunk   
19lngOffset = lngOffset + conChunkSize   
20If lngOffset > lngPictSize Then Exit Do   
21Loop   
22  
23rs.close   
24set rs=Nothing   
25conn.close   
26set conn=nothing   

就是这些了,希望此方法对大家能有所帮助。:)

Published At
Categories with Web编程
Tagged with
comments powered by Disqus