package com.ICT.AFC.user.actions;

import org.apache.struts.action.*;
import javax.servlet.http.*;
import javax.servlet.ServletContext;
import javax.sql.DataSource;
import com.ICT.AFC.DB.DB;
import com.ICT.AFC.user.beans.DepartmentOperate;

public class listDepartmentAction
    extends Action {
  public ActionForward execute(ActionMapping actionMapping,
                               ActionForm actionForm,
                               HttpServletRequest Request,
                               HttpServletResponse Response)
    throws Exception {
int ss=1;
    HttpSession session = Request.getSession();
  //獲取數據源
    ServletContext context = servlet.getServletContext();
    DataSource dataSource = (DataSource) context.getAttribute("contract");
    DB db = new DB(dataSource);
    String PageForward = "listdepartment";

  // String departmentid = Request.getParameter("departmentId");
  // int departmentId = Integer.parseInt(departmentid);
   session.setAttribute("DEPARTMENTCONTRACTLIST",
                        DepartmentOperate.searchAllDepartment(db));
  // DepartmentOperate.searchDepartment(db, departmentId);
      db.close();
      return (actionMapping.findForward(PageForward));

 }
}