clubusergrade.java

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

package com.gamvan.club;
import com.gamvan.conn.*;
import com.gamvan.tools.*;
import java.sql.*;
/* Made in GamVan
 * 社区用户等级bean
 */
public class ClubUserGrade{
    private String ugTxt, ugName;
    private Statement sta;
    private int uoGradeID;
    private String message;
    private String sqlCommand =  new String();
    //建立数据库联接
    ConnClub bridge = new ConnClub();
    Gb clubgb = new Gb();
    public void userGradeEdit(int ugID) throws Exception{
        Connection con = bridge.getConnection();
        try{
            sta = con.createStatement();
            sqlCommand = "UPDATE GVclubUserGrade set ugTxt = '"+ ugTxt + "' where ugID = " + ugID;
            sta.executeUpdate(sqlCommand);
            sta.close();
        }catch(Exception e){
            con.close();
        }finally{
            con.close();
        }
    }
    public void userGradeInfo(String uoUser, int uoCID) throws Exception{
        Connection con = bridge.getConnection();
        try{
            ResultSet rs;
            sta = con.createStatement();
            sqlCommand = "SELECT * FROM GVclubUserop where uoIs=1 and uoUser='" + uoUser + "'";
            if(uoCID>0){
                sqlCommand += " and uoCID = "+ uoCID +"";
            }
            sqlCommand += " order by uoGradeID";
            message = sqlCommand;
            rs = sta.executeQuery(sqlCommand);
            if(rs.next()){
                uoGradeID = rs.getInt("uoGradeID");
            }else{
                uoGradeID = 8; //不在管理组则等级为注册用户
            }
            rs.close();
            sta.close();
        }catch(Exception e){
            uoGradeID = 10;
            con.close();
        }finally{
            con.close();
        }
    } 
    public void userGradeList(int ugID) throws Exception{
        Connection con = bridge.getConnection();
        try{
            ResultSet rs;
            sta = con.createStatement();
            sqlCommand = "SELECT * FROM GVclubUserGrade where ugID = " + ugID;
            rs = sta.executeQuery(sqlCommand);
            if(rs.next()){
                ugName = rs.getString("ugName");
                ugTxt = rs.getString("ugTxt");
            }
            rs.close();
            sta.close();
        }catch(Exception e){
            con.close();
        }finally{
            con.close();
        }
    } 
    public String getMessage(){
        return this.message;
    }
    public int getUoGradeID(){
        return this.uoGradeID;
    }
    public String getUgName(){
        return this.ugName;
    }
    public String getUgTxt(){
        return this.ugTxt;
    }
    public void setUgTxt(String ugTxt){
        this.ugTxt = ugTxt;
    }
}