📄 c_kaoqin_detail.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>
<a href="javascript:history.back();" class="a">返回</a>
<hr></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="";
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><div align="center">考勤情况</div></td>
<td><div align="center">删除</div></td>
</tr>
<%
sql="select * from kaoqin_info where teacher_id='"+teacher_id+"' and year_id='"+year_id+"' and kecheng_id='"+kecheng_id+"' and class_id='"+class_id+"' order by sk_time DESC,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>
<td><%= rs.getString("stu_number") %></td>
<td><%= rs.getString("stu_name") %></td>
<td><%= rs.getString("stu_sex") %></td>
<%
String stu_status=rs.getString("stu_status");
char stu_s=stu_status.charAt(0);
String stu_status_2="";
switch(stu_s){
case '2' : stu_status_2="旷课";break;
case '3' : stu_status_2="迟到";break;
case '4' : stu_status_2="早退";break;
case '5' : stu_status_2="请假";break;
}
%>
<td><div align="center"><%= stu_status_2 %></div></td>
<td><div align="center"><a href="del_stu.jsp?id=<%=rs.getInt("id")%>&stu_number=<%= rs.getString("stu_number") %>&sk_time=<%= rs.getDate("sk_time")%>&teacher_id=<%=teacher_id%>&year_id=<%=year_id%>&kecheng_id=<%=kecheng_id%>&class_id=<%=class_id%> " onclick="return confirm('您确信要删除吗？')">删除</a></div></td>
</tr>
<%
}
conn.close();
%>
</table>
</center>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -