js 级联 JSP

最新推荐文章于 2024-07-23 11:32:13 发布

Bruce54

最新推荐文章于 2024-07-23 11:32:13 发布

阅读量401

点赞数

文章标签： jsp function javascript include action import

本文链接：https://blog.csdn.net/epng54/article/details/2230600

版权

<%@ 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 οnlοad="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();
}

function chgSlave()
{
form1.selSlave.options.length=0;
for(var i=0;i<arrData.length;i++)
{
if(arrData[i][0]==form1.selMain.value)
{
var oOptB=document.createElement("OPTION");
oOptB.value=arrData[i][1];
oOptB.innerHTML=arrData[i][1];
form1.selSlave.appendChild(oOptB);
}
}
}
</SCRIPT>
   <form name="form1" method="post" action="4.jsp">
   <table>
      <tr>
      <td>报考专业:<select id="selMain" οnchange="chgSlave()" name="selMain"></select>
      专业代码:<select id="selSlave" name="selSlave"></select>
</td>
   </tr>
   </table>
   </form>
  </body>
</html>

Bruce54

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
js 级联 JSP

级联菜单 Connection con=null; con=conn.Conn(); Statement stmt=con.createStatement(); ResultSet rs=stmt.executeQuery("select * from specialtyinfo where
复制链接

扫一扫