function refresh()
{
//2秒自动刷新一次,2秒取得一次数据.
timer = window.setInterval("loadData()",4000);
}
</script>
<script language="javascript">
<!--
function loadData(){
var xml = new ActiveXObject("Msxml2.XMLHTTP") || new XMLHttpRequest();
//var xml2=new ActiveXObject("Microsoft.XMLDOM");
xml.open( 'get', 'server.asp', true );
xml.onreadystatechange = function(){
if( xml.readyState == 4 )
{
if( xml.status == 200 )
oncomplete( xml );
}
}
xml.send(null);
}
//这个函数负责填充表格
function oncomplete( xml ){
var xml = xml.responseXML;
alert(xml.responseXML);
var user = xml.getElementsByTagName("userItem");
var html = "<ul>";
for(i=0;i<user.length;i++)
{
userName = user[i].firstChild.text || user[i].firstChild.textContent;
sex= user[i].lastChild.text || user[i].lastChild.textContent;
html += "<li>" + userName +"(" + sex + ")" + "</li>";
}
html += "</ul>";
document.getElementById("userList").innerHTML = html;
}
var connstr = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source="+Server.MapPath("data.mdb");
var conn = Server.CreateObject("ADODB.Connection");
conn.Open(connstr);
//var roomname=request("roomname");
var roomname="房间1";
var rs=Server.CreateObject("ADODB.RECORDSET");
var query;
query="select * from roomonlineuserlist where roomname='"+roomname+"'";
rs.Open(query,conn,3,3);