怎么做二级下拉菜单? - 编程论坛

xieyanyong002006-04-30 17:09

<%@ page contentType="text/html;charset=gb2312"%>
<%@ include file="tocn.jsp"%>
<%@ page language="java" import="java.sql.*,com.ExamTable.*"%>
<jsp:useBean id="conn" scope="page" class="com.ExamTable.ConnectionManager"/>
<html>
<head><title>级联菜单</title></head>
<body onload="initSel()">
<SCRIPT LANGUAGE="JavaScript">
<%
Connection con=null;
con=conn.Conn();
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select * from specialtyinfo where specialtyid<>0");
int i=0;
%>
var arrData=new Array();
<%
while(rs.next()){
%>
arrData[<%=i%>]=new Array("<%=rs.getString("specialty")%>","<%=rs.getString("specialtyCode")%>");
<%
i++;
}
rs.close();
stmt.close();
con.close();
%>
function initSel() {
var optStr="";
for(var i=0;i<arrData.length;i++){
if(optStr.search("("+arrData[i][0]+")")<0){
optStr+="("+arrData[i][0]+")";
var oOptA=document.createElement("OPTION");
oOptA.value=arrData[i][0];
oOptA.innerHTML=arrData[i][0];
form1.selMain.appendChild(oOptA);
}
}
chgSlave();
}