boardmanagercache.java

源码/软件简介: 云网论坛1.1RC国际版是采用JSP开发的集论坛、CMS（网站内容管理系统）、博客、聊天室、商城、交友、语音灌水等于一体的门户式社区。拥有CWBBS ( Cloud Web BBS

package com.redmoon.forum;

import cn.js.fan.base.ObjectCache;
import cn.js.fan.db.Conn;
import com.redmoon.forum.person.UserDb;
import java.sql.PreparedStatement;
import java.util.Vector;
import java.sql.ResultSet;

public class BoardManagerCache extends ObjectCache {
    final String BOARD_MANAGER = "BOARD_MGR_";

    public BoardManagerCache(BoardManagerDb bm) {
        super(bm);
    }

    public void setGroup() {
        group = "BOARDMANAGER_";
    }

    public void setGroupCount() {
        COUNT_GROUP_NAME = "BOARDMANAGER_COUNT_";
    }

    public void refreshBoardManagers(String boardCode) {
        try {
            rmCache.remove(BOARD_MANAGER + boardCode, group);
        }
        catch (Exception e) {
            logger.error("refreshBoardManagers:" + e.getMessage());
        }
    }

    public Vector getBoardManagers(String boardcode) {
        Vector managers = null;
        try {
            managers = (Vector)rmCache.getFromGroup(BOARD_MANAGER + boardcode, group);
        }
        catch (Exception e) {
            logger.error("getBoardManagers:" + e.getMessage());
        }
        if (managers!=null)
            return managers;
        managers = new Vector();
        String sql =
                "select name from sq_boardmanager where boardcode=? order by sort";
        ResultSet rs = null;
        Conn conn = new Conn(connname);
        UserDb user = new UserDb();
        try {
            PreparedStatement ps = conn.prepareStatement(sql);
            ps.setString(1, boardcode);
            rs = conn.executePreQuery();
            if (rs != null) {
                while (rs.next()) {
                    managers.addElement(user.getUser(rs.getString(1)));
                }
            }
            rmCache.putInGroup(BOARD_MANAGER + boardcode, group, managers);
        } catch (Exception e) {
            logger.error("getBoardManagers:" + e.getMessage());
        } finally {
            if (conn != null) {
                conn.close();
                conn = null;
            }
        }
        return managers;
    }
}