bbsboardgroupmanager.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 BBSBoardGroupManager
  extends RecordManager
{
  public BBSBoardGroupManager()
  {
  }

  protected final static String TableName = "BBSBoardGroup"; //定义声明本类操作表名称
  protected final static String IDFieldName = "ID"; //定义声明主键或者可以确定唯一记录的字段名称为“ID”，必须为自增整型
  protected final static String[] NumericFieldsName =
    {
    "OrderNumber", "ReqPower", "IsShow"}; //声明数值型字段名称
  protected final static String[] StringFieldsName =
    {
    "GroupName", "Content", "MultUserID", "MultSysID", "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 strGroupName String
   * @param stPower string
   * @param strContent 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 strGroupName, String strContent, String strPower, String strIsShow, String strMultUserID, String strMultSysID, String strOrderBy, String strIsDesc)
  {

    String strSQL = "select ID,GroupName,IsShow,ReqPower,Content,BuildTime,OrderNumber,MultUserID,MultSysID,Remark from " +
      TableName + " WHERE ID > 0";

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

    if (strGroupName.trim().length() > 0)
    {
      strSQL += " and [GroupName] like '%" + strGroupName + "%'";
    }
    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 (strMultUserID.trim().length() > 0)
    {
      strSQL += " and [MultUserID] like '" + strMultUserID + "'";

    }
    if (strMultSysID.trim().length() > 0)
    {
      strSQL += " and [MultSysID] like '" + strMultSysID + "'";
    }
    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 * FROM " + TableName);
       return vt;
   }

}