clubstringreplace.java

GamVan Club v1.1 源代码

package com.gamvan.club.manage;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import com.gamvan.conn.ConnClub;
import com.gamvan.tools.Gb;
public class ClubStringReplace {
    private String replaceTopic = new String("");
    private String replaceContent = new String("");
    private String replaceMsgTopic = new String("");
    private String replaceMsgContent = new String("");
    private String replaceUserName = new String("");
    private String replaceUserPen = new String("");
    private String message = "";
    ConnClub bridge = new ConnClub();
    Gb clubgb = new Gb();
    public boolean replaceSelect() throws Exception{
        boolean bea = false;
        String sqlCommand = new String();
        Connection con = bridge.getConnection();
        try{
            sqlCommand = "select * from GVclubStringReplace";
            PreparedStatement pps = con.prepareStatement(sqlCommand);
            ResultSet rs;
            rs = pps.executeQuery();
            if(rs.next()){
                replaceUserName = rs.getString(2);
                replaceTopic = rs.getString(3);
                replaceContent = rs.getString(4);
                replaceMsgTopic = rs.getString(5);
                replaceMsgContent = rs.getString(6);
                replaceUserPen = rs.getString(7);
            }
            rs.close();
            pps.close();
        }catch(Exception e){
            message = e.toString();
        }finally{
            con.close();
        }
        return bea;
    }
    public boolean replaceUpdate() throws Exception{
        boolean bea = false;
        StringBuffer sqlCommand = new StringBuffer("");
        Connection con = bridge.getConnection();
        try{
            sqlCommand.append("Update GVclubStringReplace set replaceUserName=?");
            sqlCommand.append(", replaceTopic=?, replaceContent=?");
            sqlCommand.append(", replaceMsgTopic=?, replaceMsgContent=?, replaceUserPen=?");
            PreparedStatement pps = con.prepareStatement(sqlCommand.toString());
            replaceUserName=replaceUserName.replaceAll("\r","");
            replaceUserName=replaceUserName.replaceAll("\n","");
            pps.setString(1,clubgb.gb(replaceUserName));
            pps.setString(2,clubgb.gb(replaceTopic));
            pps.setString(3,clubgb.gb(replaceContent));
            pps.setString(4,clubgb.gb(replaceMsgTopic));
            pps.setString(5,clubgb.gb(replaceMsgContent));
            pps.setString(6,clubgb.gb(replaceUserPen));  
            pps.executeUpdate();
            pps.close();
            message = "数据更新完毕！";
            bea = true;
        }catch(Exception e){
            message = "数据更细发生错误，详细：" + e.toString();
            bea = false;
        }finally{
            con.close();
        }
        return bea;
    }
    public String getMessage(){
        return this.message;
    }
    public String getReplaceUserName(){
        return this.replaceUserName;
    }
    public String getReplaceUserPen(){
        return this.replaceUserPen;
    }
    public String getReplaceTopic(){
        return this.replaceTopic;
    }
    public String getReplaceContent(){
        return this.replaceContent;
    }
    public String getReplaceMsgTopic(){
        return this.replaceMsgTopic;
    }
    public String getReplaceMsgContent(){
        return this.replaceMsgContent;
    }
    public void setReplaceUserName(String str){
        this.replaceUserName = str;
    }
    public void setReplaceUserPen(String str){
        this.replaceUserPen = str;
    }
    public void setReplaceTopic(String str){
        this.replaceTopic = str;
    }
    public void setReplaceContent(String str){
        this.replaceContent = str;
    }
    public void setReplaceMsgTopic(String str){
        this.replaceMsgTopic = str;
    }
    public void setReplaceMsgContent(String str){
        this.replaceMsgContent = str;
    }
}