?? getdepartment.jsp
字號:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<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>
<jsp:useBean id="department" scope="page" class="myBean.Department"/>
<body>
<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 id="",name="",cname="";
int class_count=0;
%>
</p>
<p align="center"><font color="#00FF00" size="+3" face="華文行楷">所有院系</font></p>
<p><a href="addDepartment.jsp">新增院系</a></p>
<div align="center">
<table width="520" 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">所屬班級數(shù)</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>
<%
ResultSet rs=department.getAll(dep);
while(rs.next()) {
id=rs.getString("ID");
name=rs.getString("NAME");
cname=rs.getString("CNAME");
class_count=rs.getInt("CLA_COUNT");
%>
<tr>
<td align="center" bgcolor="#FFFFFF"><%=id%></td>
<td align="center" bgcolor="#FFFFFF"><%=name%></td>
<td align="center" bgcolor="#FFFFFF"><%=cname%></td>
<td align="center" bgcolor="#FFFFFF"><%=class_count%></td>
<td align="center" bgcolor="#FFFFFF"><a href="DepartmentSvlt?action=delete&id=<%=id%>">刪除</a></td>
<td align="center" bgcolor="#FFFFFF"><a href="updateDep.jsp?id=<%=id%>&name=<%=name%>&cname=<%=cname%>&class_count=<%=class_count%> ">更新</a></td>
<td align="center" bgcolor="#FFFFFF"><a href="getClass.jsp?id=<%=id%> ">查看班級</a></td>
<td align="center" bgcolor="#FFFFFF"><a href="getTeacher.jsp?departmentid=<%=id%> ">查看教師</a></td>
</tr>
<%
}
%>
</table>
</div>
<p align="center"> </p>
<p align="center"><a href="admin.jsp" target="_parent">返回</a></p>
</body>
</html>
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -