bbsuserinfomanager.java

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

package com.gforce.gfoa;

/**
 * <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 zhanghshixia
 * @version 1.0
 */

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

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

  protected final static String TableName = "BBSUserInfo"; //定义声明本类操作表名称
  protected final static String IDFieldName = "ID"; //定义声明主键或者可以确定唯一记录的字段名称为“ID”，必须为自增整型
  protected final static String[] NumericFieldsName =
    {
    "LoginTimes", "PostID", "ArticleNum", "StyleID", "IsPubEmail"
  }; //声明数值型字段名称
  protected final static String[] StringFieldsName =
    {
    "UserName", "Password", "Question", "Answer", "NickName", "SignInfo",
    "EMail", "RealName", "LinkWay", "LastLoginIP", "Expression", "MultUserID",
    "MultSysID", "Remark"
  }; //声明字符型字段名称
  protected final static String[] DatetimeFieldsName =
    {
    "RegTime", "LastLoginTime"
  }; //声明日期时间型字段名称
  protected final static String[] TextFieldsName =
    {}; //声明大字符串型字段名称

  protected String[] getNumericFieldsName()
  {
    return NumericFieldsName;
  }

  /**
   * 获得主键
   * @return 主键
   */
  protected String getIDFieldName()
  {
    return IDFieldName;
  }

  /**
   * 得到所操作表明称
   * @return 表名
   */
  public String getTableName()
  {
    return TableName;
  }

  /**
   * 根据字段名称获取修改数据时表单元素名称
   * @param strFieldName  字段名称
   * @return  表单素名称
   */
  protected String UpdateParament(String strFieldName)
  {
    return "" + strFieldName + ""; //可以根据需要加前缀、后缀
  }

  /**
   * 获取日期时间型字段名称
   * @return 字段名称
   */
  protected String[] getDatetimeFieldsName()
  {
    return DatetimeFieldsName;
  }

  /**
   * 获得字符串型字段名称
   * @return 字段名称（数组）
   */
  protected String[] getStringFieldsName()
  {
    return StringFieldsName;
  }

  /**
   * 根据字段名称获取插入数据时表单元素名称
   * @param strFieldName  字段名称
   * @return  表单素名称
   */
  protected String InsertParament(String strFieldName)
  {
    return "" + strFieldName + ""; //可以根据需要加前缀、后缀
  }

  /**
   * 获得大字符串型字段名称
   * @return 字段数组
   */
  protected String[] getTextFieldsName()
  {
    return TextFieldsName;
  }

  /**
   *检查用户登录是否正确，并返回用户ID
   * @param strUserName  用户名
   * @param strPassword  用户密码
   * @return  用户信息集
   */
  public static Vector CheckLogin(String strUserName, String strPassword)
  {
    int intID;
    Vector returnVector = null;
    Vector vt = SQLManager.GetResultSet(
      "Select ID from BBSUserInfo where UserName = '" + strUserName.toLowerCase() +
      "' and Password = '" + strPassword + "'");
    if (vt.size() > 0)
    {
      intID = Integer.parseInt( ( (Vector) vt.get(0)).get(0).toString());
      String strSql =
        "SELECT a.ID,a.UserName,a.Password,a.Question,a.Answer,a.NickName," +
        "a.SignInfo,a.EMail,a.RealName,a.LinkWay,a.RegTime,a.LastLoginTime,a.LastLoginIP," +
        "a.LoginTimes,a.PostID,a.ArticleNum,a.Expression,a.StyleID,a.MultUserID,a.MultSysID," +
        "a.Remark,a.IsPubEMail,b.PostName,b.PowerLevel FROM " + TableName +
        " as a " +
        " left outer join BBSPost as b on (a.PostID = b.ID) where a.ID = " +
        intID;
      Vector vtAll = SQLManager.GetResultSet(strSql);
      returnVector = vtAll;
    }
    return returnVector;
  }

  /**
   * 获取指定ID的数据集
   * @param iBBSUserID int
   * @return 指定ID的数据集
   */
  public static Vector getBBSUserInfoByID(int iBBSUserID)
  {
    return getBBSUserBySearch("" + iBBSUserID, "", "", "", "", "", "", "", "",
                              "", "",
                              "", "", "", "", "", "", "", "", "");
  }

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

  /**
   * 得到符合条件的数据集
   * @param strIDs String
   * @param strUserName String
   * @param strNickName String
   * @param strSignInfo String
   * @param strEMail String
   * @param strRealName String
   * @param strLinkWay String
   * @param strLoginTimes String
   * @param strPostID String
   * @param strArticleNum String
   * @param strExpression String
   * @param strStyleID String
   * @param strMultUserID String
   * @param strMultSysID String
   * @param strRemark String
   * @param strIsPubEmail String
   * @param strPostName String
   * @param strPowerLevel String
   * @param strOrderBy String
   * @param strIsDesc String
   * @return  Vector 数据集
   */

  public static Vector getBBSUserBySearch(String strIDs, String strUserName,
                                          String strNickName,
                                          String strSignInfo, String strEMail,
                                          String strRealName,
                                          String strLinkWay,
                                          String strLoginTimes,
                                          String strPostID,
                                          String strArticleNum,
                                          String strExpression,
                                          String strStyleID,
                                          String strMultUserID,
                                          String strMultSysID, String strRemark,
                                          String strIsPubEmail,
                                          String strPostName,
                                          String strPowerLevel,
                                          String strOrderBy, String strIsDesc)
  {
    String strSQL =
      "SELECT a.ID,a.UserName,a.Password,a.Question,a.Answer,a.NickName," +
      "a.SignInfo,a.EMail,a.RealName,a.LinkWay,a.RegTime,a.LastLoginTime,a.LastLoginIP," +
      "a.LoginTimes,a.PostID,a.ArticleNum,a.Expression,a.StyleID,a.MultUserID,a.MultSysID," +
      "a.Remark,a.IsPubEMail,b.PostName,b.PowerLevel FROM " + TableName +
      " as a left outer join BBSPost as b on (a.PostID = b.ID) where a.ID > 0";

    /**
     *   "SELECT ID,UserName,Password,Question,Answer,NickName," +
      "SignInfo,EMail,RealName,LinkWay,RegTime,LastLoginTime,LastLoginIP," +
      "LoginTimes,PostID,ArticleNum,Expression,StyleID,MultUserID,MultSysID," +
      "Remark,IsPubEMail FROM " + TableName +" where ID > 0 ";
     */

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

    if (strUserName.trim().length() > 0)
    {
      strSQL += " and a.[UserName] like '%" + strUserName + "%'";
    }
    if (strNickName.trim().length() > 0)
    {
      strSQL += " and a.[NickName] like '%" + strNickName + "%'";
    }
    if (strSignInfo.trim().length() > 0)
    {
      strSQL += " and a.SignInfo like '%" + strSignInfo + "%'";
    }

    if (strEMail.trim().length() > 0)
    {
      strSQL += " and a.EMail like '%" + strEMail + "%'";
    }

    if (strRealName.trim().length() > 0)
    {
      strSQL += " and a.RealName like '%" + strRealName + "%'";
    }

    if (strLinkWay.trim().length() > 0)
    {
      strSQL += " and a.LinkWay like '%" + strLinkWay + "%'";
    }

    if (strLoginTimes.trim().length() > 0)
    {
      strSQL += " and a.LoginTimes >= '" + strLoginTimes + "'";
    }

    if (strPostID.trim().length() > 0)
    {
      strSQL += " and (a.PostID in (" + strPostID + "))";
    }

    if (strArticleNum.trim().length() > 0)
    {
      strSQL += " and a.ArticleNum >= '" + strArticleNum + "'";
    }
    if (strExpression.trim().length() > 0)
    {
      strSQL += " and a.Expression = '" + strExpression + "'";
    }
    if (strStyleID.trim().length() > 0)
    {
      strSQL += " and a.StyleID = '" + strStyleID + "'";
    }
    if (strIsPubEmail.trim().length() > 0)
    {
      strSQL += " and a.IsPubEmail = '" + strIsPubEmail + "'";
    }

    if (strMultUserID.trim().length() > 0)
    {
      strSQL += " and a.MultUserID = '" + strMultUserID + "'";
    }

    if (strMultSysID.trim().length() > 0)
    {
      strSQL += " and a.MultSysID = '" + strMultSysID + "'";
    }

    if (strRemark.trim().length() > 0)
    {
      strSQL += " and a.Remark like '%" + strRemark + "%'";
    }

    if (strPostName.trim().length() > 0)
    {
      strSQL += " and a.PostName like '%" + strPostName + "%'";
    }

    if (strPowerLevel.trim().length() > 0)
    {
      strSQL += " and a.PostName = '" + strPowerLevel + "'";
    }

    if (strOrderBy.trim().length() > 0)
    {
      if (strIsDesc.equalsIgnoreCase("True"))
      {
        strSQL += " Order by " + strOrderBy + " desc";
      }
      else
      {
        strSQL += " Order by " + strOrderBy + "";
      }
    }
    else
    {
      strSQL += " Order by ArticleNum";
    }

    Vector vt = SQLManager.GetResultSet(strSQL);
    return vt;
  }
}