📄 qj_info.jsp
字号:
<%@ page contentType="text/html;charset=GBK" %>
<%@ page errorPage="/public/errorBusy.jsp" %>
<%@ include file="/public/check_admin.jsp" %>
<%@ page import="java.sql.*" %>
<%@ page import="qingjia.QJ_Record" %>
<jsp:useBean id="conn" scope="page" class="SQLBean.DBConn"/>
<jsp:useBean id="qj" scope="page" class="qingjia.QingJia"/>
<%!
ResultSet rs=null;
String sql="";
ResultSet _rs=null;
String _sql="";
String id="";
String stu_number="";
String stu_name="";
String stu_sex="";
String grade_name="";
String sp_name="";
String class_number_name="";
String class_teacher_name="";
String class_teacher_restore="";
String college_leader_id="";
String college_leader_name="";
String college_leader_restore="";
String year_name="";
String college_name="";
int class_status=0;
int college_status=0;
int day_number=0;
String qj_yy="";
java.sql.Timestamp qingjia_time=null;
java.sql.Date start_time=null;
java.sql.Date end_time=null;
java.sql.Timestamp c_sp_time=null;
java.sql.Timestamp college_sp_time=null;
%>
<%
request.setCharacterEncoding("GBK");
id=request.getParameter("id");
sql="select * from qingjia_detail where id='"+id+"'";
rs=conn.executeQuery(sql);
if(rs.next()){
stu_number=rs.getString("stu_number");
stu_name=rs.getString("stu_name");
stu_sex=rs.getString("stu_sex");
grade_name=rs.getString("grade_name");
sp_name=rs.getString("sp_name");
class_number_name=rs.getString("class_number_name");
qingjia_time=rs.getTimestamp("qingjia_time");
start_time=rs.getDate("start_time");
end_time=rs.getDate("end_time");
day_number=rs.getInt("day_number");
qj_yy=rs.getString("qingjia_yuanyin");
class_teacher_name=rs.getString("class_teacher_name");
college_leader_id=rs.getString("college_leader_id");
class_teacher_restore=rs.getString("class_teacher_restore");
college_leader_restore=rs.getString("college_leader_restore");
year_name=rs.getString("year_name");
college_name=rs.getString("college_name");
class_status=rs.getInt("class_teacher_status");
college_status=rs.getInt("college_leader_status");
c_sp_time=rs.getTimestamp("class_teacher_sp_time");
college_sp_time=rs.getTimestamp("college_leader_sp_time");
}
conn.close();
_sql="select * from college_leader_user where college_leader_id='"+college_leader_id+"'";
_rs=conn.executeQuery(_sql);
if(_rs.next())
college_leader_name=_rs.getString("college_leader_name");
_rs.close();
conn.close();
String class_sp=" ";
switch(class_status){
case 0: class_sp="等待审批";c_sp_time=null;break;
case 1: class_sp="同意请假";break;
case 2: class_sp="不同意请假";break;
}
String college_sp=" ";
switch(college_status){
case 0: {
if(day_number>=4&&class_status!=2)
college_sp="等待审批";
college_sp_time=null;
break;
}
case 1: college_sp="同意请假";break;
case 2: college_sp="不同意请假";break;
}
int T=class_status;
int C=college_status;
int N=day_number;
QJ_Record r=new QJ_Record(T,C,N);
int result=qj.judge(r);
String result_s=" ";
switch(result){
case 0: result_s="等待审批";break;
case 1: result_s="请假成功";break;
case -1:result_s="请假失败";break;
}
%>
<script language="javascript">
function printit()
{
if (confirm('确定打印吗？')) {
wb.execwb(6,6)
}
}
</script>
<html>
<head>
<title>学生请假详细信息</title>
<link rel="stylesheet" href="../../public/style.css">
<style type="text/css">
<!--
.style1 {font-size: 12pt}
-->
</style>
</head>
<body class="ss">
<center>
<h3>请假信息卡</h3>
<table width="90%" height="222" border="0" cellpadding="0" cellspacing="0" id="wb">
<tr>
<td colspan="2"><div align="center" class="style1">
<div align="center">学生信息</div>
</div></td>
</tr>
<tr>
<td width="26%">学号:</td>
<td width="74%"><%= stu_number %></td>
</tr>
<tr>
<td>姓名:</td>
<td><%= stu_name %></td>
</tr>
<tr>
<td>性别:</td>
<td><%= stu_sex %></td>
</tr>
<tr>
<td>院系:</td>
<td><%= college_name %></td>
</tr>
<tr>
<td>年级:</td>
<td><%= grade_name %></td>
</tr>
<tr>
<td>专业:</td>
<td><%= sp_name %></td>
</tr>
<tr>
<td>班级:</td>
<td><%= class_number_name %> 班</td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
<tr>
<td colspan="2"><div align="center" class="style1">
<div align="center">请假信息</div>
</div></td>
</tr>
<tr>
<td>请假学年:</td>
<td><%= year_name %></td>
</tr>
<tr>
<td>申请时间:</td>
<td><%= qingjia_time %></td>
</tr>
<tr>
<td>开始时间:</td>
<td><%= start_time %></td>
</tr>
<tr>
<td>结束时间:</td>
<td><%= end_time %></td>
</tr>
<tr>
<td>请假天数:</td>
<td><%= day_number %> 天</td>
</tr>
<tr>
<td>请假原因:</td>
<td><%= qj_yy %></td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
<tr>
<td colspan="2"><div align="center" class="style1">
<div align="center">班主任意见</div>
</div></td>
</tr>
<tr>
<td>班主任姓名:</td>
<td><%= class_teacher_name %></td>
</tr>
<tr>
<td>审批时间:</td>
<td><%= c_sp_time %></td>
</tr>
<tr>
<td>审批结果:</td>
<td><font color="red"><%= class_sp %></font></td>
</tr>
<tr>
<td>反馈意见:</td>
<td><%= class_teacher_restore %></td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
<tr>
<td colspan="2"><div align="center" class="style1">
<div align="center">院系意见</div>
</div></td>
</tr>
<tr>
<td>院系领导姓名:</td>
<td><%= college_leader_name %></td>
<% college_leader_name=" "; %>
</tr>
<tr>
<td>审批时间:</td>
<td><%= college_sp_time %></td>
</tr>
<tr>
<td>审批结果:</td>
<td><font color="red"><%= college_sp %></font></td>
</tr>
<tr>
<td>反馈意见:</td>
<td><%= college_leader_restore %></td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
<tr>
<td class="style1">请假结果:</td>
<td><font color="red"><%= result_s %></font></td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
</table>
<table width="90%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="34%"><div align="right">
<input type="button" value="打印信息" onClick="javascript:printit()">
</div></td>
<td width="27%"> </td>
<td width="39%"><input type="button" value="关闭窗口" onClick="window.close()"></td>
</tr>
</table>
</center>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -