bbsadmin.java

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

package mybbs;
import java.sql.*;
public class BBSadmin {
  public BBSadmin(){
  }
  public StringBuffer getBbs(){
    StringBuffer buffer=new StringBuffer();
    DBConn conn =new DBConn();
    try{
      String sql="SELECT * FROM forums WHERE isparent=1";
      ResultSet rs=conn.query(sql);
      while(rs.next()){
        buffer.append("<TR bgcolor='#ADD0EC'><TD width=10%></TD><TD align=left>");
        buffer.append("<FONT color=blue>"+rs.getString("forum_name")+"</FONT>&nbsp;&nbsp;");
        buffer.append("<a href='AddForum.do?action=5&forumid="+rs.getInt("sortid")+"'>");
        buffer.append("<img src='images/del.gif'></a></TD></TR>");
        buffer.append("<TR><TD width=10%></TD><TD align=left>");
        buffer.append(getForum(rs.getInt("sortid")));
        buffer.append("<FORM action='AddForum.do' method='post'>");
        buffer.append("向分类中添加分论坛：<BR>");
        buffer.append("论坛名：<INPUT size=12 type=text name='forumname' value=''>");
        buffer.append("<INPUT type=hidden name='action' value='2'>");
        buffer.append("<INPUT type=hidden name='forumid' value='"+rs.getInt("sortid")+"'>");
        buffer.append("<INPUT type='submit' value='提交'><BR>");
        buffer.append("<FONT color=red>================================</FONT>");
        buffer.append("</FORM></TD></TR>");
      }

    }
    catch(Exception e){

    }
    return buffer;
  }
  public StringBuffer getForum(int id){
  StringBuffer buffer=new StringBuffer();
  DBConn conn =new DBConn();
  try{
    String sql="SELECT * FROM forums WHERE isparent=0 AND sortid="+id;
    ResultSet rs=conn.query(sql);
    while(rs.next()){
      buffer.append("<LI><a href='forumdetail.do?forumid="+rs.getInt("id")+"'>");
      buffer.append(rs.getString("forum_name")+"</a>&nbsp;&nbsp;&nbsp;&nbsp;");
      buffer.append("<a href='AddForum.do?action=4&forumid="+rs.getInt("id")+"'>");
      buffer.append("<img src='images/del.gif'></a><BR>");
    }
  }
  catch(Exception e){
      buffer.append("目前无分论坛");
  }
  return buffer;
}
public StringBuffer getForumdetail(String id){
StringBuffer buffer=new StringBuffer();
DBConn conn =new DBConn();
try{
  String sql="SELECT * FROM forums WHERE isparent=0 AND id="+id;
  ResultSet rs=conn.query(sql);
  if(rs.next()){
    buffer.append("论坛名称:");
    buffer.append("<INPUT type=text name='forumname' value='"+rs.getString("forum_name")+"'>");
    buffer.append("<BR>论坛描述:");
    buffer.append("<INPUT type=text name='description' value='"+rs.getString("description")+"'>");
    buffer.append("<BR>论坛图标:");
    buffer.append("<INPUT type=text name='logo' value='"+rs.getString("pic_logo")+"'>");
    buffer.append("<BR>管理名单:");
    buffer.append("<INPUT type=text name='admin' value='"+rs.getString("admin_author")+"'>");
  }
}
catch(Exception e){
    buffer.append("目前无分论坛");
}
return buffer;
}



}