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="修改">
<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 + -
显示快捷键?