📄 getclass.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>
<jsp:useBean id="myclass" scope="page" class="myBean.MyClass"/>
<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 dep_id = request.getParameter("id");
if(dep_id!=null){dep = dep_id;}
String id="",monitor="",depN="";
int count=0,leave=0,year=0;
%></p>
<p align="center"><font color="#00FF00" size="+3" face="华文行楷">所有班级</font></p>
<p><a href="addClass.jsp">新增班级</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>
</tr>
<%
ResultSet rs=myclass.getClass(dep);
while(rs.next()) {
id=rs.getString("ID");
count=rs.getInt("COUNT");
leave=rs.getInt("LEAVECOUNT");
year=rs.getInt("DATE");
dep=rs.getString("DEPARTMENT");
monitor=rs.getString("MONITOR");
depN=rs.getString(7);
%>
<tr>
<td align="center" bgcolor="#FFFFFF"><%=id%></td>
<td align="center" bgcolor="#FFFFFF"><%=year%></td>
<td align="center" bgcolor="#FFFFFF"><%=count%></td>
<td align="center" bgcolor="#FFFFFF"><%=leave%></td>
<td align="center" bgcolor="#FFFFFF"><%=depN%></td>
<td align="center" bgcolor="#FFFFFF"><%=monitor%></td>
<td align="center" bgcolor="#FFFFFF"><a href="MyClassSvlt?action=delete&class_id=<%=id%>">删除</a></td>
<td align="center" bgcolor="#FFFFFF"><a href="updateClass.jsp?class_id=<%=id%>&monitor=<%=monitor%>&depN=<%=depN%> ">更新</a></td>
<td align="center" bgcolor="#FFFFFF"><a href="showStudent.jsp?class_id=<%=id%>">查看本班学生</a></td>
</tr>
<%
}
%>
</table>
</div>
<p align="center"> </p>
<p align="center"><a href="javascript:history.back();">返回</a></p>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -