?? member.jsp
字號:
<%@page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="err.jsp" %>
<%
if (session.getValue("UserName")==null)
{
response.sendRedirect("err.jsp?id=5");
return;
}
%>
<html>
<head>
<link rel='stylesheet' type='text/css' href='inc/FORUM.CSS'>
<META NAME="keywords" CONTENT="溢洋 溢洋論壇 xyworker@163.com java forum jsp forum">
<META NAME="description" CONTENT="溢洋 溢洋論壇 xyworker@163.com java forum jsp forum">
<script language="JavaScript">
function Popup(url, window_name, window_width, window_height)
{ settings=
"toolbar=no,location=no,directories=no,"+
"status=no,menubar=no,scrollbars=yes,"+
"resizable=yes,width="+window_width+",height="+window_height;
NewWindow=window.open(url,window_name,settings); }
function icon(theicon) {
document.input.message.value += " "+theicon;
document.input.message.focus();
}
</script>
<title>溢洋論壇</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body text="#0000ff" >
<jsp:include page="inc/public.jsp" flush="true"/>
<table width="99%" cellspacing="0" cellpadding="0" align="center" height="22">
<tr>
<td width="62%" height="22"> <a href="../default1.asp">首頁</a>>><a href="index.jsp">溢洋論壇</a>>>查看用戶資料
</td>
<td class="post" align="right" width="38%" height="22"> </td>
</tr></table>
<table cellspacing="0" cellpadding="0" border="0" width="99%" align="center">
<tr><td bgcolor="#009ACE">
<table border="0" cellspacing="1" cellpadding="6" width="100%">
<tr bgcolor="#9CCFFF">
<td colspan="2">
<p align="center">查看用戶資料</p>
</td>
</tr>
<jsp:useBean id="yy" scope="page" class="yy.jdbc"/>
<%! String sql,Online_State,User_Name;%>
<%
User_Name=request.getParameter("member");
Connection con=yy.getConn();
Statement stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs=null;
sql="select * from 在線 where 在線用戶名='"+User_Name+"'";
rs=stmt.executeQuery(sql);
rs.last();
if(rs.getRow()>0)
Online_State="在線";
else
Online_State="離線";
sql="Select * from 用戶表 Where 用戶名='"+User_Name+"'";
rs=stmt.executeQuery(sql);
rs.last();
if (rs.getRow()>0)
{
String User_Level=rs.getString("用戶等級");
String User_Email=rs.getString("用戶郵箱");
%>
<tr bgcolor="#F7FBFF">
<td width="42%">用戶名稱</td>
<td bgcolor="#F7FBFF" width="58%"><%=User_Name%> </td>
</tr>
<tr bgcolor="#F7FBFF">
<td width="42%">用戶圖像</td>
<td width="58%"><img src="<%=rs.getString("用戶圖像")%>" width="32" height="32">
</td>
</tr>
<tr bgcolor="#F7FBFF">
<td width="42%">姓別</td>
<td width="58%"><%=rs.getString("用戶性別")%> </td>
</tr>
<tr bgcolor="#F7FBFF">
<td width="42%">出生日期</td>
<td width="58%"><%=rs.getString("出生日期")%> </td>
</tr>
<tr bgcolor="#F7FBFF">
<td width="42%">居住地址</td>
<td width="58%"><%=rs.getString("居住地址")%> </td>
</tr>
<tr bgcolor="#F7FBFF">
<td width="42%">注冊日期</td>
<td width="58%"><%=rs.getString("注冊日期").substring(0,10)%> </td>
</tr>
<tr bgcolor="#F7FBFF">
<td width="42%">訪問次數 </td>
<td width="58%"><%=rs.getString("訪問次數")%> </td>
</tr>
<tr bgcolor="#F7FBFF">
<td width="42%">貼子數量 </td>
<td width="58%"><%=rs.getString("發貼次數")%> </td>
</tr>
<tr bgcolor="#F7FBFF">
<td width="42%">用戶等級</td>
<td width="58%">
<%
out.println(User_Level);
if (User_Level.equals("新手上路"))
out.println(" <IMG SRC=IMAGES/STAR.GIF>");
else if (User_Level.equals("初級會員"))
out.println(" <IMG SRC=IMAGES/STAR.GIF><IMG SRC=IMAGES/STAR.GIF>");
else if (User_Level.equals("中級會員"))
out.println(" <IMG SRC=IMAGES/STAR.GIF><IMG SRC=IMAGES/STAR.GIF><IMG SRC=IMAGES/STAR.GIF>");
else if (User_Level.equals("高級會員"))
out.println(" <IMG SRC=IMAGES/STAR.GIF><IMG SRC=IMAGES/STAR.GIF><IMG SRC=IMAGES/STAR.GIF><IMG SRC=IMAGES/STAR.GIF>");
else if (User_Level.equals("資深會員"))
out.println(" <IMG SRC=IMAGES/STAR.GIF><IMG SRC=IMAGES/STAR.GIF><IMG SRC=IMAGES/STAR.GIF><IMG SRC=IMAGES/STAR.GIF>");
else if (User_Level.equals("版主"))
out.println(" <IMG SRC=IMAGES/STAR.GIF><IMG SRC=IMAGES/STAR.GIF><IMG SRC=IMAGES/STAR.GIF><IMG SRC=IMAGES/STAR.GIF><IMG SRC=IMAGES/STAR.GIF><IMG SRC=IMAGES/STAR.GIF>");
%>
</td>
</tr>
<tr bgcolor="#F7FBFF">
<td width="42%">在線情況</td>
<td width="58%">
<%=Online_State%>
</td>
</tr>
<tr bgcolor="#F7FBFF">
<td width="42%">用戶郵箱</td>
<td width="58%"><a href="mailto:<%=User_Email%>"><%=User_Email%></a></td>
</tr>
<tr bgcolor="#F7FBFF">
<td width="42%">OICQ</td>
<td width="58%"><%=rs.getString("oicq")%></td>
</tr>
<tr bgcolor="#F7FBFF">
<td width="42%">>> <a href="article.jsp?member=<%=User_Name%>">搜索這個用戶的所有貼子</a></td>
<td width="58%"> </td>
</tr>
<%
}
else
{
%>
<tr bgcolor="#F7FBFF">
<td width="42%">>> 對不起，此用戶不存在</td>
<td width="58%"> </td>
</tr>
<%
}
%>
</table>
</td></tr></table>
<jsp:include page="inc/jumpboard.jsp" flush="true"/>
</body></html>
<html><script language="JavaScript"></script></html>
<jsp:include page="inc/online.jsp" flush="true"/>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -