📄 aboutuser.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<jsp:useBean id="con" scope="page" class="numb1.com.db"/>
<jsp:useBean id="ht" scope="page" class="numb1.com.Dohtml"/>
<%@ include file = "include/config.jsp" %>
<%
String root=(String)session.getAttribute("root");root=ht.donull(root);
String user_id=request.getParameter("id");user_id=ht.donull(user_id);
String user_mail="";
String tim="";
String user_root="0";
String user_duty="";
String duty="";
String user_face="face/0.gif";
String user_name="";
String user_sex="";
String sex="";
String user_birth="";
String em="";
String user_qq="";
String user_web="";
String user_tel="";
String user_comefrom="";
String user_job="";
String user_love="";
String aboutself="";
String user_ontims="";
String user_txt="";
String user_retxt="";
String user_point="";
String user_popu="";
String user_sup="";
String user_recom="";
String user_lastime="";
String sql;
ResultSet rs;
sql="SELECT numb1.mail, numb1.tim, user.step, user.face, user.name, user.sex, user.birth, user.mail, user.qq, user.web, user.tel, user.comefrom, user.job, user.love, user.aboutme, online.ontims, online.txt, online.re, online.point, online.popu, online.suptxt, online.recomtxt, online.lastim FROM numb1, user, online WHERE numb1.userid='"+user_id+"' AND user.userid='"+user_id+"' AND online.userid='"+user_id+"'";
rs=con.query(sql);rs.next();
if(rs.getRow()==0){
out.print("<meta http-equiv=\"refresh\" content=\"3;URL=index.jsp\"><center><font color=#FF0000><strong>对不起，该会员不存在！</strong></font></center>");
}else{
user_mail="<a href=\"mailto:"+rs.getString(1)+"\">"+rs.getString(1)+"</a>";
tim=rs.getString(2).substring(0,10);
user_root=rs.getString(3);
user_face=rs.getString(4);
user_name=con.getStr(rs.getString(5));
user_sex=rs.getString(6);if("m".equals(user_sex)){sex="男";} if("f".equals(user_sex)){sex="女";}
if(!"2004-12-02".equals(rs.getString(7)))user_birth=rs.getString(7);
em=rs.getString(8);if("h".equals(em)){user_mail="";}
user_qq=con.getStr(rs.getString(9));
if(rs.getString(10).length()!=0){user_web="<a href=\""+con.getStr(rs.getString(10))+"\" target=_blank>"+con.getStr(rs.getString(10))+"</a>";}
user_tel=con.getStr(rs.getString(11));
user_comefrom=con.getStr(rs.getString(12));
user_job=con.getStr(rs.getString(13));
user_love=con.getStr(rs.getString(14));
aboutself=con.getStr(rs.getString(15));
user_ontims=rs.getString(16);
user_txt=rs.getString(17);
user_retxt=rs.getString(18);
user_point=rs.getString(19);
user_popu=rs.getString(20);
user_sup=rs.getString(21);
user_recom=rs.getString(22);
user_lastime=rs.getString(23).substring(0,16);
con.close();
if(root.compareTo("")==0){root="0";}
int step=Integer.parseInt(root);
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title><% out.print(user_name+"的信息");%></title>
<style type="text/css">
<!--
p{text-indent:18pt;font-size:13px}
th{font-size:13px;}
td{font-size:13px;}
a:link{text-decoration:none;color:#0000ff}
a:visited{text-decoration:none;color:#0000ff}
a:hover{text-decoration:underline;color:#96CCFE}
body {
font-size:13px;
margin-top: 0px;
background-image: url(img/bg9.gif);
margin-bottom: 0px;
}
.style3 {color: #ffffff}
-->
</style>
</head>
<body>
<table width="750" border="0" align="center" cellspacing="0" bgcolor="#ffffff">
<tr>
<td><table width="88%" border="0" align="center">
<tr>
<td><div align="right">
</div></td>
</tr>
</table>
<div align="right" style="font-size:12px "></div></td>
</tr>
</table>
<table width="750" border="0" align="center" bgcolor="#ffffff">
<tr>
<td height="15"></td>
</tr>
<tr>
<td> <table width="88%" border="0" align="center">
<tr>
<td colspan="2"><table width="100%" border="0" cellspacing="1">
<tr>
<th bgcolor="#7188e0" class="style3"><%=user_name%>的个人信息</th>
</tr>
</table></td>
</tr>
<tr>
<td width="27%" valign="top"><table width="150" border="0" cellspacing="0">
<tr>
<td width="145" height="199"><table width="100%" border="0" align="center" cellspacing="1" bgcolor="#0000FF">
<tr>
<td height="190" bgcolor="#FFFFFF"><a href="<%=user_face%>" target="_blank"><img src="<%=user_face%>" width="140" height="191" border="0"></a></td>
</tr>
</table></td>
<td width="14" bgcolor="#aaaaaa"></td>
</tr>
<tr bgcolor="#aaaaaa">
<td height="5"></td>
<td bgcolor="#aaaaaa"></td>
</tr>
</table></td>
<td width="73%" valign="top"><table width="100%" border="0" cellspacing="3">
<tr>
<td><table width="100%" border="0" cellspacing="1" bgcolor="#f0f0f0">
<tr bgcolor="#f8f8f8">
<td width="21%" height="20"><div align="right">用户ID：</div></td>
<td width="28%" height="21"> <%=user_id%></td>
<td width="19%" height="21"><div align="right">昵 称：</div></td>
<td width="32%" height="21"> <%=user_name%></td>
</tr>
<tr bgcolor="#f8f8f8">
<td height="20"><div align="right">性 别：</div></td>
<td height="21"> <%=sex%></td>
<td height="21"><div align="right">生 日：</div></td>
<td height="21"> <%=user_birth%></td>
</tr>
<tr bgcolor="#f8f8f8">
<td height="20"><div align="right">所在地：</div></td>
<td height="21"> <%=user_comefrom%></td>
<td height="21"><div align="right">职 业：</div></td>
<td height="21"> <%=user_job%></td>
</tr>
<tr bgcolor="#f8f8f8">
<td height="20"><div align="right">电 话：</div></td>
<td height="21"> <%=user_tel%></td>
<td height="21"><div align="right">E-mail：</div></td>
<td height="21"> <%=user_mail%></td>
</tr>
<tr bgcolor="#f8f8f8">
<td height="20"><div align="right">爱 好：</div></td>
<td height="21"> <%=user_love%></td>
<td height="21"><div align="right">Q Q ：</div></td>
<td height="21"> <%=user_qq%></td>
</tr>
<tr bgcolor="#f8f8f8">
<td height="20"><div align="right">社区职务：</div></td>
<td height="21"> <%=duty%></td>
<td height="21"><div align="right">权限值：</div></td>
<td height="21"> <%=user_root%></td>
</tr>
<tr bgcolor="#f8f8f8">
<td height="20"><div align="right">注册日期：</div></td>
<td height="21" colspan="3"> <%=tim%><div align="right"></div></td>
</tr>
<tr bgcolor="#f8f8f8">
<td height="20"><div align="right">上次登录：</div></td>
<td height="21" colspan="3"> <%=user_lastime%></td>
</tr>
<tr bgcolor="#f8f8f8">
<td height="20"><div align="right">个人网站：</div></td>
<td height="21" colspan="3"> <%=user_web%></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<% if(step>3){
%>
<tr>
<td height="8"></td>
</tr>
<tr>
<td><table width="88%" border="0" align="center" cellspacing="1" bgcolor="#7188e0">
<tr bgcolor="#f8f8f8">
<td><div align="center"><a href="admin/rootlist.jsp?id=<%=user_id%>">会员管理</a></div></td>
<td><div align="center"><a href="admin/changeroot.php?id=<%=user_id%>">改变权限</a></div></td>
<td><div align="center">详细资料</div></td>
<td><div align="center">发送密码</div></td>
<td><div align="center">
<% if(step>4){%>删除该会员<% }%></div></td>
</tr>
</table></td>
</tr>
<%
}%>
<tr>
<td height="8"></td>
</tr>
<tr>
<td><table width="88%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#7188e0">
<tr bgcolor="#f8f8f8">
<td colspan="4"><table width="100%" border="0" cellpadding="0" cellspacing="1">
<tr>
<th bgcolor="#7188e0" class="style3">社 区 业 绩</th>
</tr>
</table></td>
</tr>
<tr bgcolor="#f8f8f8">
<td width="19%"><div align="right">发表文章：</div></td>
<td width="33%"> <%=user_txt%></td>
<td width="11%"><div align="right">恢复：</div></td>
<td width="37%"> <%=user_retxt%></td>
</tr>
<tr bgcolor="#f8f8f8">
<td><div align="right">精华文章：</div></td>
<td> <%=user_sup%></td>
<td><div align="right">推荐文章</div></td>
<td> <%=user_recom%></td>
</tr>
<tr bgcolor="#f8f8f8">
<td><div align="right">上线次数：</div></td>
<td> <%=user_ontims%></td>
<td><div align="right">得分：</div></td>
<td> <%=user_point%></td>
</tr>
<tr bgcolor="#f8f8f8">
<td height="15" colspan="4"></td>
</tr>
</table></td>
</tr>
<tr>
<td height="8"></td>
</tr>
<tr>
<td><table width="88%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#7188e0">
<tr bgcolor="#f8f8f8">
<th width="100%"><table width="100%" border="0" cellpadding="0" cellspacing="1">
<tr>
<th bgcolor="#7188e0" class="style3"> 个 人 说 明</th>
</tr>
</table></th>
</tr>
<tr bgcolor="#f8f8f8">
<td height="15">
<table width="98%" border="0" align="center">
<tr>
<td height="10"></td>
</tr>
<tr>
<td><%=aboutself%></td>
</tr>
<tr>
<td height="10"></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td height="15"></td>
</tr>
</table>
<table width="750" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td> </td>
</tr>
<tr>
<td height="20" bgcolor="#f0f0f0"><table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="18" bgcolor="#f0f0f0" style="font-size: 11px; font-family: Tahoma, Arial;color:#686868"><div align="center"></div></td>
</tr>
</table></td>
</tr>
<tr>
<td> </td>
</tr>
</table>
</body>
</html>
<%
}
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -