📄 stu_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"/>
<%!
String str="";
public String ShowOnePage(ResultSet rs,int Page,int PageSize){
str="";
try{
rs.absolute((Page-1)*PageSize+1);
}catch(SQLException e){
}
for(int iPage=1;iPage<=PageSize;iPage++){
str+=RsToGbook(rs);
try{
if(!rs.next())
break;
}catch(Exception e){}
}
return str;
}
public String RsToGbook(ResultSet rs){
String tt="";
try{
tt+="<tr>";
tt+="<td>"+rs.getString("stu_number")+"</td>";
tt+="<td>"+rs.getString("stu_name")+"</td>";
tt+="<td><center>"+rs.getString("stu_sex")+"</center></td>";
tt+="<td><center><a href='stu_update.jsp?id="+rs.getInt("id")+"'>修改</a></center></td>";
tt+="<td><center><a href='stu_del.jsp?id="+rs.getInt("id")+"' onClick=\"return confirm('您确信要删除吗？此学生的信息将全部删除!')\">删除</a></center></td>";
tt+="</tr>";
}catch(SQLException e){}
return tt;
}
%>
<%!
ResultSet rs=null;
ResultSet _rs=null;
String sql="";
String _sql="";
String class_id="";
String college_name="";
String grade_name="";
String sp_name="";
String class_number_name="";
%>
<%
request.setCharacterEncoding("GBK");
class_id=request.getParameter("class_id");
sql="select sp_name,college_name,grade_name,class_number_name from class_sp_college where class_id='"+class_id+"'";
rs=conn.executeQuery(sql);
if(rs.next()){
college_name=rs.getString("college_name");
grade_name=rs.getString("grade_name");
sp_name=rs.getString("sp_name");
class_number_name=rs.getString("class_number_name");
}
conn.close();
%>
<script language="javascript">
function formCheck(theForm)
{
if(theForm.stu_number.value=="")
{
alert("学号不能为空！");
theForm.stu_number.focus();
return false;
}
if(theForm.stu_name.value=="")
{
alert("姓名不能为空!");
theForm.stu_name.focus();
return false;
}
}
</script>
<html>
<head>
<title>班级管理</title>
<link rel="stylesheet" href="../../public/style.css">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</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="stu_add.jsp" method="post" onSubmit="return formCheck(this)">
<table width="90%" border="0" cellspacing="0">
<tr>
<td colspan="9"><center><h3><%= grade_name %>级 <%= sp_name %> <%= class_number_name %>班</h3></center></td>
</tr>
<tr>
<td width="16%"><font color="blue" size="4">添加学生<input type="hidden" name="class_id" value="<%=class_id%>"></font></td>
<td width="11%">学号:</td>
<td width="20%"><input name="stu_number" type="text" size="20" maxlength="20"></td>
<td width="11%">姓名:</td>
<td width="17%"><input name="stu_name" type="text" size="20" maxlength="20"></td>
<td width="5%"><input type="radio" name="stu_sex" value="男" checked>男</td>
<td width="5%"><input type="radio" name="stu_sex" value="女">女</td>
<td width="8%"><input type="submit" name="Submit" value="添加"></td>
<td width="7%"><input type="reset" 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>
<table width="60%" border="1" cellpadding="1" cellspacing="0">
<tr bgcolor="#3399FF">
<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>
</tr>
<%!
ResultSet rs_f=null;
ResultSet rsTmp=null;
String sql_f="";
int PageSize=12;
int Page=1;
int totalPage=1;
%>
<%
sql_f="select * from student where class_id='"+class_id+"'";
rsTmp=conn.executeQuery("select count(*) as number from student where class_id='"+class_id+"'");
rsTmp.next();
int totalrecord=rsTmp.getInt("number");
if(totalrecord%PageSize==0) //如是当前页码的整数倍
totalPage=totalrecord/PageSize;
else
totalPage=(int)Math.floor(totalrecord/PageSize)+1;//如果最后还空于一页
if(totalPage==0) totalPage=1;
conn.close();
rsTmp.close();
try{
if(request.getParameter("Page")==null || request.getParameter("Page").equals(""))
Page=1;
else
Page=Integer.parseInt(request.getParameter("Page"));
}catch(java.lang.NumberFormatException e){
Page=1;
}
if(Page<1) Page=1;
if(Page>totalPage) Page=totalPage;
rs_f=conn.executeQuery(sql_f);
out.println(ShowOnePage(rs_f,Page,PageSize));
conn.close();
%>
</table>
<form action="stu_manager.jsp" method="get">
<input type="hidden" name="class_id" value="<%=class_id%>">
<%
if(Page!=1){
out.println("<a href=stu_manager.jsp?Page=1&class_id="+class_id+">第一页</a>");
out.println("<a href=stu_manager.jsp?Page="+(Page-1)+"&class_id="+class_id+">上一页</a>");
}
if(Page!=totalPage){
out.println("<a href=stu_manager.jsp?Page="+(Page+1)+"&class_id="+class_id+">下一页</a>");
out.println("<a href=stu_manager.jsp?Page="+totalPage+"&class_id="+class_id+">最后一页</a>");
}
rs.close();
%>
<p>输入页数:<input type="text" name="Page" size="3">页数:<font color="red" size=""><%= Page %>/<%= totalPage %></font></p>
</form>
</center>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -