useraction.java

网上购物系统

// ----------------------------------------------------------
// $Id: $
// Copyright (c) SHSAFE 2005-2006. All Rights Reserved.
// ----------------------------------------------------------
package example.user;

import java.sql.ResultSet;
import java.sql.Statement;
import java.util.List;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.action.ActionMessage;
import org.apache.struts.action.ActionMessages;

import com.shsafe.common.database.DatabaseConnection;
import com.shsafe.common.database.DatabaseConnectionManager;
import com.shsafe.common.struts.action.BaseAction;

import example.common.dto.UserDTO;

/**
 * @author Michael J Chane
 * @version $Revision: $ $Date: $
 */
public class UserAction extends BaseAction {

  /**
   * @param mapping
   * @param form
   * @param request
   * @param response
   * @return ActionForward
   * @throws Exception
   */
  public ActionForward search(ActionMapping mapping,
                              ActionForm form,
                              HttpServletRequest request,
                              HttpServletResponse response) throws Exception {
    UserForm userForm = ((UserForm) form);
    DatabaseConnection connection = DatabaseConnectionManager.getMyConnection();
    UserDAO dao = new UserDAO(connection);
    System.out.println("========>getCondition"+userForm.getCondition());
    int count = dao.countUsers(userForm.getCondition());
    
    userForm.getPageInfo().setMaxRecordNum(count);
    if (count == 0) {
      ActionMessages msgs = new ActionMessages();
      msgs.add("all", new ActionMessage("dataNotFound"));
      saveErrors(request, msgs);
      return mapping.findForward("failure");
    }
    List<UserDTO> dtoList = dao.searchUsers(userForm.getCondition(), userForm
        .getPageInfo());
    userForm.setListData(dtoList);
    return mapping.findForward("success");
  }

  /**
   * @param mapping
   * @param form
   * @param request
   * @param response
   * @return ActionForward
   * @throws Exception
   */
  public ActionForward update(ActionMapping mapping,
                              ActionForm form,
                              HttpServletRequest request,
                              HttpServletResponse response) throws Exception {

    UserForm userForm = ((UserForm) form);
    DatabaseConnection connection = DatabaseConnectionManager.getMyConnection();
    UserDAO dao = new UserDAO(connection);
    int count = dao.updateUsers(userForm.getListData());
    log.info(count + " rows updated!");
    ActionMessages msgs = new ActionMessages();
    msgs.add("all", new ActionMessage("Success"));
    saveMessages(request, msgs);
    return mapping.findForward("success");
  }
}