homeaction.java

使用eclipse开发的web程序

package com.wrox.tourism.actions;

import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.Action;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.action.ActionErrors;
import org.apache.struts.action.ActionError;
import org.apache.struts.action.ActionServlet;

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

import java.io.IOException;

import java.sql.Connection;
import java.sql.SQLException;

import java.util.Collection;

import com.wrox.tourism.db.util.ConnectionPool;
import com.wrox.tourism.db.AttractionDAO;

public class HomeAction extends Action {

  private ConnectionPool pool;

  public HomeAction() {
    pool = ConnectionPool.getInstance();
  }

  public ActionForward perform(ActionMapping mapping,ActionForm form,
    HttpServletRequest request,HttpServletResponse response)
      throws IOException,ServletException {

    Connection con = null;

    try {
      con = pool.getConnection();
      AttractionDAO attractionDAO = new AttractionDAO(con);
      Collection col = attractionDAO.findAll();
      request.setAttribute(BeanNames.ATTRACTION_LIST,col);
      return mapping.findForward("success");
    } catch (SQLException e) {
      e.printStackTrace();
      throw new RuntimeException("Unable to get connection.");
    } finally {
      try {
        if (con != null)
          con.close();
      } catch (SQLException e) {
        throw new RuntimeException(e.getMessage());
      }
    }

  }

}