9.2.3 connection对象的errors集合.html

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

<script>
   var conn=new ActiveXObject("ADODB.Connection");
   var dbPath="E:\\database.mdb";
   cntStr="Provider=microsoft.jet.oledb.4.0;Data Source="+dbPath;
   conn.Open(cntStr);
   var sql="insert into book (ID,姓名,性别,年龄,关系) Values(2,'高大伟','男',25,'同学')";
   try
     {
        conn.Execute(sql);
     }
    catch(err)
	{
		var oerrs=new Enumerator(conn.Errors);
		while(!oerrs.atEnd())
		{
		   var oerr=oerrs.item();
		   with (document)
		    {
			   write("<li>"+oerr.Number);
			   write("<li>"+oerr.Description);
			   write("<li>"+oerr.Source);
			   write("<li>"+oerr.SQLState);
			}
		   oerrs.moveNext();
		}
	}	 
   conn.Close();
   conn=null;
</script>