<script language="javascript" runat="server"> //用 JavaScript 写服务器端连接数据库的代码示例 var conn = new ActiveXObject("ADODB.Connection"); conn.Open("Provider=SQLOLEDB.1; Data Source=localhost; User ID=sa; " +"Password=000000; Initial Catalog=test");var rs = new ActiveXObject("ADODB.Recordset"); var sql="select * from users where id=2";rs.open(sql, conn); if (!rs.EOF) { var name = (rs("userName")+""); alert(name); } rs.close(); rs = null; conn.close(); conn = null; </script>
//用 JavaScript 写服务器端连接数据库的代码示例
var conn = new ActiveXObject("ADODB.Connection");
conn.Open("Provider=SQLOLEDB.1; Data Source=localhost; User ID=sa; "
+"Password=000000; Initial Catalog=test");var rs = new ActiveXObject("ADODB.Recordset");
var sql="select * from users where id=2";rs.open(sql, conn);
if (!rs.EOF)
{
var name = (rs("userName")+"");
alert(name);
}
rs.close(); rs = null; conn.close(); conn = null;
</script>