📄 class_manager.jsp
字号:
<%@ page contentType="text/html;charset=GBK" import="java.sql.*"%>
<%@ page errorPage="/public/errorBusy.jsp" %>
<%@ include file="/public/check_admin.jsp" %>
<jsp:useBean id="conn" scope="page" class="SQLBean.DBConn"/>
<%!
ResultSet rs=null;
ResultSet _rs=null;
String sql="";
String _sql="";
String sp_id="";
String sp_name="";
int class_number=0;
%>
<%
request.setCharacterEncoding("GBK");
sp_id=request.getParameter("sp_id");
sql="select * from specialty where sp_id='"+sp_id+"'";
rs=conn.executeQuery(sql);
if(rs.next())
sp_name=rs.getString("sp_name");
conn.close();
%>
<html>
<head>
<title><%= sp_name %>班级管理</title>
<link rel="stylesheet" href="../../public/style.css">
</head>
<body class="ss">
<a href="college_manager.jsp" class="a">建立院系</a>
<a href="college_manager_m.jsp" class="a">管理院系</a>
<a href="javascript:window.location.reload()" class="a">刷新</a>
<a href="javascript:history.back()" class="a">返回</a>
<hr></hr>
<center>
<form action="class_add.jsp" method="post">
<table width="98%" border="0" cellspacing="0">
<tr>
<td colspan="9"><center><h3><%= sp_name %></h3></center></td>
</tr>
<tr>
<td width="15%"><font color="blue" size="4">建立班级<input type="hidden" name="sp_id" value="<%=sp_id%>"></font></td>
<td width="20%">请选择年级名称:</td>
<td width="10%"><select name="grade_name">
<%
ResultSet rs_t=null;
rs_t=conn.executeQuery("select * from grade");
while(rs_t.next())
out.println("<option value="+rs_t.getString("grade_name")+">"+rs_t.getString("grade_name")+"</option>");
conn.close();
%>
</select></td>
<td width="10%">班级:</td>
<td width="10%"><select name="class_number_name">
<%
ResultSet rs_c=null;
rs_c=conn.executeQuery("select * from class_number");
while(rs_c.next())
out.println("<option value="+rs_c.getString("class_number_name")+">"+rs_c.getString("class_number_name")+"</option>");
conn.close();
%>
</select></td>
<td width="10%"><input type="submit" name="Submit" value="添加"></td>
</tr>
<%
String msg=(String)request.getParameter("errmsg");
if(msg!=null&&!msg.equals("")){
%>
<tr>
<td colspan="9"><div align="center"><font color="red" size="2"><%=msg%></font></div></td>
</tr>
<%
}
%>
<tr>
<td colspan="9"><hr color="red" width="100%"></hr></td>
</tr>
</table>
</form>
</center>
<center>
<table width="98%" border="1" cellpadding="1" cellspacing="0">
<tr bgcolor="#3399FF">
<td width="10%">班级代号</td>
<td width="10%">年级名称</td>
<td width="20%">专业名称</td>
<td width="10%"><center>班级</center></td>
<td width="10%"><center>总人数</center></td>
<td width="10%"><center>添加学生</td>
<td width="10%"><center>删除</center></td>
</tr>
<%
sql="select * from class where sp_id='"+sp_id+"'";
rs=conn.executeQuery(sql);
while(rs.next()){
%>
<tr>
<td><%= rs.getString("class_id") %></td>
<td><%=rs.getString("grade_name") %> 级</td>
<td><%= sp_name %></td>
<td><center><%= rs.getString("class_number_name") %> 班</center></td>
<%
String class_id=(String)rs.getString("class_id");
_sql="select count(*) as number from student where class_id='"+class_id+"'";
_rs=conn.executeQuery(_sql);
_rs.next();
class_number=_rs.getInt("number");
conn.close();
%>
<td><center><%= class_number %> 人</center></td>
<td><center><a href="stu_manager.jsp?class_id=<%=class_id%>">添加</a></center></td>
<td><center><a href="class_del.jsp?id=<%=rs.getInt("id")%>" onClick="return confirm('您确信要删除吗？此班级的信息将全部删除！')">删除</a></center></td>
</tr>
<%
}
// conn.close();
%>
</table>
</center>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -