📄 c_kaoqin_tongji.jsp

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

<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 color="blue"></hr>
  <center>
  <% 
    ResultSet rs=null;
    ResultSet _rs=null;
    String sql="";
    String _sql="";
    String kecheng_name="";
    String grade_name="";
    String sp_name="";
    String class_number_name="";
    String year_name="";
    String week_name="";
    String lesson_name="";
    String class_id="";
    String kecheng_id="";
    String year_id="";
    String teacher_id="";
    String stu_number="";
    int stu_qj=0;
    int stu_kk=0;
    int stu_cd=0;
    int stu_zt=0;
    teacher_id=request.getParameter("teacher_id");
    year_id=request.getParameter("year_id");
    kecheng_id=request.getParameter("kecheng_id");
    class_id=request.getParameter("class_id");
    _sql="select distinct grade_name,sp_name,class_number_name,kecheng_id,kecheng_name,year_name from course_info where year_id='"+year_id+"' and teacher_id='"+teacher_id+"' and kecheng_id='"+kecheng_id+"' and class_id='"+class_id+"'";
    _rs=conn.executeQuery(_sql);
    if(_rs.next()){
       year_name=_rs.getString("year_name");
       grade_name=_rs.getString("grade_name");
       sp_name=_rs.getString("sp_name");
       class_number_name=_rs.getString("class_number_name");
       kecheng_name=_rs.getString("kecheng_name");
    }
    conn.close();
   %>
   <h3><%= year_name %> <%= grade_name %> 级 <%= sp_name %> <%= class_number_name %> 班 <%= kecheng_name %> 考勤统计信息</h3>
   <table width="80%" border="1" cellspacing="0">
      <tr bgcolor="#0099FF">
         <td>学号</td>
         <td>姓名</td>
         <td>性别</td>
         <td>请假次数</td>
         <td>旷课次数</td>
         <td>迟到次数</td>
         <td>早退次数</td>
         <td><div align="center">详细信息</div></td>
      </tr>
      <% 
         sql="select count(stu_status) as number from kaoqin_info where teacher_id='"+teacher_id+"' and year_id='"+year_id+"' and kecheng_id='"+kecheng_id+"' and class_id='"+class_id+"'";
         String sql_s="select * from student where class_id='"+class_id+"'";
         ResultSet rs_s=conn.executeQuery(sql_s);
         while(rs_s.next()){
           stu_number=rs_s.getString("stu_number");
           
           String sql_qj=sql+" and stu_number='"+stu_number+"' and stu_status='5'";
           rs=conn.executeQuery(sql_qj);
           rs.next();
           stu_qj=rs.getInt("number");
           conn.close();
           
           String sql_kk=sql+" and stu_number='"+stu_number+"' and stu_status='2'";
           rs=conn.executeQuery(sql_kk);
           rs.next();
           stu_kk=rs.getInt("number");
           conn.close();
           
           String sql_cd=sql+" and stu_number='"+stu_number+"' and stu_status='3'";
           rs=conn.executeQuery(sql_cd);
           rs.next();
           stu_cd=rs.getInt("number");
           conn.close();
           
           String sql_zt=sql+" and stu_number='"+stu_number+"' and stu_status='4'";
           rs=conn.executeQuery(sql_zt);
           rs.next();
           stu_zt=rs.getInt("number");
           conn.close();
      %>
      <tr>
         <td><%= rs_s.getString("stu_number") %></td>
         <td><%= rs_s.getString("stu_name") %></td>
         <td><%= rs_s.getString("stu_sex") %></td>
         <td><font color="red"><%= stu_qj %></font> 次</td>
         <td><font color="red"><%= stu_kk %></font> 次</td>
         <td><font color="red"><%= stu_cd %></font> 次</td>
         <td><font color="red"><%= stu_zt %></font> 次</td>
         <td><div align="center"><a href="stu_kaoqin_detail.jsp?stu_number=<%=stu_number%>&kecheng_id=<%=kecheng_id%>&teacher_id=<%=teacher_id%>&year_id=<%=year_id%>&class_id=<%=class_id%>">查看</a></div></td>
      </tr>   
      <% 
          }
       conn.close();
       %>
   </table>
  </center>
  </body>
</html>
⌨️ 快捷键说明

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