bbsboardmanager.java

一个目前正在上线运行的JSP企业网站系统

package com.gforce.gfoa;

/**
 * <p>Title: 西部信托网站项目</p>
 * <p>Description: 西部信托网站项目</p>
 * <p>Copyright: 版权所有 2004 (c) 西安吉力科技发展有限公司  Copyright (c) 2004 GForce Sceince & Technology</p>
 * <p>Company: 西安吉力科技发展有限公司 (GForce Sceince & Technology)</p>
 * @author 马登军
 * @version 1.0
 */
import com.gforce.currency.*;
import com.gforce.currency.database.*;
import java.util.*;

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

  protected final static String TableName = "BBSBoard"; //定义声明本类操作表名称
  protected final static String IDFieldName = "ID"; //定义声明主键或者可以确定唯一记录的字段名称为“ID”，必须为自增整型
  protected final static String[] NumericFieldsName =
    {"OrderNumber", "ReqPower", "IsShow", "GroupID"}; //声明数值型字段名称
  protected final static String[] StringFieldsName =
    {"BoardName", "Content", "BoardMasterIDs", "Remark"}; //声明字符型字段名称
  protected final static String[] DatetimeFieldsName =
    {"BuildTime"}; //声明日期时间型字段名称
  protected final static String[] TextFieldsName =
    {}; //声明大字符串型字段名称

  /**
   * 根据字段名称获取插入数据时表单元素名称
   * @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;
  }

  /**
   * 获取指定ID的数据集
   * @param iID 要检索的ID
   * @return 指定ID的数据集
   */
  public static Vector getRecordByID(int iID)
  {
    return getRecordBySearch("" + iID, "", "", "", "", "", "", "","");
  }

  /**
   * 获取指定ID的数据集
   * @param strIDs 要检索的ID
   * @return 指定ID的数据集
   */
  public static Vector getRecordByIDs(String strIDs)
  {
    return getRecordBySearch(strIDs, "", "", "", "", "", "", "","");
  }

  /**
   * 获取符合条件的数据集
   * @param strIDs String
   * @param strBoardName String
   * @param strContent String
   * @param stPower string
   * @param strIsShow String
   * @param strMultUserID String
   * @param strMultSysID String
   * @param strOrderBy String
   * @param strIsDesc String
   * @return Vector 获取符合条件的数据集
   */
  public static Vector getRecordBySearch(String strIDs, String strBoardName, String strContent, String strPower, String strIsShow, String strGroupID, String strBoardMasterIDs, String strOrderBy, String strIsDesc)
  {

    String strSQL = "select ID,BoardName,IsShow,ReqPower,Content,BuildTime,OrderNumber,GroupID,BoardMasterIDs,Remark from " +
      TableName + " WHERE ID > 0";

    if (strIDs.trim().length() > 0)
    {
      strSQL += " and ([ID] in (" + strIDs + "))";
    }

    if (strBoardName.trim().length() > 0)
    {
      strSQL += " and [BoardName] like '%" + strBoardName + "%'";
    }
    if (strContent.trim().length() > 0)
    {
      strSQL += " and [Content] like '%" + strContent + "%'";
    }
    if (strPower.trim().length() > 0)
    {
      strSQL += " and [ReqPower] <= " + strPower + "";
    }
    if (strIsShow.trim().length() > 0)
    {
      if (strIsShow.equalsIgnoreCase("True"))
      {
        strSQL += " and [IsShow] = 1";
      }
      else if (strIsShow.equalsIgnoreCase("False"))
      {
        strSQL += " and [Link] = 0";
      }
    }
    if (strGroupID.trim().length() > 0)
    {
      strSQL += " and [GroupID] in (" + strGroupID + ")";

    }
    if (strBoardMasterIDs.trim().length() > 0)
    {
      strSQL += " and ',' + [BoardMasterIDs] + ',' like '%," + strBoardMasterIDs + ",%'";
    }
    if (strOrderBy.trim().length() > 0)
    {
      if (strIsDesc.equalsIgnoreCase("True"))
      {
        strSQL += " Order by " + strOrderBy + " desc";
      }
      else
      {
        strSQL += " Order by " + strOrderBy + "";
      }
    }
    else
    {
      strSQL += " Order by OrderNumber";
    }
    Vector vt = SQLManager.GetResultSet(strSQL);
    return vt;
  }

  /**
   * 返回所有记录（＋分类名称）
   * @return Vector
   */
  public static Vector getAllRecord()
  {
      Vector vt = SQLManager.GetResultSet("SELECT a.*,b.GroupName FROM " + TableName +" as a " +
        " left outer join BBSBoardGroup as b on (a.GroupID = b.ID) where a.ID > 0" );
      return vt;
  }


}