clubclassedit.java

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

/*
 * Made in GamVan
 * Created on 2004年11月29日, 上午11:04
 */
package com.gamvan.club;
import com.gamvan.conn.*;
import com.gamvan.tools.*;
import java.sql.*;
public class ClubClassEdit {
    String ccName=""; //分类或版面名称
    String ccSummary = ""; //分类或版面简介
    String ccUserPass = ""; //分类或版面的认证用户
    int ccOrder = 0; //分类或版面的排序ID 
    int ccIDD = 0; //分类或版面的上级ID
    int ccType = 0; //类型，判断是分类还是版面 0为分类 1为版面
    int ccPro = 0; //分类或版面的属性
    int ccHidden = 0; //是否隐藏 默认0不隐藏
    int ccUpfileMax = 0; //上传附件的最大限制，单位字节
    int ccUpfilePass = 0; //判断是否打开了上传
    int ccStyle = 0; //论坛的风格 0 为默认风格BBS， 1 为讨论区风格
    int ccUgid = 10; //浏览版面所需的等级
    int ccTopicNum = 15; //主题显示条数
    int ccReplyNum = 10; //回复显示数
    int ccMostOnline = 0; //最多在线人数
    int ccList = 0;
    private Statement sta;
    private String sqlCommand =  new String();
    private String message;
    //新建对像用于中文编码
    Gb clubgb = new Gb();
    //建立数据库联接
    ConnClub bridge = new ConnClub();
    public void classEdit(int ccID){
        try{
            Connection con = bridge.getConnection();
            sta = con.createStatement();
            if(ccID>0){
                sqlCommand = "UPDATE GVclubClass set ccIDD = "+ ccIDD;
                sqlCommand += ", ccName = '" + ccName + "' ";
                sqlCommand += ", ccOrder  = " + ccOrder ;
                sqlCommand += ", ccType = " + ccType ;
                sqlCommand += ", ccStyle = " + ccStyle ;
                sqlCommand += ", ccPro = " + ccPro ;
                sqlCommand += ", ccHidden = " + ccHidden ;
                sqlCommand += ", ccUpfilePass = " + ccUpfilePass ;
                sqlCommand += ", ccUpfileMax = " + ccUpfileMax ;
                sqlCommand += ", ccUgid = " + ccUgid ;
                sqlCommand += ", ccTopicNum = " + ccTopicNum ;
                sqlCommand += ", ccReplyNum =" + ccReplyNum ;
                sqlCommand += ", ccMostOnline =" + ccMostOnline ;
                sqlCommand += ", ccSummary = '" + ccSummary + "'" ;
                sqlCommand += ", ccUserPass = '" + ccUserPass + "'" ;
                sqlCommand += ", ccList = "+ ccList +"";
                sqlCommand += " where ccID = " + ccID ;
            }else{
                sqlCommand = "INSERT INTO GVclubClass(ccIDD, ccName, ccOrder, ccType, ccStyle, ccPro" ;
                sqlCommand += ", ccHidden, ccUpfilePass, ccUpfileMax, ccUgid, ccTopicNum" ;
                sqlCommand += ", ccReplyNum, ccMostOnline, ccSummary, ccUserPass, ccList";
                sqlCommand += ") ";
                sqlCommand += " VALUES(" + ccIDD + ", '" + ccName + "', " + ccOrder + ", "+ ccType + "";
                sqlCommand += ", "  + ccStyle + ", " + ccPro + " , " + ccHidden + "" ;
                sqlCommand += ", " + ccUpfilePass + ", " + ccUpfileMax + ", "+ ccUgid + "" ;
                sqlCommand += ", " + ccTopicNum + ", " + ccReplyNum + "," + ccMostOnline + "";
                sqlCommand += ", '" + ccSummary + "', '" + ccUserPass + "', "+ ccList +"";
                sqlCommand += ") ";
            }   
            message = sqlCommand;
            sta.executeUpdate(sqlCommand);
            sta.close();
            con.close();  
        }catch(Exception e){
            
        }
    }

    public String getMessage(){
        return this.message;
    }
    public void setccidd(String ccIDD){
        this.ccIDD = Integer.parseInt(ccIDD);
    }
    public void setccname(String ccName){
        ccName = clubgb.Gb(ccName);
        this.ccName = ccName;
    }
    public void setcctype(String ccType){
        this.ccType = Integer.parseInt(ccType);
    }
    public void setccstyle(String ccStyle){
        this.ccStyle = Integer.parseInt(ccStyle);
    }
    public void setccorder(String ccOrder){
        this.ccOrder = Integer.parseInt(ccOrder);
    }
    public void setccpro(String ccPro){
        this.ccPro = Integer.parseInt(ccPro);
    }
    public void setcchidden(String ccHidden){
        this.ccHidden = Integer.parseInt(ccHidden);
    }
    public void setccupfilemax(String ccUpfileMax){
        this.ccUpfileMax = Integer.parseInt(ccUpfileMax);
    }
    public void setccupfilepass(String ccUpfilePass){
        this.ccUpfilePass = Integer.parseInt(ccUpfilePass);
    }
    public void setccugid(String ccUgid){
        this.ccUgid = Integer.parseInt(ccUgid);
    }
    public void setcctopicnum(String ccTopicNum){
        this.ccTopicNum = Integer.parseInt(ccTopicNum);
    }
    public void setccreplynum(String ccReplyNum){
        this.ccReplyNum = Integer.parseInt(ccReplyNum);
    }
    public void setccmostonline(String ccMostOnline){
        this.ccMostOnline = Integer.parseInt(ccMostOnline);
    }
    public void setccsummary(String ccSummary){
        ccSummary = clubgb.Gb(ccSummary);
        this.ccSummary = ccSummary;
    }
    public void setccuserpass(String ccUserPass){
        ccUserPass = clubgb.Gb(ccUserPass);
        this.ccUserPass = ccUserPass;
    }
    public void setcclist(String ccList){
        this.ccList = Integer.parseInt(ccList);
    }
}