?? usermod.jsp
字號:
<%@ page language="java" contentType="text/html; charset=gb2312"
import="java.util.*" pageEncoding="gb2312" errorPage="../error.jsp"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>修改用戶</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
<style type="text/css">
<!--
.STYLE3 {font-family: "宋體"; font-size: 18px; }
.STYLE5 {color: #FFFFFF}
-->
</style>
<link href="style.css" rel="stylesheet" type="text/css">
</head>
<jsp:useBean id="myRs" scope="page" class="utils.DBManager" />
<%
String id = (String) session.getAttribute("userid");
if (id == null)
response.sendRedirect("../index.jsp?error=2");
%>
<%
Integer level = (Integer) session.getAttribute("level");
int l = level.intValue();
if (level == null)
response.sendRedirect("../index.jsp?error=2");
if (!(l == 3))
response.sendRedirect("../error.jsp");
%>
<%
String sql = null;
java.sql.ResultSet rs = null;
String message = "";
String type = "";
String Userid = "";
String password = "";
Integer levels = null;
%>
<%
request.setCharacterEncoding("gb2312");
Userid = (String) session.getAttribute("Userid");
if (Userid != null) {
sql = "select * from users where userid='" + Userid + "'";
try {
rs = myRs.executeQuery(sql);
while (rs.next()) {
Userid = rs.getString("userid");
password = rs.getString("password");
levels = Integer.valueOf(rs.getInt("levels"));
}
} catch (Exception e) {
e.printStackTrace();
message = "查詢用戶失敗";
}
type = request.getParameter("type");
if (type != null && type.equals("update")) {
String userid = request.getParameter("userid");
password = request.getParameter("password");
levels = Integer.valueOf(request.getParameter("levels"));
sql = "update users set ";
if (userid != null) {
sql += "userid='" + userid + "',";
}
if (password != null) {
sql += "password='" + password + "',";
}
if (levels != null) {
sql += "levels=" + levels + ",";
}
sql = sql.substring(0, sql.length() - 1);
sql += " where userid='" + Userid + "'";
//out.println(sql);
try {
int i = myRs.executeUpdate(sql);
message = "修改用戶成功！";
} catch (Exception e) {
e.printStackTrace();
message = "修改用戶失敗！請后退，或者重新修改！";
} finally {
myRs = null;
}
}
}
%>
<body>
<table width="1024" border="0" align="center">
<tr>
<td>
<img src="MainImages/Top.jpg" width="1024" height="126">
</td>
</tr>
<tr>
<td>
<table width="1024" height="300" border="0"
background="MainImages/bg01.gif">
<tr>
<td width="192" valign="top">
<table width="100%" border="0">
<tr>
<td valign="middle">
<div align="center" class="STYLE3">
<a href="../Main.jsp">首頁</a>
</div>
</td>
</tr>
<tr>
<td valign="middle">
<div align="center" class="STYLE3">
<a href="UserInfo.jsp">用戶信息</a>
</div>
</td>
</tr>
<tr>
<td valign="middle">
<div align="center" class="STYLE3">
<a href="UserAdd.jsp">增加用戶</a>
</div>
</td>
</tr>
<tr>
<td valign="middle">
<div align="center" class="STYLE3">
<a href="UserDel.jsp">刪除用戶</a>
</div>
</td>
</tr>
<tr>
<td valign="middle">
<div align="center" class="STYLE3">
<a href="UserMod.jsp">修改用戶</a>
</div>
</td>
</tr>
</table>
</td>
<td width="822" align="center">
<form name="form" method="post" action="UserMod.jsp?type=update">
<table width="100%" border="1">
<tr>
<td width="35%">
<div align="right">
用戶帳號：
</div>
</td>
<td width="65%">
<div align="left">
<label>
<input name="userid" type="text" size="40"
value="<%=Userid%>">
</label>
</div>
</td>
</tr>
<tr>
<td>
<div align="right">
用戶密碼：
</div>
</td>
<td>
<div align="left">
<label>
<input name="password" type="password" size="40"
value="<%=password%>">
</label>
</div>
</td>
</tr>
<tr>
<td>
<div align="right">
權限分級：
</div>
</td>
<td>
<div align="left">
<label>
<input name="levels" type="text" size="40"
value="<%=levels%>">
</label>
</div>
</td>
</tr>
<tr>
<td colspan="2">
<div align="center">
<label>
<input type="submit" name="Submit" value="修改">
</label>
</div>
</td>
</tr>
</table>
</form>
<center>
<%=message%>
</center>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td>
<p align="center">
<img src="MainImages/bottom.gif" width="1024" height="80"
border="0" usemap="#Map">
</p>
</td>
</tr>
</table>
<map name="Map">
<area shape="rect" coords="521,49,605,70"
href="mailto:zhangxuebo1025@163.com" target="_blank">
</map>
<br>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -