clubclassmanage.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 ClubClassManage{
    private String ccSummary = "";
    private String ccAffiche = "";
    private String message = "";
    private int ccID = 0;
    Gb clubgb = new Gb();
    public boolean classManage(String act){
        boolean bea = false;
        if(act.equals("确定发布")){
            if(bea){
                message= "公告已发布！";
            }else{
                message= "公告发布失败，请重新尝试！";
            }
        }else if(act.equals("确定更新")){
            if(bea){
                message= "公告更新成功！";
            }else{
                message= "公告更新失败，请重新尝试！";
            }
        }else if(act.equals("更新寄语")){
            bea = ccSummaryUpdate();
            if(bea){
                message= "版面寄语更新成功！";
            }else{
                message= "版面寄语更新失败，请重新尝试！";
            }
        }else{
            message= "您的操作触发一个美丽的意外，指令将不被执行，请重新尝试！";
        }
        return bea;
    }
    public boolean ccSummaryUpdate(){
        boolean bea = false;
        String sqlCommand = new String();
        try{
            ConnClub bridge = new ConnClub();
            Connection con = bridge.getConnection();
            ResultSet rs;
            sqlCommand = "Update GVclubClass set ccSummary=? where ccID=?";
            PreparedStatement pps = con.prepareStatement(sqlCommand);
            pps.setString(1,ccSummary);
            pps.setInt(2,ccID);
            pps.executeUpdate();
            pps.close();
            con.close();
            //message= "论坛寄语更新成功！";
            bea = true;
        }catch(Exception e){
            bea = false;
            message= "您的操作触发一个美丽的意外，指令将不被执行，请重新尝试！";
        }
        
        return bea;
    }
    public String getMessage(){
        return this.message;
    }
    public void setSummary(String ccSummary){
        ccSummary = clubgb.gb(ccSummary.trim());
        this.ccSummary = ccSummary;
    }
    public void setAffiche(String ccAffiche){
        ccAffiche = clubgb.gb(ccAffiche);
        this.ccAffiche = ccAffiche;
    }
    public void setCCID(int ccID){
        this.ccID = ccID;
    }
}