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("imagedata") = NULL
rs("imagedata").appendchunk Image
else
rs("imagedata") = NULL
rs("imagedata").appendchunk Image
end if
'-------------------------
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
%>
----------------show.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
if rs.recordcount = 0 then
rs.close
rs.open "SELECT * FROM imgdata WHERE user = 'not_available'",conn,1,1
end if
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