?? accountchange.jsp
字號:
<%@page contentType="text/html;charset=GBK"%>
<%@page import="java.sql.*" errorPage="/public/error.jsp"%>
<%@ include file="/public/checkvalidadmin.jsp"%>
<%@ include file="/public/checkvalidadmin8.jsp"%>
<jsp:useBean id="conn" scope="page" class="test.ConnOracle"/>
<%!
ResultSet rs = null;
String username = "";
String truename = "";
String password = "";
String priv = "";
String oper = "";
String sql = "";
int result = 0;
%>
<html>
<head>
<title>權限管理</title>
<link rel="stylesheet" href="../public/style.css">
</head>
<Body class="ss">
<center>
<%
request.setCharacterEncoding("GBK");
username = request.getParameter("username");
truename = request.getParameter("truename");
password = request.getParameter("password");
priv = request.getParameter("priv");
oper = request.getParameter("oper");
// 避免用戶直接在瀏覽器地址欄輸入地址所產生的Exception
if(username==null || username.equals("")) {
out.println("<center>");
out.println("請進行合法操作！");
out.println("</center>");
return;
}
try{
rs = conn.executeQuery("select * from test_admin where loginname='"+username+"'");
if(!rs.next()) {
out.println("<center>");
out.println("數據庫沒有用戶名為" + username + "的用戶！<br>");
out.println("單擊這里<a href=javascript:history.back()>返回</a><br>");
out.println("</center>");
} else {
if(oper.equals("修改")) {
sql = "update test_admin set PRIVILEDGE=" + priv ;
sql+= ",truename='"+ truename + "',";
sql+= "password='" + password + "' ";
sql+= "where loginname='" + username + "'";
} else if(oper.equals("刪除")){
sql = "delete from test_admin ";
sql+= "where loginname='" + username + "'";
}
result = conn.executeUpdate( sql );
}
}catch(Exception ee) {
out.println("<center>");
out.println("管理員賬號信息更新失敗！<br><br>");
out.println("請將下列信息告知管理員<br><br>");
out.println(ee.toString() + "<br><br>");
out.println("單擊這里<a href=javascript:history.back()>返回</a><br>");
out.println("</center>");
}
%>
<jsp:forward page="accountmanager.jsp"/>
</center>
</Body>
</html>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -