19.4.3 bof、eof属性.html

javascript即用即差核心对象手册

<script type="text/javascript" src="openCon.js"></script>
<script type="text/javascript" src="adojavas.inc"> </script>
<script language="javascript">
   var sql="select * from book where 性别='男' and 年龄=24";
   var rs=objconn.Execute(sql);
   if (rs.BOF && rs.EOF)
     {
	    document.write("没有查询到符合条件的记录!,正在重新查询...<br>");
		sql="select * from book where 性别='男' and 年龄>24";
		rs.Close();
		rs=objconn.Execute(sql);
	 }
   if(!(rs.EOF&&rs.BOF))
    {
	   with(document)
	   {
	       var strRlt="<table style='border-collapse:collapse' border='1' bordercolor='#339900'>"
		   strRlt+=writeHead(rs,strRlt);
		   while(!rs.EOF)
	       { 
		         strRlt+="<tr>";
	             var flds=new Enumerator(rs.Fields);
	             while(!flds.atEnd())
	              {
	                 var fd=flds.item();
		             strRlt+="<td>"+fd.Value+"</td>";
		             flds.moveNext();
	              }
	              strRlt+="</tr>";
	              rs.moveNext();  
		   }
		   strRlt+="</table>";
		   write(strRlt);
	   }
	}
	function writeHead(rs,str)
	{
	    var flds=new Enumerator(rs.Fields);
		str+="<tr>";
		while(!flds.atEnd())
	      {
	           var fd=flds.item();
		       str+="<td>"+fd.Name+"</td>";
		       flds.moveNext();
	      }
		 str+="</tr>";
		return str;
	}
</script>