querysfzyfenye.java~16~

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

package com.webtier.queryInformation;

import org.apache.struts.action.*;
import javax.servlet.http.*;
import com.service.SfzyFacade;
import com.service.SfzyFacadeImpl;
import java.util.List;
import com.domain.FfzyForm;
import java.io.UnsupportedEncodingException;

public class QuerySfzyFenYe
    extends Action {

  private SfzyFacade facade;
  public QuerySfzyFenYe() {
    this.facade = new SfzyFacadeImpl();
  }

  public ActionForward perform(ActionMapping actionMapping,
                               ActionForm actionForm,
                               HttpServletRequest httpServletRequest,
                               HttpServletResponse httpServletResponse) throws
      UnsupportedEncodingException {
    httpServletRequest.setCharacterEncoding("gb2312");
    httpServletRequest.setAttribute("total", String.valueOf(this.facade.toatl()));
    System.out.println("Total"+String.valueOf(this.facade.toatl()));
    Integer iCount = Integer.valueOf(httpServletRequest.getParameter("iCount"));
    System.out.println("iCount:"+iCount);
    httpServletRequest.setAttribute("iCount", iCount);
    iCount = new Integer( (iCount.intValue() - 1) * 5);
    if (iCount.intValue() > 0) {
      List list=this.facade.sfzyFenYe(iCount);
      for(int i=0;i<list.size();i++){
        FfzyForm form =(FfzyForm)list.get(i);

      System.out.println("id="+form.getSfzy_id());

      }
      httpServletRequest.setAttribute("sfzylist",list);

      System.out.println("iCount="+iCount);
      System.out.println("集合="+this.facade.sfzyFenYe(iCount));
      return actionMapping.findForward("fenyeSuccess");
    }
    else {
      return actionMapping.findForward("fenyeFail");
    }

  }
}