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;  }}