list_topics.java

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

package mybbs;

import java.io.*;
//import com.mysql.jdbc.Driver;
import java.sql.*;
import java.io.IOException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public class list_topics extends HttpServlet {

  PrintWriter out;
  ResultSet rs;
  int page=1;
  String forumid,inte;
    public void doPost(HttpServletRequest request,
                      HttpServletResponse response)
        throws IOException
    {
        response.setContentType("text/html;charset=gbk");
        out = response.getWriter();
        inte=request.getParameter("page");
        if(inte==null){
          page=1;
        }
        else{
          page=Integer.parseInt(inte);
        }
        String fid=request.getParameter("forumsid");
        int forumid=Integer.parseInt(fid);
        int pagesize=params.Topic_Page_Size;
        try{

       ForumInfo fi=new ForumInfo();
       fi.setForumid(forumid);
       String forumname = fi.getForumname();

          /*-------------------------------------------------------------*/
       out.print("<TABLE width='98%' align=center cellPadding=1 cellSpacing=0 background='images/head.gif'");
       out.print("style=BORDER-RIGHT: #5aa8da 1px solid; BORDER-TOP: #5aa8da 1px solid; BORDER-LEFT: #5aa8da 1px solid>");
       out.print(" <TBODY> <TR><TD width='69%' align=left background='images/8.gif' class=head>");
       out.print("<B><A href=default.jsp>本站论坛</A><FONT color=red>≡></FONT>"+forumname);

       out.print("<FONT color=red>≡></FONT></B></TD>");
       out.print("<TD width='31%' align=right background='images/header-01.jpg' class=head>");
       out.print(" </TD></TR><TR background='images/head.gif'><TD height=23 colSpan=2 align=right class=cbg>");
       out.print(" [<A href='#'>使用道具</A>]</TD></TR></TBODY></TABLE>");
      out.print("<TABLE class=i_table style=TABLE-LAYOUT: fixed; WORD-WRAP: break-word");
      out.print("cellSpacing=1 cellPadding=0 width='98%' align=center>");
        out.print("<TBODY> <TR>");
         out.print(" <TD style=PADDING-RIGHT: 5px; PADDING-LEFT: 5px; PADDING-BOTTOM: 5px; PADDING-TOP: 5px ");
         out.print("vAlign=top width='63%' bgColor=#ffffff height='100%'>&nbsp;</TD>");
         out.print("<TD vAlign=top width='37%' bgColor=#ffffff height='100%'><div align='center'>");
         out.print("<A href='post.do?action=1&forumsid="+forumid+"'><IMG src='images/post.gif'></A>");
         out.print("&nbsp;<A href='post.do?action=3&forumsid="+forumid+"'><IMG src='images/votting.gif'></A> ");

        out.print("</div></TD></TR></TBODY></TABLE><TABLE width='99%' align=center><TBODY>");
        out.print("<TR><TD height=1></TD></TR></TBODY></TABLE>");

       /*-------------------------------------------------------------*/
           ShowTopic ST=new ShowTopic();
           //显示公告
           out.print(ST.ListPublicPost());
        /*---------------------------------------------------*/
          out.print(ST.DisplayTopic(forumid,page));
 /*-----------------------------------------------*/
         int pagecount=ST.getPageCount();
         out.print("<BR></TBODY></TABLE>");
         out.print("&nbsp;&nbsp;&nbsp;&nbsp;[共"+pagecount+"页]>>>");
         for(int j=1;j<=pagecount;j++)
          {
           if(j==page){
           out.print("[");}
           out.print("<A href=list-topic.do?forumsid="+forumid+"&page="+j+">");
           out.print(""+j);
           out.print("</A>");
           if(j==page){
             out.print("]");
           }
           out.print("&nbsp; ");
          }
  /*-----------------------------------------------*/


       }catch(Exception e){
       request.setAttribute("throw",e.toString());
        response.sendRedirect("global.do");
         }

    }

 public void doGet(HttpServletRequest request,
                      HttpServletResponse response)
        throws IOException
    {
        doPost(request, response);
    }
}