clubmaster.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 ClubMaster{
    private String cmName, cmPass, cmip1, cmip2;
    private int cmIpLock, cmgID;
    private String cmIP1, cmIP2;
    private Statement sta;
    private String message;
    //新建对像用于中文编码
    Gb clubgb = new Gb();
    EncodeIP enc = new EncodeIP();
    EncodeString ens = new EncodeString();
    //提交删除管理员信息的操作
    public void clubMasterDel(String[] cmIDs){
        String cmID = "0";
        int i = 0;
        try{
            ConnClub bridge = new ConnClub();
            ResultSet rs;
            String sqlCommand;
            sqlCommand = new String();
            Connection con = bridge.getConnection();
            sta = con.createStatement();
            for (i = 0; i < cmIDs.length; i++) {
                cmID += "," + cmIDs[i];
            }
            sqlCommand = "DELETE FROM GVclubMaster where cmID in (" + cmID +")";
            sta.executeUpdate(sqlCommand);
            //message = sqlCommand; //测试专用
            sta.close();
            con.close();  
        }catch(Exception e){
            
        }
    }
    // 读取管理员信息
    public void clubMasterList(int cmID){
        try{
            ConnClub bridge = new ConnClub();
            ResultSet rs;
            String sqlCommand;
            sqlCommand = new String();
            Connection con = bridge.getConnection();
            sta = con.createStatement();
            sqlCommand = "SELECT * FROM GVclubMaster where cmID = "+ cmID + "";
            rs = sta.executeQuery(sqlCommand);
            if(rs.next()){
                cmgID = rs.getInt("cmgID");
                cmName = rs.getString("cmName");
                cmPass = rs.getString("cmPass");
                cmIpLock = rs.getInt("cmIpLock");
                cmIP1 = rs.getString("cmIP1");
                cmIP2 = rs.getString("cmIP2");
                //将IP转换成字符串；
                cmip1 = enc.deAddr(cmIP1); 
                cmip2 = enc.deAddr(cmIP2); 
            }
            sta.close();
            con.close();  
        }catch(Exception e){}
    }
    
    // 添加、编辑管理员信息
    public void clubMasterEdit(int cmID){
        try{
            ConnClub bridge = new ConnClub();
            ResultSet rs;
            String sqlCommand;
            sqlCommand =  new String();
            Connection con = bridge.getConnection();        
            sta = con.createStatement();
            // cmID 大于0修改管理员信息 否则添加管理员信息
            if(cmID>0){
                sqlCommand = "UPDATE GVclubMaster set cmgID = " + cmgID + ", cmName = '" + cmName + "', cmPass = '" + cmPass + "'";
                sqlCommand = sqlCommand +  ", cmIpLock = " + cmIpLock + ", cmIP1 = '" + cmIP1 + "', cmIP2 = '" + cmIP2 + "'";
                sqlCommand = sqlCommand +  " where cmID = "+ cmID +"";
            sta.executeUpdate(sqlCommand);
            message = "OK！管理员信息编辑成功啦！";             
            }else{
                sqlCommand = "";
                sqlCommand = "SELECT cmID From GVclubMaster where cmName = '" + cmName +"'";
                rs = sta.executeQuery(sqlCommand);
                if(rs.next()){
                    message = "数据库中已有同名ID的管理员存在，本次操作被终止！";
                }else{
                    sqlCommand = "";
                    sqlCommand = "INSERT INTO GVclubMaster(cmName, cmPass, cmIP1, cmIP2, cmIpLock, cmgID)";
                    sqlCommand = sqlCommand + " VALUES('" + cmName +  "', '" + cmPass + "'";
                    sqlCommand = sqlCommand + ", '"+ cmIP1 + "', '" + cmIP2 + "', "+ cmIpLock + ", "+ cmgID + ")";   
                    sta.executeUpdate(sqlCommand);
                    message = "OK！管理员信息添加成功啦！";   
                }
            } 
            sta.close();
            con.close();
           }catch(Exception e){
            P.rint(e.toString());
        }
    }
    public String getMessage(){
        return this.message;
    }
    public void setCmName(String cmName){
        cmName = clubgb.Gb(cmName);
        this.cmName = cmName;
    }
    public void setCmPass(String cmPass, int i){
        cmPass = clubgb.Gb(cmPass);
        if(cmPass!="" && i==0){
            cmPass = ens.encodeString("md5of16",cmPass);
        }
        this.cmPass = cmPass;
    }
    public void setCmIP1(String cmIP1){
        this.cmIP1 = enc.enAddr(cmIP1);
    }
    public void setCmIP2(String cmIP2){
        this.cmIP2 = enc.enAddr(cmIP2);
    }
     public void setCmIpLock(String cmIpLock){
        this.cmIpLock = Integer.parseInt(cmIpLock);
    }
     public void setCmgID(String cmgID){
        this.cmgID = Integer.parseInt(cmgID);
    }
     public int getCmgID(){
         return this.cmgID;
     }
     public int getCmIpLock(){
         return this.cmIpLock;
     }
     public String getCmIP1(){
         return this.cmip1;
     }
     public String getCmIP2(){
         return this.cmip2;
     }
     public String getCmName(){
         return this.cmName;
     }
     public String getCmPass(){
         return this.cmPass;
     }
}