怎样将jpg图片上传至服务器端的ACCESS数据库中？谢谢

zhdletter 2001-09-13 06:25:17

...全文

148 2 打赏收藏转发到动态举报

写回复

用AI写文章

2 条回复

切换为时间正序

请发表友善的回复…

发表回复

viking 2001-09-13

打赏
举报

示例一共有三个文件：upload.htm(上传界面)
process.asp(处理程序)
showimg.asp(显示图象)
数据库:在pubs数据库中建立一个新表名为imgtest
字段名　　　　类型　　长度
----------------------------------------------
id int (自动编号)
img iamge
imginfo nchar 50

以下是三个文件的代码:

upload.htm
---------------------------------------------------------------------
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<style type="text/css">

</style>
</head>

<body bgcolor="#FFFFFF" text="#000000">
<form name="form1" method="post" action="process.asp" enctype="multipart/form-data" >
<table width="71%" border="1" cellspacing="0" cellpadding="5" align="center"

bordercolordark="#CCCCCC" bordercolorlight="#000000">
<tr bgcolor="#CCCCCC">
<td height="22" align="left" valign="middle" bgcolor="#CCCCCC"> Sobina
的图文上传界面</td>
</tr>
<tr align="left" valign="middle" bgcolor="#eeeeee">
<td bgcolor="#eeeeee"> <br>
</td>
</tr>
<tr align="center" valign="middle">
<td align="left" id="upid" height="122">
<p>图象路径:
<input type="file" name="img" style="width:400" class="tx1" value="">
</p>
<p>图象说明:
<input type="text" name="imginfo">
</p>
</td>
</tr>
<tr align="center" valign="middle" bgcolor="#eeeeee">
<td bgcolor="#eeeeee" height="2">
<input type="submit" name="Submit" value="· 提交 ·" class="bt">
<input type="reset" name="Submit2" value="· 重置 ·" class="bt">
</td>
</tr>
</table>
</form>
</body>
</html>
------------------------------------------------------------------------
process.asp
------------------------------------------------------------------------

<%
response.expires=0
'目的：将二进制字符转换成普通字符
Function bin2str(binstr)
Dim varlen,clow,ccc,skipflag
skipflag=0
ccc = ""
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
bin2str = ccc
End Function

'目的：把表单中的图象数据分离出来
'其中参数formsize为表单数据大小，formdata为表单的总数据
Function ImageUp(formsize,formdata)
bncrlf=chrb(13) & chrb(10)
divider=leftb(formdata,instrb(formdata,bncrlf)-1) 'formdata第一个bncrlf左边的数据
datastart=instrb(formdata,bncrlf & bncrlf)+4 '两个bncrlf右边的数据的起始位
dataend=instrb(datastart+1,formdata,divider)-datastart
Imageup=midb(formdata,datastart,dataend)
End Function

'目的：把表单中的变量值取出
'其中参数varName为要寻找的字段变量，strTXT为已从图象中分离出来的的所有文本
Function findVar(varName,strTxt)
startPos=1
strLen=len(varName)+2
'表单中可能有多个同名变量(用在有主表与明细表中的数据更新中）
for i=1 to len(strTXT)
varStart=instr(startPos,strTXT,varName)+strLen+3
varEnd=instr(varStart,strTXT,"--")-2
varValLen=varEnd-varStart

inVar=mid(strTXT,varStart,varValLen)
findVar=findVar & inVar

startPos=instr(varStart,strTXT,varName)
if startPos=0 then exit for '如果找不到则退出循环
findVar=findVar & "," ' 以","作为多个同名变量值间的分隔符,实际上本例倒不需要
next

End function

FormSize = Request.TotalBytes
FormData = Request.BinaryRead( FormSize )
Image = ImageUp(FormSize,Formdata)

'以下两步不能省略，否则取不出文字
strTXT=mid(formdata,instr(formdata,image)+len(image)+1) '取出文字
strTXT=bin2str(strTXT) '二进制转换成普通文字

imginfo=findVar("imginfo",strTXT) '相当于request.form("imginfo")
'MyArray = Split(imginfo, ",", -1, 1) '分离从imginfo返回的多个值,在本例子中不用

Application.Lock
set objCnn=Server.CreateObject("ADODB.Connection")
objCnn.Open strCnn
set rec=Server.CreateObject("ADODB.Recordset")
rec.Open "imgtest",objCnn,1,3
rec.addnew '如果你只想更新一个记录，则可使这句失效
rec("imginfo")=imginfo
if Len(Image)>1 then
rec("img").Appendchunk Image '把图象写入数据库
end if
rec.update
rec.close:set rec=nothing
set objCnn=Nothing
Application.Unlock
'输出图象说明和图象
response.write imginfo
response.write "<img src='showimg.asp?imginfo=" & imginfo & "' boder=0>"
%>
-----------------------------------------------------------------------
showimg.asp
-----------------------------------------------------------------------

<%
response.expires=0
response.buffer=true
response.clear
Response.ContentType = "image/*"

set objCnn=server.CreateObject("ADODB.connection")
objCnn.Open strCnn

strsql="SELECT * FROM imgtest where imginfo='" & Request.QueryString("imginfo") & "'"
set rec=objCnn.Execute(strsql)

Response.BinaryWrite rec("img")

rec.close:set rec=nothing
set objCnn=nothing
%>

lanying 2001-09-13

打赏
举报

index.asp
<html>
<head>
<title>上传图标</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<style type="text/css">

</style>
</head>

