petinfoaction.java

网上购物系统

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

import java.sql.PreparedStatement;
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.PetInfoDTO;

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

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

			return mapping.findForward("success");
}

  /**
   * @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 {
	  log.trace("Start");
	  try{
	  	PetInfoForm petInfoForm = ((PetInfoForm) form);
	    System.out.println("============>petinfoINNT");
	    
	    DatabaseConnection connection = DatabaseConnectionManager.getMyConnection();
	    PetInfoDAO dao = new PetInfoDAO(connection);
	    
	    System.out.println("============>getCondition-->"+petInfoForm.getCondition());
	    
	    int count = dao.countUsers(petInfoForm.getCondition());

	    petInfoForm.getPageInfo().setMaxRecordNum(count);
	   
	    if (count == 0) {
	      ActionMessages msgs = new ActionMessages();
	      msgs.add("all", new ActionMessage("没有查询到信息",false));
	      saveErrors(request, msgs);
	      return mapping.findForward("success");
	    }
	    System.out.println("++++++++++==");
	    List<PetInfoDTO> users = dao.searchUsers(petInfoForm.getCondition(), petInfoForm
	            .getPageInfo());
	    petInfoForm.setUsers(users);
		    
	  }catch(Exception e){
		  e.printStackTrace();
	  }
	  log.trace("End");
	  return mapping.findForward("success");
  }

  /**
   * @param mapping
   * @param form
   * @param request
   * @param response
   * @return ActionForward
   * @throws Exception
   */
  public ActionForward choose(ActionMapping mapping,
                             ActionForm form,
                             HttpServletRequest request,
                             HttpServletResponse response) throws Exception {
	    log.trace("Start");
	    PetInfoForm petInfoForm = ((PetInfoForm) form);
	    System.out.println("============>petinfochoose");
	    DatabaseConnection connection = DatabaseConnectionManager.getMyConnection();
	    PetInfoDAO dao = new PetInfoDAO(connection);
	    
	    System.out.println("===================getPetNo"+petInfoForm.getPname()+"=====");
	    System.out.println("===================getPetNo"+petInfoForm.getIndex()+"=====");   
	    PetInfoDTO petInfo = dao.findByPrimaryKey(petInfoForm.getIndex()); 
	    petInfoForm.setSpecies(petInfo.getSpecies());  
	    petInfoForm.setPrice(petInfo.getPrice());
	    petInfoForm.setPname(petInfo.getPname());
	    
	    log.trace("End");
	    return mapping.findForward("success");
	    }

  /**
   * @param mapping
   * @param form
   * @param request
   * @param response
   * @return ActionForward
   * @throws Exception
   */
  public ActionForward certain(ActionMapping mapping,
                             ActionForm form,
                             HttpServletRequest request,
                             HttpServletResponse response) throws Exception {
	    log.trace("Start");
	    PetInfoForm petInfoForm = ((PetInfoForm) form);
	    System.out.println("============>petinfocertain");
	    DatabaseConnection connection = DatabaseConnectionManager.getMyConnection();
	    String insertStat = "insert into tbl_pet(PET_NAME,PET_PRICE,PET_INFO,DEL_FLG,PET_COUNT) values(?,?,?,?,?)";
	    PreparedStatement ps = connection.prepareStatement(insertStat);
	    ps.setString(1,petInfoForm.getPname());
	    ps.setString(2,petInfoForm.getPrice());
	    ps.setString(3,petInfoForm.getSpecies());
	    ps.setString(4,"0"); 
	    ps.setString(5,petInfoForm.getPnumber());
	    ps.executeUpdate();
	    ps.close();
	    
	    System.out.println("============>petinfocertain end");
	    log.trace("End");
	    return mapping.findForward("certain");
	    }
}