¡¾·±ÌåÖÐÎÄ¡¿
¡¾ÉèΪÊ×Ò³¡¿
¡¾¼ÓÈëÊղء¿
µ±Ç°Î»ÖãºASP¼¼ÊõÊ×Ò³ >> ASPÓ¦Óà >> ÎÞ×é¼þÎļþÉÏ´«´úÂëʵÀý£¨Ö§³Ö¶àÎļþÉÏ´«¼°ÎļþºÍinputÓò»ìºÏÉÏ´«£©

ÎÞ×é¼þÎļþÉÏ´«´úÂëʵÀý£¨Ö§³Ö¶àÎļþÉÏ´«¼°ÎļþºÍinputÓò»ìºÏÉÏ´«£©

2004-10-01 08:26:10  ×÷Õߣº  À´Ô´£º»¥ÁªÍø  ä¯ÀÀ´ÎÊý£º44  ÎÄ×Ö´óС£º¡¾´ó¡¿¡¾ÖС¿¡¾Ð¡¡¿
¼ò½é£º¹ØÓÚÎÞ×é¼þÎļþÉÏ´«µÄÎÄÕÂÒѾ­ºÜ¶àÁË£¬ËùÒÔÔÚÕâÀïÎÒ²»ÏëÔÙ½âÊÍÎÞ×é¼þÎļþÉÏ´«µÄÔ­Àí¡£ÔÚASPÖÐÎÞ·¨½«¶þ½øÖÆÎļþÊý¾ÝÖ±½Ó±£´æ³ÉÎļþ£¬ËùÒÔÎÒÃÇÒ»°ã»¹ÊÇÀûÓÃÊý¾Ý¿âÀ´±£´æÓû§ÉÏ´«µÄÎļþ¡£ 1¡£Êý¾Ý¿â±í½á¹¹(Access)...

¹ØÓÚÎÞ×é¼þÎļþÉÏ´«µÄÎÄÕÂÒѾ­ºÜ¶àÁË£¬ËùÒÔÔÚÕâÀïÎÒ²»ÏëÔÙ½âÊÍÎÞ×é¼þÎļþÉÏ´«µÄÔ­Àí¡£ÔÚASPÖÐÎÞ·¨½«¶þ½øÖÆÎļþÊý¾ÝÖ±½Ó±£´æ³ÉÎļþ£¬ËùÒÔÎÒÃÇÒ»°ã»¹ÊÇÀûÓÃÊý¾Ý¿âÀ´±£´æÓû§ÉÏ´«µÄÎļþ¡£

1¡£Êý¾Ý¿â±í½á¹¹(Access)£º

UserID:Text(±£´æÉÏ´«ÎļþµÄÓû§ID)

