📄 classmanager.jsp

📁 企业员工考勤系统
💻 JSP
字号:
<%@ page contentType="text/html;charset=GBK" import="java.sql.*"%>
<%@ page errorPage="/public/errorBusy.jsp" %>
<%@ include file="/public/check_admin.jsp" %>
<jsp:useBean id="conn" scope="page" class="SQLBean.DBConn"/>

<%! 
  ResultSet rs=null;
  String sql="";
 %>
<% 
  sql="select * from specialty";
  rs=conn.executeQuery(sql);
%>
<script language="javascript">
   subcat=new Array();
   <% 
     int count=0;
     while(rs.next()){
    %>
   subcat[<%= count %>]=new Array("<%= rs.getString("sp_id") %>","<%= rs.getString("sp_name") %>","<%= rs.getString("college_id") %>");
  <% 
        count++;
      }
    conn.close();
  %>
  var one_count=<%= count %>;   
  function changlocation(id){
     college_id=id;
     document.form1.sp_id.length = 0; 
     document.form1.sp_id.options[0]=new Option("=====请选择=====","");
     for(j=0;j<one_count;j++)
     {
        if(subcat[j][2]==college_id)
        {
           document.form1.sp_id.options[document.form1.sp_id.length]=new Option(subcat[j][1],subcat[j][0]);
        }
     }
  }
  
  function formCheck(theForm)
  {
     if(theForm.college_id.value=="")
	 {
	    alert("请选择院系！");
		theForm.college_id.focus();
		return false;
	 }
	 if(theForm.grade_name.value=="")
	 {
	    alert("请选择年级！");
		theForm.grade_name.focus();
		return false;
	 }
	 if(theForm.sp_id.value=="")
	 {
	    alert("请选择专业！");
		theForm.sp_id.focus();
		return false;
	 }
	 if(theForm.class_number_name.value=="")
	 {
	    alert("请选择班级！");
		theForm.class_number_name.focus();
		return false;
	 }
  }
</script>

<html>
  <head>
     <title>班级管理</title>
	 <link rel="stylesheet" href="../../public/style.css">
  </head>
  <body>
  <a href="classmanager.jsp" class="a">建立班级</a>&nbsp;&nbsp;
  <a href="classmanager_m.jsp" class="a">管理班级</a>&nbsp;&nbsp;
  <a href="javascript:window.location.reload()" class="a">刷新</a>&nbsp;&nbsp;
  <a href="javascript:history.back()" class="a">返回</a>
  <hr></hr>
  <center>
  <h3>建立新的班级</h3>
  <form action="class_add_2.jsp" method="post" name="form1" onSubmit="return formCheck(this)">
  <table width="40%" border="0" cellspacing="0">     
      <tr>
        <td width="40%">请选择院系:</td>
        <td width="60%"><select name="college_id" onchange="changlocation(document.form1.college_id.options[document.form1.college_id.selectedIndex].value)">
          <option value="">=====请选择=====</option>
         <% 
           ResultSet rs_c=null;
           rs_c=conn.executeQuery("select * from college");
           while(rs_c.next())
             out.println("<option value="+rs_c.getString("college_id")+">"+rs_c.getString("college_name")+"</option>");
           conn.close();
        %>
        </select></td>
      </tr>
      <tr>
        <td colspan="2">&nbsp;</td>
      </tr>
      <tr>
        <td width="40%">请选择年级名称:</td>
        <td width="60%"><select name="grade_name">
          <option value="" selected>=====请选择=====</option>
        <% 
           ResultSet rs_g=null;
           rs_g=conn.executeQuery("select * from grade");
           while(rs_g.next())
             out.println("<option value="+rs_g.getString("grade_name")+">"+rs_g.getString("grade_name")+"</option>");
           conn.close();
        %>
        </select></td>
      </tr>
      <tr>
         <td colspan="2">&nbsp;</td>
      </tr>
      <tr>
        <td>请选择专业:</td>
        <td><select name="sp_id">
           <option value="" selected>=====请选择=====</option>
         </select></td>
      </tr>
      <tr>
        <td colspan="2">&nbsp;</td>
      </tr>
      <tr>
        <td width="10%">选择班级:</td>
        <td width="10%"><select name="class_number_name">
          <option value="">=====请选择=====</option>
         <% 
           ResultSet rs_b=null;
           rs_b=conn.executeQuery("select * from class_number");
           while(rs_b.next())
             out.println("<option value="+rs_b.getString("class_number_name")+">"+rs_b.getString("class_number_name")+"</option>");
           conn.close();
         %>
        </select></td>
     </tr>
     <tr>
        <td colspan="2">&nbsp;</td>
     </tr>
     <tr>
        <td colspan="2"><center><input type="submit" name="Submit" value="添加"></center></td>
      </tr>
      <%
		 String msg=(String)request.getParameter("errmsg");
	     if(msg!=null&&!msg.equals("")){
	  %>
      <tr>
         <td colspan="9"><div align="center"><font color="red" size="2"><%=msg%></font></div></td>
      </tr>
	  <%
		   }
	  %>
  </table>
  </form>
  </center>
  </body>
</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -