你可以在WEB后台语言里向返回流里生成这样的JS字符串的嘛,呵呵...JS也可以借助于ACTIVEX来进行数据库的访问,我就是用JS来做ASP的...var conn = new ActiveXObject("ADODB.Connection");
conn.Open("Provider=SQLOLEDB;Data Source=127.0.0.1;uid=sa;password=123456;Database=Northwind;");
conn.Execute("DELETE FROM Customer");具体自己参考ADO文档...
conn.Open("Provider=SQLOLEDB;Data Source=127.0.0.1;uid=sa;password=123456;Database=Northwind;");
conn.Execute("DELETE FROM Customer");具体自己参考ADO文档...
<html>
<head>
<title>机场信息牌</title>
<style>
td {color:white;font-size:12px;}
</style>
</head>
<body bgColor=black>
<script language="javascript">
//机场循环滚动信息牌
var myInfo = document.all.hInfo;
var infos=new Array(myInfo.length);
for(var i=0;i<myInfo.length;i++){
infos[i]=myInfo.value;
}var infos=new Array();
var topIndex=0;
var drawIndex=0;
var rows=4;infos[0]=new Array('C7200','长沙/ChangSha','10:45 AM','');
infos[1]=new Array('T286','北京/BeiJin','10:55','');
infos[2]=new Array('T500','西安/XiAn','11:05','');
infos[3]=new Array('C1702','天津/TianJin','11:30','');
infos[4]=new Array('S509','东京/Japan','9:20','<font color=#66ff66>Boarding</font>');
infos[5]=new Array('S515','汉城/Korea','9:25','<font color=yellow>postponed</font>');
infos[6]=new Array('S710','华盛顿/USA','9:40','<font color=#66ff66>Boarding</font>');
infos[7]=new Array('B530V','深圳/ShenZhen','9:45','<font color=#66ff66>Boarding</font>');
infos[8]=new Array('C22','上海/ShangHai','9:50','');
infos[9]=new Array('B101','台北/Taiwan','10:05','');function drawItem(){
var dIndex=(topIndex+drawIndex)%rows;
var vIndex=(topIndex+drawIndex)%infos.length;
InfoTable.rows[dIndex+1].cells[0].innerHTML=infos[vIndex][0];
InfoTable.rows[dIndex+1].cells[1].innerHTML=infos[vIndex][1];
InfoTable.rows[dIndex+1].cells[2].innerHTML=infos[vIndex][2];
InfoTable.rows[dIndex+1].cells[3].innerHTML=infos[vIndex][3];
drawIndex++;
if (vIndex>=infos.length) {
//drawIndex=0;
topIndex=(topIndex+rows)%infos.length;
}
setTimeout("drawItem()",1600);
}window.onload=drawItem;
</script>
<table id=InfoTable border=0 cellpadding=2 cellspacing=1 bgColor="#330000">
<tr>
<td>
<%
'这里的内容从数据库里取
Set Conn = Server.CreateObject("ADODB.Connection") On Error Resume Next
' Access数据库
Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("db.mdb")
set Rs= Server.CreateObject("ADODB.RECORDSET")
Sql="SELECT * FROM jichang "
Rs.Open Sql,Conn,1,1
If Not Rs.Eof Then
Do While Not Rs.Eof
ghangbanhao=Rs("航班号")
didian=RS("地点")
shijian=rs("时间")
zhuantai=Rs("状态")
Response.Write "<INPUT TYPE='hidden' name='hInfo' value='"&ghangbanhao&","&didian&","&shijian&","&zhuantai&"'>"
Rs.Movenext
Loop
End If
Rs.close
Conn.close
Set Rs = Nothing
Set Conn = Nothing%>
</td>
</tr>
</table>
</body>
</html>
运行后input里的值是从数据库里取出的就是传不到JS里去。
<table id=InfoTable border=0 cellpadding=2 cellspacing=1 bgColor="#330000">
<tr>
<td>
<INPUT TYPE='hidden' name='hInfo' value='A3567,上海,18:00,正常'><INPUT TYPE='hidden' name='hInfo' value='BJ549,河南,5:50,'><INPUT TYPE='hidden' name='hInfo' value='C3435,杭州,9:00,'><INPUT TYPE='hidden' name='hInfo' value='DE9564,墨尔本,14:50,'><INPUT TYPE='hidden' name='hInfo' value='EF785,广州,15:40,失事'><INPUT TYPE='hidden' name='hInfo' value='ES456,江苏,6:30,'><INPUT TYPE='hidden' name='hInfo' value='EW888,纽约,11:20,降落'><INPUT TYPE='hidden' name='hInfo' value='R3453,北京,23:30,起飞'><INPUT TYPE='hidden' name='hInfo' value='W456,哈尔宾,16:30,'><INPUT TYPE='hidden' name='hInfo' value='WE444,大连,8:30,'>
</td>
</tr>
</table>