📄 course_detail.jsp

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

<%! 
  ResultSet rs=null;
  String year_id="";
  String class_id="";
  String sql="";
  String xingqi="";
  
  String _sql="";
  ResultSet _rs=null;
 %>
 <% 
   request.setCharacterEncoding("GBK");
   year_id=request.getParameter("year_id");
   class_id=request.getParameter("class_id");
   sql="select distinct class_id,college_name,grade_name,sp_name,class_number_name,year_name,year_id  from course_info where class_id='"+class_id+"' and year_id='"+year_id+"'";
   rs=conn.executeQuery(sql);
   rs.next();
   String year_name=rs.getString("year_name");
   String college_name=rs.getString("college_name");
   String grade_name=rs.getString("grade_name");
   String sp_name=rs.getString("sp_name");
   String class_number_name=rs.getString("class_number_name");
   conn.close();
   //上课安排
   sql="select * from course_info where class_id='"+class_id+"' and year_id='"+year_id+"'";
   String KeCheng[][]=new String[7][4];
   String Teacher[][]=new String[7][4];
   String Status[][]=new String[7][4];
   String Week[]={"星期一","星期二","星期三","星期四","星期五","星期六","星期日"};
   String Lesson[]={"第一二节课","第三四节课","第五六节课","第七八节课"};
   for(int i=0;i<Week.length;i++){
       for(int j=0;j<Lesson.length;j++){
         _sql=sql+" and week_name='"+Week[i]+"' and lesson_name='"+Lesson[j]+"'";
         _rs=conn.executeQuery(_sql);
         if(_rs.next()){
           KeCheng[i][j]=_rs.getString("kecheng_name");
           Teacher[i][j]=_rs.getString("teacher_name");
           Status[i][j]=_rs.getString("status");
          }else{
            KeCheng[i][j]="&nbsp;";
            Teacher[i][j]="&nbsp;";
            Status[i][j]="&nbsp;";
           }
       }
   }  
  %>
  
<html>
  <head>
    <title><%= grade_name %>级 <%= sp_name %><%= class_number_name %>班 课程表</title>
	<link rel="stylesheet" href="../../public/style.css">
  </head>
  <body class="ss">
  <center>
     <table>
        <tr>
          <td><h3><%= year_name %><%= college_name %><%= grade_name %>级 <%= sp_name %><%= class_number_name %>班 课表安排</h3></td>
        </tr>
     </table>
     <table width="100%" border="1" cellspacing="0">
        <tr bgcolor="#3399FF">
           <td>星期</td>
           <td>第一二节</td>
           <td>单/双周</td>
           <td>第三四节</td>
           <td>单/双周</td>
           <td>第五六节</td>
           <td>单/双周</td>
           <td>第七八节</td>
           <td>单/双周</td>
       </tr>
 <% 
   sql="select * from course_name_teacher where class_id='"+class_id+"' and year_id='"+year_id+"'";
   for(int i=0;i<7;i++){
       switch(i+1){
          case 1:xingqi="星期一";break;
          case 2:xingqi="星期二";break;
          case 3:xingqi="星期三";break;
          case 4:xingqi="星期四";break;
          case 5:xingqi="星期五";break;
          case 6:xingqi="星期六";break;
          case 7:xingqi="星期日";break;
       }
       out.println("<tr>");
       out.println("<td>"+xingqi+"</td>");
     for(int j=0;j<4;j++){
          String ds=Status[i][j];
          char status=ds.charAt(0);
          String danshuang="&nbsp;";
          switch(status){
              case '0':danshuang="单双周";break;
              case '1':danshuang="单周";break;
              case '2':danshuang="双周";break;
          }
          if(!KeCheng[i][j].equals("&nbsp;"))
            {
             out.println("<td>"+KeCheng[i][j]+"<br>("+Teacher[i][j]+")</td>");
             out.println("<td>"+danshuang+"</td>");
            }else{
             out.println("<td>&nbsp;</td>");
             out.println("<td>&nbsp;</td>");
            }
     }
       out.println("<tr>");
   }
  %>       
    </table>
     <table width="100%"  border="0" cellspacing="0" cellpadding="0">
       <tr>
         <td colspan="3">&nbsp;</td>
       </tr>
       <tr>
         <td width="34%"><div align="right">
           <input type="button" value="打印课表">
         </div></td>
         <td width="27%">&nbsp;</td>
         <td width="39%"><div align="left">
           <input type="button" value="关闭窗口" onclick="window.close()">
         </div></td>
       </tr>
     </table>
    <p>&nbsp;</p>
  </center>
  </body>
</html>
⌨️ 快捷键说明

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