⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 member.jsp

📁 论坛元程序
💻 JSP
字号:
🔍 
<%@ 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="会员";
		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> &nbsp;&nbsp;<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">用户等级</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">发帖次数</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">访问次数</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">当前状态</td>
      <td width="223" height="33" bgcolor="#F2F2F2" class="tablerow"> <%=Isonline%>  
      </td>
         </tr>
</table>               

</body></html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -