clubinfo.java

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

/*
 * Made in GamVan
 */
package com.gamvan.club;
import com.gamvan.conn.*;
import com.gamvan.tools.P;
import java.sql.*;
public class ClubInfo{
    private String clubName, clubUrl, clubTitle, clubMeta, clubSmtp, clubEmail, clubTemp, txt;
    private String clubSmtpID, clubSmtpPass,clubEmailSend, clubYear, clubUpfileExt, clubCopyRight;
    private int clubMenu;
    private int clubSmtpUsePass, clubUpfileOpen, clubUpfileUser, clubUpfileMax;
    private Statement sta;
    public ClubInfo() throws Exception{
        ConnClub bridge = new ConnClub();
        Connection con = bridge.getConnection();     
        try{
            ResultSet rs; //记录集
            String sqlCommand;
            sta = con.createStatement();
            sqlCommand = "SELECT * FROM GVclubInfo ";
            rs = sta.executeQuery(sqlCommand);    
            if(!rs.next()){
            }else{   
                //rs.next();
                clubMenu = rs.getInt("clubMenu");
                clubName = rs.getString("clubName");
                clubUrl = rs.getString("clubUrl");
                clubTitle = rs.getString("clubTitle");
                clubMeta = rs.getString("clubMeta");
                clubSmtp = rs.getString("clubSmtp");
                clubSmtpID = rs.getString("clubSmtpID");
                clubSmtpPass = rs.getString("clubSmtpPass");
                clubEmail = rs.getString("clubEmail");
                clubEmailSend = rs.getString("clubEmailSend");
                clubSmtpUsePass = rs.getInt("clubSmtpUsePass");
                clubUpfileOpen = rs.getInt("clubUpfileOpen");
                clubUpfileMax = rs.getInt("clubUpfileMax");
                clubUpfileUser = rs.getInt("clubUpfileUser");
                clubUpfileExt = rs.getString("clubUpfileExt");
                clubCopyRight = rs.getString("clubCopyRight");             
                clubYear = rs.getString("clubYear");
            }
            rs.close();
            sta.close();
        }
        catch(Exception e){
            P.rintl(e.toString());
            con.close();
        }finally{
            con.close();
        }

    }
    public String getClubTemp(){
        return this.clubTemp;
    }
    public String getClubName(){
        return this.clubName;
    }
    public String getClubUrl(){
        return this.clubUrl;
    }
    public String getClubTitle(){
        return this.clubTitle;
    }    
    public String getClubMeta(){
        return this.clubMeta;
    }
    public String getClubSmtp(){
        return this.clubSmtp;
    }
    public String getClubSmtpID(){
        return this.clubSmtpID;
    }
    public String getClubSmtpPass(){
        return this.clubSmtpPass;
    }
    public String getClubEmail(){
        return this.clubEmail;
    }
    public String getClubEmailSend(){
        return this.clubEmailSend;
    } 
    public String getClubCopyRight(){
        return this.clubCopyRight;
    }
    public String getClubYear(){
        return this.clubYear;
    }
    public String getClubUpfileExt(){
        return this.clubUpfileExt;
    }
    public int getClubStmpUsePass(){
        return this.clubSmtpUsePass;
    }
    public int getClubMenu(){
        return this.clubMenu;
    }
    public int getClubUpfileOpen(){
         return this.clubUpfileOpen;
    }
    public int getClubUpfileUser(){
        return this.clubUpfileUser;
    }
    public int getClubUpfileMax(){
        return this.clubUpfileMax;
    }
}