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">&nbsp;<%=rs.getString("username")%></td>
    <td align="center">&nbsp; 
      <%
	  	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>&nbsp; </p>
</body>
</html>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?