?? getpunishment.jsp
字號:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="errorpage.jsp" %>
<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>
<jsp:useBean id="ad" scope="page" class="myBean.AwardPC" />
<%
String admin_id = (String)session.getAttribute("id");
if(admin_id==null){response.sendRedirect("login.jsp");}
String dep = (String)session.getAttribute("dep");
if(dep==null){response.sendRedirect("login.jsp");}
String name="",stu_id="",sex="",classid="",levels="",record_time="",info="",validate="",f="",code="";
ResultSet rs = null;
%>
<p align="center"><font color="#00FF00" size="+3" face="華文行楷">所有處罰學生</font></p>
<p><a href="addPunishment.jsp?f=P">新加懲罰學生</a></p>
<div align="center">
<table cellpadding="2" cellspacing="1" bgcolor="#DEDFDE">
<tr>
<td align="center" bgcolor="#EEEEEE">學生號</td>
<td align="center" bgcolor="#EEEEEE">姓名</td>
<td align="center" bgcolor="#EEEEEE">性別</td>
<td align="center" bgcolor="#EEEEEE">處罰</td>
<td align="center" bgcolor="#EEEEEE">處罰日期</td>
<td align="center" bgcolor="#EEEEEE">班級</td>
<td align="center" bgcolor="#EEEEEE">系別</td>
<td align="center" bgcolor="#EEEEEE">備注</td>
<td align="center" bgcolor="#EEEEEE">生效</td>
<td align="center" bgcolor="#EEEEEE">刪除</td>
<td align="center" bgcolor="#EEEEEE">更新</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 align="center" bgcolor="#FFFFFF"><%=stu_id%></td>
<td align="center" bgcolor="#FFFFFF"><%=name%></td>
<td align="center" bgcolor="#FFFFFF"><%=sex%></td>
<td align="center" bgcolor="#FFFFFF"><%=levels%></td>
<td align="center" bgcolor="#FFFFFF"><%=record_time%></td>
<td align="center" bgcolor="#FFFFFF"><%=classid%></td>
<td align="center" bgcolor="#FFFFFF"><%=dep%></td>
<td align="center" bgcolor="#FFFFFF"><%=info%></td>
<td align="center" bgcolor="#FFFFFF"><%=validate%></td>
<td align="center" bgcolor="#FFFFFF"><a href="PunishmentSvlt?action=delete&stu_id=<%=stu_id%>&record_time=<%=record_time%>&code=<%=code%>">刪除</a></td>
<td align="center" bgcolor="#FFFFFF"><a href="updatePunishment.jsp?stu_id=<%=stu_id%>&record_time=<%=record_time%>&code=<%=code%>&info=<%=info%>&validate=<%=validate%>">更新</a> </td>
</tr>
<%
}rs.close();
%>
</table>
</div>
<p align="center"> </p>
<div align="center"><a href="admin.jsp" target="_parent">返回</a>
</div>
</body>
</html>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -