asp 文件上传(无组件上传)

最新推荐文章于 2014-05-10 09:18:49 发布

weixin_33719619

最新推荐文章于 2014-05-10 09:18:49 发布

阅读量246

点赞数

文章标签：数据库

文件1.上传界面文件 upload.htm
<html>
<head>
<meta
http-equiv="Content-Language" content="zh-cn">
<meta
http-equiv="Content-Type" content="text/html;
charset=gb2312">
<title>文件上传</title>
</head>

<body>
<form
method="POST" action="SaveFile.asp">
文件上传：<input type="file"
name="file" size="42"> <input type="submit" value="提交"
name="bb">
</form>
</body>
</html>

文件2.保存上传文件
SaveFile.asp
<%
dim file,filename,houzui
file = Request.Form("file")
if file="" then
response.write"<script>alert('请选择要上传的文件！');window.location.href='upload.htm';</script>"
else
houzui=mid(file,InStrRev(file, "."))
if houzui=".gif" or houzui=".jpg" or houzui=".bmp" then '允许上传的文件类型
filename=year(date) & month(date) & day(date) & Hour(time) & minute(time) & second(time) & houzui
Set objStream = Server.CreateObject("ADODB.Stream")
objStream.Type = 1
objStream.Open
objStream.LoadFromFile file
objStream.SaveToFile
Server.MapPath(filename),2
objStream.Close

'把文件名写入数据库，如无需要，可删除此段代码！
Set conn = Server.CreateObject("ADODB.Connection")
conn.open "Driver={SQL Server};Server=(Local);UID=sa;PWD=123;"&"database=db_search;"
set rs=server.CreateObject("adodb.recordset")
rs.open "select*from img",conn,1,2
rs.addnew
rs("name")=filename
rs.update

rs.Close
set rs=nothing
conn.Close
set conn=nothing

'========================================

response.write"<script>alert('图片上传成功！');window.location.href='upload.htm';</script>"
else
response.write"<script>alert('不允许上传" & houzui & "的格式！');window.location.href='upload.htm';</script>"
end if
end if
%>