📄 spmanager_m.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_c=null;
String sql="";
String sql_c="";
int c_number=0;
%>
<%
request.setCharacterEncoding("GBK");
%>
<html>
<head>
<title>专业管理</title>
<link rel="stylesheet" href="../../public/style.css">
</head>
<body class="ss">
<a href="spmanager.jsp" class="a">建立专业</a>
<a href="spmanager_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>
<h3>专业列表</h3>
<table width="98%" border="1" cellpadding="1" cellspacing="0">
<tr bgcolor="#3399FF">
<td width="20%">院系名称</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>修改</center></td>
<td width="10%"><center>删除</center></td>
</tr>
<%
sql="select * from specialty_college order by college_name,sp_name asc";
rs=conn.executeQuery(sql);
if(!rs.next())
out.println("<br><br>还没有专业!");
else{
do{
%>
<tr>
<td><%= rs.getString("college_name") %></td>
<td><%=rs.getString("sp_id") %></td>
<td><%= rs.getString("sp_name") %></td>
<%
String sp_id=(String)rs.getString("sp_id");
sql_c="select count(sp_id) as number from class where sp_id='"+sp_id+"'";
rs_c=conn.executeQuery(sql_c);
rs_c.next();
c_number=rs_c.getInt("number");
conn.close();
%>
<td><center><%= c_number %></center></td>
<td><center><a href="class_manager.jsp?sp_id=<%=sp_id%>">添加</a></center></td>
<td><center><a href="sp_update.jsp?id=<%=rs.getInt("id")%>">修改</a></center></td>
<td><center><a href="sp_del_2.jsp?id=<%=rs.getInt("id")%>" onClick="return confirm('您确信要删除吗？此专业的信息将全部删除！')">删除</a></center></td>
</tr>
<%
}while(rs.next());
}
// conn.close();
%>
</table>
</center>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -