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());      }    }  }}