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

  protected final static String TableName = "WebSiteDirectory"; //定义声明本类操作表名称为“UserInfo”
  protected final static String IDFieldName = "ID"; //定义声明主键或者可以确定唯一记录的字段名称为“ID”，必须为自增整型
  protected final static String[] NumericFieldsName =
    {
    "LevelNumber", "ChildrenAcount", "OrderNumber", "IsLink", "IsShow"}; //声明数值型字段名称
  protected final static String[] StringFieldsName =
    {
    "Name", "Station", "OpenedICO", "CloseedICO", "LinkUrl", "Target",
    "Content", "InfoType", "PageTempletFile", "MultUserID", "MultSysID",
    "Remark"}; //声明字符型字段名称
  protected final static String[] DatetimeFieldsName =
    {}; //声明日期时间型字段名称
  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 getRecordByID(String strIDs)
  {
    return getRecordBySearch(strIDs, "", "", "", "", "", "", "", "", "", "",
                             "", "", "", "", "");
  }


  /**
   * 获取指定用户、指定系统、指定级别、指定是否显示的网站栏目数据
   * @param strMultUserID String 多用户用户ID
   * @param strMultSysID String 多系统系统ID
   * @param strLevelNumber String 栏目级别
   * @param strIsShow String 是否显示
   * @return Vector 符合条件的网站栏目数据
   */
  public static Vector getWebSiteDirData(String strMultUserID,String strMultSysID,String strLevelNumber,String strIsShow)
  {
    return getRecordBySearch("","","",strLevelNumber,"","","","","",strIsShow,"","",strMultUserID,strMultSysID,"","");
  }
  /**
   * 获取指定用户、指定系统、指定级别的网站栏目数据
   * @param strMultUserID String 多用户用户ID
   * @param strMultSysID String 多系统系统ID
   * @param strLevelNumber String 栏目级别
   * @return Vector 符合条件的网站栏目数据
   */
  public static Vector getWebSiteDirData(String strMultUserID,String strMultSysID,String strLevelNumber)
  {
    return getWebSiteDirData(strMultUserID,strMultSysID,strLevelNumber,"True");
  }

  /**
   * 获取符合条件的数据集
   * @param strIDs String
   * @param strName String
   * @param strStation String
   * @param strLevelNumber String
   * @param strChildrenAcount String
   * @param strLinkURL String
   * @param strTarget String
   * @param strIsLink String
   * @param strContent String
   * @param strIsShow String
   * @param strInfoType String
   * @param strPageTempletFile String
   * @param strMultUserID String
   * @param strMultSysID String
   * @param strOrderBy String
   * @param strIsDesc String
   * @return Vector 获取符合条件的数据集
   */
  public static Vector getRecordBySearch(String strIDs, String strName,
                                         String strStation,
                                         String strLevelNumber,
                                         String strChildrenAcount,
                                         String strLinkURL, String strTarget,
                                         String strIsLink, String strContent,
                                         String strIsShow, String strInfoType,
                                         String strPageTempletFile,
                                         String strMultUserID,
                                         String strMultSysID, String strOrderBy,
                                         String strIsDesc)
  {

    String strSQL = "select ID,Name,Station,LevelNumber,ChildrenAcount,OrderNumber,OpenedICO,CloseedICO,LinkUrl,Target,IsLink,Content,IsShow,InfoType,PageTempletFile,MultUserID,MultSysID,Remark from " +
      TableName + " WHERE ID > 0";

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

    if (strName.trim().length() > 0)
    {
      strSQL += " and [Name] like '%" + strName + "%'";
    }
    if (strStation.trim().length() > 0)
    {
      strSQL += " and [Station] like '%" + strStation + "%'";
    }
    if (strLevelNumber.trim().length() > 0)
    {
      strSQL += " and ([LevelNumber] in (" + strLevelNumber + "))";
    }
    if (strChildrenAcount.trim().length() > 0)
    {
      strSQL += " and ([ChildrenAcount] in (" + strChildrenAcount + "))";
    }
    if (strLinkURL.trim().length() > 0)
    {
      strSQL += " and [LinkURL] like '%" + strLinkURL + "%'";

    }
    if (strTarget.trim().length() > 0)
    {
      strSQL += " and [Target] like '%" + strTarget + "%'";

    }
    if (strIsLink.trim().length() > 0)
    {
      if (strIsLink.equalsIgnoreCase("True"))
      {
        strSQL += " and [IsLink] = 1";
      }
      else if (strIsLink.equalsIgnoreCase("False"))
      {
        strSQL += " and [IsLink] = 0";
      }
    }
    if (strContent.trim().length() > 0)
    {
      strSQL += " and [Content] like '%" + strContent + "%'";

    }
    if (strIsShow.trim().length() > 0)
    {
      if (strIsShow.equalsIgnoreCase("True"))
      {
        strSQL += " and [IsShow] = 1";
      }
      else if (strIsShow.equalsIgnoreCase("False"))
      {
        strSQL += " and [Link] = 0";
      }
    }
    if (strInfoType.trim().length() > 0)
    {
      strSQL += " and [InfoType] like '%" + strInfoType + "%'";
    }
    if (strPageTempletFile.trim().length() > 0)
    {
      strSQL += " and [PageTempletFile] like '%" + strPageTempletFile + "%'";
    }
    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"))