<body bgcolor="#FFFFFF">
<table width="95%" border="0" align="center" cellpadding="5">
<tr align="center" valign="middle">
<td> <b> </b>
<form method="post" action="savelogo.asp" name="reg" enctype="multipart/form-data">
文件名：
<input type="file" name="file" size="32">
<br>
用户名：
<input type="text" name="id" value="test">
（如果已经存在用户，则覆盖）<br>
<input type="ddd" name="mydata" value="">
<br>
<input type="submit" name="Submit" value="开始上传">
<input type="reset" name="reset" value="重新选择">
<br>
</form>
</td>
</tr>
<tr align="center">
<td>
<table width="380" border="1" cellspacing="0" cellpadding="2" bordercolordark="#FFFFFF" bordercolorlight="#000000">
<tr>
<td width="544" bgcolor="#003399"><font color="#FFFFFF"><b>关于图标制作 </b></font></td>
</tr>
<tr>
<td width="544">
<table width="100%" border="0">
<tr>
<td width="6%"><img src="http://www.qbtrade.com/images/make.gif" width="32" height="32"></td>
<td width="94%">如果你不会做图标，我们可以帮你代做，代价是你付出一定的Q币，当然你也可以请别人帮你做，我们的首页上就有一些免费帮别人做图标的网站的链接。</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<tr align="center">
<td>Copyright ?By <a href="http://www.qbtrade.com">QBTrade</a>? Group, 2000.8.30<br>
All rights Reserved </td>
</tr>
</table>
<script language=vbscript>
function reg_Onsubmit()
if document.reg.id.value="" then
msgbox "用户名必须填写！"
reg_onsubmit=false
exit function
else
document.reg.action="savelogo.asp?id=" & document.reg.id.value & "&mydata=" & document.reg.mydata.value
end if
end function
</script>
</body>
</html>
savelogo.asp
<%
' Allrights Qbtrade.com
' Maozai
dim conn
dim connstr
dim rs
dim sql

on error resume next
call conn_init()
id=Request.QueryString("id")
mydata=Request.QueryString("mydata")

FormSize = Request.TotalBytes
FormData = Request.BinaryRead(FormSize)
Image=ImageUp (FormSize,Formdata)

set rs=server.CreateObject("adodb.recordset")
sql="SELECT * FROM imgdata WHERE user ='" &id &"'"
rs.Open sql,conn,1,3
if rs.recordcount = 0 then
rs.close
sql="SELECT * FROM imgdata"
rs.Open sql,conn,1,3
rs.AddNew
rs("user") = id
rs("mydata") = mydata
rs("imagedata") = NULL
rs("imagedata").appendchunk Image
else
rs("imagedata") = NULL
rs("imagedata").appendchunk Image
end if

rs.Update
rs.Close
set rs=nothing
endconnection

%>
<style type="text/css">

</style>
<title>完成</title>
<body bgcolor="#FFFFFF" text="#000000">
<table width="95%" border="0" align="center" cellpadding="5" height="167">
<tr align="center" valign="middle">
<td height="128">
<p>恭喜，<%=id%>，你已经上传了你的图标，加入了QBTrade宣传的行列！</p>
<p>以下是你刚才上传的图标，如果你不满意，可以返回重新修改一次。</p>
<p><img src="showlogo.asp?id=<%=id%>"></p>
</td>
</tr>
</table>
<div align="center">Copyright ?By <a href="http://www.qbtrade.com">QBTrade</a>?
Group, 2000.8.30<br>
All rights Reserved </div>
<p align="center"></p>
<%

function ImageUp(formsize,formdata)
bncrlf=chrb(13) & chrb(10)
divider=leftb(formdata,instrb(formdata,bncrlf)-1)
datastart=instrb(formdata,bncrlf&bncrlf)+4
dataend=instrb(datastart+1,formdata,divider)-datastart
imageup=midb(formdata,datastart,dataend)
end function

'-------------------------
sub conn_init()
connstr="DBQ="+server.mappath("image.mdb")+";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"
set conn=server.createobject("ADODB.CONNECTION")
if err.number<>0 then
err.clear
set conn=nothing
response.write "数据库连接出错！"
Response.End
else
conn.open connstr
if err then
'err.clear
set conn=nothing
response.write "数据库连接出错！！！<br>" + err.description
err.clear
Response.End
end if
end if
end sub

sub endConnection()
conn.close
set conn=nothing
end sub

%>
showlogo.asp
<%

dim conn
dim connstr
dim rs
dim sql
dim id
id = request("id")

on error resume next
call conn_init()

set rs=server.CreateObject("adodb.recordset")
sql="SELECT * FROM imgdata WHERE user = '" & id & "'"
rs.Open sql,conn,1,1
response.contenttype="x-mixed-replace"
Response.BinaryWrite rs("imagedata")
rs.Close

endconnection

function ImageUp(formsize,formdata) '这个函数的功能是截取其中的图像部分。
bncrlf=chrb(13) & chrb(10) '做成函数后。以后你可以自己随意使用了。
divider=leftb(formdata,instrb(formdata,bncrlf)-1)
datastart=instrb(formdata,bncrlf&bncrlf)+4
dataend=instrb(datastart+1,formdata,divider)-datastart
imageup=midb(formdata,datastart,dataend)
end function

'-------------------------
sub conn_init()
connstr="DBQ="+server.mappath("image.mdb")+";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"
set conn=server.createobject("ADODB.CONNECTION")
if err.number<>0 then
err.clear
set conn=nothing
response.write "数据库连接出错！"
Response.End
else
conn.open connstr
if err then
'err.clear
set conn=nothing
response.write "数据库连接出错！！！<br>" + err.description
err.clear
Response.End
end if
end if
end sub

sub endConnection()
conn.close
set conn=nothing
end sub

%>