adminuser.jsp

来自「JSP+ORACLE网站开发实例(下).rar」· JSP 代码 · 共 87 行

JSP
87
字号
<%@ include file="conn.jsp"%>
<%if ((session.getValue("admin")==null)||(session.getValue("admin")=="")){
 response.sendRedirect("admin.jsp");
}
%>
<html>
<head>
<title>用户管理</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="style.css" rel="stylesheet" type="text/css">
</head>
<%String sql;
 sql="select * from scott.admin";
      ResultSet rs=stmt.executeQuery(sql); 

%>
<body>
<div align="center">
  <p> </p>
  <p>修改管理员信息 | <a href=adduser.jsp>增加管理员</a></p>
  <table width="501" border="0" cellspacing="1" cellpadding="0">
    <tr class="title"> 
      <td height="25"  width="30"> 
        <div align="center">序号</div>
      </td>
      <td  width="120"> 
        <div align="center">用户名</div>
      </td>
      <td  width="120"> 
        <div align="center">密码</div>
      </td>
      <td  width="100"> 
        <div align="center">权限</div>
      </td>
      <td  width="130"> 
        <div align="center">操作</div>
      </td>
    </tr>
  </table>
  <%while(rs.next()){ %>
    <form method="post" action="saveuser.jsp" style="margin:0">
    <table width="500" border="0" cellspacing="1" cellpadding="0">
      <tr class="tdbg"> 
        <td height="30" width="30"> 
          <div align="center">1</div>
        </td>
        <td height="30" width="120"> 
          <div align="center">
            <input class="smallinput" type="text" name="manager" value="<%=rs.getString("username")%>" size="12">
          </div>
        </td>
        <td height="30" width="120"> 
          <div align="center">
            <input class="smallinput" type="password" name="newpin" value="<%=rs.getString("password")%>" size="12">
          </div>
        </td>
        <td height="30" width="100">
          <%if(rs.getString("flag").equals("1")){  %> 
          <div align="center">超级用户</div>
          <%}%>
          <%if(rs.getString("flag").equals("2")){  %> 
          <div align="center">普通用户</div>
          <%}%>
          <%if(rs.getString("flag").equals("3")){  %> 
          <div align="center">员工</div>
          <%}%>
        </td>
        <td height="30" width="130"> 
          <div align="center">
            <input class="buttonface" type="submit" name="Submit" value="修改">&nbsp;
            <input class="buttonface" type="submit" name="Submit" value="删除">
            <input type="hidden" name="oldmanager" value="<%=rs.getString("username")%>">
            <input type="hidden" name="oldpin" value="<%=rs.getString("password")%>">
          </div>
        </td>
      </tr>
    </table>
  </form>    
  <%
}

  %>
  <p> </p> </div>

<p align=center>超级用户可以进行所有功能的操作<br>普通用户没有用户管理和栏目管理权限,用户只有添加程序的权限。
</body>
</html>

⌨️ 快捷键说明

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