 xml+javascript 實現動態的下拉菜單
該代碼實現根據欄位1中的選擇的值來改變欄位2的值﹐而這個值則在下拉條上顯示
不知道斑竹是否能整理一下﹐
<<單個欄位點擊后觸發onchange動作后并將數據顯示在當前的欄位>>
原理是不是差不多呢
我一點xml的基礎都沒有 慚愧.....
data.jsp:
======================================
<%@ page contentType="text/html;charset=Big5"%>
<%@ page import="java.sql.*"%>
<?xml version="1.0" encoding="GB2312" standalone="yes"?>
<dummy>
<%
Class.forName("com.informix.jdbc.IfxDriver").newInstance();
String url = "jdbc:informix-sqli://10.97.43.9:9042/ds:INFORMIXSERVER=on_tcp42;user=1111;password=pk0081";
Connection conn= DriverManager.getConnection(url);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from user where id =";
System.out.print("fdsafdsafdsafda");
System.out.print(sql);
String id=request.getParameter("id");
sql+=id;
sql+="'";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()){
%>
<dummy2>
<codes>
<%=rs.getString(1)%>
</codes>
<name>
<%=rs.getString(2)%>
</name>
</dummy2>
<%}%>
</dummy>
===============================================
xml_test.jsp:
===============================================
<form name=test>
<select name=a onchange="change()">
<option value=1>ONE</option>
<option value=2>TWO</option>
<option value=3>THREE</option>
<select>
<select name=b></select>
</form>
<XML id=xmldso></XML>
<script>
function change(){
xmldso.async = false;
xmldso.load("data.jsp?id="+document.test.a.value);
with(document.test.b){
xmldso.recordset.MoveFirst();
for (var i=0;!xmldso.recordset.eof;i++){
length=i+1;
options[i].value=xmldso.recordset.fields(0).value;
options[i].text=xmldso.recordset.fields(1).value;
xmldso.recordset.MoveNext();
}
}
}
change();
</script>
|
[返回] 中文XML论坛 - 专业的XML技术讨论区 →
XML.ORG.CN讨论区 - XML技术 → 『 XML源码及示例(仅原创和转载) 』 → xml+javascript 實現動態的下拉菜單
(订阅本版)
2005/3/9 16:18:00
新浪微博
