guestbook.java

BBS-CS是采用JSP+JavaBean+Servlet开发的一套网络虚拟社区系统. 运行平台： Liunx + JDK + Apache + Tomcat + MYSQL 或 Window

package com.laoer.bbscs.bbs;

import java.sql.*;
import java.io.*;
import java.util.*;
import com.laoer.bbscs.db.*;
import com.laoer.bbscs.txthtml.*;
import com.laoer.bbscs.admin.BBSConf;

/**
 * <p>Title: BBS-CS</p>
 * <p>Description: BBS-CS(BBS式虚拟社区系统)</p>
 * <p>Copyright: Copyright (c) 2002</p>
 * <p>Company: loveroom.com.cn</p>
 * @author 龚天乙（laoer）
 * @version 3.0
 */

public class GuestBook {

  String SQL = "";
  DbTrans DBSQL;
  DoText myDoText;
  ResultSet rs = null;
  public GuestBook() {
      this.DBSQL = new DbTrans();
      this.myDoText = new DoText();
  }

  public String getGuestBookList(String strUserID, String pages, String fileName, int intPageSize) {
      int GB_num = 0;
      String strGuestBookList = "";
      PageBreak myPageBreak = new PageBreak();
      BBSConf myBBSConf = new BBSConf();

      SQL = "select count(*) as GB_num from guestbook where UID="+ strUserID;
      try {
          rs = DBSQL.executeQuery(SQL);
          if (rs.next()) {
              GB_num = rs.getInt("GB_num");
          }
          rs.close();
      }
      catch (SQLException e){
      }
      if (GB_num != 0) {
          strGuestBookList += "<TABLE border=0 cellPadding=5 cellSpacing=0 class=p9 width=400>\n";
          strGuestBookList += "<TBODY>\n";
          strGuestBookList += "<TR>\n";
          strGuestBookList += "<TD><CENTER>发送人</CENTER></TD>\n";
          strGuestBookList += "<TD><CENTER>接收时间</CENTER></TD>\n";
          strGuestBookList += "<TD><CENTER>状态</CENTER></TD>\n";
          strGuestBookList += "<TD><CENTER>格式</CENTER></TD>\n";
          strGuestBookList += "</TR>\n";
          String strCountSQL = "";
          String strSQL = "";
          strCountSQL = "select count(*) as total from guestbook where UID="+ strUserID;
          strSQL = "select * from guestbook where UID="+ strUserID +" order by stime desc";
          rs = myPageBreak.getPageBreak(pages,strCountSQL,strSQL,intPageSize);
          String tablecolor = "";
          int n = 2;
          int i = 1;
          int mtype = 0;
          try {
              while (rs.next()) {
                  if ((i %= n)==1) {
                      tablecolor = myBBSConf.gettabletintcolor();
                  }
                  else {
                      tablecolor = myBBSConf.gettabledarkcolor();
                  }
                  strGuestBookList += "<TR>\n";
                  strGuestBookList += "<TD align=middle><A href='userinfo.jsp?UID="+rs.getInt("FID")+"'>"+myDoText.iso2gb(rs.getString("Fname"))+"</A></TD>\n";
                  strGuestBookList += "<TD align=middle>"+rs.getString("stime")+"</TD>\n";
                  strGuestBookList += "<TD align=middle>";
                  if (rs.getInt("yd")==1) {
                      strGuestBookList += "已读";
                  }
                  else {
                      strGuestBookList += "<font color=#ff0000>未读</font>";
                  }
                  strGuestBookList += "</TD>\n";
                  strGuestBookList += "<TD align=middle><A href='note.jsp?action=read&GID="+rs.getInt("ID")+"'>";
                  mtype = rs.getInt("mtype");
	          switch(mtype) {
                      case 0:
	              strGuestBookList += "普通";
	              break;
	              case 1:
	              strGuestBookList += "链接";
	              break;
	              case 2:
                      strGuestBookList += "图片";
	              break;
	              case 3:
	              strGuestBookList += "文件";
                      break;
	              default:
                      strGuestBookList += "普通";
	              break;
                  }
	          strGuestBookList += "</A></TD>\n";
                  strGuestBookList += "</TR>\n";
                  i++;
                  myBBSConf.close();
              }
          }
          catch (SQLException e){
          }
          strGuestBookList += "<tr><td colspan=4>"+ myPageBreak.listPageBreak(fileName) +" <A href='note.jsp?action=delall'>全部删除</A></td></tr>\n";
          strGuestBookList += "</TR>\n</TBODY>\n</TABLE>\n";
          myPageBreak.close();
          return strGuestBookList;
      }
      else {
          return strGuestBookList;
      }
  }

