back.txt.bak

论坛元程序

<%
    String hostname,Host_Name;
    String community_name="";
    String fid=request.getParameter("fid");
     Connection con=yy.getConn();
     Statement  stmt=con.createStatement();
     ResultSet  rs=null;
     String sql="Select host_name,community_name From Community where community_id='"+fid+"' ";
    rs=stmt.executeQuery(sql);
    if(rs.next())
    {
    hostname=rs.getString("host_name");
    hostname=yy.ex_chinese(hostname);
    community_name=yy.ex_chinese(rs.getString("community_name"));
    Host_Name="<a href=member.jsp?member="+hostname+">"+hostname+"</a>";
    if (session.getValue("UserName")==null)
		{ %>
		有问题请于版主:<a href=member.jsp?member="+Forum_Mastor+"><%=Host_Name%> 联系
		<% }	
		else
		 { out.println(session.getValue("UserName")+" 欢迎您");}%>
		  &nbsp;&nbsp;&nbsp;&nbsp;有问题请于版主:<%=Host_Name%> 联系
		  <%}%>
<tr> 
    <td width="40%"><img src="images/qleft7.jpg" width="410" height="154"></td>
    <td width="25%"><img src="images/qleft8.jpg" width="256" height="154"></td>
    <td width="35%"><img src="images/qleft9.gif" width="358" height="154"></td>
  </tr>
  <tr> 
    <td colspan="3">&nbsp;</td>
  </tr>
  <tr> 
    <td height="53" colspan="3"> &nbsp;&nbsp;<a href="index.jsp">论坛首页</a> &gt; <%=community_name%></td>
  </tr>
</table>
<table width="100%" height="280" border="1" cellpadding="0" cellspacing="0">
  <tr bordercolor="#CCCCCC"> 
    <td width="35%">主题</td>
    <td width="20%">作者</td>
    <td width="10%">回复数量</td>
    <td width="10%">浏览数量</td>
    <td width="25%">最后回复</td>
  </tr>
  <%	
		String Subject_title,Publish_time,Author,Numofsee,Numofreply,Lastreplier,Lastreplytime,Subject_topic,Subject_id;
		sql="SELECT * FROM Subject where community_id='"+fid+"' order by publish_time desc";
		rs=stmt.executeQuery(sql);
		while (rs.next())
		  {
		        Subject_id=rs.getString("subject_id");
		        Subject_title=yy.ex_chinese(rs.getString("subject_title"));
                Publish_time=rs.getString("publish_time");
                Author=yy.ex_chinese(rs.getString("author"));
                Numofsee=rs.getString("numofsee");
                Numofreply=rs.getString("numofreply");
                Lastreplier=yy.ex_chinese(rs.getString("last_replier"));
                Lastreplytime=rs.getString("last_replytime");
                Subject_topic=rs.getString("subject_topic");
				if(Publish_time==null)
				   Publish_time="";
				if (Subject_topic==null)
			       Subject_topic="";
			    if (Lastreplytime==null)
			       Lastreplytime="";
			    if(Lastreplier==null)
			       Lastreplier="无";
			    else
					Lastreplier="<a href='member.jsp?member="+Lastreplier+"'>"+Lastreplier+"</a>";
			
				%>
				<tr bordercolor="#CCCCCC">
          <td align="center"  height="26" width="30%"><a href="subject_display.jsp?sid=<%=Subject_id%>"><%=Subject_title%><br>发布时间:<%=Publish_time%></a></td>
          <td height="26" width="20%" ><a href="member.jsp?member=<%=Author%>"> <%=Author%> </a></td>
          <td align="center" height="26" width="10%"><%=Numofreply%></td>
          <td align="center" height="26" width="10%"><%=Numofsee%></td>
          <td height="26" width="25%">时间：<%=Lastreplytime%><br>
            回复者：<a href="member.jsp?member=<%=Lastreplier%>"><%=Lastreplier%></a></td>
         
        </tr>

		<%

                }
          
                %>
</table>
<p align="right">[首页] [上页] [下页] [尾页] 1/34 转到第 
  <select name="select2">
  </select>
  页 </p>