clubblackget.java

GamVan Club v1.1 源代码

/*
 * ClubBlackList.java
 * www.GamVan.com
 * Created on 2005年3月1日, 上午2:12
 */
package com.gamvan.club.user;
import com.gamvan.conn.*;
import java.sql.*; 
public class ClubBlackGet {
    private int bID=0
        , ccID=0
        , blackDate=0
        , blackOver=0
        , userID=0;
    private String blackUserName = ""
        , blackInfo = ""
        , blackTxt = ""
        , blackAddTime = ""
        , byUserIp = ""
        , byUserName=""
        , byAddTime=""
        , sqlCommand="";
    ConnClub bridge = new ConnClub();
    public boolean clubBlackSelect(String uName, int info) throws Exception{
        // info=0 不提取黑名单信息，只查询其是否存在记录
        boolean bea = false;
        Connection con = bridge.getConnection();
        try{
            sqlCommand = "select * From GVclubBlackList ";
            sqlCommand += " where blackUserName=? and datediff(d,byAddTime,getdate()) < "
            + " blackDate and blackOver=0 order by blackOver, blackDate desc, bID desc";
            PreparedStatement pps = con.prepareStatement(sqlCommand);
            pps.setString(1, uName);
            ResultSet rs = pps.executeQuery();
            if(rs.next()){
                if(info==1){
                    bID = rs.getInt(1);
                    blackUserName = rs.getString(2).trim();
                    blackInfo = rs.getString(3).trim();
                    blackTxt = rs.getString(4).trim();
                    blackDate = rs.getInt(5);
                    blackOver = rs.getInt(6);
                    byUserName = rs.getString(7).trim();
                    byAddTime = rs.getString(8).trim();
                    byUserIp = rs.getString(9).trim();
                    ccID = rs.getInt(10);
                    userID = rs.getInt(11);
                }
                bea = true;
            }else{
                bea = false;
            }
            rs.close();
            pps.close();
        }catch(Exception e){
            bea = false;
            con.close();
        }finally{
            con.close();
        }
        return bea;
    }
    public boolean clubBlackSelect(int userid, int info) throws Exception{
        // info=0 不提取黑名单信息，只查询其是否存在记录
        boolean bea = false;
        Connection con = bridge.getConnection();
        try{
            sqlCommand = "select * From GVclubBlackList ";
            sqlCommand += " where userID=? and datediff(d,byAddTime,getdate()) < "
            + " blackDate and blackOver=0 order by blackOver, blackDate desc, bID desc";
            PreparedStatement pps = con.prepareStatement(sqlCommand);
            pps.setInt(1, userid);
            ResultSet rs = pps.executeQuery();
            if(rs.next()){
                if(info==1){
                    bID = rs.getInt(1);
                    blackUserName = rs.getString(2).trim();
                    blackInfo = rs.getString(3).trim();
                    blackTxt = rs.getString(4).trim();
                    blackDate = rs.getInt(5);
                    blackOver = rs.getInt(6);
                    byUserName = rs.getString(7).trim();
                    byAddTime = rs.getString(8).trim();
                    byUserIp = rs.getString(9).trim();
                    ccID = rs.getInt(10);
                    userID = rs.getInt(11);
                }
                bea = true;
            }else{
                bea = false;
            }
            rs.close();
            pps.close();
        }catch(Exception e){
            bea = false;
        }finally{
            con.close();
        }
        return bea;
    }

    //=========================================================
    public boolean clubBlackBid(int bid, int info) throws Exception{
        // info=0 不提取黑名单信息，只查询其是否存在记录
        boolean bea = false;
        Connection con = bridge.getConnection();
        try{
            sqlCommand = "select * From GVclubBlackList ";
            sqlCommand += " where bID=?";
            PreparedStatement pps = con.prepareStatement(sqlCommand);
            pps.setInt(1, bid);
            ResultSet rs = pps.executeQuery();
            if(rs.next()){
                if(info==1){
                    bID = rs.getInt(1);
                    blackUserName = rs.getString(2).trim();
                    blackInfo = rs.getString(3).trim();
                    blackTxt = rs.getString(4).trim();
                    blackDate = rs.getInt(5);
                    blackOver = rs.getInt(6);
                    byUserName = rs.getString(7).trim();
                    byAddTime = rs.getString(8).trim();
                    byUserIp = rs.getString(9).trim();
                    ccID = rs.getInt(10);
                    userID = rs.getInt(11);
                }
                bea = true;
            }else{
                bea = false;
            }
            rs.close();
            pps.close();
        }catch(Exception e){
            bea = false;
            con.close();
        }finally{
            con.close();
        }
        return bea;
    }

        
    public int getBid(){
        return this.bID;
    }
    public String getBlackUserName(){
        return this.blackUserName;
    }
    public String getBlackInfo(){
        return this.blackInfo;
    }
    public String getBlackTxt(){
        return this.blackTxt;
    }
    public int getBlackDate(){
        return this.blackDate;
    }
    public int getBlackOver(){
        return this.blackOver;
    }
    public String getBlackAddTime(){
        return this.blackAddTime;
    }
    public String getByUserName(){
        return this.byUserName;
    }
    public String getByAddTime(){
        return this.byAddTime;
    }
    public String getByUserIp(){
        return this.byUserIp;
    }
    public int getCCID(){
        return this.ccID;
    }
    public int getUserID(){
        return this.userID;
    }
}