  public boolean addNote(String strUserID, String strUserName, String UID, String Fname, String mtype ,String note) {
      SQL = "insert into  guestbook set UID='"+ UID +"',Uname=\""+ Fname +"\",FID='"+ strUserID +"',Fname=\""+ strUserName +"\",mtype='"+ mtype +"',note=\""+ note +"\",stime=now()";
      try {
          DBSQL.executeUpdate(SQL);
          return true;
      }
      catch (SQLException e){
          return false;
      }
  }

  public String readNote(String strUserID, String GID) {
     String strReadNote = "";
     BBSConf myBBSConf = new BBSConf();
     String tabledarkcolor = myBBSConf.getConfTableDarkColor();
     String tablemaincolor = myBBSConf.getConfTableMainColor();
     SQL = "select * from guestbook where UID="+ strUserID +" and ID="+ GID;
     try {
         rs = DBSQL.executeQuery(SQL);
         if (rs.next()) {
             strReadNote += "<TABLE bgColor="+tablemaincolor+" border=0 cellPadding=3 cellSpacing=0 width=400>\n";
             strReadNote += "<TBODY>\n<TR align=middle>\n";
             strReadNote += "<TD class=p9><FONT color=#ffffff>留言便签</FONT></TD></TR></TBODY></TABLE>\n";
             strReadNote += "<TABLE border=0 cellPadding=2 cellSpacing=0 class=p9 width=400>\n";
             strReadNote += "<TBODY>\n<TR bgColor="+ tabledarkcolor +">";
             strReadNote += "<TD align=right>信息来自：</TD>\n";
             strReadNote += "<TD align=left><a href='userinfo.jsp?UID="+ rs.getInt("FID") +"'>"+ myDoText.iso2gb(rs.getString("Fname")) +"</a></TD>\n";
             strReadNote += "<TD>接收时间</TD>\n";
             strReadNote += "<TD>"+ rs.getString("stime") +"</TD></TR>\n";
             strReadNote += "<TR bgColor="+ tabledarkcolor +">\n";
             strReadNote += "<TD align=right vAlign=top>留言：</TD>\n";
             strReadNote += "<TD colSpan=3>"+ myDoText.iso2gb(rs.getString("note")) +"</TD>\n";
             strReadNote += "</TR></TBODY></TABLE>\n";
             strReadNote += "<TABLE border=0 cellPadding=0 cellSpacing=0 class=p9 width=400>\n";
             strReadNote += "<TBODY>\n";
             strReadNote += "<TR align=middle bgColor="+tablemaincolor+">\n";
             strReadNote += "<TD height=30><A href='javascript:history.go(-1)'><font color=#FFFFFF>返回</font></A> <A href='note.jsp?action=del&GID="+ GID +"'><font color=#FFFFFF>删除</font></A> <A href='guestbook.jsp?Fname="+ myDoText.iso2gb(rs.getString("Fname")) +"'><font color=#FFFFFF>回复</font></A>";
             strReadNote += "</TD></TR></TBODY></TABLE>\n";
             myBBSConf.close();
         }
         rs.close();
     }
     catch (SQLException e){
     }
     SQL = "update guestbook set yd=1 where UID="+ strUserID +" and ID="+ GID;
     try {
         DBSQL.executeUpdate(SQL);
     }
     catch (SQLException e){
     }
     return strReadNote;
  }

  public boolean delOneNote(String strUserID, String GID) {
      SQL = "delete from guestbook where UID="+ strUserID +" and ID="+ GID;
      try {
          DBSQL.executeUpdate(SQL);
          return true;
      }
      catch (SQLException e){
          return false;
      }
  }

  public boolean delAllNote(String strUserID) {
      SQL = "delete from guestbook where UID="+ strUserID;
      try {
          DBSQL.executeUpdate(SQL);
          return true;
      }
      catch (SQLException e){
          return false;
      }
  }

  public void close() {
      try {
          DBSQL.close();
      }
      catch (SQLException e) {
      }
  }

}