复制代码 代码如下:

<scriptlanguage="javascript">

//用JavaScript写服务器端连接数据库的代码示例

varconn=newActiveXObject("ADODB.Connection");

conn.Open("DBQ=c:a.mdb;DRIVER={MicrosoftAccessDriver(*.mdb)};");

varrs=newActiveXObject("ADODB.Recordset");

varsql="select*fromfriends_infor";

rs.open(sql,conn);

shtml="<tablewidth='100%'border=1>";

shtml+="<trbgcolor='#f4f4f4'><td>au_id</td><td>au_lname</td><td>au_fname</td></tr>";

while(!rs.EOF)

{

shtml+="<tr><td>"+rs("friend_id")+"</td><td>"+rs("friend_name")+"</td><td>"+rs("friend_nickname")+"</td></tr>";

rs.moveNext;

}

shtml+="</table>";

document.write(shtml);

rs.close();

rs=null;

conn.close();

conn=null;

</script>