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("向分類(lèi)中添加分論壇：<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("目前無(wú)分論壇");  }  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("論壇名稱(chēng):");    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>論壇圖標(biāo):");    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("目前無(wú)分論壇");}return buffer;}}