moneywareaction.java

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

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

import java.sql.Date;
import java.util.List;
import java.util.Map;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;

import com.company.manager.tool.PageUtil;
import com.company.struts.action.basic.BaseAll;
import com.company.struts.form.returnmoney.MoneyWareViewForm;

/** 
 * MyEclipse Struts
 * Creation date: 03-04-2008
 * 
 * XDoclet definition:
 * @struts.action path="/moneyWare" name="moneyWareForm" scope="request" validate="true"
 * @struts.action-forward name="error" path="/error.jsp"
 * @struts.action-forward name="success" path="/returnmoney/MoneyWareSelect.jsp"
 */
public class MoneyWareAction 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) {
		String pageNo = request.getParameter("pageNo");
		MoneyWareViewForm moneyWareForm = (MoneyWareViewForm) form;
		String sqlStr = " XsMoneyWare where (";
	
		if(!moneyWareForm.getWareDateBegin().equals("")){
			sqlStr = sqlStr+"verifierDate>'"+moneyWareForm.getWareDateBegin()+"'";
		}
		if(!moneyWareForm.getWareDateEed().equals("")){
			sqlStr = sqlStr +" and verifierDate<'"+moneyWareForm.getWareDateEed() +"'";
			
		}
		if(!moneyWareForm.getWareId().equals("")){
			sqlStr = sqlStr+" and moneyWareCode="+moneyWareForm.getWareId();
		}
		if (!moneyWareForm.getCusName().equals("")) {
			sqlStr = sqlStr + " and cusCode=" + moneyWareForm.getCusName();
		}
		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("smwlist", list);
			return mapping.findForward("success");
		}else{
			System.out.println("list is null!!!!!!");
			return mapping.findForward("error");
		}
	}
}