?? getaward.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" />
<p>
<%
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>
<p align="center"><font color="#00FF00" size="+3" face="華文行楷">所有獎勵學生</font></p>
<p><a href="addAward.jsp?f=A">新加獎勵學生</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,"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 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="AwardSvlt?action=delete&stu_id=<%=stu_id%>&record_time=<%=record_time%>&code=<%=code%>">刪除</a></td>
<td align="center" bgcolor="#FFFFFF"><a href="updateAward.jsp?stu_id=<%=stu_id%>&record_time=<%=record_time%>&code=<%=code%>&info=<%=info%>&validate=<%=validate%>">更新</a> </td>
</tr>
<%}%>
</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 + -