clubblackrequest.java

GamVan Club v1.1 源代码

package com.gamvan.club.user;
import com.gamvan.conn.*;
import com.gamvan.club.ClubUsers;
import com.gamvan.club.user.ClubBlackGet;
import java.sql.*; 
public class ClubBlackRequest {
    private int bID=0
        , ccID=0
        , blackDate=0
        , blackOver=0
        , userID=0
        , byUserID=0;
    private String blackUserName = ""
        , blackInfo = ""
        , blackTxt = ""
        , blackAddTime = ""
        , byUserIp = ""
        , byUserName=""
        , byAddTime=""
        , sqlCommand=""
        , act = ""
        , message = "";
        //格式化当前时间
    java.text.SimpleDateFormat isNow = new java.text.SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
    private String now = isNow.format(new java.util.Date());
    ClubUsers cu = new ClubUsers();
    ClubBlackGet cbg = new ClubBlackGet();
    public boolean blackAct() throws Exception{
        boolean bea = false;
        boolean bea2=false;
       if(cu.userSelect(blackUserName)){ //判断用户是否存在
           userID = cu.getUserID();
            if(bID>0){
                blackUpdate();
            }else{
                bea2 = cbg.clubBlackSelect(blackUserName, 1);
                if(bea2){
                    this.bID = cbg.getBid();
                    blackUserName = cbg.getBlackUserName();
                    //byAddTime = cbg.getByAddTime();
                    //blackOver = cbg.getBlackOver(); 
                    //blackDate = cbg.getBlackDate();
                    //message = "有记录";
                    blackUpdate();
                }else{
                    bea = blackInsert();
                    //message = "无记录";
                }
            }
        }else{
                message = "您所输入的用户ID不存在或已被删除！";
                bea = false;
        }
        return bea;
    }
    public boolean blackInsert() throws Exception{
        boolean bea = false;
        ConnClub bridge = new ConnClub();
        Connection con = bridge.getConnection();
        String sqlCommand = new String();
        cu.userSelect(byUserName);
        byUserID = cu.getUserID();
        try{
            sqlCommand = "Insert into GVclubBlackList(blackUserName, blackInfo, blackTxt "
            + ", blackDate, blackOver, byUserName, byAddTime, byUserIp, ccID, userID, byUserID) "
            + " Values(?,?,?,?,?,?,?,?,?,?,?)";
            PreparedStatement pps = con.prepareStatement(sqlCommand);
            pps.setString(1, blackUserName);
            pps.setString(2, blackInfo);
            pps.setString(3, blackTxt);
            pps.setInt(4, blackDate);
            pps.setInt(5, 0);
            pps.setString(6, byUserName);
            pps.setString(7, now); //更细操作不更新加入时间
            pps.setString(8, byUserIp);
            pps.setInt(9, ccID);  
            pps.setInt(10, userID);
            pps.setInt(11, byUserID);
            pps.executeUpdate();
            pps.close();
            message = "操作成功！" + blackUserName + " 已被列入黑名单！" ;
        }catch(Exception e){
            message = "数据写入错误：" + e.toString();
            con.close();
        }finally{
            con.close();
        }
        return bea;
    }
    public boolean blackUpdate() throws Exception{
        cu.userSelect(byUserName);
        byUserID = cu.getUserID();
        boolean bea = false;
        ConnClub bridge = new ConnClub();
        Connection con = bridge.getConnection();
        String sqlCommand = new String();
        try{
            sqlCommand = "Update GVclubBlackList set blackUserName=?, blackInfo=?";
            sqlCommand += ", blackTxt=?, blackDate=?, blackOver=?";
            sqlCommand += ", byUserName=?, byUserIp=?, ccID=?";
            sqlCommand += ", userID=? where bID=?";
            PreparedStatement pps = con.prepareStatement(sqlCommand);
            pps.setString(1, blackUserName);
            pps.setString(2, blackInfo);
            pps.setString(3, blackTxt);
            pps.setInt(4, blackDate);
            pps.setInt(5, 0);
            pps.setString(6, byUserName);
            //pps.setString(7, now);
            pps.setString(7, byUserIp);
            pps.setInt(8, ccID);  
            pps.setInt(9, userID);
            pps.setInt(10, bID);  
            pps.executeUpdate();
            pps.close();            
            bea = true;
            message = "操作成功！" + blackUserName + " 已被更新列入黑名单！" ;
        }catch(Exception e){
            con.close();
        }finally{
            con.close();
        }        
        return bea;        
    }
    public String getMessage(){
        return this.message;
    }
    public void setAct(String act){
        this.act = act;
    }
    public void setBid(int bID){
        this.bID = bID;
    }
    public void setBlackDate(String blackDate){
        if(blackDate!=null){
            this.blackDate = Integer.parseInt(blackDate);
        }else{
            this.blackDate = 0;
        }
    }
    public void setBlackOver(String blackOver){
        if(blackOver!=null){
            this.blackOver = Integer.parseInt(blackOver);
        }else{
            this.blackOver = 0;
        }
    }
    public void setCCID(String ccID){
        if(ccID!=null){
            this.ccID = Integer.parseInt(ccID);
        }else{
            this.ccID = 0;
        }
    }
    public void setBlackUserName(String blackUserName){
        this.blackUserName = blackUserName;
    }
    public void setBlackInfo(String blackInfo){
        this.blackInfo = blackInfo;
    }
    public void setBlackTxt(String blackTxt){
        if(blackTxt!=null){
            this.blackTxt = blackTxt;
        }
    }
    public void setByUserIp(String byUserIp){
        this.byUserIp = byUserIp;
    }
    public void setByUserName(String byUserName){
        this.byUserName = byUserName;
    }
    public void setByUserID(int byUserID){
        this.byUserID = byUserID;
    }
}