📄 getawardpc.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="errorpage.jsp" %>
<%@ page import="myBeans.sqlBean"%>
<html>
<head>
<link href="Inc/student_com.css" type="text/css" rel="stylesheet">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>奖惩</title>
</head>
<body bgcolor="#0099FF" text="#FFFFFF" link="#33FF00" vlink="#22EE00">
<jsp:useBean id="ad" scope="page" class="myBean.awardPC" />
<%
String name="",stu_id="",dep="",sex="",classid="",levels="",record_time="",info="",validate="",f="",code="";
dep = "0000";
ResultSet rs = null;
%>
<p> </p>
<p align="center"><font color="#00FF00" size="+3" face="华文行楷">所有奖励学生</font></p>
<p><a href="addAwardPC.jsp?f=A"><font align="left" size="+1" face="宋体">新加奖励学生</font></a></p>
<table width="75%" border="1" align="center">
<tr>
<td>学生号</td>
<td>姓名</td>
<td>性别</td>
<td>奖励</td>
<td>奖励日期</td>
<td>班级</td>
<td>系别</td>
<td>备注</td>
<td>生效</td>
<td>删除</td>
<td>更新</td>
</tr>
<%rs = ad.getAwardPC(dep,"A");
while(rs.next()){
stu_id=rs.getString("STUID");
name=rs.getString("NAME");
sex=rs.getString("SEX");
levels = rs.getString("DESCRIPTION");
record_time = rs.getString("RECORD_TIME");
classid=rs.getString("CLASS_ID");
dep=rs.getString("DEPARTMENT");
info = rs.getString("INFOS");
validate = rs.getString("VALIDATE");
code = rs.getString("CODE");%>
<tr>
<td><%=stu_id%></td>
<td><%=name%></td>
<td><%=sex%></td>
<td><%=levels%></td>
<td><%=record_time%></td>
<td><%=classid%></td>
<td><%=dep%></td>
<td><%=info%></td>
<td><%=validate%></td>
<td><a href="AwardPCSvlt?action=delete&stu_id=<%=stu_id%>&record_time=<%=record_time%>&code=<%=code%>">删除</a></td>
<td><a href="updateAwardPC.jsp?stu_id=<%=stu_id%>&record_time=<%=record_time%>&code=<%=code%>&info=<%=info%>&validate=<%=validate%>">更新</a> </td>
</tr>
<%}%>
</table>
<p> </p>
<p align="center"><font color="#00FF00" size="+3" face="华文行楷">所有处罚学生</font></p>
<p><div align="left"><a href="addAwardPC.jsp?f=P"><font align="left" size="+1" face="宋体">新加惩罚学生</font></a></div></p>
<table width="75%" border="1" align="center">
<tr>
<td>学生号</td>
<td>姓名</td>
<td>性别</td>
<td>处罚</td>
<td>处罚日期</td>
<td>班级</td>
<td>系别</td>
<td>备注</td>
<td>生效</td>
<td>删除</td>
<td>更新</td>
</tr>
<%
rs = ad.getAwardPC(dep,"P");
while(rs!=null && rs.next())
{
stu_id=rs.getString(1);
name=rs.getString(2);
sex=rs.getString(3);
levels = rs.getString(4);
record_time = rs.getString(5);
classid=rs.getString(6);
dep=rs.getString(7);
info = rs.getString(8);
validate = rs.getString(9);
code = rs.getString(10);%>
<tr>
<td><%=stu_id%></td>
<td><%=name%></td>
<td><%=sex%></td>
<td><%=levels%></td>
<td><%=record_time%></td>
<td><%=classid%></td>
<td><%=dep%></td>
<td><%=info%></td>
<td><%=validate%></td>
<td><a href="AwardPCSvlt?action=delete&stu_id=<%=stu_id%>&record_time=<%=record_time%>&code=<%=code%>">删除</a></td>
<td><a href="updateAwardPC.jsp?stu_id=<%=stu_id%>&record_time=<%=record_time%>&code=<%=code%>&info=<%=info%>&validate=<%=validate%>">更新</a> </td>
</tr>
<%
}
%>
</table>
<p> </p>
<p align="center"><font color="#00FF00" size="+3" face="华文行楷">所有变动学生</font></p>
<p><div align="left"><a href="addAwardPC.jsp?f=C"><font size="+1" face="宋体">新加变动学生</font></a></div></p>
<table width="75%" border="1" align="center">
<tr>
<td>学生号</td>
<td>姓名</td>
<td>性别</td>
<td>变动</td>
<td>变动日期</td>
<td>班级</td>
<td>系别</td>
<td>备注</td>
<td>生效</td>
<td>删除</td>
<td>更新</td>
</tr>
<%
rs = ad.getAwardPC(dep,"C");
while(rs!=null && rs.next())
{
stu_id=rs.getString(1);
name=rs.getString(2);
sex=rs.getString(3);
levels = rs.getString(4);
record_time = rs.getString(5);
classid=rs.getString(6);
dep=rs.getString(7);
info = rs.getString(8);
validate = rs.getString(9);
code = rs.getString(10);%>
<tr>
<td><%=stu_id%></td>
<td><%=name%></td>
<td><%=sex%></td>
<td><%=levels%></td>
<td><%=record_time%></td>
<td><%=classid%></td>
<td><%=dep%></td>
<td><%=info%></td>
<td><%=validate%></td>
<td><a href="AwardPCSvlt?action=delete&stu_id=<%=stu_id%>&record_time=<%=record_time%>&code=<%=code%>">删除</a></td>
<td><a href="updateAwardPC.jsp?stu_id=<%=stu_id%>&record_time=<%=record_time%>&code=<%=code%>&info=<%=info%>&validate=<%=validate%>">更新</a> </td>
</tr>
<%
}
%>
</table>
<p align="center"> </p>
<a href="admin.jsp"><<Back </a>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -