clubclassbar.java

特色说明： 1.沿袭今晚在线论坛独有的双风格分桢形式 2.社区最多可进行3级分类

/*
 * Made in GamVan
 */
package com.gamvan.club;
import com.gamvan.club.ClubInfo;
import com.gamvan.conn.*;
import com.gamvan.tools.*;
import java.sql.*;
public class ClubClassBar {
    private String classStr = new String("");
    ConnClub bridge = new ConnClub();
    private String clubName,  clubTitle;
    public String classBar_1() throws Exception{
    String ccName;
    String sqlCommand;
    int ccOrder, ccStyle, ccHidden, ccPro, ccType, ccID, ccIDD, ccTopic, ccReply, ccList;
        Connection con = bridge.getConnection();
    try{
            Statement sta;
            sta = con.createStatement();
            ResultSet rs;
            sqlCommand = "";
            sqlCommand = "select * from GVclubClass where ccIDD=0 and ccHidden=0 order by ccOrder desc";
            PreparedStatement pps = con.prepareStatement(sqlCommand);
            rs = pps.executeQuery();
            while(rs.next()){
                ccID = rs.getInt(1);
                ccIDD = rs.getInt(2);
                ccName = rs.getString(3).trim();
                ccPro = rs.getInt(7);
                ccList = rs.getInt(19);
                classStr += "<table  width=\"99%\" border=\"0\" cellpadding=\"1\" cellspacing=\"0\">";
                classStr += "<tr><td height=\"18\" class=\"barbgOut\" onmouseover=\"this.className='barbgOver'\"  ";
                classStr += "onmouseout=\"this.className='barbgOut'\"> <img style=\"cursor:hand;\"  id=\"icon_"+ ccID +"\"  ";
                classStr += " onclick=\"loadTree("+ ccID +" ,'')\" src=\"GVimgs/tree/t1.gif\" align=\"absmiddle\" />&nbsp;";
                classStr += "<a onclick=\"loadTree("+ ccID +" ,'');prtie('"+ clubName +"＞＞" + ccName + "')\" ";
                classStr += " href=\"clubClass.jsp?ccID="+ ccID +"\" target=\"rFrame\">";
                classStr += ccName + "</a>";
                classStr += "<td></tr>";
                classStr += "<tr id=\"load_"+ ccID +"\"  style=\"DISPLAY: none\"><td>";
                classStr += classBar_2(ccID, ccName);
                classStr += "<div id=\"replies_"+ ccID +"\"></div>";
                classStr += "</td></tr></table>";
                if(ccList!=0){
                    classStr += "<script language=\"javascript\">loadTree("+ ccID +" ,'');</script>";
                }
            }
                rs.close();
                sta.close();
        }catch(Exception e){
            con.close();
            classStr = "论坛分类索引读取失败";
        }finally{
            con.close();
        }
        return classStr;
    }
    public String classBar_2(int ccidd, String ccname) throws Exception{
    String ccName;
    String sqlCommand;
    int ccOrder, ccHidden, ccType, ccID, ccIDD, ccList;
    Connection con = bridge.getConnection();
        try{
            Statement sta;
            sta = con.createStatement();
            ResultSet rs2;
            sqlCommand = "";
            classStr = "";
            sqlCommand = "select * from GVclubClass where ccIDD = "+ ccidd +" and ccHidden=0 order by ccOrder desc";
            PreparedStatement pps = con.prepareStatement(sqlCommand);
            rs2 = pps.executeQuery();
            while(rs2.next()){
                ccID = rs2.getInt(1);
                ccIDD = rs2.getInt(2);
                ccName = rs2.getString(3).trim();
                ccType = rs2.getInt(5);
                ccList = rs2.getInt(19);
                if(ccType==0){
                classStr += "<table  width=\"99%\" border=\"0\" cellpadding=\"1\" cellspacing=\"0\">";
                classStr += "<tr><td height=\"18\" class=\"barbgOut\" onmouseover=\"this.className='barbgOver'\" ";
                classStr += "onmouseout=\"this.className='barbgOut'\">&nbsp;&nbsp;<img style=\"cursor:hand;\"  id=\"icon_"+ ccID +"\"  ";
                classStr += " onclick=\"loadTree("+ ccID +" ,'')\" src=\"GVimgs/tree/t1.gif\" ";
                classStr += "align=\"absmiddle\" />&nbsp;<a onclick=\"loadTree("+ ccID +" ,'');prtie('"+ clubName +"＞＞" + ccname + "＞＞" + ccName + "')\" ";
                classStr += " href=\"clubClass.jsp?ccID="+ ccID +"\" target=\"rFrame\">";
                classStr += ccName + "</a>";
                classStr += "<td></tr>";
                classStr += "<tr id=\"load_"+ ccID +"\"  style=\"DISPLAY: none\"><td>";
                classStr += classBar_3(ccID, ccName);  
                classStr += "<div id=\"replies_"+ ccID +"\"></div>";
                classStr += "</td></tr></table>";
                if(ccList!=0){
                    classStr += "<script language=\"javascript\">loadTree("+ ccID +" ,'');</script>";
                }
                }else{
                classStr += "<table  width=\"100%\" border=\"0\" cellpadding=\"1\" cellspacing=\"0\">";
                classStr += "<tr><td height=\"18\" class=\"barbgOut\" onmouseover=\"this.className='barbgOver'\" ";
                classStr += " onmouseout=\"this.className='barbgOut'\">&nbsp;&nbsp;<img  src=\"GVimgs/tree/t2.gif\" align=\"absmiddle\" />";
                classStr += "&nbsp;<a prtie('"+ clubName +"＞＞" + ccname + "＞＞" + ccName + "')\" ";
                classStr += " href=\"clubClass.jsp?ccID="+ ccID +"\" target=\"rFrame\">";
                classStr += ccName + "</a>";
                classStr +="</td></tr></table>";
                }
            }
                rs2.close();
                sta.close();
                con.close();
        }catch(Exception e){
            classStr = "论坛分类索引读取失败";
            con.close();
        }finally{
            con.close();
        }
        return classStr;
    } 
   public String classBar_3(int ccidd, String ccname) throws Exception{
    String ccName;
    String sqlCommand;
    int ccOrder, ccHidden, ccType, ccID, ccIDD, ccList;
    Connection con = bridge.getConnection();
        try{
            Statement sta;
            sta = con.createStatement();
            ResultSet rs3;
            sqlCommand = "";
            classStr = "";
            sqlCommand = "select * from GVclubClass where ccIDD = "+ ccidd +" and ccHidden=0 order by ccOrder desc";
            PreparedStatement pps = con.prepareStatement(sqlCommand);
            rs3 = pps.executeQuery();
            while(rs3.next()){
                ccID = rs3.getInt(1);
                ccIDD = rs3.getInt(2);
                ccName = rs3.getString(3).trim();
                ccType = rs3.getInt(5);
                classStr += "<table  width=\"100%\" border=\"0\" cellpadding=\"1\" cellspacing=\"0\">";
                classStr += "<tr><td height=\"18\" class=\"barbgOut\" onmouseover=\"this.className='barbgOver'\" ";
                classStr += " onmouseout=\"this.className='barbgOut'\">&nbsp;&nbsp;&nbsp;&nbsp;<img  src=\"GVimgs/tree/t2.gif\" align=\"absmiddle\" />";
                classStr += "&nbsp;<a prtie('"+ clubName +"＞＞" + ccname + "＞＞" + ccName + "')\" ";
                classStr += " href=\"clubClass.jsp?ccID="+ ccID +"\" target=\"rFrame\">";
                classStr += ccName + "</a>";
                classStr +="</td></tr></table>";
            }
                rs3.close();
                sta.close();
                con.close();
        }catch(Exception e){
            classStr = "";
        }finally{
            con.close();
        }
        return classStr;
    }    
    public ClubClassBar() throws Exception{
        ClubInfo ci = new ClubInfo();
        clubName = ci.getClubName();
    }
    public void clearStr(){
        classStr = null;
    }
    
}