backuser.jsp
来自「NTsky新闻发布v1.0(提供JavaBean)」· JSP 代码 · 共 82 行
JSP
82 行
<%@ page contentType="text/html; charset=GBK"%>
<%@ page import="ntsky.admin.usr.*,java.sql.*"%>
<%@ include file="check.jsp"%>
<jsp:useBean id="dft" class="ntsky.admin.Default"/>
<%
if((dft.purview(user)) == 2){
dft.backError(response,"../../error/purviewerror.jsp");
}
%>
<html>
<head>
<title>类别管理</title>
<link rel="stylesheet" href="../../css/admin.css" type="text/css">
</head>
<body>
<br>
<table width="80%" height="2%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="26" align="center"><font color="#FFFFFF">用户信息管理</font></td>
</tr>
</table>
<%
//从javabean中获取指针
BackUser bur = new BackUser();
ResultSet rs = bur.rs_usr();
//获取记录进行判断
int sum = bur.Sum();
%>
<table width="90%" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#FFFFFF">
<tr valign="middle" bgcolor="#799ae1">
<td width="35%" height="28" align="center"><font color="#FFFFFF">用户名</font></td>
<td width="46%" align="center"><font color="#FFFFFF">用户等级</font></td>
<td width="19%" align="center"><font color="#FFFFFF">删除</font></td>
</tr>
<%
//判断指针是否为空,如果为空说明还没有数据!
if(sum>0){
while(rs.next()){//循环将结果显示
%>
<tr>
<td height="30" align="center"> <%=rs.getString("username")%></td>
<td align="center">
<%
int purview = rs.getInt("purview");
if(purview == 1){
out.print("管理员");
}
else{
if(purview == 2){
out.print("录入员");
}
}
%>
</a>
</td>
<td align="center"><a href="delbackuser.jsp?username=<%=rs.getString("username")%>" ><img src="../../images/admin/del.gif" alt="删除用户" width="16" height="16" border="0"></a></td>
</tr>
<%
}
}else{
%>
<tr align="center">
<td height="35" colspan="3" align="center" class="title">Sorry! 还没有任何记录? 请先添加!</td>
</tr>
<%
}
%>
<%
rs.close();
bur.close();
%>
</table>
<p> </p>
</body>
</html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?