動態菜單問題

siemenwang

在先前的精華帖里面有這么個問題
經整理后代碼如下﹕
該代碼實現根據欄位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.value=xmldso.recordset.fields(0).value;
options.text=xmldso.recordset.fields(1).value;
xmldso.recordset.MoveNext();
}
}
}
change();
</script>;
=========  不甚感謝﹗﹗﹗﹗