js访问数据库

最新推荐文章于 2022-09-14 11:18:37 发布

开发者孙小聪

最新推荐文章于 2022-09-14 11:18:37 发布

阅读量5.4k

点赞数

文章标签： sql server 数据库 function xhtml javascript database

本文链接：https://blog.csdn.net/pridescc/article/details/6575967

版权

测试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>