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
代码:
<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