19.3.3 带参数查询.html

javascript即用即差核心对象手册

<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>