clubtopicinfo.java

GamVan Club v1.1 源代码

            }
            rs.close();
            pps.close();
       }catch(Exception e){
            bea = false;
            con.close();
        }finally{
            con.close();
        }
        return bea;
    }
    public void topicUpdate(int tID, int i, int r) throws Exception{
        String sqlCommand = new String();
        ResultSet rs;
        Connection con = bridge.getConnection();
        try{
            sqlCommand = "Update GVclubTopic set topicViewCount=topicViewCount+"+ i +"";
            sqlCommand += ", topicReCount = topicReCount+"+ r +"";
            sqlCommand += " where topicID=?";
            PreparedStatement pps = con.prepareStatement(sqlCommand);
            pps.setInt(1, tID);  
            pps.executeUpdate();
            pps.close();
        }catch(Exception e){
            con.close();
        }finally{
            con.close();
        }
    }
    public boolean topicInfo(int tID) throws Exception{
        boolean bea = false;
        String sqlCommand = new String();
        ResultSet rs;
        Connection con = bridge.getConnection();
        try{
            sqlCommand = "Select * From GVclubTopic where topicID=?";
            PreparedStatement pps = con.prepareStatement(sqlCommand);
            pps.setInt(1, tID);
            rs = pps.executeQuery();
            if(rs.next()){
                topicID = rs.getInt(1);
                topicReID = rs.getInt(2);
                topicOrder = rs.getInt(3);
                topicLayer = rs.getInt(4);
                topicTree = rs.getInt(5);
                topic = rs.getString(6).trim();
                userName = rs.getString(7).trim();
                ccID = rs.getInt(8);
                ccID2 = rs.getInt(9);
                ccID1 = rs.getInt(10);
                moveCCID = rs.getInt(11);
                topicList = rs.getString(12);
                topicMood = rs.getInt(13);
                topicPro = rs.getInt(14);
                topicType = rs.getInt(15); 
                topicTypeNum = rs.getInt(16);
                topicAddTime = rs.getString(17);
                topicAddTime = topicAddTime.replace(".000","");
                topicAddip = rs.getString(18);
                topicLastReUser = rs.getString(19);
                topicLastReTime = rs.getString(20);
                topicViewCount = rs.getInt(21);
                topicReCount = rs.getInt(22);
                topicLen = rs.getInt(23);
                userID = rs.getInt(26);
                contentInfo(tID);
                bea = true;
            }
            rs.close();
            pps.close();
        }catch(Exception e){
            message = "系统错误，无法读取主题，请联系管理员";
            bea = false;
            con.close();
        }finally{
            con.close();
        }
        return bea;
    }
    public void contentInfo(int tID) throws Exception{
        String sqlCommand = new String();
        ResultSet rsc;
        Connection con = bridge.getConnection();
        try{
            sqlCommand = "Select * From GVclubContent where topicID=?";
            PreparedStatement pps = con.prepareStatement(sqlCommand);
            pps.setInt(1, tID);
            rsc = pps.executeQuery();
            if(rsc.next()){
                content = rsc.getString(3).trim();
                contentUserPen = rsc.getInt(4);
                contentUrl = rsc.getInt(5);
                contentImg = rsc.getInt(6);
                contentEmail = rsc.getInt(7);
                contentCopyRight = rsc.getInt(8);
            }else{
                content="";
            }
            rsc.close();
            pps.close();
        }catch(Exception e){
            message = e.toString() + "系统错误，无法读取主题详细内容，请联系管理员";
            con.close();
        }finally{
            con.close();
        }
    }
    public String getMessage(){
        return this.message;
    }
    public String getReUsers(){
        return this.reUsers;
    }
    public String getContent(){
        return this.content;
    }
    public int getContentUrl(){
        return this.contentUrl;
    }
    public int getContentUserPen(){
        return this.contentUserPen;
    }
    public int getContentImg(){
        return this.contentImg;
    }
    public int getContentEmail(){
        return this.contentEmail;
    }
    public int getContentCopyRight(){
        return this.contentCopyRight;
    }
    public int getTopicID(){
        return this.topicID;
    }
    public int getTopicReID(){
        return this.topicReID;
    }
    public String getTopic(){
        return this.topic;
    }
    public int getTopicOrder(){
        return this.topicOrder;
    }
    public int getTopicTree(){
        return this.topicTree;
    }
    public int getTopicLayer(){
        return this.topicLayer;
    }
    public String getUserName(){
        return this.userName;
    }
    public int getCCID(){
        return this.ccID;
    }
    public int getCCID1(){
        return this.ccID1;
    }
    public int getCCID2(){
        return this.ccID2;
    }
    public int getMoveCCID(){
        return this.moveCCID;
    }
    public String getTopicList(){
        return this.topicList;
    }
    public int getTopicMood(){
        return this.topicMood;
    }
    public int getTopicPro(){
        return this.topicPro;
    }
    public int getTopicType(){
        return this.topicType;
    }
    public int getTopicTypeNum(){
        return this.topicTypeNum;
    }
    public String getTopicAddTime(){
        return this.topicAddTime;
    }
    public String getTopicAddip(){
        return this.topicAddip;
    }
    public String getLastReUser(){
        return this.topicLastReUser;
    }
    public String getLastReTime(){
        return this.topicLastReTime;
    }
    public int getTopicViewCount(){
        return this.topicViewCount;
    }
    public int getTopicReCount(){
        return this.topicReCount;
    }
    public int getUserID(){
        return this.userID;
    }
    public int getTopicLen(){
        return this.topicLen;
    }
}