asp上传文件保存(asp上传大文件)

http://www.itjxue.com  2023-02-11 11:50  来源:未知  点击次数: 

在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) 是保存

(责任编辑:IT教学网)

更多

推荐Oracle认证文章