minichitina wrote:
各位高手：
您們寫得我照著寫也不知道那裡出問題，還是出不來,以下是我改過的程式，我是要在jsp網頁裏從資料庫取出資料，在html中有兩個下拉式選單，其第二個選單需跟著第一個選單變動而變動，即select id from a where id >= 第一個下拉式選單之值

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58

<% Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); Connection Conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://140.115.84.223:1433;databasename=project","project","coolmeeting"); int i=0; Statement stmt = Conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY); Statement stmt2 = Conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY); String SQL = "Select id From a"; ResultSet rs = stmt.executeQuery(SQL); %> <SCRIPT LANGUAGE="javascript"> <!-- function ChangeSelect(city, region) { val = city.options[city.options.selectedIndex].value; <%while(rs.next()){ String SQL2 = " select id from a where id >=" + rs.getString("id") ; ResultSet rs2 = stmt2.executeQuery(SQL2); %> if (val == '<%=rs.getString("id")%>') { <%while(rs2.next()){ i++; }%> region.length = <%=i%>; <% i=0; rs2.first(); do{%> region.options[<%=i%>].value = '<%=rs2.getString("id")%>'; region.options[<%=i%>].text = '<%=rs2.getString("id")%>'; <% i++; }while(rs2.next()); i=0;%> } <%} rs.first();%> } --> </script> <form name="selection"> <select name=city onChange="ChangeSelect(document.selection.city,document.selection.region)" size="1"> <option>==請選擇城市==</option> <%do{%> <option value="<%=rs.getString("id")%>"><%=rs.getString("id")%></option> <%}while(rs.next());%> </select><BR> 選擇您要的區域</font><br> <SELECT name=region> </SELECT> </p> </form>