list_forum.java

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

package mybbs;

import java.io.*;
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_forum
    extends HttpServlet {

  PrintWriter out;
  ResultSet rs, rs1;
  public void doPost(HttpServletRequest request,
                     HttpServletResponse response) throws IOException {
    response.setContentType("text/html;charset=gbk");
    out = response.getWriter();
    try {

      DBConn conn = new DBConn();
      String sql = "SELECT * FROM forums WHERE isparent=1";

      rs = conn.query(sql);
      //int i=1;
      // out.print(sql);
      while (rs.next()) {
        /*-------------------------------------------------------------*/

        out.print("<TABLE class=i_table cellSpacing=1 cellPadding=5 width='98%' align=center><TBODY>");
        out.print("<TR><TD class=head align=left colSpan=6 background='images/head.gif'>");
        out.print("<B><A class=cfont href='http://bbs'>");
        out.print("≡" + rs.getString("forum_name") +"</A></B>&nbsp; </TD></TR>");
        out.print("<TR class=cbg align=middle height=23>");
        out.print("<TD width='4%'></TD><TD colspan='4'>论坛分类主题</TD>");
        out.print("<TD width='35%'>最后发表</TD></TR>");
        /*-----------------------------------------*/
        String sql2="SELECT * FROM forums WHERE isparent=0 AND sortid="+rs.getString("sortid");
        rs1 = conn.query(sql2);
        while (rs1.next()){
          out.print("<TR> <TD rowspan='3' align=middle vAlign=center class=f_two>");
          out.print("<A href='http://bbs' target=_blank><IMG src='images/old.gif'></A></TD>");
          out.print("<TD width='6%' rowspan='2' align=left ");
          out.print("class=f_one onmouseover=this.className='f_two' onmouseout=this.className='f_one' >");
          out.print("<IMG src='" + rs1.getString("pic_logo") + "' /></TD>");
          out.print("<TD width='45%' align=left class=f_one onmouseover=this.className='f_two'");
          out.print(" onmouseout=this.className='f_one'>");
          out.print("『<A class=fnamecolor href='list-topic.do?forumsid=" +
                    rs1.getString("id") + "'><B>" + rs1.getString("forum_name") +
                    "</B></A> 』<BR></TD>");
          out.print("<TD align=right class=f_one onmouseover=this.className='f_two' ");
          out.print("onmouseout=this.className='f_one'>");
          out.print("<p align='right'>发表新贴<A href='post.do?action=1&forumsid=" +
                    rs1.getString("id") +
                    "'><IMG alt=发表新贴 src='images/icon_12.gif' /></A></P></TD>");
          out.print("<TD width='1' rowspan='3' align=middle></TD>");
          ForumInfo FI = new ForumInfo();
          out.print(FI.getLastTopic(rs1.getInt("id")));
          out.print("</TR><TR><TD colspan='2' align=left class=f_one ");
          out.print("onmouseover=this.className='f_two' onmouseout=this.className='f_one' >");
          out.print("<SPAN class=smalltxt>" + rs1.getString("description") +
                    "</SPAN></TD></TR>");
          out.print("<TR><TD colspan='3' align=left class=f_one ");
          out.print(" onmouseover=this.className='f_two' onmouseout=this.className='f_one'>");
          out.print("版主:" + rs1.getString("admin_author") + "</TD>");
          out.print("<TD bgColor=#ffffff class=smalltxt>主题:" +
                    rs1.getString("total_topic"));
          out.print("文章：" + rs1.getString("total_post") + "</TD></TR> ");

        }
        rs1.close();

        /*------------- ---------------*/
        out.print("</TBODY></TABLE><TABLE><TBODY><TR>");
        out.print("<TD height=5 width='98%'></TD><TR></TBODY></TABLE>");
        /*-----------------------------------------------*/
      }
      rs.close();
      conn.DBclose();
    }
    catch (Exception e) {
      request.setAttribute("throw", e.toString());
      response.sendRedirect("global.do");
    }

  }

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