package com.webtier.skhfkAction;

import com.tool.Chinese;
import org.apache.struts.action.*;
import javax.servlet.http.*;
import com.domain.SkhfkForm;
import com.service.SkhfkFacade;
import com.service.SkhfkFacadeImpl;
import com.service.CkhmydFacade;
import com.service.CkhmydFacadeImpl;
import java.util.List;
import com.domain.CkhmydForm;

//把滿意程度傳的sql語句中，去查詢有多少條記錄和查出有多少條記錄
public class SkhfkMydShow
    extends Action {
  private SkhfkFacade facade = null;
  private CkhmydFacade khmyd = null;
  public SkhfkMydShow() {
    this.facade = new SkhfkFacadeImpl();
    this.khmyd = new CkhmydFacadeImpl();
  }

  public ActionForward perform(ActionMapping actionMapping,
                               ActionForm actionForm,
                               HttpServletRequest httpServletRequest,
                               HttpServletResponse httpServletResponse) {
    SkhfkForm skhfkForm = (SkhfkForm) actionForm;

    String count = String.valueOf(this.facade.skhfkCount()-1); //有多少條記錄
    httpServletRequest.setAttribute("count", count);

    List listMyd = this.facade.skhfkMyd();
    httpServletRequest.setAttribute("listMyd", listMyd); //指向的是滿意程度表



    return actionMapping.findForward("skhfkMydShow");
  }
}