usermanagerbean.java

招标投标网上系统

/*
 * @(#)BusinessBean.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;

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

  /**
   * 业务逻辑处理机能
   */
  public void execute(HttpServletRequest request, HttpServletResponse response, Parameters parameters) throws CommonException{
    try{

      String strSql = "";

      SqlUtil sqlutil = new SqlUtil();

      String command = request.getParameter("command")==null?"":request.getParameter("command");

      if(command.equals("del"))
      {
        String userid[] = null;
        if(request.getParameterValues("userid")!=null)
        {
          userid = (String[])request.getParameterValues("userid");
          for(int i=0; i<userid.length; i++)
          {
            // 删除用户
            strSql = "DELETE FROM USER_TBL WHERE USERID = '" + userid[i] + "'";
            sqlutil.executeUpdate(strSql);
          }
        }
      }
      else if(command.equals("onoff"))
      {
        String userid = "";
        if(request.getParameter("userid")!=null)
        {
          userid = (String)request.getParameter("userid");

        }

        String onoff = "0";
        if(request.getParameter("onoffvalue")!=null)
        {
          onoff = (String)request.getParameter("onoffvalue");
        }

          // 改变用户可用状态
          strSql = "UPDATE USER_TBL SET ONOFF='" + onoff + "' WHERE USERID = '" + userid + "'";
          sqlutil.executeUpdate(strSql);
      }
      else
      {
      }

      strSql = "SELECT A.USERID,A.USERNAME,A.NICENAME,A.PASSWORD,A.SEX,A.BIRTHDAY,EXTRACT(YEAR FROM A.BIRTHDAY) AS YEAR,EXTRACT(MONTH FROM A.BIRTHDAY) AS MONTH,EXTRACT(DAY FROM A.BIRTHDAY) AS DAY,A.OICQ,A.MAIL,A.ORGNAME,A.UNITNAME,A.HOMEPAGE,A.COMEFROM,A.INTRODUCTION,A.LASTLOGINTIME,B.ROLEID,B.ROLENAME,SYSDATE() AS LOGINTIME,A.ONOFF FROM USER_TBL A,ROLE_TBL B WHERE A.ROLEID = B.ROLEID ORDER BY A.ROLEID,A.ORGNAME,A.UNITNAME,A.CREATETIME,A.USERID";
      ResultSet resultset = sqlutil.executeQuery(strSql);

      parameters.setParameters("results","UserList", resultset);

      sqlutil.close();

      parameters.setParameters("results", "ForwardPage", "/framework/exam/usermanager.jsp");
    }
    catch(Exception ex){
      ;
    }
  }


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


  }

}