📄 getuser.jsp
字号:
<%@page language="java" contentType="text/html; charset=GBK"%>
<%@page import="java.sql.*"%>
<html>
<head>
<title>学生管理</title>
<style type="text/css">
<!--
.STYLE1 {
font-size: 14px;
font-weight: bold;
color: #FFFFFF;
}
.STYLE2 {
font-size: 12px;
}
.STYLE3 {
font-size: 12px;
font-weight: bold;
}
.STYLE5 {font-size: 12px; font-weight: bold; color: #FF0000; }
-->
</style>
<script language=JavaScript>
function getconfirm(str)
{
if (confirm(str))
return ture;
else
return false;
}
function openWindow(url){
window.open(url,'', 'height=200, width=300, top=200, left=400, toolbar=no, menubar=no, scrollbars=no, resizable=no,location=no, status=no');
}
</script>
<link rel="stylesheet" href="style.css" type="text/css">
<style type="text/css">
<!--
.STYLE6 {color: #FF0000}
-->
</style>
</head>
<jsp:useBean id="user" scope="page" class="edu.UserBean" />
<body>
<%
int id;
String name="",psw="",address="",age="",sex="",email="",namel="",sort="";
int allrow=0,pagesize=20, intpage=1;
try{
namel=session.getAttribute("name").toString();
sort=session.getAttribute("sort").toString();
}catch(NullPointerException e){}
if(namel==null||namel.equalsIgnoreCase("null")||!sort.equalsIgnoreCase("admin"))
response.sendRedirect("error_ad.jsp");
try{
intpage=Integer.valueOf(request.getParameter("intpage")).intValue();
}catch(NumberFormatException e){}
ResultSet rs=user.getCount();
if(rs.next())
allrow=rs.getInt(1);
int allpage = (allrow+pagesize-1) / pagesize;
// 调整待显示的页码
if(intpage>allpage) intpage = allpage;
if(intpage<1) intpage = 1;
int startrow=(intpage-1)*pagesize;
user.setStartpage(startrow);
user.setPagesize(pagesize);
%>
<table width="750" height="30" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="250"> </td>
<td width="250"><div align="center"><font size="+2" face="华文行楷">学生列表</font></div></td>
<td width="250"><div align="right"><font face="宋体"><a href="adduser_ad.jsp"class="code"><strong>新增学生</strong></a></font></div></td>
</tr>
</table>
<table width="750" border="0" align="center" cellspacing="1"
bordercolor="#CCCCCC" bgcolor="E7F2FF">
<tr>
<td width="19%" height="25" bgcolor="#708AB6">
<div align="center" class="STYLE1">帐号</div>
</td>
<td width="7%" bgcolor="#708AB6">
<div align="center" class="STYLE1">年龄</div>
</td>
<td width="8%" bgcolor="#708AB6">
<div align="center" class="STYLE1">性别</div>
</td>
<td width="27%" bgcolor="#708AB6">
<p align="center" class="STYLE1">E-mail</p>
</td>
<td width="39%" align=center bgcolor="#708AB6">
<div align="center"><span class="STYLE1">管理操作</span>
</div>
</td>
</tr>
<%
rs = user.getUser();
while(rs.next())
{
id=rs.getInt("u_id");
name=rs.getString("u_name");
psw=rs.getString("u_psw");
address=rs.getString("u_address");
age=rs.getString("u_age");
sex=rs.getString("u_sex");
email=rs.getString("u_email");
if(email==null || email.equals(""))
email="没有";
%>
<tr>
<td bgcolor="#F7F7F7" class="STYLE3">
<div align="center"><a
href="show_ad.jsp?sort=user&userid=<%=id %>"><%=name%></a></div>
</td>
<td bgcolor="#F7F7F7" class="STYLE2">
<div align="center"><%=age%></div>
</td>
<td bgcolor="#F7F7F7" class="STYLE2">
<div align="center"><%=sex%></div>
</td>
<td bgcolor="#F7F7F7" class="STYLE2">
<div align="center"><%=email%></div>
</td>
<td bgcolor="#F7F7F7">
<div align="center">
<%if(user.isforbid(id)){%> <a
href="Servletuser?action=unforbid&id=<%=id%>"
onClick="return getconfirm('您确定要取消禁言吗？')"><strong>取消禁言</strong></a>
<%}if(!user.isforbid(id)){%>
<a href="Servletuser?action=forbid&id=<%=id%>"
onClick="return getconfirm('您确定要禁止（他/她）发言吗？')"><strong>禁止发言</strong></a>
<%} %> <a href="modifyuser_ad.jsp?id=<%=id%>">修改</a> <a
href="Servletuser?action=delete&id=<%=id%>"
onClick="return getconfirm('您确定要删除吗？')">删除</a> <%if(!user.isu(id)){ %><a
href="javascript:openWindow('adduuser.jsp?u_id=<%=id%>')">列为优秀</a>
<%}else{ %> <span class="STYLE5">优秀</span> <%} %>
</div>
</td>
</tr>
<%
}rs.close();
%>
</table>
<div align="center">
<table width="750" border="0">
<tr>
<td width="30%" height="30">
<div align="center">共<span class="STYLE6"><%=allrow %></span>条记录 当前第<span class="STYLE6"><%=intpage %></span>页/共<span class="STYLE6"><%=allpage %></span>页</div></td>
<td width="70%"><div align="center"><a href="getuser.jsp">首页</a>
<%int tenpage=((int)(intpage/10))*10;
if(intpage-10>0) {%>
<a href="getuser.jsp?intpage=<%=intpage-10%>">上十页</a>
<%} %>
<a href="getuser.jsp?intpage=<%=intpage-1%>">上一页</a>
<%if(tenpage+10<=allpage){
for(int i=1;i<=10;i++){%>
<a href="getuser.jsp?intpage=<%=tenpage+i %>"><%=tenpage+i %></a>
<%}}if(tenpage+10>allpage){
for(int i=1;i+tenpage<=allpage;i++){%>
<a href="getuser.jsp?intpage=<%=tenpage+i %>"><%=tenpage+i %></a>
<%}} %>
<a href="getuser.jsp?intpage=<%=intpage+1%>">下一页</a>
<%if(intpage+10<=allpage) {%>
<a href="getuser.jsp?intpage=<%=intpage+10%>">下十页</a>
<%} %>
<a href="getuser.jsp?intpage=<%=allpage%>">尾页</a></div></td>
</tr>
</table></div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -