showtopic.java

JSP论坛系统 数据库：mysql数据库； 技术平台：Tomcat 5.0服务器； 开发工具：Eclipse＋Lomboz、EditPlus开发工具； 操作系统：Windows XP Prof

package mybbs;
import java.sql.*;
import java.util.*;

public class ShowTopic {
private ResultSet rs=null;
private int pagecount=0;
DBConn conn=new DBConn();
public ShowTopic(){

}
public StringBuffer ListPublicPost() throws Exception {
    StringBuffer buffer=new StringBuffer();
    String sqln="SELECT * FROM posts WHERE isdel=0 AND groupid=2 AND"+
        " istopic>0 ORDER BY (posts.istop+1)*posts.last_time DESC";

   rs=conn.query(sqln);


/*--------------------------------------------------------------*/

     buffer.append(" <TABLE class=i_table id=ajaxtable ");
     buffer.append("cellSpacing=1 cellPadding=4 width='98%' align=center>");
     buffer.append("<TBODY><TR class=head align=middle><TD width='5%'>状态</TD>");
     buffer.append("<TD align=middle width='55%'>文章</TD>");
     buffer.append("<TD width='15%'>作者</TD><TD width='5%'>回复</TD><TD width='5%'>人气</TD>");
     buffer.append("<TD width='15%'>最后发表</TD></TR><TR class=cbg><TD colSpan=3>&nbsp;<B>专题：</B> ");
     buffer.append("<A href='http://bbs'>所有主题</A> ");
     buffer.append("<A href='http://bbs'>精华主题</A>");
     buffer.append("</TD> <TD vAlign=center align=right colSpan=3></TD></TR>");
 //buffer.append(sqln);
 while(rs.next()){
     buffer.append("<TR class=t_two align=middle><TD><A title=打开新窗口 href='http://bbs'");
     buffer.append(" target=_blank><IMG src='images/topichot.gif' border=0></A></TD>");
     buffer.append("<TD class=t_one id= onmouseover=this.className='t_two' ");
     buffer.append("style=PADDING-LEFT: 8px onmouseout=this.className='t_one' align=left>");
     buffer.append("<IMG alt=置顶帖标志 src='images/headtopic_3.gif'>");
     buffer.append("<A href='disbbs.do?forumsid="+rs.getString("forumid"));
     buffer.append("&topicid="+rs.getString("topic_id")+"'>"+rs.getString("title")+"</A>");
     buffer.append("<IMG alt=精华帖标志 src='images/digest_1.gif'>[");
     buffer.append("<IMG src='images/multipage.gif' border=0>1,2]<DIV></DIV></TD>");
     buffer.append("<TD class=smalltxt>"+rs.getString("author")+"");
     buffer.append("<BR>"+rs.getString("post_time").substring(0,16));
     buffer.append("</TD><TD class=t_one>"+rs.getString("reply_times")+"</TD>");
     buffer.append("<TD class=t_one>"+rs.getString("click_times")+"</TD><TD class=smalltxt>&nbsp;");
     buffer.append(""+rs.getString("last_time").substring(0,16)+"");
     buffer.append("<BR>By:<FONT color=blue><A href='user_info.do?userid="+rs.getString("author_id")+"'>");
     buffer.append(rs.getString("last_postor")+"</A></FONT></TD></TR>");
  }
 buffer.append("<TR class=cbg><TD colSpan=6>&nbsp; <B>普通主题</B></TD></TR>");
  rs.close();
  return buffer;
}
public StringBuffer DisplayTopic(int forumid,int page)throws Exception{
  StringBuffer buffer2=new StringBuffer();
  String sql="SELECT * FROM posts WHERE isdel=0 AND groupid!=2 AND istopic>=1"+" AND forumid="+
      forumid+" ORDER BY (posts.istop+1)*posts.last_time DESC";
  try{
    rs = conn.query(sql);
    rs.last();
    int lastrow = rs.getRow();
    int pagesize = params.Post_Page_Size;
    //计算分页后的总页数
    pagecount = (lastrow % pagesize == 0) ? (lastrow / pagesize) :
        (lastrow / pagesize + 1);
    //当前的社始页数

    if (page >= pagecount) {
      page = pagecount;
    }
    int posion = (page - 1) * pagesize;
    if (posion == 0) {
      posion = 1;
    }
    rs.absolute(posion);
    for (int i = 1; i <= pagesize; i++) {
      buffer2.append("<TR class=t_two align=middle>");
      if (rs.getInt("istopic") == 2) {
        buffer2.append(
            " <TD><A title=投票 ><IMG src='images/vote.gif' border=0></A></TD>");
      }

      if (rs.getInt("groupid") == 1&&rs.getInt("istopic") != 2) {
        buffer2.append(
            " <TD><A title=精华 ><IMG src=images/isbest.gif border=0></A></TD>");
      }
      if ( (rs.getInt("groupid") != 1) && (rs.getInt("istopic") != 2)) {
        buffer2.append(
            " <TD><A title=普通贴子 ><IMG src=images/topicnew.gif border=0></A></TD>");
      }

      buffer2.append("<TD align=left>");
      if (rs.getInt("islock") == 1) {
        buffer2.append("<A title=不能回复 >");
        buffer2.append("<IMG src=images/locked.gif border=0></A>");
         }
      if (rs.getInt("istop") > 0)
        buffer2.append("<IMG src=images/uping.gif >");
      buffer2.append("<A href='disbbs.do?forumsid=" + forumid +
                     "&topicid=" + rs.getString("topic_id") + "'>");
        buffer2.append(rs.getString("title") + "</A></TD>");

      buffer2.append("<TD class=smalltxt><A href='user_info.do?userid=" +
                     rs.getString("author_id") + "' >" +rs.getString("author") + "</A>");
      buffer2.append("<BR>" + rs.getString("post_time").substring(0, 16) +
                     "</TD>");
      buffer2.append(" <TD class=t_one>" + rs.getString("reply_times") +
                     "</TD>");
      buffer2.append("<TD class=t_one>" + rs.getString("click_times") +
                     "</TD>");
      buffer2.append("<TD class=smalltxt>&nbsp; " +
                     rs.getString("last_time").substring(0, 16) + "");
      buffer2.append("<BR>By:<FONT color=blue><A href='user_info.do?userid=" +
                     rs.getString("author_id") + "'>" +
                     rs.getString("last_postor") + "</A></FONT></TD></TR>");
      if (!rs.next())
        break;

    }
    rs.close();
  }
  catch(Exception e){
    buffer2.append("暂时没有贴子！或操作出错。");
  }
  return buffer2;
}
public int getPageCount(){
  return pagecount;
}
}