filter属性.html

javascript即用即差核心对象手册

<script type="text/javascript" src="openCon.js"></script>
<script type="text/javascript" src="adojavas.inc"> </script>
<form>  
   性别<select name="sex">
           <option value="男">男</option>
           <option value="女">女</option>
       </select>
   年龄<select name="opt">
		 <option value=">"> > </option>
		 <option value="<"> < </option>
		 <option value="="> = </option>
		 <option value="Like">Like</option>
	 </select>
     <input type="text" name="age" size="4"/>
	 <input type="button" value="查询" onClick="getNewList()"><br>
	 <div id="list"></div>
</form>
<script>
var rs=objconn.Execute("select * from book");
//输出全部数据
document.all("list").innerHTML=writeTable(rs);
//根据刷选条件重新筛选
function getNewList()
  {
      var sex=document.forms[0].sex.value;
	  var opt=document.forms[0].opt.value;
	  var age=document.forms[0].age.value;
	  strFilter="性别='"+sex+"' and 年龄"+opt+age;
	  rs.Filter=strFilter;
      document.all("list").innerHTML=writeTable(rs);
  }
  //以表格形式输出记录
function writeTable(rs)
    {
	         with(document)
	          {
		          var strRlt="<table style='border-collapse:collapse' border='1' bordercolor='#339900'>"
		          strRlt+=writeHead(rs,strRlt);
		          while(!rs.EOF)
	               { 
		               strRlt+="<tr>";
					   strRlt+="<td><input type='checkbox' name='rd"+rs("id").Value+"'></td>";
	                   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>";
		             return strRlt;
	            }
      }
	//定义函数输出表格头
	function writeHead(rs,str)
	{
	    var flds=new Enumerator(rs.Fields);
		str+="<tr><td></td>";
		while(!flds.atEnd())
	      {
	           var fd=flds.item();
		       str+="<td>"+fd.Name+"</td>";
		       flds.moveNext();
	      }
		 str+="</tr>";
		return str;
	}
</script>