📄 stu_kq.jsp

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

<%! 
  ResultSet rs=null;
  String sql="";
  String stu_number="";
  String year_id="";
  String class_id="";
  String kecheng_id="";
  String year_name="";
  String kecheng_name="";
  String teacher_name="";
 %>
<% 
 request.setCharacterEncoding("gb2312");
 stu_number=request.getParameter("stu_number");
 year_id=request.getParameter("year_id");
 kecheng_id=request.getParameter("kecheng_id");
 class_id=request.getParameter("class_id");
 sql="select distinct kecheng_name,teacher_name,year_name from course_info where class_id='"+class_id+"' and year_id='"+year_id+"' and kecheng_id='"+kecheng_id+"'";
 rs=conn.executeQuery(sql);
 if(rs.next()){
   year_name=rs.getString("year_name");
   kecheng_name=rs.getString("kecheng_name");
   teacher_name=rs.getString("teacher_name");
 }
 conn.close();
 
	String stu_name="";
    sql="select stu_name from student where stu_number='"+stu_number+"'";
    rs=conn.executeQuery(sql);
    if(rs.next()){
	  stu_name=rs.getString("stu_name");
	}
    conn.close();
%>
<html>
  <head>
    <title>考勤信息</title>
     <link rel="stylesheet" href="../../public/style.css">
	 <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
  </head>
  <body class="ss">
  <a href="kq_select.jsp" class="a">查询</a>&nbsp;&nbsp;
  <a href="javascript:window.location.reload();" class="a">刷新</a>&nbsp;&nbsp;
  <a href="javascript:history.back();" class="a">返回</a>
  <hr></hr>
  <center>
    <h3><%= year_name %> <%= teacher_name %> 老师 <%= kecheng_name %> <%=stu_name%> 考勤详细信息</h3>
    <hr width="80%"></hr>
    <table border="1" cellspacing="0" width="60%">
      <tr bgcolor="#0099FF">
        <td>时间</td>
        <td>星期</td>
        <td>课时</td>
        <td><div align="center">考勤情况</div></td>
		<td><div align="center">删除</div></td>
      </tr>
      <% 
         String stu_status="";
         sql="select sk_time,week_name,lesson_name,stu_status,id from kaoqin_info where year_id='"+year_id+"' and kecheng_id='"+kecheng_id+"' and stu_number='"+stu_number+"'";
         rs=conn.executeQuery(sql);
         while(rs.next()){
       %>
      <tr>
        <td><%= rs.getDate("sk_time") %></td>
        <td><%= rs.getString("week_name") %></td>
        <td><%= rs.getString("lesson_name") %></td>
        <% 
           stu_status=rs.getString("stu_status");
           char stu_s=stu_status.charAt(0);
           switch(stu_s){
              case '2' : stu_status="旷课";break;
              case '3' : stu_status="迟到";break;
              case '4' : stu_status="早退";break;
              case '5' : stu_status="请假";break;
           }
         %>
        <td><div align="center"><%=stu_status %></div></td>
		<td><div align="center"><a href="del_stu_kq.jsp?id=<%=rs.getInt("id")%>&stu_number=<%=stu_number%>&sk_time=<%= rs.getDate("sk_time") %>&year_id=<%=year_id%>&kecheng_id=<%=kecheng_id%>&class_id=<%=class_id%>">删除</a></div></td>
      </tr>
      <% 
          }
        conn.close();
       %>
    </table>
    <br>
    <br>
    <a href="javascript:history.back();" class="a">返回</a>  
  </center>
  </body>
</html>
⌨️ 快捷键说明

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