FileContentType:Text(ÓÃÀ´±£´æÉÏ´«ÎļþµÄÀàÐÍ£¬eg:"Application/msword"£¬Ö÷ÒªÓÃÀ´Ê¹Óû§ÄÜÕýÈ·ÏÂÔØ´ËÎļþ£©

FileContent:OLE Object£¨±£´æÎļþÊý¾Ý£©

2¡£HTMLÎļþ

muploadfile.htm

'ÕâÀïÓÃÀ´±íʾ¿ªÊ¼ÎļþÊý¾ÝÉÏ´«

File to send:



'ÕâÀïÓÃÀ´±íʾÎļþÊý¾Ý½áÊø

3¡£ASPÎļþ

muploadfile.asp

<%

Response.Expires=0

Function bin2str(binstr)

Dim varlen,clow,ccc,skipflag

skipflag=0

ccc = ""

If Not IsNull(binstr) Then

varlen=LenB(binstr)

For i=1 To varlen

If skipflag=0 Then

clow = MidB(binstr,i,1)

If AscB(clow) > 127 Then

ccc =ccc & Chr(AscW(MidB(binstr,i+1,1) & clow))

skipflag=1

Else

ccc = ccc & Chr(AscB(clow))

End If

Else

skipflag=0

End If

Next

End If

bin2str = ccc

End Function

varByteCount = Request.TotalBytes

bnCRLF = chrB( 13 ) & chrB( 10 )

binHTTPHeader=Request.BinaryRead(varByteCount)

Divider = LEFTB( binHTTPHeader, INSTRB( binHTTPHeader, bnCRLF ) - 1 )

'¿ªÊ¼¶Á·ÇÎļþÓòµÄÊý¾Ý

Do while lenB(binHTTPHeader)>46

binHeaderData = LeftB(binHTTPHeader, INSTRB( binHTTPHeader, bnCRLF & bnCRLF )-1)

strHeaderData=bin2str(binHeaderData)

lngFieldNameStart=Instr(strHeaderData,"name="&chr(34))+Len("name="&chr(34))

lngFieldNameEnd=Instr(lngFieldNameStart,strHeaderData,chr(34))

strFieldName=Mid(strHeaderData,lngFieldNameStart,lngFieldNameEnd-lngFieldNameStart)

strFieldName=Trim(strFieldName)

strFieldName=Replace(strFieldName,vbcrlf,vbnullstring)

'ÅжÏÎļþÊý¾Ýʱºò¿ªÊ¼

If strComp(strFieldName,"FileUploadStart",1)=0 Then

binHTTPHeader=MIDB(binHTTPHeader,INSTRB( DataStart + 1, binHTTPHeader, divider ))

exit do

End if

DataStart = INSTRB( binHTTPHeader, bnCRLF & bnCRLF ) + 4

DataEnd = INSTRB( DataStart + 1, binHTTPHeader, divider ) - DataStart

binFieldValue=MIDB( binHTTPHeader, DataStart, DataEnd )

strFieldValue=bin2str(binFieldValue)

strFieldValue=Trim(strFieldValue)

strFieldValue=Replace(strFieldValue,vbcrlf,vbnullstring)

'·ÇÎļþÉÏ´«Óò±äÁ¿¸³Öµ

execute strFieldName&"="""&strFieldValue&""""

binHTTPHeader=MIDB(binHTTPHeader,INSTRB( DataStart + 1, binHTTPHeader, divider ))

loop

'¿ªÊ¼´¦ÀíÎļþÊý¾Ý

Do while lenB(binHTTPHeader)>46

binHeaderData = LeftB(binHTTPHeader, INSTRB( binHTTPHeader, bnCRLF & bnCRLF )-1)

strHeaderData=bin2str(binHeaderData)

'¶ÁÈ¡ÉÏ´«ÎļþµÄContent-Type

lngFileContentTypeStart=Instr(strHeaderData,"Content-Type:")+Len("Content-Type:")

strFileContentType=Trim(Mid(strHeaderData,lngFileContentTypeStart))

strFileContentType=Replace(strFileContentType,vbCRLF,vbNullString)

'¶ÁÈ¡ÉÏ´«µÄÎļþÃû

lngFileNameStart=Instr(strHeaderData,"filename="&chr(34))+Len("filename="&chr(34))

lngFileNameEnd=Instr(lngFileNameStart,strHeaderData,chr(34))

strFileName=Mid(strHeaderData,lngFileNameStart,lngFileNameEnd-lngFileNameStart)

strFileName=Trim(strFileName)

strFileName=Replace(strFileName,vbCRLF,vbNullString)

'¶ÁÈ¡ÉÏ´«ÎļþÊý¾Ý

DataStart = INSTRB( binHTTPHeader, bnCRLF & bnCRLF ) + 4

DataEnd = INSTRB( DataStart + 1, binHTTPHeader, divider ) - DataStart

If strFileName<>"" Then

binFieldValue=MIDB( binHTTPHeader, DataStart, DataEnd )

'½«ÉÏ´«µÄÎļþдÈëÊý¾Ý¿â

set conn = Server.CreateObject("ADODB.Connection")

conn.Open "DSN=abc"

SQL="select * from User_File"

set rs=server.CreateObject("ADODB.Recordset")

rs.Open sql,conn,3,3

rs.addnew

rs("UserID")=UserID

rs("FileContentType")=strFileContentType

rs("FileContent").AppendChunk binFieldValue

rs.update

rs.close

set rs=Nothing

conn.Close

set conn=Nothing

End if

binHTTPHeader=MIDB(binHTTPHeader,INSTRB( DataStart + 1, binHTTPHeader, divider ))

loop

%>

4¡£ÏÂÔØÓû§ÉÏ´«µÄÎļþ

<%

Response.Buffer = true

Response.Clear

UserID=request("UserID")

Set conn=server.createobject("adodb.connection")

set rs=server.createobject("adodb.recordset")

conn.open "DSN=UploadFile"

rs.open "select * from User_File where UserID='"&UserID&"'",conn,3,3

Response.ContentType = rs("FileContentType")

lngOffset=0

conChunkSize=1024

lngPictSize=rs("FileContent").ActualSize

Do While lngOffset < lngPictSize

varChunk = rs("FileContent").GetChunk(conChunkSize)

Response.BinaryWrite varChunk

lngOffset = lngOffset + conChunkSize

If lngOffset > lngPictSize Then Exit Do

Loop

rs.close

set rs=Nothing

conn.close

set conn=nothing

%>

¾ÍÊÇÕâЩÁË£¬Ï£Íû´Ë·½·¨¶Ô´ó¼ÒÄÜÓÐËù°ïÖú¡££º£©

ÔðÈα༭£ºadmin
±¾ÎÄÒýÓõØÖ·£º http://www.3pcode.com/asp/2004/10/353.htm
Ïà¹ØÎÄÕÂ