skhfkmydshow.java~4~

JSP+SQL实现了一个拥有添加、删除、查询基本功能的CRM系统

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;
    List listMyd=this.facade.skhfkMyd();
    httpServletRequest.setAttribute("myd",listMyd);//指向的是满意程度表
    String count=String.valueOf(this.facade.skhfkCount()); //有多少条记录
    httpServletRequest.setAttribute("count",count);
    System.out.println("listMyd="+listMyd);
    System.out.println("count="+this.facade.skhfkCount());
    return actionMapping.findForward("skhfkMydShow");
  }
}