?? member.jsp
字號(hào):
<%@ page import="java.sql.*,java.util.*"%>
<%@ page contentType="text/html;charset=gb2312"%>
<jsp:useBean id="yy" scope="page" class="yy.jdbc"/>
<html>
<head>
<link rel='stylesheet' type='text/css' href='imbed/forum.css'>
</head>
<body >
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<%
String User_Name="";
String User_Password="";
String User_Email="";
String User_Icon="";
String User_Question="";
String User_Answer="";
String User_rank="";
String Isonline="";
String Numofpublish="";
String Numofvisit="";
Connection con=yy.getConn();
Statement stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs=null;
User_Name=yy.ex_chinese(request.getParameter("member"));
String sql="select * from User where user_name='"+User_Name+"'";
rs=stmt.executeQuery(sql);
rs.last();
if (rs.getRow()>0)
{
//User_Password=rs.getString("user_password");
User_Email=rs.getString("email");
User_Icon=rs.getString("user_pic");
User_Question=rs.getString("question");
User_Answer=rs.getString("answer");
User_rank=rs.getString("user_rank");
if(User_rank.equals("1"))
User_rank="會(huì)員";
else if(User_rank.equals("2"))
User_rank="版主";
else if(User_rank.equals("3"))
User_rank="管理員";
Isonline=rs.getString("isonline");
if(Isonline.equals("0"))
Isonline="不在線";
else if(Isonline.equals("1"))
Isonline="在線";
Numofpublish=rs.getString("numofpublish");
Numofvisit=rs.getString("numofvisit");
}
%>
<tr>
<td><img src="images/qtop5.jpg" width="432" height="55"><img src="images/dot.gif" width="12" height="11">
<font size="2">收藏本站</font><strong> <img src="images/dot.gif" width="12" height="11">
</strong><font size="2"><a href="index.jsp">返回首頁</a></font></td>
</tr>
</table>
<br>
<table border="1" cellspacing="1" cellpadding="3" width="743" >
<tr bordercolor="#CCCCCC" bgcolor="#FFFFFF">
<td width="278" height="32" bgcolor="#DFDFDF" class="tablerow" >用戶名稱</td>
<td width="223" height="32" bgcolor="#F2F2F2" class="tablerow"> <%=User_Name%>
</td>
</tr>
<tr bordercolor="#CCCCCC" bgcolor="#FFFFFF">
<td width="278" height="33" bgcolor="#DFDFDF" class="tablerow">E-Mail</td>
<td width="223" height="33" bgcolor="#F2F2F2" class="tablerow"> <%=User_Email%>
</td>
</tr>
<tr bordercolor="#CCCCCC" bgcolor="#FFFFFF">
<td width="278" height="1" bgcolor="#DFDFDF" class="tablerow">頭像地址</td>
<td height="1" colspan="2" bgcolor="#F2F2F2" class="tablerow">
<img src=<%=User_Icon%>>
</td>
</tr>
<tr bordercolor="#CCCCCC" bgcolor="#FFFFFF">
<td width="278" height="33" bgcolor="#DFDFDF" class="tablerow">用戶等級(jí)</td>
<td width="223" height="33" bgcolor="#F2F2F2" class="tablerow"> <%=User_rank%>
</td>
</tr>
<tr bordercolor="#CCCCCC" bgcolor="#FFFFFF">
<td width="278" height="33" bgcolor="#DFDFDF" class="tablerow">發(fā)帖次數(shù)</td>
<td width="223" height="33" bgcolor="#F2F2F2" class="tablerow"><%=Numofpublish%>
</td>
</tr>
<tr bordercolor="#CCCCCC" bgcolor="#FFFFFF">
<td width="278" height="33" bgcolor="#DFDFDF" class="tablerow">訪問次數(shù)</td>
<td width="223" height="33" bgcolor="#F2F2F2" class="tablerow"> <%=Numofvisit%>
</td>
</tr>
<tr bordercolor="#CCCCCC" bgcolor="#FFFFFF">
<td width="278" height="33" bgcolor="#DFDFDF" class="tablerow">當(dāng)前狀態(tài)</td>
<td width="223" height="33" bgcolor="#F2F2F2" class="tablerow"> <%=Isonline%>
</td>
</tr>
</table>
</body></html>
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -