📄 16-4.txt

📁 开发王代码代码

💻 TXT

字号:

<body>
<script type="text/javascript">
<!--
  //-----------------------------[01]-------------------------------
  //创建一个连接，并且创建一个ADODB.Recordset用于操作返回的数据
  var oConn = new ActiveXObject("ADODB.Connection");
  var oCmd = new ActiveXObject("ADODB.Command");
  oConn.ConnectionString = "DSN=sampleDB;UID=;PWD=;";
  oConn.Open();
  //-----------------------------[02]-------------------------------
  //这里创建一个SQL UPDATE语句
  oCmd.ActiveConnection = oConn;
  oCmd.CommandText = "UPDATE employees SET firstName = 'myFirst1',lastName = 'myLast1', EmpType = 'myEmpType1' WHERE firstName = 'myFirst' AND lastName = 'myLast'";
  //执行更新操作
  oCmd.Execute();
  //-----------------------------[03]-------------------------------  
  document.write("操作成功！");
  //-----------------------------[04]-------------------------------
  //显式的关闭连接
  oConn.Close();
  oConn = null;
-->
</script>
</body>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -