📄 detailuser.jsp
字号:
<html>
<body>
<%@ page contentType="text/html;charset=gb2312" import="java.sql.*"%>
<jsp:useBean id="conn" class="dbBean.DBBean" scope="session"/>
<%@ include file="check.jsp"%>
<center>
<%
String id="0";
String name="";
String sex="";
String age="";
String phone="";
String email="";
String address="";
int rank=0;
String rankstr="";
String pubnum="";
String face="";
if(request.getParameter("detailid")!=null)
id=request.getParameter("detailid");
String sql="select * from user where userid="+id;
ResultSet rs=conn.executeQuery(sql);
if(rs.next())
{
name=rs.getString("name");
sex=rs.getString("sex");
age=rs.getString("age");
phone=rs.getString("phone");
email=rs.getString("email");
address=rs.getString("address");
rank=rs.getInt("rank");
pubnum=rs.getString("pubnum");
face=rs.getString("face");
}
rs.close();
conn.close();
switch(rank)
{
case 0:rankstr="普通用户";break;
case 1:rankstr="1区斑竹";break;
case 2:rankstr="2区斑竹";break;
case 3:rankstr="3区斑竹";break;
case 4:rankstr="管理员";break;
}
%>
<link rel="stylesheet" type="text/css" href="style.css"/>
<p>
<table width="95%" height="40%" cellpadding="3" cellspacing="0" border bordercolor="#ff6600" bordercolorlight="#FFFFFF">
<tr>
<th background="images/bg1.gif" colspan="5" height="40">查看用户详细信息</th>
<tr>
<th width="10%" align="center" bgcolor="#ff9933">用户名</th>
<td width="30%" align="center"><%=name%></td>
<th width="10%" align="center" bgcolor="#ff9933">性别</th>
<td width="30%" align="center"><%=sex%></td>
<td rowspan="4"><img src="<%=face%>" width="80%" height="80%"></td>
<tr>
<th align="center" bgcolor="#ff9933">年龄</th>
<td align="center"><%=age%></td>
<th align="center" bgcolor="#ff9933">电话</th>
<td align="center"><%=phone%></td>
<tr>
<th align="center" bgcolor="#ff9933">电子邮件</th>
<td align="center"><%=email%></td>
<th align="center" bgcolor="#ff9933">联系地址</th>
<td align="center"><%=address%></td>
<tr>
<th align="center" bgcolor="#ff9933">发表文章</th>
<td align="center"><%=pubnum%></td>
<th align="center" bgcolor="#ff9933">用户级别</th>
<td align="center"><%=rankstr%></td>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -