📄 classteacher.jsp

📁 企业员工考勤系统

💻 JSP

字号:

<%@ page contentType="text/html;charset=gb2312" import="java.sql.*"%>
<%@ page errorPage="/public/errorBusy.jsp" %>
<%@ include file="/public/check_admin.jsp" %>
<jsp:useBean id="conn" scope="page" class="SQLBean.DBConn"/>

<% 
  request.setCharacterEncoding("gb2312");
%>

<html>
  <head>
     <title>班主任安排</title>
	 <link rel="stylesheet" href="../../public/style.css">
  <meta http-equiv="Content-Type" content="text/html; charset=gb2312"><style type="text/css">
<!--
body {
	background-color: #66CCFF;
}
-->
</style></head>
  <body onload="parent.admin_right.location.replace('index.jsp')" class="ss">
  <br><br><br><br><br><br>
  <form action="class_teacher.jsp" method="post" target="admin_right">
  <table width="20%">
    <tr>
      <td><center><h4>浏览班主任安排</h4></center></td>
    </tr>
    <tr>
      <td>选择学年：</td>
    </tr>
    <tr>
      <td><select name="year_id">
          <option value="">=======全部=======</option>
           <% 
           ResultSet rs_y=null;
           rs_y=conn.executeQuery("select * from year order by year_id DESC");
           while(rs_y.next())
             out.println("<option value="+rs_y.getString("year_id")+">"+rs_y.getString("year_name")+"</option>");
           conn.close();
           %>
      </select></td>
    </tr>
    <tr>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td>选择院系:</td>
    </tr>
    <tr>
      <td><select name="college_id">
         <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>&nbsp;</td>
    </tr>
    <tr>
      <td><center><input type="submit" value="查看"></center></td>
    </tr>
 </table>
  </form>
  </body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -