📄 course_time_view.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 kecheng_name="";
   String teacher_name="";
   String _sql="";
   String xingqi="";
   String dx="";
   String week="";
   String lesson="";
 %>
 <% 
   request.setCharacterEncoding("GBK");
   String year_name=request.getParameter("year_name");
   String college_name=request.getParameter("college_name");
   String grade_name=request.getParameter("grade_name");
   String sp_name=request.getParameter("sp_name");
   String class_number_name=request.getParameter("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>
        <tr>
          <td><h3><%= year_name %><%= college_name %><%= grade_name %>级 <%= sp_name %><%= class_number_name %>班 课表预览</h3></td>
        </tr>
     </table>
     <hr color="red" width="80%">
     
    <% 
      String sql_d="delete from course";  //清空临时表
      conn.executeUpdate(sql_d);
     %>
     
      <table width="98%" border="1" cellspacing="0">
        <tr>
           <td>星期</td>
           <td>第一二节</td>
           <td>单/双周</td>
           <td>第三四节</td>
           <td>单/双周</td>
           <td>第五六节</td>
           <td>单/双周</td>
           <td>第七八节</td>
           <td>单/双周</td>
        </tr>
 <% 
   year_id=request.getParameter("year_id");
   class_id=request.getParameter("class_id");
   String sql="select * from course_name_teacher where class_id='"+class_id+"' and year_id='"+year_id+"'";
   for(int i=1;i<=7;i++){
       switch(i){
          case 1:xingqi="星期一";week="Mon";break;
          case 2:xingqi="星期二";week="Tue";break;
          case 3:xingqi="星期三";week="Wed";break;
          case 4:xingqi="星期四";week="Thu";break;
          case 5:xingqi="星期五";week="Fri";break;
          case 6:xingqi="星期六";week="Sat";break;
          case 7:xingqi="星期日";week="Sun";break;
       }
       out.println("<tr>");
       out.println("<td>"+xingqi+"</td>");
     for(int j=1;j<=4;j++){
        String kc="kecheng"+i+j;
        String danshuang=""+i+j;
        String status=request.getParameter(danshuang);
        char _status=status.charAt(0);
        switch(_status){
           case '0': dx="单双周";break;
           case '1': dx="单周";break;
           case '2': dx="双周";break;
        }
        String course_id=request.getParameter(kc);
        switch(j){
          case 1:lesson="lesson_1";break;
          case 2:lesson="lesson_2";break;
          case 3:lesson="lesson_3";break;
          case 4:lesson="lesson_4";break;
         }
        String sql_i="insert into course values('"+course_id+"','"+week+"','"+lesson+"','"+status+"')";
        if(!course_id.equals("")&&course_id!=null)      
           {
            conn.executeUpdate(sql_i);      //把数据保存到临时表
            
           // out.println(kc);
          //  out.println(course_id);
            
            _sql=sql+" and course_id='"+course_id+"'";
            rs=conn.executeQuery(_sql);
            if(rs.next())
              {kecheng_name=rs.getString("kecheng_name");
               teacher_name=rs.getString("teacher_name");
              }  
            out.println("<td>"+kecheng_name+"<br>("+teacher_name+")</td>");
            out.println("<td>"+dx+"</td>");
           }
        else
           {out.println("<td>&nbsp;</td>");
            out.println("<td>&nbsp;</td>");
           }
     }
       out.println("<tr>");
   }
  %>       
     </table>
      <br>
      <a href="javascript:history.back()" class="a">返回</a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a href="course_storage.jsp?class_id=<%=class_id%>&year_id=<%=year_id%>" class="a">保存课表</a>
  </center>
  </body>
</html>
⌨️ 快捷键说明

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