當前位置:編程學習大全網 - 源碼下載 - 求asp上傳視頻到指定文件夾並寫入文件名到數據庫代碼

求asp上傳視頻到指定文件夾並寫入文件名到數據庫代碼

以下是壹個上傳圖片的ASP程序,只要修改下後綴名就可上傳視頻文件,並保存至數據庫

---上傳組件(upload_5xsoft.asp)

<%

dim Data_5xsoft

Class upload_5xsoft

dim objForm,objFile,Version

Public function Form(strForm)

strForm=lcase(strForm)

if not objForm.exists(strForm) then

Form=""

else

Form=objForm(strForm)

end if

end function

Public function File(strFile)

strFile=lcase(strFile)

if not objFile.exists(strFile) then

set File=new FileInfo

else

set File=objFile(strFile)

end if

end function

Private Sub Class_Initialize

dim RequestData,sStart,vbCrlf,sInfo,iInfoStart,iInfoEnd,tStream,iStart,theFile

dim iFileSize,sFilePath,sFileType,sFormValue,sFileName

dim iFindStart,iFindEnd

dim iFormStart,iFormEnd,sFormName

Version="化境HTTP上傳程序 Version 2.1"

set objForm=Server.CreateObject("Scripting.Dictionary")

set objFile=Server.CreateObject("Scripting.Dictionary")

if Request.TotalBytes<1 then Exit Sub

set tStream = Server.CreateObject("adodb.stream")

set Data_5xsoft = Server.CreateObject("adodb.stream")

Data_5xsoft.Type = 1

Data_5xsoft.Mode =3

Data_5xsoft.Open

Data_5xsoft.Write Request.BinaryRead(Request.TotalBytes)

Data_5xsoft.Position=0

RequestData =Data_5xsoft.Read

iFormStart = 1

iFormEnd = LenB(RequestData)

vbCrlf = chrB(13) & chrB(10)

sStart = MidB(RequestData,1, InStrB(iFormStart,RequestData,vbCrlf)-1)

iStart = LenB (sStart)

iFormStart=iFormStart+iStart+1

while (iFormStart + 10) < iFormEnd

iInfoEnd = InStrB(iFormStart,RequestData,vbCrlf & vbCrlf)+3

tStream.Type = 1

tStream.Mode =3

tStream.Open

Data_5xsoft.Position = iFormStart

Data_5xsoft.CopyTo tStream,iInfoEnd-iFormStart

tStream.Position = 0

tStream.Type = 2

'tStream.Charset ="gb2312"

tStream.Charset ="utf-8"

sInfo = tStream.ReadText

tStream.Close

'取得表單項目名稱

iFormStart = InStrB(iInfoEnd,RequestData,sStart)

iFindStart = InStr(22,sInfo,"name=""",1)+6

iFindEnd = InStr(iFindStart,sInfo,"""",1)

sFormName = lcase(Mid (sinfo,iFindStart,iFindEnd-iFindStart))

'如果是文件

if InStr (45,sInfo,"filename=""",1) > 0 then

set theFile=new FileInfo

'取得文件名

iFindStart = InStr(iFindEnd,sInfo,"filename=""",1)+10

