直接往数据库中插图片???
在数据库(sql)中使用image类型,以下是从数据库中取图片的代码:
set conn=opendb("conn")
Set rs=Server.CreateObject("ADODB.recordset")
sql="select photo from manpower_personinf where id=" & trim(request("id"))
rs.open sql,conn,1,1
Response.ContentType = "image/*"
Response.BinaryWrite rs("photo").getChunk(7500000)
rs.close
set rs=nothing
set conn=nothing
在数据库(sql)中使用image类型,以下是从数据库中取图片的代码:
set conn=opendb("conn")
Set rs=Server.CreateObject("ADODB.recordset")
sql="select photo from manpower_personinf where id=" & trim(request("id"))
rs.open sql,conn,1,1
Response.ContentType = "image/*"
Response.BinaryWrite rs("photo").getChunk(7500000)
rs.close
set rs=nothing
set conn=nothing
{
var cpicture = recordSet("picture"); //读出数据库里的路径数据放入cpicture
Response.Write("<tr>");
Response.Write("<td>");
Response.Write(recordSet("year"));
Response.Write("</td>");
Response.Write("<td>");
Response.Write("<img src=../picture/hostelsp/ & cpicture width=50 height=50>");//想要的是可以调用变量cpicture作为路径的一部分,可是好像那里不对
Response.Write("</td>");
Response.Write("<td>");
Response.Write(recordSet("p-description"));
Response.Write("</td>");
Response.Write("</tr>"); recordSet.MoveNext();
}Response.Write("</table>");%>
Response.Write("<img src=../picture/hostelsp/" & cpicture & "width=50 height=50>")
<%var recordSet = Server.CreateObject("ADODB.RecordSet");recordSet.Open("select * from picture where year=1946;","DSN=willenhall");Response.Write("<table border=1 align=center>");while(!recordSet.EOF)
{
var cpicture = recordSet("picture");
Response.Write("<tr>");
Response.Write("<td>");
Response.Write(recordSet("year"));
Response.Write("</td>");
Response.Write("<td>");
Response.Write("<img src=../picture/hostelsp/" & cpicture & "width=50 height=50>");//为什么显示是0?
Response.Write("</td>");
Response.Write("<td>");
Response.Write(recordSet("p-description"));
Response.Write("</td>");
Response.Write("</tr>"); recordSet.MoveNext();
}Response.Write("</table>");%>
{
var cpicture = recordSet("picture");
Response.Write("<tr>");
Response.Write("<td>");
Response.Write(recordSet("year"));
Response.Write("</td>");
Response.Write("<td>");
Response.Write("<img src=../picture/hostelsp/" & cpicture & " width=50 height=50> ");//为什么显示是0?
Response.Write("</td>");
Response.Write("<td>");
Response.Write(recordSet("p-description"));
Response.Write("</td>");
Response.Write("</tr>"); recordSet.MoveNext();
}Response.Write(" < /table > ");%>