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>
|