html页面上连数据库

2019独角兽企业重金招聘Python工程师标准>>>

<script language="javascript"> 
//用 JavaScript 写服务器端连接数据库的代码示例 
var conn = new ActiveXObject("ADODB.Connection"); 
conn.Open("DBQ=11.mdb;DRIVER={Microsoft Access Driver (*.mdb)};"); 
var rs = new ActiveXObject("ADODB.Recordset"); 
var sql="select * from taba"; 
rs.open(sql, conn); 
shtml = "<table width='100%' border=1>"; 
shtml +="<tr bgcolor='#f4f4f4'><td>au_id</td><td>au_lname</td><td>au_fname</td></tr>"; 
while(!rs.EOF) 
{ 
shtml += "<tr><td>" + rs("aid") + "</td><td>" + rs("aa") + "</td><td>" + rs("ab") + "</td></tr>"; 
rs.moveNext; 
} 
shtml += "</table>"; 
document.write(shtml); 
rs.close(); 
rs = null; 
conn.close(); 
conn = null; 
</script>

转载于:https://my.oschina.net/zhangyafei/blog/653542