📄 class_teacher.jsp

📁 jsp+mssql 实现考勤的基本功能包括签到签离请假销假批假等功能
💻 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 year_id="";
  String college_id="";
 %>

<% 
  request.setCharacterEncoding("GBK");
  year_id=request.getParameter("year_id");
  college_id=request.getParameter("college_id");
 if(!year_id.equals("")&&!college_id.equals(""))
   sql="select * from class_year where year_id='"+year_id+"' and college_id='"+college_id+"' order by college_name,grade_name,sp_name,class_number_name";
 else{
     if(!year_id.equals("")&&college_id.equals(""))
        sql="select * from class_year where year_id='"+year_id+"' order by college_name,grade_name,sp_name,class_number_name";
     if(year_id.equals("")&&!college_id.equals(""))
        sql="select * from class_year where college_id='"+college_id+"' order by college_name,grade_name,sp_name,class_number_name";
     if(year_id.equals("")&&college_id.equals(""))
        sql="select * from class_year order by college_name,grade_name,sp_name,class_number_name";
     }
%>

<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>
  <table width="90%" border="1" cellspacing="0">
    <% 
       rs=conn.executeQuery(sql);
       if(rs.next()){
    %>
    <tr bgcolor="#0099FF">
       <td>学年</td>
       <td>院系名称</td>
       <td>年级名称</td>
       <td>专业名称</td>
       <td>班级</td>
       <td>班主任</td>
       <td><div align="center">指定/修改班主任</div></td>
    </tr>    
    <%
          do{
     %>
    <tr>
       <td><%= rs.getString("year_name") %></td>
       <td><%= rs.getString("college_name") %></td>
       <td><%= rs.getString("grade_name") %> 级</td>
       <td><%= rs.getString("sp_name") %></td>
       <td><%= rs.getString("class_number_name") %> 班</td>
        <% 
          String class_id=rs.getString("class_id");
                 year_id=rs.getString("year_id");
          String class_teacher_name="<div align='center'><font color='red' size='2'>没指定</font></div>";
          String _sql="select * from class_teacher_year where class_id='"+class_id+"' and year_id='"+year_id+"'";
          ResultSet _rs=conn.executeQuery(_sql);
          if(_rs.next())
            class_teacher_name=_rs.getString("class_teacher_name");
          conn.close();
          _rs.close();
         %>
        <td><%= class_teacher_name %></td>
        <td><div align="center"><a href="c_teacher_zd.jsp?class_id=<%=rs.getString("class_id")%>&year_id=<%=rs.getString("year_id")%>&college_id=<%=rs.getString("college_id")%>">指定/修改</a></div></td>
    </tr>
    <% 
          }while(rs.next());
       }else
         out.println("<center><h3>您指定的院系还没有班级!</h3></center>");
     conn.close();
     rs.close();
     %>
  </table> 
  </center>
  </body>
</html>
⌨️ 快捷键说明

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