📄 mdfuser.jsp.htm
字号:
<%@page contentType="text/html;charset=gb2312"%>
<%@page import="java.sql.*"%>
<html>
<head>
<title>管理用户详细信</title>
</head>
<%
//得到要修改的用户的用户名
String user=request.getParameter("user");
//接收登陆用户的身份等级信息rankid
int rankid=Integer.parseInt(request.getParameter("rankid"));
//如果是管理员
if(rankid==3)
{
//加载数据库驱动并用连接池连结数据库
String sql="";
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e)
{
out.print(e);
}
String strDirPath=application.getRealPath(request.getRequestURI());
strDirPath=strDirPath.substring(0,strDirPath.lastIndexOf('\\'))+"\\";
String url = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ="+strDirPath+"forum.mdb";
Connection conn = DriverManager.getConnection(url);
Statement stmt = conn.createStatement();
//得到要修改的用户的信息
sql="select * from User where UserName='"+user+"'";
ResultSet rs=stmt.executeQuery(sql);
rs.next();
String username=rs.getString("UserName");
%>
<table width="90%" align="center" cellpadding="3" cellspacing="1">
<tr>
<td colspan="2" bgcolor="#009933">      管理用户 <%=user%>
    <a href="javascript:history.back();">返回</a>
</td>
</tr>
<form name="myform" method="post" action="magtodb.jsp?work=mdfusr&user=<%=user%>&rankid=<%=rankid%>" OnSubmit="return checkdata();">
<tr>
<td bgcolor="#efefef" width="37%">编号</td>
<td bgcolor="#efefef" width="63%">
<%=rs.getString("ID")%>
</td>
</tr>
<tr>
<td bgcolor="#efefef" width="37%">用户名</td>
<td bgcolor="#efefef" width="63%">
<%=username%>
<input type="hidden" name="username" value="<%=username%>">
</td>
</tr>
<tr>
<td bgcolor="#efefef" width="37%">密码</td>
<td bgcolor="#efefef" width="63%">
<input type="text" name="password" value=<%=rs.getString("Password")%>>
</td>
</tr>
<tr>
<td bgcolor="#efefef" width="37%">Email</td>
<td bgcolor="#efefef" width="63%">
<input type="text" name="email" value=<%=rs.getString("Email")%>>
</td>
</tr>
<tr>
<td bgcolor="#efefef" width="37%">性别</td>
<td bgcolor="#efefef" width="63%">
<%
if(rs.getString("Sex").equals("men")) {%>
<input type="radio" name="sex" value="men" checked><img src="images/boy.gif" width="24" height="24">男孩
<input type="radio" name="sex" value="women"><img src="images/girl.gif" width="26" height="26">女孩
<%}else{%>
<input type="radio" name="sex" value="men"><img src="images/boy.gif" width="24" height="24">男孩
<input type="radio" name="sex" value="women" checked><img src="images/girl.gif" width="26" height="26">女孩
<%}%>
</td>
</tr>
<tr>
<td bgcolor="#efefef" width="37%">电话</td>
<td bgcolor="#efefef" width="63%">
<input type="text" name="phone" value=<%=rs.getString("Phone")%>>
</td>
</tr>
<tr>
<td bgcolor="#efefef" width="37%">地址</td>
<td bgcolor="#efefef" width="63%">
<input type="text" name="address" value=<%=rs.getString("Address")%>>
</td>
</tr>
<tr>
<td bgcolor="#efefef" width="37%">年龄</td>
<td bgcolor="#efefef" width="63%">
<input type="text" name="age" value=<%=rs.getString("Age")%>>
</td>
</tr>
<tr>
<td bgcolor="#efefef" width="37%">头像</td>
<td bgcolor="#efefef" width="63%">
<select name="face" size=1 onChange="document.images['face'].src=options[selectedIndex].value;">
<%
for (int i=1;i<=60;i++)
out.println("<option value=images/face/Image" + i + ".gif>Image"+ i +"</option>");
%>
</select>
<img id=face src=<%=rs.getString("Face")%>>
</td>
</tr>
<tr>
<td bgcolor="#efefef" width="37%">发贴数</td>
<td bgcolor="#efefef" width="63%">
<input type="text" name="postnumber" value=<%=rs.getInt("PostNumber")%>>
</td>
</tr>
<tr>
<td bgcolor="#efefef" width="37%">等级</td>
<td bgcolor="#efefef" width="63%">
<input type="text" name="rank" value=<%=rs.getInt("Rank")%>>
</td>
</tr>
<tr>
<td colspan=2>
<center>
<input type="submit" value="确定">      
<input type="reset" value="重置">
</center>
</td>
</tr>
</table>
<% //关闭连接
stmt.close();
conn.close();
}else{%>
<h3>您不具备管理员的权限，请<a href="index.html">返回登陆论坛</a></h3>
<%}%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -