asp上传文件保存(asp上传大文件)
在ASP中如何上传图片到文件夹并且将该图片的路径保存到ACEESS数据库?要详细的代码。。。急~~
代码太长,搞不上来
你可以用无惧无组件上传方式
设定一个表单
其中一个文本框,后面跟一个上传浏览项
调用无惧无组件上传类
返回保存文件路径给表单,提交并保存到数据库存就好了
求ASP多个文件上传,并将路径保存到数据库。
完整的代码,有部分注释,应该看的明白...需要你手动设置一下,如 :数据库路径,上传路径等等代码如下:%
if lcase(request("upload"))="true" then
dim upload,file,formName,formPath,iCount
dim upmsg
set upload=new upload_5xSoft
SET conn =SERVER.CREATEOBJECT("ADODB.CONNECTION")
SET rs =SERVER.CREATEOBJECT("ADODB.RECORDSET")
conn.open "driver={Microsoft Access Driver (*.mdb)};dbq=" server.mappath("ss.mdb") '要写入数据库路径
formpath=server.mappath(".") "\" '上传文件路径
iCount=0
for each formName in upload.file
set file=upload.file(formName)
if file.FileSize0 then
file.SaveAs formPath replace(file.FileName," ","")
upmsg=upmsg vbcrlf replace(file.FileName," ","") " 上传成功!" '开始把上传文件名称写入数据库
rs.open "select * from upload",conn,1,3
rs.addnew
rs("文件名")=formPath replace(file.FileName," ","")
rs.update
rs.close
'写入数据库结束 iCount=iCount+1
end if
set file=nothing
next
set upload=nothing ''删除此对象
upmsg=upmsg vbcrlf iCount" 个文件上传结束!"
response.write "script" vbcrlf
upmsg=replace(upmsg,vbcrlf,"")
response.write "ts.innerHTML='';" vbcrlf
response.write "alert('" upmsg "');" vbcrlf
response.write "location='dd.asp';" vbcrlf '要返回的地址
response.write "/script" vbcrlf
response.end
end if
%
SCRIPT RUNAT=SERVER LANGUAGE=VBSCRIPT
'*********
'*化境上传*
'*********
dim upfile_5xSoft_Stream
Class upload_5xSoft
dim Form,File,Version
Private Sub Class_Initialize
dim iStart,iFileNameStart,iFileNameEnd,iEnd,vbEnter,iFormStart,iFormEnd,theFile
dim strDiv,mFormName,mFormValue,mFileName,mFileSize,mFilePath,iDivLen,mStr
if Request.TotalBytes1 then
Exit Sub
end if
set Form=CreateObject("Scripting.Dictionary")
set File=CreateObject("Scripting.Dictionary")
set upfile_5xSoft_Stream=CreateObject("Adodb.Stream")
upfile_5xSoft_Stream.mode=3
upfile_5xSoft_Stream.type=1
upfile_5xSoft_Stream.open
upfile_5xSoft_Stream.write Request.BinaryRead(Request.TotalBytes)
vbEnter=Chr(13)Chr(10)
iDivLen=inString(1,vbEnter)+1
strDiv=subString(1,iDivLen)
iFormStart=iDivLen
iFormEnd=inString(iformStart,strDiv)-1
while iFormStart iFormEnd
iStart=inString(iFormStart,"name=""")
iEnd=inString(iStart+6,"""")
mFormName=subString(iStart+6,iEnd-iStart-6)
iFileNameStart=inString(iEnd+1,"filename=""")
if iFileNameStart0 and iFileNameStartiFormEnd then
iFileNameEnd=inString(iFileNameStart+10,"""")
mFileName=subString(iFileNameStart+10,iFileNameEnd-iFileNameStart-10)
iStart=inString(iFileNameEnd+1,vbEntervbEnter)
iEnd=inString(iStart+4,vbEnterstrDiv)
if iEndiStart then
mFileSize=iEnd-iStart-4
else
mFileSize=0
end if
set theFile=new FileInfo
theFile.FileName=getFileName(mFileName)
theFile.FilePath=getFilePath(mFileName)
theFile.FileSize=mFileSize
theFile.FileStart=iStart+4
theFile.FormName=FormName
file.add mFormName,theFile
else
iStart=inString(iEnd+1,vbEntervbEnter)
iEnd=inString(iStart+4,vbEnterstrDiv)
if iEndiStart then
mFormValue=subString(iStart+4,iEnd-iStart-4)
else
mFormValue=""
end if
form.Add mFormName,mFormValue
end if
iFormStart=iformEnd+iDivLen
iFormEnd=inString(iformStart,strDiv)-1
wend
End Sub
Private Function subString(theStart,theLen)
dim i,c,stemp
upfile_5xSoft_Stream.Position=theStart-1
stemp=""
for i=1 to theLen
if upfile_5xSoft_Stream.EOS then Exit for
c=ascB(upfile_5xSoft_Stream.Read(1))
If c 127 Then
if upfile_5xSoft_Stream.EOS then Exit for
stemp=stempChr(AscW(ChrB(AscB(upfile_5xSoft_Stream.Read(1)))ChrB(c)))
i=i+1
else
stemp=stempChr(c)
End If
Next
subString=stemp
End function
Private Function inString(theStart,varStr)
dim i,j,bt,theLen,str
InString=0
Str=toByte(varStr)
theLen=LenB(Str)
for i=theStart to upfile_5xSoft_Stream.Size-theLen
if iupfile_5xSoft_Stream.size then exit Function
upfile_5xSoft_Stream.Position=i-1
if AscB(upfile_5xSoft_Stream.Read(1))=AscB(midB(Str,1)) then
InString=i
for j=2 to theLen
if upfile_5xSoft_Stream.EOS then
inString=0
Exit for
end if
if AscB(upfile_5xSoft_Stream.Read(1))AscB(MidB(Str,j,1)) then
InString=0
Exit For
end if
next
if InString0 then Exit Function
end if
next
End Function
Private Sub Class_Terminate
form.RemoveAll
file.RemoveAll
set form=nothing
set file=nothing
upfile_5xSoft_Stream.close
set upfile_5xSoft_Stream=nothing
End Sub
Private function GetFilePath(FullPath)
If FullPath "" Then
GetFilePath = left(FullPath,InStrRev(FullPath, "\"))
Else
GetFilePath = ""
End If
End function
Private function GetFileName(FullPath)
If FullPath "" Then
GetFileName = mid(FullPath,InStrRev(FullPath, "\")+1)
Else
GetFileName = ""
End If
End function
Private function toByte(Str)
dim i,iCode,c,iLow,iHigh
toByte=""
For i=1 To Len(Str)
c=mid(Str,i,1)
iCode =Asc(c)
If iCode0 Then iCode = iCode + 65535
If iCode255 Then
iLow = Left(Hex(Asc(c)),2)
iHigh =Right(Hex(Asc(c)),2)
toByte = toByte chrB("H"iLow) chrB("H"iHigh)
Else
toByte = toByte chrB(AscB(c))
End If
Next
End function
End Class
Class FileInfo
dim FormName,FileName,FilePath,FileSize,FileStart
Private Sub Class_Initialize
FileName = ""
FilePath = ""
FileSize = 0
FileStart= 0
FormName = ""
End Sub
Public function SaveAs(FullPath)
dim dr,ErrorChar,i
SaveAs=1
if trim(fullpath)="" or FileSize=0 or FileStart=0 or FileName="" then exit function
if FileStart=0 or right(fullpath,1)="/" then exit function
set dr=CreateObject("Adodb.Stream")
dr.Mode=3
dr.Type=1
dr.Open
upfile_5xSoft_Stream.position=FileStart-1
upfile_5xSoft_Stream.copyto dr,FileSize
dr.SaveToFile FullPath,2
dr.Close
set dr=nothing
SaveAs=0
end function
End Class
/SCRIPT
script
function setid()
{
str='br';
if(!window.form3.upcount.value)
window.form3.upcount.value=1;
for(i=1;i=window.form3.upcount.value;i++)
str+='文件'+i+':input type=file name=file'+i+' style="width:400px"brbr';
window.upid.innerHTML=str+'br';
}
/script
form name=form3 method='post' action='?upload=true' enctype='multipart/form-data'
table style='border:white 1px solid;font-size:12px;font-family:arial;color:black;font-weight:bold;background:#FF9900'
tr
td colspan=2 align=center style='border-bottom:white 2px solid'
上传文件
/td
/tr
tr
td
上传个数
/td
td
input name=upcount value=1 onchange='setid()'
/td
/tr
tr
td colspan=2 style='border-top:white 2px solid'
div id='upid'
文件1input type='file' name=file1 style='width:400px' value=''
/div
/td
/tr
tr
td align=center colspan=2
input type='submit' name=submit3 value='提交'
/td
/tr
/table
/form
asp.net多文件上传并把路劲保存到SQL数据库
1、多文件上传 你可以通过数组或者集合来保存每一个文件的路径和文件名
2、传递到后台后循环遍历插入即可
在这段asp代码中,那一句是“上传文件”的文件名,那一句是保存文件的语句
file.filename 是文件名
set result = file.saveToFile(savepath,0,true) 是保存