loginbean.java

招标投标网上系统

/*
 * @(#)LoginBean.java
 *
 * Copyright 2003 by SYNTC, All rights reserved.
 *
 * This software is the confidential and proprietary information of SYNTC.
 * ("Confidential Information").
 */
package cn.com.syntc.webapp.business;

import javax.servlet.*;
import javax.servlet.http.*;

import cn.com.syntc.common.action.*;
import cn.com.syntc.common.io.*;
import cn.com.syntc.common.util.*;
import cn.com.syntc.common.type.*;
import cn.com.syntc.webapp.taglib.CheckLogin;
import cn.com.syntc.webapp.define.Constant;
import cn.com.syntc.webapp.session.UserSession;

/**
 * 进行登录的业务逻辑处理的例子<br>
 * @author wang yong
 * @version 1.0
 */
public class LoginBean extends BusinessLogic
{
  /**
   * 构造函数
   */
  public LoginBean()
  {
    System.out.println("FrameWork：业务处理类实例化完成【" + this.getClass().getName() + "】");
  }

  /**
   * 业务逻辑处理机能
   */
  public void execute(HttpServletRequest request, HttpServletResponse response, Parameters parameters) throws CommonException
  {
    String forwardPage = "/framework/exam/index.jsp";
    try
    {
      request.getSession().setMaxInactiveInterval(24*60*60);

      // 用户信息
      UserSession USession = new UserSession();

      SqlUtil sqlutil = new SqlUtil();

      String userid = (String)parameters.getParameters("request", "userid");
      String pwd = (String)parameters.getParameters("request", "pwd");

      String strSql = "SELECT A.USERID,A.USERNAME,A.NICENAME,A.PASSWORD,A.SEX,A.BIRTHDAY,A.OICQ,A.MAIL,A.ORGNAME,A.UNITNAME,A.HOMEPAGE,A.COMEFROM,A.INTRODUCTION,A.LASTLOGINTIME,B.ROLEID,B.ROLENAME,SYSDATE() AS LOGINTIME FROM USER_TBL A,ROLE_TBL B WHERE A.USERNAME='" + userid + "' AND A.PASSWORD='"+pwd+"' AND A.ROLEID = B.ROLEID AND A.ONOFF='1'";

      ResultSet resultset = sqlutil.executeQuery(strSql);

      // 验证成功
      if(resultset.next())
      {
        /**** 取得用户信息 ****/

        // 设置用户ID
        USession.setUserID(resultset.getString("USERID"));

        // 设置用户名
        USession.setUserName(resultset.getString("USERNAME"));

        // 设置用户别名
        USession.setNiceName(resultset.getString("NICENAME"));

        // 设置用户密码
//        USession.setPassword(resultset.getString("PASSWORD"));

        // 设置用户性别
        USession.setSex(resultset.getString("SEX"));

        // 设置出生年月
        USession.setBirthday(resultset.getString("BIRTHDAY"));

        // 设置用户QQ
        USession.setOicq(resultset.getString("OICQ"));

        // 设置用户邮件
        USession.setMail(resultset.getString("MAIL"));

        // 来自哪里
        USession.setComeFrom(resultset.getString("COMEFROM"));

        // 设置个人主页
        USession.setHomePage(resultset.getString("HOMEPAGE"));

        // 设置个人介绍
        USession.setIntroduction(resultset.getString("INTRODUCTION"));

        // 设置角色ID
        USession.setRoleID(Integer.parseInt(resultset.getString("ROLEID")));

        // 设置角色名
        USession.setRoleName(resultset.getString("ROLENAME"));

        // 设置所属单名称
        USession.setOrgName(resultset.getString("ORGNAME"));

        // 设置所属部门名称
        USession.setUnitName(resultset.getString("UNITNAME"));

        // 设置登录时间
        USession.setLoginTime(resultset.getString("LOGINTIME"));

        // 设置登录IP
        USession.setLogonIP(request.getRemoteAddr());

        // 修改最后登陆时间
        strSql = "UPDATE USER_TBL SET LASTLOGINTIME = SYSDATE()";
        sqlutil.preparedStatement(strSql);
        sqlutil.executeUpdate();

        forwardPage = "/ExamList.do";
        request.getSession().setAttribute("ActiveMenu", "0");
			}
      // 验证失败
      else
      {
        forwardPage = "/login.jsp";
      }

      sqlutil.close();

      request.getSession().setAttribute("UserSession", USession);
      parameters.setParameters("results", "ForwardPage", forwardPage);
    }
    catch(Exception ex)
    {
      forwardPage = "/error.jsp";
    }
  }

  /**
   * 页面表单检测处理机能
   */
  public void validate(HttpServletRequest request, HttpServletResponse response, Parameters parameters) throws CommonException
  {

  }
}