28,390
社区成员
发帖
与我相关
我的任务
分享
<table id="pic" width="496" border="0">
<tr>
<td>
<%
set cccc=server.createobject("adodb.connection")
db="/***"
ccccstr="Provider=Microsoft.jet.oledb.4.0;data source="&server.mappath(db)
cccc.open ccccstr
'以下代码为随机读取1条记录
'连接数据库
randomize()
intrandomnumber=int(1000*rnd)+1
sql="select * from pic order by rnd("&(-1*intrandomnumber)&"*id)"
set rst=cccc.execute(sql)
response.write("<img height=290 id=tp src="&Replace(rst("address"),Chr(32),"%20")&">")%>
</td>
</tr>
<tr>
<td valign="baseline"><%=rst("name")%>
</td>
</tr>
<%
rst.close
set rst=nothing
cccc.close
set cccc=nothing
%></table>
<html>
<head>
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.4/jquery.min.js"></script>
<script type="text/javascript">
function reload()
{
$.ajax({
url: "pic.asp",
success: function(data) {
$("#mainBodyer").html('<table id="pic" width="496" border="0">
'+data+'</table>');
}
});
setTimeout("reload()",5000);
}
</script>
</head>
<body>
<div id="mainBodyer">
</div>
<script type="text/javascript">
reload();
</script>
</body>
</html>