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.EventDAO;import com.wrox.tourism.entity.Attraction;public class ListEventsAction extends Action {  private ConnectionPool pool;  public ListEventsAction() {    pool = ConnectionPool.getInstance();  }  public ActionForward perform(ActionMapping mapping,ActionForm form,    HttpServletRequest request,HttpServletResponse response)      throws IOException,ServletException {    Connection con = null;    ActionErrors errors = new ActionErrors();    try {      con = pool.getConnection();      String userId = request.getRemoteUser();      EventDAO eventDAO = new EventDAO(con);      Collection col = eventDAO.findAll(userId);      request.setAttribute(BeanNames.EVENT_LIST,col);      return mapping.findForward("success");    } catch (SQLException e) {      e.printStackTrace();      ActionError error = new ActionError("error.unexpected");      errors.add(ActionErrors.GLOBAL_ERROR,error);    } catch (Throwable e) {      e.printStackTrace();      ActionError error = new ActionError(e.getMessage());      errors.add(ActionErrors.GLOBAL_ERROR,error);    } finally {      try {        if (con != null)          con.close();      } catch (SQLException e) {        throw new RuntimeException(e.getMessage());      }    }    saveErrors(request,errors);    return new ActionForward(mapping.getInput());  }}