1<html>
2<head>
3<title>不刷新页面查询的方法</title>
4<meta content="text/html; charset=utf-8" http-equiv="Content-Type"/>
5</head>
6<script language="javascript">
7<!--初始化，将数据岛中数据装入列表框中-->
8function loadinsel()
9{
10var employeeid,employeelastname; //分别存放雇员ID和雇员名字
11root=document.all.xmlemployees.childNodes.item(0); //返回第一个元素－－employee
12for(i=0;i<root.childNodes.length;i++){
13getnode=root.childNodes(i); //得到empolyee的一个子节点
14employeeid=root.childNodes(i).getAttribute("emid");//得到雇员ID
15for(j=0;j<getnode.childNodes.length;j++){
16employeeinf=getnode.childNodes(j).nodeName;
17if(employeeinf=="lastname"){
18employeelastname=getnode.childNodes(j).text; //得到雇员名字
19}
20}
21//将得到的employeeid和employeelastname写进select中
22if(employeeid!="" && employeelastname!=""){
23option1=document.createElement("option");
24option1.text=employeelastname;
25option1.value=employeeid;
26employeelist.add(option1);
27}
28}
29}
30
31<!--初始化，从数据岛中检索数据，装入列表框中-->
32function findemployee(){
33var employeelastname,employeeid; //分别存放雇员名字和雇员ID
34employeelastname="";
35employeeid="";
36findtext=window.findcontent.value; //得到检索条件
37//清除列表框
38employeecount=employeelist.length
39for(i=employeecount-1;i>=0;i--){
40employeelist.remove(i);
41}
42root=window.xmlemployees.childNodes(0);
43for(i=0;i<root.childNodes.length;i++){
44getitem=root.childNodes(i); //得到empolyee的一个子节点
45employeeid=root.childNodes(i).getAttribute("emid"); //得到雇员ID
46for(j=0;j<getitem.childNodes.length;j++){
47if(getitem.childNodes(j).nodeName=="lastname"){
48employee_temp=getitem.childNodes(j).text;
49if(employee_temp.indexOf(findtext)!=-1){ //查找匹配项
50employeelastname=employee_temp; //找到名字匹配的雇员
51}
52
53}
54
55}
56//将符合条件的雇员信息写进select中
57if(employeeid!="" && employeelastname!=""){
58option1=document.createElement("option");
59option1.value=employeeid;
60option1.text=employeelastname;
61window.employeelist.add(option1);
62employeeid="";
63employeelastname="";
64}
65}
66}
67</script>
68<body bgcolor="#FFFFFF" onload="javascript:loadinsel()" text="#000000">
69<table border="1" width="80%">
70<tr>
71<td> 请输入查询条件：
72<input name="findcontent" type="text"/>
73<input name="Submit" onclick="javascript:findemployee()" type="button" value="查找"/>
74</td>
75</tr>
76<tr>
77<td> 查询结果：
78<select name="employeelist">
79</select>
80</td>
81</tr>
82</table>
83<?xml version="1.0" encoding="gb2312"?>
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
1<!--将数据库中信息放入数据岛中-->
2<xml id="xmlemployees">
3<employee>
do while not rs.eof
1<employeeitem ```"="" emid="```
2=rs(" employeeid")="">
3<lastname>```
4=rs("lastname")
5```</lastname>
6</employeeitem>
rs.movenext
loop
1</employee> </xml>
rs.close
set rs=nothing
1</body>
2</html>