iFindEnd = InStr(iFindStart,sInfo,"""",1)

sFileName = Mid (sinfo,iFindStart,iFindEnd-iFindStart)

theFile.FileName=getFileName(sFileName)

theFile.FilePath=getFilePath(sFileName)

theFile.FileExt=GetFileExt(sFileName)

'取得文件類型

iFindStart = InStr(iFindEnd,sInfo,"Content-Type: ",1)+14

iFindEnd = InStr(iFindStart,sInfo,vbCr)

theFile.FileType =Mid (sinfo,iFindStart,iFindEnd-iFindStart)

theFile.FileStart =iInfoEnd

theFile.FileSize = iFormStart -iInfoEnd -3

theFile.FormName=sFormName

if not objFile.Exists(sFormName) then

objFile.add sFormName,theFile

end if

else

'如果是表單項目

tStream.Type =1

tStream.Mode =3

tStream.Open

Data_5xsoft.Position = iInfoEnd

Data_5xsoft.CopyTo tStream,iFormStart-iInfoEnd-3

tStream.Position = 0

tStream.Type = 2

' tStream.Charset ="gb2312"

tStream.Charset ="utf-8"

sFormValue = tStream.ReadText

tStream.Close

if objForm.Exists(sFormName) then

objForm(sFormName)=objForm(sFormName)&", "&sFormValue

else

objForm.Add sFormName,sFormValue

end if

end if

iFormStart=iFormStart+iStart+1

wend

RequestData=""

set tStream =nothing

End Sub

Private Sub Class_Terminate

if Request.TotalBytes>0 then

objForm.RemoveAll

objFile.RemoveAll

set objForm=nothing

set objFile=nothing

Data_5xsoft.Close

set Data_5xsoft =nothing

end if

End Sub

Private function GetFilePath(FullPath)

If FullPath <> "" Then

GetFilePath = left(FullPath,InStrRev(FullPath, "\"))

Else

GetFilePath = ""

End If

End function

Private function GetFileExt(FullPath)

If FullPath <> "" Then

GetFileExt = mid(FullPath,InStrRev(FullPath, ".")+1)

Else

GetFileExt = ""

End If

End function

Private function GetFileName(FullPath)

If FullPath <> "" Then

GetFileName = mid(FullPath,InStrRev(FullPath, "\")+1)

Else

GetFileName = ""

End If

End function

End Class

Class FileInfo

dim FormName,FileName,FilePath,FileSize,FileExt,FileType,FileStart

Private Sub Class_Initialize

FileName = ""

FilePath = ""

FileSize = 0

FileStart= 0

FormName = ""

FileType = ""

FileExt = ""

End Sub

Public function SaveAs(FullPath)

dim dr,ErrorChar,i

SaveAs=true

if trim(fullpath)="" or FileStart=0 or FileName="" or right(fullpath,1)="/" then exit function

set dr=CreateObject("Adodb.Stream")

dr.Mode=3

dr.Type=1

dr.Open

Data_5xsoft.position=FileStart

Data_5xsoft.copyto dr,FileSize

dr.SaveToFile FullPath,2

dr.Close

set dr=nothing

SaveAs=false

end function

End Class

%>

------處理頁面--------

<!--#include file="include/upload_5xsoft.asp"-->

<body>

<%

'獲取表單數據

dim name,from,sort,image,xinjiu,price,about,fname

set upload=new upload_5xsoft ''建立上傳對象

name=trim(upload.form("name"))

from=trim(upload.form("from"))

sort=trim(upload.form("sort"))

xinjiu=trim(upload.form("new"))

price=trim(upload.form("price"))

about=trim(upload.form("about"))

'獲取上傳的圖像

if trim(upload.file("image").filename)="" then

fname="nofile.png"

else

set image=upload.file("image")

'判斷上傳文件的格式

if lcase(image.FileExt) <> "jpg" and lcase(image.FileExt)<> "gif" then

set image=nothing

set upload=nothing

cnn.close

set cnn=nothing

showalert("上傳的圖片格式只能是(jpg和gif)!")

showscript("window.location.href='good_add.asp'")

end if

'圖片文件名使用上傳的時間表示

dim str

str=now

str=replace(str,"-","")

str=replace(str,":","")

str=replace(str," ","")

fname=str & "." & image.FileExt

'上傳文件到指定文件夾

image.saveas server.MapPath("../upload/" & fname)

set image=nothing

set upload=nothing ''刪除此對象

end if

'將物品信息寫入數據庫

dim rs

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

rs.open "T_GOOD",cnn,3,3

rs.addnew

rs("G_name")=name

rs("G_from")=from

rs("G_image")=fname

rs("G_sort")=sort

rs("G_starttime")=now

rs("G_price")=cdbl(price)

rs("G_new")=cint(xinjiu)

rs("G_state")=1

rs("G_about")=about

rs.update

rs.close

set rs=nothing

cnn.close

set cnn=nothing

showalert("物品添加成功!")

showscript("window.location.href='good_query.asp'")

%>

</body>

</html>

  • 上一篇:如何打開7z文件,如何打開7z文件。
  • 下一篇:是 微軟模擬飛行X 好玩還是 X-plane 好玩啊,哪個更真實,我有 微軟模擬飛行X
  • copyright 2024編程學習大全網