bbsmanager.java

一个完整的

package com.gforce.gfoa;

/**
 * <p>Title: 吉力科技办公自动化系统</p>
 * <p>Description: 吉力科技办公自动化系统</p>
 * <p>Copyright: 版权所有 2003 (c) 西安吉力科技发展有限公司  Copyright (c) 2003 GForce Sceince & Technology</p>
 * <p>Company: 西安吉力科技发展有限公司 (GForce Sceince & Technology)</p>
 *  在线论坛管理类
 *  @author 王江涛
 * @version 1.0
 */

import com.gforce.currency.database.*;
import com.gforce.currency.*;
import java.util.*;

public class BBSManager
    extends RecordManager
{
    public BBSManager()
    {
    }

    protected final static String TableName = "BBSInfo"; //定义声明本类操作表名称
    protected final static String IDFieldName = "ID"; //定义声明主键或者可以确定唯一记录的字段名称为“ID”，必须为自增整型
    protected final static String[] NumericFieldsName =
        {"PublishUserID", "FaceID","SysDirID","ViewTimes"}; //声明数值型字段名称
    protected final static String[] DatetimeFieldsName =
        {"PublishTime"}; //声明日期时间型字段名称
    protected final static String[] StringFieldsName =
        {"Title", "Station"}; //声明字符型字段名称
    protected final static String[] TextFieldsName =
        {"Content"}; //声明大字符串型字段名称

    /* * 根据字段名称获取插入数据时表单元素名称
     * @param strFieldName  字段名称
     * @return  表单素名称
     */
    protected String InsertParament(String strFieldName)
    {
        return "" + strFieldName + ""; //可以根据需要加前缀、后缀
    }

    /**
     * 根据字段名称获取修改数据时表单元素名称
     * @param strFieldName  字段名称
     * @return  表单素名称
     */
    protected String UpdateParament(String strFieldName)
    {
        return "" + strFieldName + ""; //可以根据需要加前缀、后缀
    }

    /**
     * 获取本类操作表名称
     * @return  表名称
     */
    public String getTableName()
    { //获取本类操作表名称
        return TableName;
    }

    protected String getIDFieldName()
    { //获取主键或者可以确定唯一记录的字段名称
        return IDFieldName;
    }

    protected String[] getNumericFieldsName()
    { //获取数值型字段名称
        return NumericFieldsName;
    }

    protected String[] getStringFieldsName()
    { //获取字符型字段名称
        return StringFieldsName;
    }

    protected String[] getDatetimeFieldsName()
    { //获取日期时间型字段名称
        return DatetimeFieldsName;
    }

    protected String[] getTextFieldsName()
    { //获取大字符串型字段名称
        return TextFieldsName;
    }

    /**
     * 获取所有记录向量集
     * @return 所有记录向量集
     */
    public static Vector getAllRecord()
    {
        Vector vt = SQLManager.GetResultSet("SELECT " + TableName + ".*,PersonnelInfo.Name FROM " + TableName +
                                            " left outer join UserInfo on (" + TableName +
            ".PublishUserID=UserInfo.ID) left outer join PersonnelInfo on (UserInfo.PersonnelID=PersonnelInfo.ID) order by "+TableName+".ID desc");
        return vt;
    }
    /**
     * 获取所有地文章（不包括回复）。
     * @return 数据集
     */
    public static Vector getAllBBSRecord()
    {
        Vector vt = SQLManager.GetResultSet("SELECT " + TableName + ".*,PersonnelInfo.Name FROM " + TableName +
                                            " left outer join UserInfo on (" + TableName +
            ".PublishUserID=UserInfo.ID) left outer join PersonnelInfo on (UserInfo.PersonnelID=PersonnelInfo.ID)"+
            " WHERE Station = '_0_' order by " + TableName + ".ID desc");
        return vt;
    }

    public static Vector getBBSRevertRecord(String strStation)
    {
        Vector vt = SQLManager.GetResultSet("SELECT * FROM " + TableName + " WHERE Station = '"+strStation+"' ORDER BY " +
            TableName + ".ID desc");
        return vt;
    }

    /**
     * 通过ID获取指定记录
     * @param intRecordID  记录ID
     * @return 指定记录向量集
     */
    public static Vector getRecordByID(int intRecordID)
    {
        Vector vt = SQLManager.GetResultSet("SELECT * FROM " + TableName + " WHERE ID = " + intRecordID+"");
        return vt;
    }

    /**
     * 获取属于指定系统目录下的记录向量集
     * @param iSysDirID  系统目录ID
     * @return  属于指定系统目录下的记录向量集
     */
    public static Vector getRecordBySysDirID(int iSysDirID)
    {
        Vector vt = SQLManager.GetResultSet("SELECT "+TableName+".*,PersonnelInfo.Name FROM " + TableName +
                                            " left outer join UserInfo on (" + TableName +
                                            ".PublishUserID=UserInfo.ID) left outer join PersonnelInfo on (UserInfo.PersonnelID=PersonnelInfo.ID)"+
                                            " WHERE SysDirID=" + iSysDirID +" AND Station = '_0_'"+
                                            " order by "+TableName+".ID desc");
        return vt;
    }

    /**
     * 将指定记录的浏览次数加1
     * @param intID  记录ID
     */
    public static void UpdateReocordView(int intID)
    {
        SQLManager.ExcuteSQL("Update " + TableName + " set ViewTimes=(ViewTimes+1) where ID = " + intID+"");
    }

    /**
     * 获取指定文章地恢复文章数目。
     * @param intID 指定地文章
     * @return  恢复地文章地总数
     */
    public static String getArtilceStatistics(int intID)
    {
        Vector vt = SQLManager.GetResultSet("SELECT Count(*) FROM "+TableName+" WHERE station = ((SELECT Station FROM "+
                                            TableName+" WHERE ID = "+intID+")+'"+intID+"_')");
        return ((Vector)vt.get(0)).get(0).toString();
    }

    /**
     * 重构父类RecordManager地DeleteByID方法，首先删除记录相关地文章。
     * @param iID 要删除地记录ID
     * @return
     */
    public int DeleteByID(int iID)
    {
        SQLManager.ExcuteSQL("Delete from " + TableName + " where Station like ((select Station from " + TableName + " where ID=" + iID +") + '" + iID +"_%')");
        int iReturnValue = super.DeleteByID(iID);
        return iReturnValue;
    }

}