[点滴积累]jdbc与js结合的级联下拉列表
代码片段
<td valign="top" ><p align="right">车牌号码：</p></td> <td > <select size="1" name="CLID" onchange="javaScript:changelocation(this.value);" style="width:200"> <option value="">==请选择==</option><% SQL = "Select CLID,CPHM,CLMC,SJMC from CL_JBXX where 1=1;"; ResultSet rs_1 = queryData.getResultSet(SQL );int iCLID_select = 0;String sjmc2 = ""; while (rs_1.next()){ iCLID_select = rs_1.getInt("CLID"); sCPHM = rs_1.getString("CPHM"); sCLMC = rs_1.getString("CLMC"); // sSJMC = rs_1.getString("SJMC");%> <option <% if (iCLID_select == iCLID) {%> selected <% } %> value="<%=iCLID_select%>"><%=sCLMC%>(<%=sCPHM%>)</option><% } %> </select></td> <td > <p align="right">司机名称：</td> <td ><input name="SJMC" value="<%=sSJMC%>" type="text" maxlength="100" size="20"></td> </tr><% sql = "Select CLID,CPHM,CLMC,SJMC from CL_JBXX where 1=1 ;" ResultSet rsSelect = queryData.getResultSet(sql );%> <script language = "JavaScript"> var onecount; onecount=0; subcat = new Array();<%int iCount = 0;String sSJMC2=""; while (rsSelect.next()){ iCLID = rsSelect.getInt("CLID"); sCPHM = rsSelect.getString("CPHM"); sCLMC = rsSelect.getString("CLMC"); sSJMC2 = rsSelect.getString("SJMC");%> subcat[<%=iCount%>] = new Array("<%=sSJMC2%>","<%=iCLID%>");<% iCount = iCount + 1; }%> onecount=<%=iCount%>;</script> function changelocation(locationid) { var locationid=locationid; var ii; for (ii=0;ii < onecount; ii++) { if ((subcat[ii][1] == locationid) || (locationid==0) ) { document.form.SJMC.value = subcat[ii][0]; } } }