clubinfoedit.java

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

package com.gamvan.club;
import com.gamvan.conn.*;
import com.gamvan.tools.*;
import java.sql.*;
public class ClubInfoEdit{
    private String clubName, clubUrl, clubTitle, clubMeta, clubSmtp, clubEmail;
    private String clubSmtpID, clubSmtpPass, clubEmailSend, clubYear, clubUpfileExt, clubCopyRight;
    private int clubMenu,clubSmtpUsePass, clubUpfileOpen, clubUpfileUser, clubUpfileMax;
    private Statement sta;
    //private String clubGb;
    Gb clubgb = new Gb();
    public void setClubInfoEdit(){
        try{
            ConnClub bridge = new ConnClub();
            ClubInfoEdit operator = new ClubInfoEdit();
            String sqlCommand;
            sqlCommand =  new String();
            Connection con = bridge.getConnection();        
            sta = con.createStatement();
            sqlCommand = "UPDATE GVclubInfo SET clubMenu = " + clubMenu + "";
            sqlCommand = sqlCommand + ", clubName = \'" + clubName + "\'";
            sqlCommand = sqlCommand + ", clubUrl = \'"+ clubUrl + "\'";
            sqlCommand = sqlCommand + ", clubTitle = \'"+ clubTitle + "\'";
            sqlCommand = sqlCommand + ", clubMeta = \'"+ clubMeta + "\'";
            sqlCommand = sqlCommand + ", clubSmtp = \'"+ clubSmtp + "\'";
            sqlCommand = sqlCommand + ", clubSmtpID = \'"+ clubSmtpID + "\'";
            sqlCommand = sqlCommand + ", clubSmtpPass = \'"+ clubSmtpPass + "\'";
            sqlCommand = sqlCommand + ", clubEmail = \'"+ clubEmail + "\'";
            sqlCommand = sqlCommand + ", clubEmailSend = \'"+ clubEmailSend + "\'";
            sqlCommand = sqlCommand + ", clubSmtpUsePass = " + clubSmtpUsePass + "";
            sqlCommand = sqlCommand + ", clubUpfileOpen = " + clubUpfileOpen + "";
            sqlCommand = sqlCommand + ", clubUpfileMax = " + clubUpfileMax + "";       
            sqlCommand = sqlCommand + ", clubUpfileUser = " + clubUpfileUser + "";
            sqlCommand = sqlCommand + ", clubUpfileExt = \'"+ clubUpfileExt + "\'";
            sqlCommand = sqlCommand + ", clubCopyRight = \'"+ clubCopyRight + "\'";
            sqlCommand = sqlCommand + ", clubYear = \'"+ clubYear + "\'";      
            sta.executeUpdate(sqlCommand);
            con.close();
        }
        catch(Exception e){
            P.rint(e.toString());
        }
    }
    public void setClubName(String clubName){
        clubName = clubgb.Gb(clubName);
        this.clubName = clubName;
    }
    public void setClubUrl(String clubUrl){
        clubUrl = clubgb.Gb(clubUrl);
        this.clubUrl = clubUrl;
    }
    public void setClubTitle(String clubTitle){
        clubTitle = clubgb.Gb(clubTitle);
        this.clubTitle = clubTitle;
    }
    public void setClubMeta(String clubMeta){
        clubMeta = clubgb.Gb(clubMeta);
        this.clubMeta = clubMeta;
    }
    public void setClubSmtp(String clubSmtp){
        //clubSmtp = clubgb.Gb(clubSmtp); 主机地址中文情况基本无，所以编码转换就没必要了
        this.clubSmtp = clubSmtp;
    }
    public void setClubEmail(String clubEmail){
        this.clubEmail = clubEmail;
    }
    public void setClubSmtpID(String clubSmtpID){
        clubSmtpID = clubgb.Gb(clubSmtpID);
        this.clubSmtpID = clubSmtpID;
    }
    public void setClubSmtpPass(String clubSmtpPass){
        this.clubSmtpPass = clubSmtpPass;
    }
    public void setClubEmailSend(String clubEmailSend){
        clubEmailSend = clubgb.Gb(clubEmailSend);
        this.clubEmailSend = clubEmailSend;
    }
    public void setClubYear(String clubYear){
        clubYear = clubgb.Gb(clubYear);
        this.clubYear = clubYear;        
    }
    public void setClubUpfileExt(String clubUpfileExt){
        this.clubUpfileExt = clubUpfileExt;
    }
    public void setClubCopyRight(String clubCopyRight){
        clubCopyRight = clubgb.Gb(clubCopyRight);
        this.clubCopyRight = clubCopyRight;
    }
    public void setClubMenu(int clubMenu){
        this.clubMenu = clubMenu;
    }
    public void setClubSmtpUsePass(int clubSmtpUsePass){
        this.clubSmtpUsePass = clubSmtpUsePass;
    }
    public void setClubUpfileOpen(int clubUpfileOpen){
        this.clubUpfileOpen = clubUpfileOpen;
    }
    public void setClubUpfileUser(int clubUpfileUser){
        this.clubUpfileUser = clubUpfileUser;
    }
    public void setClubUpfileMax(int clubUpfileMax){
        this.clubUpfileMax = clubUpfileMax;
    }
}