📄 c_teacher_zd.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="";
  String college_id=""; 
  String class_id="";
  String year_id="";
  String year_name="";
  String college_name="";
  String grade_name="";
  String sp_name="";
  String class_number_name="";
 %>
 
 <% 
  request.setCharacterEncoding("GBK");
  college_id=request.getParameter("college_id");
  class_id=request.getParameter("class_id");
  year_id=request.getParameter("year_id");
  sql="select * from class_year where class_id='"+class_id+"' and year_id='"+year_id+"'";
  rs=conn.executeQuery(sql);
  if(rs.next()){
     year_name=rs.getString("year_name");
     college_name=rs.getString("college_name");
     grade_name=rs.getString("grade_name");
     sp_name=rs.getString("sp_name");
     class_number_name=rs.getString("class_number_name");
  }
  conn.close();
  %>
  
 <html>
   <head>
      <title>指定班主任</title>
	 <link rel="stylesheet" href="../../public/style.css">
  </head>
  <body class="ss">
  <a href="javascript:window.location.reload();" class="a">刷新</a>&nbsp;&nbsp;
  <a href="javascript:history.back();" class="a">返回</a>
  <hr></hr>
      <center>
      <h3><%= year_name %> <%= college_name %> <%= grade_name %> 级 <%= sp_name %> <%= class_number_name %> 班</h3>
      <hr width="80%">
      <form action="c_teacher_add.jsp" method="post">
      <table width="40%">
         <tr>
            <td>请选择班主任：</td>
            <td><select name="class_teacher_id">
                 <option value="">==请选择==</option>
                 <% 
                  ResultSet rs_c=null;
                  String sql_c="select class_teacher_id,class_teacher_name from class_teacher_user where college_id='"+college_id+"'";
                  rs_c=conn.executeQuery(sql_c);
                  if(rs_c.next())
                  do{
                      out.println("<option value="+rs_c.getString("class_teacher_id")+">"+rs_c.getString("class_teacher_name")+"</option>");
                  }while(rs_c.next());
                  conn.close();
                  %>                 
            </select></td>
         </tr>
         <tr>
            <td colspan="2">&nbsp;</td>
         </tr>
         <tr>
            <td><center><input type="submit" value="确定"></center></td>
            <td><center><a href="javascript:history.back();">返回</a></center></td>
         </tr>
      </table>
      <input type="hidden" name="class_id" value="<%=class_id%>">
      <input type="hidden" name="year_id" value="<%=year_id%>">
      <input type="hidden" name="college_id" value="<%=college_id%>">
      </form>
      <%
		 String msg=(String)request.getParameter("errmsg");
	     if(msg!=null&&!msg.equals("")){
	  %>
       <div align="center"><font color="red" size="3"><%= msg %></font></div>
      <% 
          }
       %>
      </center>
   </body>
 </html>
⌨️ 快捷键说明

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