19.2.1 execute方法.html

来自「javascript即用即差核心对象手册」· HTML 代码 · 共 13 行

<script>
   var conn=new ActiveXObject("ADODB.Connection");
   var dbPath="E:\\database.mdb";
   var num=0;
   cntStr="Provider=microsoft.jet.oledb.4.0;Data Source="+dbPath;
   conn.Open(cntStr);
   var sql="insert into book (姓名,性别,年龄,关系) Values('高大伟','男',25,'同学')";
   conn.Execute(sql,num,1)
   document.write("本次操作受影响的记录有"+num+"条");
   conn.Close();
   conn=null;
</script>