productaction.java

巴巴运动网源码 传智博客出品 不全 一部分代码 可以参考

package com.itcast.web.action.product;

import java.util.ArrayList;
import java.util.LinkedHashMap;
import java.util.List;

import javax.annotation.Resource;
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 org.springframework.stereotype.Controller;

import com.itcast.bean.PageView;
import com.itcast.bean.product.ProductInfo;
import com.itcast.service.product.ProductInfoService;
import com.itcast.web.action.privilege.Privilege;
import com.itcast.web.formbean.product.ProductForm;

@Controller("/control/product/list")
public class ProductAction extends Action {
	@Resource(name="productInfoServiceBean")
	private ProductInfoService productInfoService;

	@Override @Privilege(model="product", privilegeValue="view")
	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) throws Exception {
		ProductForm formbean = (ProductForm) form;
		PageView<ProductInfo> pageView = new PageView<ProductInfo>(12, formbean.getPage());
		int firstindex = (pageView.getCurrentpage()-1)* pageView.getMaxresult();
		LinkedHashMap<String, String> orderby = new LinkedHashMap<String, String>();
		orderby.put("visible", "desc");
		orderby.put("id", "desc");
		
		if("true".equals(formbean.getQuery())){
			StringBuffer jpql = new StringBuffer("");
			List<Object> params = new ArrayList<Object>();
			//按产品名称查询
			if(formbean.getName()!=null && !"".equals(formbean.getName())){
				if(params.size()>0) jpql.append(" and ");
				jpql.append(" o.name like ?").append((params.size()+1));
				params.add("%"+ formbean.getName()+ "%");
			}
			//按产品类型查询
			if(formbean.getTypeid()!=null && formbean.getTypeid()>0){
				if(params.size()>0) jpql.append(" and ");
				jpql.append(" o.type.typeid=?").append((params.size()+1));
				params.add(formbean.getTypeid());
			}
			//按采购价区间查询
			if(formbean.getStartbaseprice()!=null && formbean.getStartbaseprice()>0){
				if(params.size()>0) jpql.append(" and ");
				jpql.append(" o.baseprice>=?").append((params.size()+1));
				params.add(formbean.getStartbaseprice());
			}
			if(formbean.getEndbaseprice()!=null && formbean.getEndbaseprice()>0){
				if(params.size()>0) jpql.append(" and ");
				jpql.append(" o.baseprice<=?").append((params.size()+1));
				params.add(formbean.getEndbaseprice());
			}
			//按销售价区间查询
			if(formbean.getStartsellprice()!=null && formbean.getStartsellprice()>0){
				if(params.size()>0) jpql.append(" and ");
				jpql.append(" o.sellprice>=?").append((params.size()+1));
				params.add(formbean.getStartsellprice());
			}
			if(formbean.getEndsellprice()!=null && formbean.getEndsellprice()>0){
				if(params.size()>0) jpql.append(" and ");
				jpql.append(" o.sellprice<=?").append((params.size()+1));
				params.add(formbean.getEndsellprice());
			}
			//按货号查询
			if(formbean.getCode()!=null && !"".equals(formbean.getCode())){
				if(params.size()>0) jpql.append(" and ");
				jpql.append(" o.code=?").append((params.size()+1));
				params.add(formbean.getCode());
			}
			//按品牌查询
			if(formbean.getBrandid()!=null && !"".equals(formbean.getBrandid())){
				if(params.size()>0) jpql.append(" and ");
				jpql.append(" o.brand.code=?").append((params.size()+1));
				params.add(formbean.getBrandid());
			}
			pageView.setQueryResult(productInfoService.getScrollData(ProductInfo.class, firstindex, 
					pageView.getMaxresult(), jpql.toString(), params.toArray(), orderby));
		}else{
			pageView.setQueryResult(productInfoService.getScrollData(ProductInfo.class, firstindex, 
					pageView.getMaxresult(), orderby));
		}
		request.setAttribute("pageView", pageView);		
		return mapping.findForward("list");
	}
	
	
	
}