clubrule.java

特色说明： 1.沿袭今晚在线论坛独有的双风格分桢形式 2.社区最多可进行3级分类

/*
 * Made in GamVan
 * 社区制度相关信息
 */
package com.gamvan.club;
import com.gamvan.conn.*;
import com.gamvan.tools.*;
import java.sql.*;
public class ClubRule{
    private String crMark = new String("");
    private String crMoney = new String("");
    private String crCredit = new String("");
    // 提取制度
    public void getClubRule() throws Exception{
            ConnClub bridge = new ConnClub();
            Connection con = bridge.getConnection();
        try{
            ResultSet rs;
            String sqlCommand;
            ClubRule cr = new ClubRule();
            sqlCommand = "Select * From GVclubRule";
            PreparedStatement pps = con.prepareStatement(sqlCommand);
            rs = pps.executeQuery();
            if(rs.next()){
                crMark = rs.getString(2);
                crMoney = rs.getString(3);
                crCredit = rs.getString(4);
            }    
            rs.close();
            pps.close();
        }catch(Exception e){
            con.close();
            P.rint(e.toString());
        }finally{
            con.close();
        }
    }
    public void setClubRule() throws Exception{
            ConnClub bridge = new ConnClub();
            Connection con = bridge.getConnection();
        try{
            ResultSet rs;
            String sqlCommand;
            ClubRule cr = new ClubRule();
            sqlCommand = "UPDATE GVclubRule set crMark = ?, crMoney=?, crCredit=?";
            PreparedStatement pps = con.prepareStatement(sqlCommand);
            pps.setString(1,crMark);
            pps.setString(2,crMoney);
            pps.setString(3,crCredit);
            pps.executeUpdate();
            pps.close();
        }catch(Exception e){
            P.rint(e.toString());
            con.close();
        }finally{
            con.close();
        }
    }
    public String getCrCredit(){
        return this.crCredit.trim();
    }
    public String getCrMark(){
        return this.crMark.trim();
    }
    public String getCrMoney(){
        return this.crMoney.trim();
    }
    public void setCrCredit(String crCredit){
        this.crCredit = crCredit.trim();
    }
    public void setCrMark(String crMark){
        this.crMark = crMark.trim();
    }
    public void setCrMoney(String crMoney){
        this.crMoney = crMoney.trim();
    }
}