JavaScript连接数据库

来源:互联网 发布:打印机usb2.0 端口 编辑:程序博客网 时间:2024/05/03 11:37
ps:本以为可以借此方法连接限制了IP连接的数据库。因为目标WEB只能执行静态页面。伟大的客户端脚本语言

代码:

<script language="javascript">  
var conn = new ActiveXObject("ADODB.Connection"); 
//var sqlstr="Provider=SQLOLEDB.1; Data Source=localhost; User ID=sa;Password=; Initial Catalog=pubs";
var sqlstr="Provider=SQLOLEDB;Data Source=localhost;UID=sa;PWD=;database=pubs";
conn.Open(sqlstr); 
var rs = new ActiveXObject("ADODB.Recordset"); 
var sql="select * from authors"; 
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><td>phone</td><td>address</td><td>city</td><td>state</td><td>zip</td></tr>";     
while(!rs.EOF)     
{
shtml +="<tr><td>" + rs("au_id") + "</td><td>" + rs("au_lname") + "</td><td>" + rs("au_fname") + "</td><td>" + rs("phone") + "</td><td>" + rs("address") + "</td><td>" + rs("city") + "</td><td>" + rs("state") + "</td><td>" + rs("zip") + "</td></tr>";     
rs.moveNext; 
}
shtml +=   "</table>"; 
document.write(shtml); 
rs.close(); 
rs = null; 
conn.close(); 
conn = null; 
</script>


如果执行代码提示"safety settings on this computer prohibit accessing a data source on another domain"

在Internet options中把access data sources across domains设为Enable
原创粉丝点击