/*
 * Generated by MyEclipse Struts
 * Template path: templates/java/JavaClass.vtl
 */
package com.yiboit.hhs.action;

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

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
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.yiboit.hhs.EmpBean;
import com.yiboit.hhs.daos.DeptListDAO;
import com.yiboit.hhs.daos.EmpDAO;
import com.yiboit.hhs.form.EmpUpdateForm;

/**
 * MyEclipse Struts Creation date: 06-13-2008
 * 
 * XDoclet definition:
 * 
 * @struts.action validate="true"
 * @struts.action-forward name="success" path="/empUpdate.jsp"
 */
public class PreEmpUpdateAction 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) {
		ActionForward forward = null;
		String empId = request.getParameter("id");

		try {
			List deptList = null;

			DeptListDAO dao1 = new DeptListDAO(getDataSource(request, "ora"));
			dao1.databaseAccess();
			deptList = dao1.getDeptList();
			request.getSession().setAttribute("deptList", deptList);

			EmpDAO dao = new EmpDAO(getDataSource(request, "ora"));
			dao.setEmpId(empId);
			dao.databaseAccess();
			EmpBean bean = dao.getEmpBean();
			EmpUpdateForm frm = new EmpUpdateForm();

			frm.setEmpId(bean.getEmpId());
			frm.setEmpName(bean.getEmpName());
			frm.setEmpSex(bean.getEmpSex());
			frm.setDeptId("" + bean.getDeptId());
			frm.setSalary("" + bean.getSalary());

			request.setAttribute("empUpdateForm", frm);

			forward = mapping.findForward("success");
		} catch (SQLException e) {
			forward = mapping.findForward("error");
			e.printStackTrace();
		}

		return forward;
	}
}