package vod.controller;
import vod.model.DisplayWelcome; import java.io.IOException; import java.util.LinkedList; import java.util.Locale; import javax.servlet.RequestDispatcher; import javax.servlet.ServletException; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpSession; import javax.servlet.http.HttpServletResponse; import org.apache.struts.action.Action; import org.apache.struts.action.ActionError; import org.apache.struts.action.ActionErrors; import org.apache.struts.action.ActionForm; import org.apache.struts.action.ActionForward; import org.apache.struts.action.ActionMapping; import org.apache.struts.action.ActionServlet; import org.apache.struts.util.MessageResources; import java.sql.Connection; import java.sql.SQLException; import javax.sql.DataSource;
public class DisplayWelcomeAction extends Action { Connection connection;
LinkedList footballList; LinkedList funList; LinkedList movieList; LinkedList mtvList;
/** * 通过vod.model.DisplayWeclome各个类别0取得排名前十的条目,将其放入request * @param mapping * @param form * @param request * @param response * @return * @throws IOException * @throws ServletException */ public ActionForward perform(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException{ ActionErrors errors = new ActionErrors(); try { DataSource dataSource =servlet.findDataSource(null); connection =dataSource.getConnection();
footballList=new LinkedList(); funList=new LinkedList(); movieList=new LinkedList(); mtvList=new LinkedList(); DisplayWelcome displaywelcome=new DisplayWelcome(); displaywelcome.setConn(connection); footballList=displaywelcome.getFootballList(); funList=displaywelcome.getFunList(); movieList=displaywelcome.getMovieList(); mtvList=displaywelcome.getMtvList();
if (footballList==null) { saveErrors(request, errors); return (new ActionForward("No footballList in vod.controller.DisplayWelcomeAction")); } if (funList==null) { saveErrors(request, errors); return (new ActionForward("No funList in vod.controller.DisplayWelcomeAction")); } if (movieList==null) { saveErrors(request, errors); return (new ActionForward("No movieList in vod.controller.DisplayWelcomeAction")); } if (mtvList==null) { saveErrors(request, errors); return (new ActionForward("No mtvList in vod.controller.DisplayWelcomeAction")); }
HttpSession session = request.getSession(); session.setAttribute("footballTop",footballList); session.setAttribute("funTop",funList); session.setAttribute("movieTop",movieList); session.setAttribute("mtvTop",mtvList);
//do what you wish with myConnection } catch (SQLException sqle) { getServlet().log("Connection.process", sqle); } finally { //enclose this in a finally block to make //sure the connection is closed if(connection!=null) try { connection.close(); } catch (SQLException e) { getServlet().log("Connection.close", e); } }
return (mapping.findForward("success")); } } |