websitearticlemanager.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.sql.*;
import java.util.*;

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

    protected final static String TableName = "WebSiteArticle"; //定义声明本类操作表名称为“UserInfo”
    protected final static String IDFieldName = "ID"; //定义声明主键或者可以确定唯一记录的字段名称为“ID”，必须为自增整型
    protected final static String[] NumericFieldsName = {"ViewTimes","IsHot","WebSiteDirID","PublishUserID"}; //声明数值型字段名称
    protected final static String[] StringFieldsName = {
        "Title", "Author","Publisher","ThemeImage","KeyWords","FromURL"}; //声明字符型字段名称
    protected final static String[] DatetimeFieldsName = {"PublishDate"}; //声明日期时间型字段名称
    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 getRecordByWebSiteDirID(String strStation)
    {
        Vector vc = new Vector();
        vc = SQLManager.GetResultSet("select top 15 * from " + TableName + " where WebSiteDirID in(select id from WebSiteDirectory  where Station = '"+ strStation +"') ORDER BY PublishDate desc ");
        return vc;
    }

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

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


      /**
       * 获取符合条件的数据集
       * @param strIDs String
       * @param strTitle String
       * @param strAuthor String
       * @param strPublisher String
       * @param strFromURL String
       * @param strPublishStartDate String
       * @param strPublishEndDate String
       * @param strContent String
       * @param strViewTimes String
       * @param strHot String
       * @param strThemeImage String
       * @param strKeywords String
       * @param strWebSiteDirID String
       * @param strPublishUserID String
       * @param strOrderBy String
       * @param strIsDesc String
       * @return Vector 获取符合条件的数据集
       */
      public static Vector getRecordBySearch(String strIDs,String strTitle,String strAuthor,String strPublisher,String strFromURL,String strPublishStartDate,String strPublishEndDate,String strContent,String strViewTimes,String strHot,String strThemeImage,String strKeywords,String strWebSiteDirID,String strPublishUserID,String strOrderBy,String strIsDesc)
      {

        String strSQL = "select ID,Title,Author,Publisher,FromURL,PublishDate,Content,IsHot,ThemeImage,Keywords,WebSiteDirID,PublishUserID from " + TableName + " WHERE ID > 0";

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

        if (strTitle.trim().length() > 0)
        {
          strSQL += " and [Title] like '%" + strTitle + "%'";
        }
        if (strAuthor.trim().length() > 0)
        {
          strSQL += " and [Author] like '%" + strAuthor + "%'";
        }
        if (strPublisher.trim().length() > 0)
        {
          strSQL += " and [Publisher] like '%" + strPublisher + "%'";
        }
        if (strFromURL.trim().length() > 0)
        {
          strSQL += " and [FromURL] like '%" + strFromURL + "%' ";
        }
        if (strPublishStartDate.trim().length() > 0 && strPublishEndDate.trim().length() > 0 )
        {
          strSQL += " and [PublishDate] >= " + strPublishStartDate + " and [PublishDate]<=" + strPublishEndDate + " ";

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

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

        if (strHot.trim().length() > 0)
        {
          if (strHot.equalsIgnoreCase("True"))
          {
            strSQL += " and [IsHot] = 1";
          }
          else if (strHot.equalsIgnoreCase("False"))
          {
            strSQL += " and [IsHot] = 0";
          }
        }
        if (strThemeImage.trim().length() > 0)
        {
          strSQL += " and [ThemeImage] like '%" + strThemeImage + "%'";
        }
        if (strKeywords.trim().length() > 0)
        {
          strSQL += " and [Keywords] like '%" + strKeywords + "%'";
        }
        if (strWebSiteDirID.trim().length() > 0)
        {
          strSQL += " and ([WebSiteDirID] in (" + strWebSiteDirID + "))";

        }
        if (strPublishUserID.trim().length() > 0)
        {
          strSQL += " and ([PublishUserID] in (" + strPublishUserID + "))";
        }
        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;
    }

    /**
     * 获取符合指定搜索条件记录的数据集
     * @param strIDs String
     * @param strTitle String
     * @param strAuthor String
     * @param strPublisher String
     * @param strFromURL String
     * @param strPublishDateFrom String
     * @param strPublishDateTo String
     * @param strContent String
     * @param strIsHot String
     * @param strKeywords String
     * @param strWebSiteDirID String
     * @param strPublishUserID String
     * @param strPublishUserName String
     * @param strMultUserID String
     * @param strMultSysID String
     * @param strOrderBy String
     * @param strIsDesc String
     * @return Vector 符合指定搜索条件记录的数据集
     */
    public static Vector getRecordBySearch(String strIDs,String strTitle,String strAuthor,String strPublisher,String strFromURL,String strPublishDateFrom,String strPublishDateTo,String strContent,String strIsHot,String strKeywords,String strWebSiteDirID,String strPublishUserID,String strPublishUserName,String strMultUserID,String strMultSysID,String strOrderBy,String strIsDesc)
    {
      String strSQL = "select a.[ID],a.[Title],a.[Author],a.[Publisher],a.[FromURL],a.[PublishDate],a.[Content],a.[ViewTimes],a.[IsHot],a.[ThemeImage],a.[Keywords],a.[WebSiteDirID],a.[PublishUserID],b.[Name],d.[Name] from " + TableName + " as a left outer join WebSiteDirectory as b on (a.[WebSiteDirID]=b.[ID]) left outer join UserInfo as c on (a.[PublishUserID]=c.[ID]) left outer join PersonnelInfo as d on(c.[PersonnelID]=d.[ID]) WHERE a.[ID] > 0";
      if (strIDs.trim().length() > 0)
      {
        strSQL += " and (a.[ID] in (" + strIDs + "))";
      }

      if (strTitle.trim().length() > 0)
      {
        strSQL += " and a.[Title] like '%" + strTitle + "%'";
      }
      if (strAuthor.trim().length() > 0)
      {
        strSQL += " and a.[Author] like '%" + strAuthor + "%'";
      }
      if (strPublisher.trim().length() > 0)
      {
        strSQL += " and a.[Publisher] like '%" + strPublisher + "%'";
      }
      if (strFromURL.trim().length() > 0)
      {
        strSQL += " and a.[FromURL] like '%" + strFromURL + "%' ";
      }
      if (strPublishDateFrom.trim().length() > 0)
      {
        strSQL += " and a.[PublishDate]>='" + strPublishDateFrom + " 00:00:00.000'";
      }
      if (strPublishDateTo.trim().length() > 0)
      {
        strSQL += " and a.[PublishDate]<='" + strPublishDateTo + " 23:59:59.999'";
      }
      if (strContent.trim().length() > 0)
      {
        strSQL += " and a.[Content] like '%" + strContent + "%'";

      }
      if (strIsHot.trim().length() > 0)
      {
        if (strIsHot.equalsIgnoreCase("True"))
        {
          strSQL += " and a.[IsHot] = 1";
        }
        else if (strIsHot.equalsIgnoreCase("False"))
        {
          strSQL += " and a.[IsHot] = 0";
        }
      }
      if (strKeywords.trim().length() > 0)
      {
        strSQL += " and '%' + a.[Keywords] + '%' like '%" + strKeywords + "%'";
      }
      if (strWebSiteDirID.trim().length() > 0)
      {
        strSQL += " and (a.[WebSiteDirID] in (Select ID from WebSiteDirectory where ID in(" + strWebSiteDirID + ") or Station like (Select Station + convert(varchar,ID) + '_%' from WebSiteDirectory where ID in (" + strWebSiteDirID + "))))";

      }
      if (strPublishUserID.trim().length() > 0)
      {
        strSQL += " and (a.[PublishUserID] in (" + strPublishUserID + "))";
      }
      if(strPublishUserName.trim().length()>0)
      {
        strSQL += " and (d.[Name] like '%" + strPublishUserName + "%')";
      }
      if(strMultUserID.trim().length()>0)
      {
        strSQL += " and (b.[MultUserID] like '%" + strMultUserID + "%')";
      }
      if(strMultSysID.trim().length()>0)
      {
        strSQL += " and (b.[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 a.[ID] desc";
      }
      Vector vt = SQLManager.GetResultSet(strSQL);
      return vt;
  }
}