📄 course_time.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 college_id="";
  String grade_name="";
  String sp_id="";
  String class_number_name="";
  String class_id="";
  String year_id="";
  String sql="";
 %>
<% 
  year_id=request.getParameter("year_id");
  college_id=request.getParameter("college_id");
  grade_name=request.getParameter("grade_name");
  sp_id=request.getParameter("sp_id");
  class_number_name=request.getParameter("class_number_name");
  class_id=request.getParameter("class_id");
  year_id=request.getParameter("year_id");
  sql="select * from class_sp_college where college_id='"+college_id+"' and grade_name='"+grade_name+"' and sp_id='"+sp_id+"' and class_number_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>
        <% 
         rs=conn.executeQuery(sql);
         if(rs.next()){
        // String year_name=rs.getString("year_name");
         String college_name=rs.getString("college_name");
         String sp_name=rs.getString("sp_name");
        %>
     <h3><%= year_id %> <%= college_name %> <%= grade_name %>级 <%= sp_name %><%= class_number_name %> 班 上课时间安排</h3> 
	 <form action="course_time_view.jsp" method="post">
     <table width="98%" border="1" cellspacing="0">
       <tr>
         <td width="8%">星期</td>
         <td width="15%">第一二节课</td>
         <td width="8%">单/双周</td>
         <td width="15%">第三四节课</td>
         <td width="8%">单/双周</td>
         <td width="15%">第五六节课</td>
         <td width="8%">单/双周</td>
         <td width="15%">第七八节课</td>
         <td width="8%">单/双周</td>
       </tr>
       <% 
         String xingqi="";
         for(int i=1;i<=7;i++){
           switch(i){
             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;
           }
       %>
        <tr>
           <td><%= xingqi %></td>
      <% 
           for(int j=1;j<=4;j++){    
      %>  
           <td><select name="kecheng<%=i%><%=j%>">
              <option value="" selected>======请选择======</option>
           <% 
           ResultSet rs_kc=null;
           String sql_kc="select course_id,kecheng_name from course_name_kecheng where year_id='"+year_id+"' and class_id='"+class_id+"'";
           rs_kc=conn.executeQuery(sql_kc);
           if(rs_kc.next()){
             do{
               out.println("<option value="+rs_kc.getString("course_id")+">"+rs_kc.getString("kecheng_name")+"</option>");
             }while(rs_kc.next());
             conn.close();
            }
           %>
           </select></td>
           <td><input type="radio" name="<%=i%><%=j%>" value="0" checked>单双
               <input type="radio" name="<%=i%><%=j%>" value="1">单
               <input type="radio" name="<%=i%><%=j%>" value="2">双
           </td>
           <% 
            }
            %>
        </tr>
      <%
         }
       %>
     </table>
     <br><br>
     <input type="submit" value="预览课表">
     <input type="hidden" name="year_id" value="<%=year_id%>">
     <input type="hidden" name="class_id" value="<%=class_id%>">
     
     <input type="hidden" name="year_name" value="<%=year_id%>">
     <input type="hidden" name="college_name" value="<%=college_name%>">
     <input type="hidden" name="grade_name" value="<%=grade_name%>">
     <input type="hidden" name="sp_name" value="<%=sp_name%>">
     <input type="hidden" name="class_number_name" value="<%=class_number_name%>">
     </form>
   </center> 
        <% 
         }else{
           out.println("<center><h1>此班级不存在!</h1><center>");
         }
        %> 
   说明: 单双:表示单双周都要上课 单:表示单周上课 双:表示双周上课
   </body>
 </html>
⌨️ 快捷键说明

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