elitedh.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.*;

/**
 * <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 EliteDH {

  String SQL = "";
  DbTrans DBSQL;
  DoText myDoText;
  ResultSet rs = null;

  public EliteDH(DbTrans DBSQL) {
      this.DBSQL = DBSQL;
      this.myDoText = new DoText();
  }

  public String getDH(String pid,String bid,String fileName) {
      String strDH = "";
      if (getNumDH(pid)!=0) {
          SQL = "select * from elite where ID ="+pid;
          try {
              rs = DBSQL.executeQuery(SQL);
              if (rs.next()) {
                  strDH = " >> <a href='"+fileName+"?bid="+bid+"&pid="+pid+"'>"+myDoText.iso2gb(rs.getString("elitename"))+"</a>"+strDH;
                  EliteDH myEliteDH = new EliteDH(this.DBSQL);
                  strDH = myEliteDH.getDH(rs.getString("PID"),bid,fileName) + strDH;
              }
              rs.close();
          }
          catch (SQLException e) {
          }
      }
      else {
          return strDH;
      }
      return strDH;
  }

  public int getNumDH(String pid) {
      int numDH = 0;
      SQL = "select count(*) as numDH from elite where ID = "+pid;
      try {
          rs = DBSQL.executeQuery(SQL);
          if (rs.next()) {
              numDH = rs.getInt("numDH");
          }
          rs.close();
      }
      catch (SQLException e) {
      }
      return numDH;
  }

}