不刷新页面筛选数据库中的数据(2) searchObj.add(option1); } } } else{ //如果没有输入查询条件则显示所有雇员 j=searchSource.length; for(i=0;i<j;i++){ searchsource=searchSource.options(i).text; option1=document.createElement("option"); option1.text=searchsource; option1.value=searchSource.options(i).value; searchObj.add(option1); } } } //www.knowsky.com</script><body bgcolor="#FFFFFF" text="#000000"><% servername="wyb" '服务器名 user="sa" '用户名 pw="" '用户密码 databasename="northwind" '数据库名 set conn=server.CreateObject("adodb.connection") conn.Open "DRIVER=SQL Server;SERVER="&servername&";UID="&user&";pwd="&pw&";DATABASE="&databasename set rs=server.CreateObject("adodb.recordset") sql="Select employeeid,lastname from employees order by employeeid" rs.Open sql,conn%><table width="80%" border="1"> <tr> <td> <input type="text" name="searchContent"> <input type="button" name="Button" value="查询" onclick="javascript:return search_onclick()">
