selectreturnmoneyaction.java

关于网上汽车销售系统的详细编程项目实战实例

/*
 * Generated by MyEclipse Struts
 * Template path: templates/java/JavaClass.vtl
 */
package com.company.struts.action.returnmoney;

import java.util.List;
import java.util.Map;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;

import com.company.hib.dao.impl.XsReturnMoneyDAO;
import com.company.manager.tool.PageUtil;
import com.company.struts.action.basic.BaseAll;
import com.company.struts.form.XsMoneyWare;
import com.company.struts.form.returnmoney.SelectReturnMoneyForm;

/** 
 * MyEclipse Struts
 * Creation date: 02-28-2008
 * 
 * XDoclet definition:
 * @struts.action path="/selectReturnMoney" name="selectReturnMoneyForm" input="/form/selectReturnMoney.jsp" scope="request" validate="true"
 * @struts.action-forward name="error" path="/returnmoney/ReturnError.jsp"
 * @struts.action-forward name="success" path="/returnmoney/SelectReturnMoneyResult.jsp"
 */
public class SelectReturnMoneyAction extends BaseAll {
	/*
	 * Generated Methods
	 */

	/** 
	 * Method execute
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 */

	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		SelectReturnMoneyForm srmForm = (SelectReturnMoneyForm) form;
		String pageNo = request.getParameter("pageNo");
		System.out.println("欢迎进入SelectReturnMoneyAction中");
		System.out.println(srmForm.getReturnDateBegin().toString()+srmForm.getReturnDateEnd().toString()+srmForm.getCusCode()+srmForm.getReturnMoneyCode()+srmForm.getReturnMoneyType()+srmForm.getDeptCode()+srmForm.getPersonCode()+srmForm.getSsCode()+srmForm.getChecker()+srmForm.getMaker());
		
		String sqlStr = "XsReturnMoney where (";
		if (!srmForm.getReturnDateBegin().equals("")) {
			System.out.println("returnDateBegin:"+srmForm.getReturnDateBegin());
			sqlStr = sqlStr + "returnDate>'" + srmForm.getReturnDateBegin() + "'";
		}
		if (!srmForm.getReturnDateEnd().equals("")) {
			System.out.println("returnDateEnd:"+srmForm.getReturnDateEnd());
			sqlStr = sqlStr + " and returnDate<'" + srmForm.getReturnDateEnd() + "'";
		}
		if (!srmForm.getCusCode().equals("")) {
			System.out.println("cusCode:"+srmForm.getCusCode());
			sqlStr = sqlStr + " and cusCode='" + srmForm.getCusCode() + "'";
		}
		if (!srmForm.getReturnMoneyCode().equals("")) {
				System.out.println("returnMoneyCode:"+srmForm.getReturnMoneyCode());
				sqlStr = sqlStr + " and returnMoneyCode='" + srmForm.getReturnMoneyCode() + "'";
		}
		if (!srmForm.getReturnMoneyType().equals("")) {
			if(srmForm.getReturnMoneyCode()!=null&&!srmForm.getReturnMoneyCode().equals("")){
				System.out.println("rmtcode的值:"+srmForm.getReturnMoneyCode());
				sqlStr = sqlStr + " and rmtcode='" + srmForm.getReturnMoneyType() + "'";
			}
		}
		if (!srmForm.getDeptCode().equals("")) {
			System.out.println("deptCode:"+srmForm.getDeptCode());
			sqlStr = sqlStr + " and deptCode='" + srmForm.getDeptCode() + "'";
		}
		if (!srmForm.getPersonCode().equals("")) {
			System.out.println("personCode:"+srmForm.getPersonCode());
			sqlStr = sqlStr + " and personCode='" + srmForm.getPersonCode() + "'";
		}
		if (!srmForm.getSsCode().equals("")) {
			if(srmForm.getSsCode()!=null&&!srmForm.getSsCode().equals("")&&!srmForm.getSsCode().equals("null")){
				System.out.println("SsCode的值:"+srmForm.getSsCode());
				sqlStr = sqlStr + " and ssCode='" + srmForm.getSsCode() + "'";
			}
		}
		if (srmForm.getChecker()!=null) {
			System.out.println("checker:"+srmForm.getChecker());
			sqlStr = sqlStr + " and checker='" + srmForm.getChecker()+ "'";
			System.out.println("3333");
		}
		if (srmForm.getMaker()!=null) {
			System.out.println("maker:"+srmForm.getMaker());
			sqlStr = sqlStr + " and maker='" + srmForm.getMaker() + "'";
		}
		sqlStr=sqlStr+")";
		
		System.out.println("sql语句:"+sqlStr);
		Map map1 =null;
		try{
			map1 = this.getDao().find1(pageNo, sqlStr);
		}catch(Exception e){
			e.printStackTrace();
		}
		PageUtil page=(PageUtil)map1.get("page");
		String url = request.getContextPath();//取得路径
		page.setUrlstr(url+"selectReturnMoney.do");//页面中上下页处理的Action
		List list=(List)map1.get("list2");
		if(list!=null&&list.size()!=0){
			System.out.println("ListSize:"+list.size());
			request.setAttribute("page", page);
			System.out.println("pageSize:"+page.getPageSize());
			request.setAttribute("srmlist",list);
			return mapping.findForward("success");
			
		}else{
			System.out.println("list is null!!!!!!");
			return mapping.findForward("error");
			
		}
		
	}
}