测试js访问数据库 This is my page.
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head>
<title>测试js访问数据库</title>
</head>
<script language="javascript">
var conn,rs;
function InitDB()
{
conn = null;
rs = null;
conn = new ActiveXObject("ADODB.Connection");
rs = new ActiveXObject("ADODB.Recordset");
connstr = "Driver={SQL Server}; Server=(local); Database=northwind; UID=sa; PWD=19790601";
}
function testdb()
{
conn.Open(connstr);
sqlstr = "select * from orders";
if(sqlstr == "")
{
alert("SQL查询语句不能为空");
return;
}
rs.open(sqlstr,conn);
/*alert(rs.Fields("orderid").Value);*/
Response.write(rs.Fields("orderid").Value);
rs.close();
conn.close();
}
</script>
<body onLoad="InitDB()">
This is my page. <br>
<input type="button" value="submit" onClick="testdb()">
</body>
</html>