<form>
   選擇查詢條件:<br />
   性別<select name="sex">
           <option value="男">男</option>
           <option value="女">女</option>
       </select>
	年齡><input type="text" name="age" size="4">
	<input type="button" value="查詢" onClick="listItem()"><br>
	<div id="list"></div>
</form>
<script type="text/javascript" src="openCon.js"></script>
<script type="text/javascript" src="adojavas.inc"> </script>
<script language="javascript">
function listItem()
{
    var ocmd=new ActiveXObject("ADODB.Command");
	var rs=new ActiveXObject("ADODB.RecordSet")
	var sex=document.forms[0].sex.value;
	var age=parseInt(document.forms[0].age.value);
	ocmd.ActiveConnection=objconn;
	ocmd.CommandText="select * from book where 性別=? and 年齡>?";
	//創建兩個查詢參數
	var para1=ocmd.CreateParameter("性別",adVarChar,adParamInput,10);
	var para2=ocmd.CreateParameter("年齡",adVarChar,adParamInput,10);
	para1.Value=sex;
	para2.Value=age;
	//將參數添加到Parameters結合中取
	ocmd.Parameters.Append(para1);
	ocmd.Parameters.Append(para2);
	//執行查詢
	rs=ocmd.Execute();
	var strRlt="<table border=1>";
	//輸出查詢結果
	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>";
	//輸出查選結果
	document.all("list").innerHTML=strRlt;
}
</script>