skhfkmydshow.java~13~

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;

    httpServletRequest.setAttribute("form", this.khmyd.khmydSelect());
    System.out.println("kkkkkk" + this.khmyd.khmydSelect());
    List khmydlist = this.khmyd.khmydSelect();
    for (int i = 0; i < khmydlist.size(); i++) {
      CkhmydForm form = (CkhmydForm) khmydlist.get(i);
      System.out.println("满意程度=" + form.getKhmyd_myd());
      skhfkForm.setKhfk_khmyd(form.getKhmyd_myd());
      double sum = this.facade.skhfkNumber();
      double ones = this.facade.skhfkMyd(skhfkForm);
      System.out.println("sum=" + sum);
      System.out.println("ones=" + ones);
      double percent=ones / sum * 100;
      System.out.println("percent=" + percent);
      String degree = String.valueOf(percent);
      System.out.println("degree="+degree);
      httpServletRequest.setAttribute("degree", degree);
    }
    return actionMapping.findForward("skhfkMydShow");
  }
}