clubmastergrade.java

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

package com.gamvan.club;
import com.gamvan.conn.*;
import com.gamvan.tools.*;
import java.sql.*;
/* Made in GamVan
 * 管理员等级 javaBean
 */
public class ClubMasterGrade{
    private String cmgName, cmgTxt;
    private int cmgID;
    private Statement sta;
    private String sqlCommand =  new String();
    //新建对像用于中文编码
    Gb clubgb = new Gb();
    //建立数据库联接
    ConnClub bridge = new ConnClub();
    //建立删除方法
    public void masterGradeDel(String[] cmgIDs){
        try{
            String cmgID = "0";
            int i = 0;
            Connection con = bridge.getConnection();        
            sta = con.createStatement();   
            for (i = 0; i < cmgIDs.length; i++) {
                cmgID += "," + cmgIDs[i];
            }
            sqlCommand = "DELETE FROM GVclubMasterGrade where cmgID in ("+ cmgID + ")";
            sta.executeUpdate(sqlCommand);
            sta.close();
            con.close();
        }catch(Exception e){
            P.rint(e.toString());
        }       
    }
    public void masterGradeEdit(int cmgID){
       try{
            Connection con = bridge.getConnection();        
            sta = con.createStatement();
            //cmgID等于0表示添加管理员等级，否则根木cmgID修改对应的管理员等级
            if(cmgID==0){ 
                sqlCommand = "insert into GVclubMasterGrade(cmgName, cmgTxt)";
                sqlCommand = sqlCommand + " values('"+ cmgName + "', '"+ cmgTxt + "')";
            }else{
                sqlCommand = "UPDATE GVclubMasterGrade set cmgName='" + cmgName +"\'";
                sqlCommand = sqlCommand + ", cmgTxt = '"+ cmgTxt + "' where cmgID="+ cmgID;
            }
            sta.executeUpdate(sqlCommand);
            sta.close();
            con.close();
           }catch(Exception e){
            P.rint(e.toString());
        }
    }
    public void masterGradeInfo(int cmgID){
       try{
            ResultSet rs;
            Connection con = bridge.getConnection();        
            sta = con.createStatement();
            sqlCommand = "SELECT * FROM GVclubMasterGrade where cmgID="+ cmgID;
            rs = sta.executeQuery(sqlCommand);
            if(!rs.next()){
            }else{   
                //rs.next();
                cmgName = rs.getString("cmgName");
                cmgTxt = rs.getString("cmgTxt");
            }
            rs.close();
            sta.close();
            con.close();
           }catch(Exception e){
            P.rint(e.toString());
        }      
    }
    // 取等级名称
    public String getCmgName(){
        return this.cmgName;
    }
    // 取等级权限数组
    public String getCmgTxt(){
        return this.cmgTxt;
    }
    // 设定等级名称
    public void setCmgName(String cmgName){
        cmgName = clubgb.Gb(cmgName);
        this.cmgName = cmgName;
    }
    // 设定等级权限
    public void setCmgTxt(String cmgTxt){
        this.cmgTxt = cmgTxt;
    }
}