?? showstudent.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 bgcolor="#0099FF" text="#FFFFFF" link="#33FF00" vlink="#22EE00">
<p>
<% String admin_id = (String)session.getAttribute("id");
if(admin_id==null){response.sendRedirect("login.jsp");}
String name="",id="",password="",jiguan="",dep="",sex="",assistant="",entry="",classid="",dep_id;
int age,flag;
classid = request.getParameter("class_id");
%>
</p>
<p align="center"><font color="#00FF00" size="+3" face="華文行楷">所有學生</font></p>
<div align="center">
<table border="0" 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>
<td align="center" bgcolor="#EEEEEE">刪除</td>
<td align="center" bgcolor="#EEEEEE">更新</td>
<td align="center" bgcolor="#EEEEEE">查看成績</td>
</tr>
<%myBeans.SQLBean db = new myBeans.SQLBean();
String sql = "select student.*,department.NAME from student,department where student.DEPARTMENT=department.ID and CLASS_ID='"+classid+"'";
ResultSet rs = db.executeQuery(sql);
while(rs.next())
{
id=rs.getString(1);
name=rs.getString(3);
password=rs.getString(2);
age = rs.getInt(6);
jiguan=rs.getString(7);
dep=rs.getString(13);
sex=rs.getString(4);
classid=rs.getString(8);
entry=rs.getString(5).substring(0,4);
assistant=rs.getString(10);
flag=rs.getInt("FLAG");
dep_id=rs.getString(9);
%>
<tr>
<td align="center" bgcolor="#FFFFFF"><%=id%></td>
<td align="center" bgcolor="#FFFFFF"><%=name%></td>
<td align="center" bgcolor="#FFFFFF"><%=password%></td>
<td align="center" bgcolor="#FFFFFF"><%=age%></td>
<td align="center" bgcolor="#FFFFFF"><%=jiguan%></td>
<td align="center" bgcolor="#FFFFFF"><%=dep%></td>
<td align="center" bgcolor="#FFFFFF"><%=sex%></td>
<td align="center" bgcolor="#FFFFFF"><%=entry%></td>
<td align="center" bgcolor="#FFFFFF"><%=classid%></td>
<td align="center" bgcolor="#FFFFFF"><%=assistant%></td>
<%if(flag==1){%>
<td align="center" bgcolor="#FFFFFF">是</td>
<%}else{%>
<td align="center" bgcolor="#FFFFFF">否</td>
<%}%>
<td align="center" bgcolor="#FFFFFF"><a href="StudentSvlt?action=delete&id=<%=id%>">刪除</a></td>
<td align="center" bgcolor="#FFFFFF"><a href="updateStu.jsp?id=<%=id%>&name=<%=name%>&password=<%=password%>&age=<%=age%>&jiguan=<%=jiguan%>&dep=<%=dep_id%>&classid=<%=classid%>&sex=<%=sex%>&entry=<%=entry%>">更新</a> </td>
<td align="center" bgcolor="#FFFFFF"><a href="checkMark.jsp?stu_id=<%=id%>">成績</a></td>
</tr>
<%
}
%>
</table>
</div>
<p align="center"> </p>
<div align="center"><a href="getClass.jsp">返回</a>
</div>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -