?? accountmanager.jsp
字號:
<%@page contentType="text/html;charset=GBK"%>
<%@page import="java.sql.*"%>
<%@ include file="/public/checkvalidadmin.jsp"%>
<jsp:useBean id="conn" scope="page" class="test.ConnOracle"/>
<%!
ResultSet rs = null;
String username = "";
String truename = "";
String password = "";
String priv_ok = "";
int priv = 0;
%>
<html>
<head>
<title>帳號管理</title>
<link rel="stylesheet" href="../public/style.css">
</head>
<Body class="ss">
<center>
<%
priv_ok = (String)session.getAttribute("adminpriv");
if(priv_ok!=null && priv_ok.equals("8")) {
rs = conn.executeQuery("select * from test_admin");
if(!rs.next()) {
out.println("<center>");
out.println("數(shù)據(jù)庫中還沒有用戶！<br>");
out.println("單擊這里<a href=javascript:history.back()>返回</a><br>");
out.println("</center>");
} else {
%>
<table bgColor="#00acff" border="1" borderColorDark="#ffff00" borderColorLight="#000000" cellSpacing="1" width="80%">
<tr>
<th width="20%">用戶名</th>
<th width="16%">真實姓名</th>
<th width="16%">密碼</th>
<th width="16%">面試權(quán)限</th>
<th width="16%">管理權(quán)限</th>
<th width="16%" colspan=2>操作</th>
</tr>
<%do {
username = rs.getString("loginname");
truename = rs.getString("truename");
password = rs.getString("password");
priv = rs.getInt("PRIVILEDGE");
%>
<tr align="center">
<form action="accountchange.jsp" method="post">
<td><%=username%></td>
<input type="hidden" name="username" value="<%=username%>">
<td><input type="text" name="truename" value="<%=truename%>"></td>
<td><input type="text" name="password" value="<%=password%>"></td>
<%
if(priv == 1) {
%>
<td>
<Input name="priv" type="radio" value="1" checked>
</td>
<td>
<Input name="priv" type="radio" value="8">
</td>
<%
}else if(priv == 8) {
%>
<td>
<Input name="priv" type="radio" value="1">
</td>
<td>
<Input name="priv" type="radio" value="8" checked>
</td>
<%
}
%>
<td><input type="submit" name="oper" value="修改"></td>
<td><input type="submit" name="oper" value="刪除"></td>
</form>
</tr>
<% } while(rs.next());%>
<tr>
<td colspan=7><hr color="white"></td>
</tr>
<form action="accountadd.jsp">
<tr align="center">
<td><input type="text" name="username"></td>
<td><input type="text" name="truename"></td>
<td><input type="text" name="password"></td>
<td><input type="radio" name="priv" value="1" checked></td>
<td><input type="radio" name="priv" value="8"></td>
<td colspan="2">
<Input type="submit" value="添加">
</td>
</tr>
</form>
</table>
<%
}
} else {
out.println("對不起，您的權(quán)限不足！<br>");
out.println("單擊這里<a href=javascript:history.back()>返回</a><br>");
}
%>
</form>
</center>
</Body>
</html>?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -