院系专业加上年级和学籍类型的五级联动

最新推荐文章于 2021-09-01 15:15:04 发布

overmind

最新推荐文章于 2021-09-01 15:15:04 发布

阅读量1.7k

点赞数

CC 4.0 BY-SA版权

分类专栏： jboss+struts+bv+hpunix html+javascript 文章标签： function class stylesheet javascript object input

本文链接：https://blog.youkuaiyun.com/overmind/article/details/533962

html+javascript 同时被 2 个专栏收录

61 篇文章

订阅专栏

jboss+struts+bv+hpunix

39 篇文章

订阅专栏

该博客展示了一个添加学籍班的页面代码。运用 Java 进行数据库查询，获取部门、专业等信息。使用 JavaScript 实现三级联动菜单功能，当选择上级菜单选项时，下级菜单会动态更新显示对应内容，还包含表单提交等操作。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

<%@ page contentType="text/html; charset=gb2312" %>
<%@ page import="java.sql.*" %>
<html>
<head>
<title>
添加学籍班
</title>
<script language="javascript" src="../../js/calendar.js"></script>
<link href="../../css/myStyle.css" rel="stylesheet" type="text/css">
<script language="javascript">
  var DeparmentCount; //三级联动菜单代码
  DeparmentCount = 0;
  var DivisionCount;
  DivisionCount = 0;
  var SpecialityCount;
  SpecialityCount = 0;
  //GradeCount = 0;
  ObjectIDCount = 0;
  Department = new Array();
  Division = new Array();
  Speciality = new Array();
  //Grade = new Array();
  ObjectID = new Array();
<%
  system.pub.oraclesql myDao = new system.pub.oraclesql();
  ResultSet rs = myDao.execQuery("select * from division");
  int i=0;
  for(rs.next();!rs.isAfterLast();rs.next(),i++){%>
   Division[<%=i%>] = new Array("<%=rs.getString("Division_name")%>","<%=rs.getString("department_id")%>","<%=rs.getString("id")%>");
<%  }%>
  DivisionCount = <%=i%>;

<%
  System.out.println("debug....1");
  rs = myDao.execQuery("select * from speciality");
  i=0;
  for(rs.next();!rs.isAfterLast();rs.next(),i++){%>
   Speciality[<%=i%>] = new Array("<%=rs.getString("Speciality_name")%>","<%=rs.getString("division_id")%>","<%=rs.getString("id")%>");
<%  }%>
  SpecialityCount = <%=i%>;

<%
  rs = myDao.execQuery("select distinct speciality_id,grade,object_id,name from student t,object o where o.id= t.object_id");
  i=0;
  for(rs.next();!rs.isAfterLast();rs.next(),i++){%>
   ObjectID[<%=i%>] = new Array("<%=rs.getString("speciality_id")%>","<%=rs.getString("grade")%>","<%=rs.getString("object_id")%>","<%=rs.getString("name")%>");
<%  }%>
  ObjectIDCount = <%=i%>;

function initialSelect(){
changeDepartment(document.form1.department.options[document.form1.department.selectedIndex].value);
}

</script>

</head>
<body style="font-size: 12px;" bgcolor="eeeeee">
<form name="form1" action="SpecialityRelation_Insert.jsp" method="get">
<img onclick="history.go(-1);" src="../../images/back_blue.gif" onmousemove="this.src='../../images/back_red.gif';" onmouseout="this.src='../../images/back_blue.gif'" style="cursor:hand;">
<hr>
<%
String logicalclass_name = request.getParameter("name");
String logicalclass_id = request.getParameter("logicalclass_id");
%>
<input name="logicalclass_id" value="<%=logicalclass_id%>" type="hidden">
<table border="1px">
<tr>
  <td width="100px">教学班名称</td>
  <td width="300px">
   <input class="MyInputBox" name="name" value="<%=logicalclass_name%>" style="background:'#dddddd';" size="50" readonly/>
  </td>
</tr>
<tr>
  <td>所在专业</td>
  <td>
   <select class="MySelect" name="department" size="1" id="department" onChange="changeDepartment(document.form1.department.options[document.form1.department.selectedIndex].value)">
<%
  rs = myDao.execQuery("select * from department");
  i=0;
  for(rs.next();!rs.isAfterLast();rs.next(),i++){%>
   <option value="<%=rs.getString("id")%>"><%=rs.getString("Department_name")%></option>
<%  }%>
   </select>

      <select class="MySelect" name="division" size="1" id="division" onChange="changeDivision(document.form1.division.options[document.form1.division.selectedIndex].value)">
   </select>