CRM客户管理系统 （含 数据库）

/* * Generated by MyEclipse Struts * Template path: templates/java/JavaClass.vtl */ package com.crm.struts.action; import java.util.ArrayList; import java.util.Iterator; import java.util.List; import java.util.Set; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import org.apache.log4j.Logger; import org.apache.struts.action.ActionForm; import org.apache.struts.action.ActionForward; import org.apache.struts.action.ActionMapping; import org.apache.struts.actions.DispatchAction; import com.crm.dao.BdwxxDAO; import com.crm.dao.KhbDAO; import com.crm.dao.KhjbDAO; import com.crm.dao.SjzdflxxDAO; import com.crm.dao.SjzdszxxDAO; import com.crm.dao.YhbDAO; import com.crm.dao.xx.KhbImpl; import com.crm.hbn.HibernateSessionFactory; import com.crm.interfix.Pagination; import com.crm.pojos.Bdwxx; import com.crm.pojos.Khb; import com.crm.pojos.Khjb; import com.crm.pojos.Sjzdflxx; import com.crm.pojos.Sjzdszxx; import com.crm.pojos.Yhb; import com.crm.struts.form.KhbForm; /** * MyEclipse Struts * Creation date: 12-26-2006 * * XDoclet definition: * @struts.action path="/khb" name="khbForm" input="/form/khb.jsp" parameter="method" scope="request" validate="true" */ public class KhbAction extends DispatchAction { /* * Generated Methods */ /** * Method execute * @param mapping * @param form * @param request * @param response * @return ActionForward */ public ActionForward select(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) { Logger log = Logger.getLogger(KhbAction.class); Bdwxx bdw =(Bdwxx)request.getSession().getAttribute("bdwxx"); List slxlist = new ArrayList(); List<Khb> list=null; KhbForm khbForm = (KhbForm) form; try { request.setAttribute("sele", "1"); SjzdflxxDAO sfl = new SjzdflxxDAO(); Sjzdflxx sfsa = sfl.findById(1); Set<Sjzdszxx> ssz =sfsa.getSjzdszxxes(); Iterator<Sjzdszxx> ssziter = ssz.iterator(); while (ssziter.hasNext()) { Sjzdszxx element = (Sjzdszxx) ssziter.next(); if (element.getSfqy().equals(1) && element.getZdxxmc()!=null&&element.getZdxxmc().length()>0 && element.getBdwxx().getBdid().equals(bdw.getBdid())) { slxlist.add(element); } } request.setAttribute("slxlist", slxlist); sfsa = sfl.findById(2); ssz =sfsa.getSjzdszxxes(); ssziter = ssz.iterator(); slxlist = new ArrayList(); while (ssziter.hasNext()) { Sjzdszxx element = (Sjzdszxx) ssziter.next(); if (element.getSfqy().equals(1) && element.getZdxxmc()!=null &&element.getZdxxmc().length()>0&& element.getBdwxx().getBdid().equals(bdw.getBdid())) { slxlist.add(element); } } request.setAttribute("sxzlist", slxlist); sfsa = sfl.findById(3); ssz =sfsa.getSjzdszxxes(); ssziter = ssz.iterator(); slxlist = new ArrayList(); while (ssziter.hasNext()) { Sjzdszxx element = (Sjzdszxx) ssziter.next(); if (element.getSfqy().equals(1) && element.getZdxxmc()!=null&&element.getZdxxmc().length()>0 && element.getBdwxx().getBdid().equals(bdw.getBdid())) { slxlist.add(element); } } request.setAttribute("syhlist", slxlist); sfsa = sfl.findById(4); ssz =sfsa.getSjzdszxxes(); ssziter = ssz.iterator(); slxlist = new ArrayList(); while (ssziter.hasNext()) { Sjzdszxx element = (Sjzdszxx) ssziter.next(); if (element.getSfqy().equals(1) && element.getZdxxmc()!=null&&element.getZdxxmc().length()>0 && element.getBdwxx().getBdid().equals(bdw.getBdid())) { slxlist.add(element); } } request.setAttribute("slylist", slxlist); String khkey =request.getParameter("key"); String khtype = request.getParameter("type"); String cutpage = request.getParameter("page"); String resultRow = request.getParameter("rows"); String search = request.getParameter("search"); if (resultRow==null) { resultRow="10"; } System.out.println("快点来呀！！"+cutpage); System.out.println("快点来呀！！"+resultRow); System.out.println("快点来呀！！"+search); if((search !=null && search.trim().equals("搜索"))||(search !=null && search.trim().equals("2"))) { if (cutpage==null||cutpage.equals("0")) { cutpage="1"; } String khmcstr = request.getParameter("khmc"); khbForm.setKhmc(khmcstr); khbForm.setKhxzid( request.getParameter("khxzid")); khbForm.setKhlxid( request.getParameter("khlxid")); khbForm.setKhyhid( request.getParameter("khyhid")); khbForm.setKhlyid( request.getParameter("khlyid")); System.out.println(khbForm.getKhmc()+"12345"); KhbDAO khb = new KhbImpl(); list=khb.search(khbForm.getKhmc(), khbForm.getKhxzid(), khbForm.getKhlxid(), khbForm.getKhyhid(), khbForm.getKhlyid()); Pagination pagination = new Pagination(list,new Integer(resultRow)); if (list.size()!=0) { list = pagination.getPagination(new Integer(cutpage)); } request.setAttribute("page", cutpage); request.setAttribute("pagecount", pagination.getPagecount()); request.setAttribute("totalrows", pagination.getTotal()); if (resultRow.equals("3")) { request.setAttribute("s3", "selected"); } if (resultRow.equals("5")) { request.setAttribute("s5", "selected"); } if (resultRow.equals("10")) { request.setAttribute("s10", "selected"); } request.setAttribute("sele", "2"); System.out.println("快点来呀！！"+ list.size()); }else { if (cutpage==null) { cutpage="1"; } System.out.println(khkey); System.out.println(khtype); System.out.println(cutpage); System.out.println(resultRow); KhbDAO kd = new KhbDAO(); if ((khkey==null || khkey.length()<=0) && (khtype==null || khtype.length()<=0)) { if (cutpage==null ||resultRow==null ) { list = kd.getAllKhb(); if(list.size()>0){ list = kd.getPagination(1, new Integer(resultRow)); } System.out.println(list.size()+"初始进入"); request.setAttribute("page", 1); request.setAttribute("pagecount", 3); request.setAttribute("totalrows", kd.getTotal()); }else{ list = kd.getPagination(Khb.class,new Integer(cutpage), new Integer(resultRow)); request.setAttribute("page", cutpage); request.setAttribute("pagecount", kd.getPagecount()); request.setAttribute("totalrows", kd.getTotal()); if (resultRow.equals("3")) { request.setAttribute("s3", "selected"); } if (resultRow.equals("5")) { request.setAttribute("s5", "selected"); } if (resultRow.equals("10")) { request.setAttribute("s10", "selected"); } System.out.println("进来吧"); } request.setAttribute("pagecount", kd.getPagecount()); }else{ System.out.println("不要来"); if (khtype.equals(kd.KHMC)) { request.setAttribute(kd.KHMC, "selected"); } if (khtype.equals(kd.KHBZ)) { request.setAttribute(kd.KHBZ, "selected"); } if (khtype.equals(kd.KHCZ)) { request.setAttribute(kd.KHCZ, "selected"); } if (khtype.equals(kd.KHDH)) { request.setAttribute(kd.KHDH, "selected"); } if (khtype.equals(kd.KHDZ)) { request.setAttribute(kd.KHDZ, "selected"); } if (khtype.equals(kd.KHSSCS)) { request.setAttribute(kd.KHSSCS, "selected"); } if (khtype.equals(kd.KHSSSF)) { request.setAttribute(kd.KHSSSF, "selected"); } if (khtype.equals(kd.KHWZ)) { request.setAttribute(kd.KHWZ, "selected"); } if (khtype.equals(kd.KHYB)) { request.setAttribute(kd.KHYB, "selected"); } if (khtype.equals(kd.KHYHZH)) { request.setAttribute(kd.KHYHZH, "selected");