bbspostmanager.java

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

package com.gforce.gfoa;

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


/**
 * <p>Title: 西国投网站</p>
 * <p>Description: 西安国际信托投资有限公司网站项目</p>
 * <p>Copyright: 版权所有 2004 (c) 西安吉力科技发展有限公司  Copyright (c) 2004 GForce Sceince & Technology Co.,LTD</p>
 * <p>Company: 西安吉力科技发展有限公司 (2004 GForce Sceince & Technology Co.,LTD)</p>
 * @author zhangshixia
 * @version 1.0
 */

public class BBSPostManager extends RecordManager
{
  public BBSPostManager()
  {
  }
   protected final static String TableName = "BBSPost"; //定义声明本类操作表名称
   protected final static String IDFieldName = "ID"; //定义声明主键或者可以确定唯一记录的字段名称为“ID”，必须为自增整型
   protected final static String[] NumericFieldsName =
     {
     "OrderNumber", "MinArticleNum","PowerLevel", "IsShow"}; //声明数值型字段名称
   protected final static String[] StringFieldsName =
     {
     "PostName", "Content", "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 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 strPostName, String strIsShow, String strContent, String strMultUserID, String strMultSysID, String strMinArticleNum,String strPowerLevel, 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 (strPostName.trim().length() > 0)
     {
       strSQL += " and [GroupName] like '%" + strPostName + "%'";
     }
     if (strContent.trim().length() > 0)
     {
       strSQL += " and [Content] like '%" + strContent + "%'";
     }
     if (strPowerLevel.trim().length() > 0)
     {
       strSQL += " and [PowerLevel] <= " + strPowerLevel + "";
     }
     if (strMinArticleNum.trim().length() > 0)
     {
       strSQL += " and [MinArticleNum] >= " + strMinArticleNum + "";
     }

     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;
    }

 }