?? 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);
<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 + -