/*
 * Generated by MyEclipse Struts
 * Template path: templates/java/JavaClass.vtl
 */
package com.v512.guestbook.web.action;

import java.sql.SQLException;
import java.util.List;

import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.sql.DataSource;

import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanListHandler;
import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;

import com.v512.guestbook.model.Guestbook;

/**
 * MyEclipse Struts Creation date: 08-07-2008
 * 
 * XDoclet definition:
 * 
 * @struts.action
 */
public class ReadAction extends Action {
	/*
	 * Generated Methods
	 */

	/**
	 * Method execute
	 * 
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 */
	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		String sql = "select * from guestbook by id desc";

		try {
			Context context = new InitialContext();
			DataSource ds = (DataSource) context
					.lookup("java:/comp/env/jdbc/oracleds");
			QueryRunner qr = new QueryRunner(ds);
			List list = (List) qr.query(sql, new BeanListHandler(
					Guestbook.class));
			request.setAttribute("guestbook.display.list", list);
		} catch (NamingException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return mapping.findForward("guestbook.display");
	}
}