📄 stu_kq_info.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"/>

<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>
<%! 
  ResultSet rs=null;
  String sql="";
  String class_id="";
  String year_id="";
  String year_name="";
 %>
<% 
    String stu_number=request.getParameter("stu_number");
    java.util.Date cur_time=new java.util.Date();
    java.text.DateFormat format=new java.text.SimpleDateFormat("yyyy/MM/dd HH:mm:ss");
    String cur_time_2=format.format(cur_time);
    String sql_t="select * from year where year_end>'"+cur_time_2+"' and year_start<'"+cur_time_2+"'";
    ResultSet rs_t=conn.executeQuery(sql_t);
    if(rs_t.next()){
       year_id=rs_t.getString("year_id");
       year_name=rs_t.getString("year_name");
    }
    conn.close();
	
	String year_id_2=request.getParameter("year_id");                 //查询
	if(year_id_2!=null){
	    String sql_s="select * from year where year_id='"+year_id_2+"'";
		ResultSet rs_s=conn.executeQuery(sql_s);
		if(rs_s.next()){
		   year_id=rs_s.getString("year_id");
		   year_name=rs_s.getString("year_name");
		}
	}
	
	String stu_name="";
    sql="select class_id,stu_name from student where stu_number='"+stu_number+"'";
    rs=conn.executeQuery(sql);
    if(rs.next()){
      class_id=rs.getString("class_id");
	  stu_name=rs.getString("stu_name");
	}
    conn.close();
 %> 
 <br>
  <form action="stu_kq_info.jsp" method="post">
    <input type="hidden" name="stu_number" value="<%=stu_number%>">
  <table width="40%">
    <tr>
       <td>请选择学年：</td>
       <td><select name="year_id">
          <% 
             ResultSet rs_y=null;
             String sql_y="select year_id,year_name from year order by year_id DESC";
             rs_y=conn.executeQuery(sql_y);
             while(rs_y.next())
                out.println("<option value="+rs_y.getString("year_id")+">"+rs_y.getString("year_name")+"</option>");
              conn.close();
           %>
       </select></td>
       <td><input type="submit" value="查询"></td>
    </tr>
  </table>
  </form>
  <hr width="60%">
 <h3><%= year_name %> <%=stu_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><center>考勤详细信息</center></td>
    </tr>
    <% 
       ResultSet _rs=null;
       String _sql="";
       int stu_qj=0;
       int stu_kk=0;
       int stu_cd=0;
       int stu_zt=0;
       _sql="select count(stu_status) as number from kaoqin_info where year_id='"+year_id+"' and stu_number='"+stu_number+"'";
       String kecheng_id="";
       sql="select distinct kecheng_name,teacher_name,kecheng_id from course_info where class_id='"+class_id+"' and year_id='"+year_id+"'";
       rs=conn.executeQuery(sql);
       while(rs.next()){
     %>
     <tr>
       <td><%= rs.getString("kecheng_name") %></td>
       <td><%= rs.getString("teacher_name") %></td>
       <% 
          kecheng_id=rs.getString("kecheng_id");

          String sql_qj=_sql+" and kecheng_id='"+kecheng_id+"' and stu_status='5'";
          _rs=conn.executeQuery(sql_qj);
          _rs.next();
          stu_qj=_rs.getInt("number");
          conn.close();
          
          String sql_kk=_sql+" and kecheng_id='"+kecheng_id+"' and stu_status='2'";
          _rs=conn.executeQuery(sql_kk);
          _rs.next();
          stu_kk=_rs.getInt("number");
          conn.close();
          
          String sql_cd=_sql+" and kecheng_id='"+kecheng_id+"' and stu_status='3'";
          _rs=conn.executeQuery(sql_cd);
          _rs.next();
          stu_cd=_rs.getInt("number");
          conn.close();
          
          String sql_zt=_sql+" and kecheng_id='"+kecheng_id+"' and stu_status='4'";
          _rs=conn.executeQuery(sql_zt);
          _rs.next();
          stu_zt=_rs.getInt("number");
          conn.close();
          
        %>
       <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><center><a href="stu_kq.jsp?kecheng_id=<%=kecheng_id%>&stu_number=<%=stu_number%>&class_id=<%=class_id%>&year_id=<%=year_id%>">查看</a></center></td>
     </tr>
    <% 
       }
    conn.close();
     %>
   </table>
   <br>
   <a href="javascript:history.back()" class="a">返回</a>
  </center>
  </body>
</html>
⌨️ 快捷键说明

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