productmgrimpl.java

本文论述了一个前台笔记本销售系统的开发过程

package com.set.home.business;

import java.util.ArrayList;
import java.util.List;
import org.apache.log4j.Logger;
import com.set.appframe.business.BaseManager;
import com.set.appframe.data.GenericValueObject;
import com.set.appframe.data.SearchResult;
import com.set.appframe.exception.SystemException;

import com.set.db.DBUtils;
import com.set.home.model.Product;
import com.set.home.model.ProductVO;

import com.set.utils.Converter;
import com.set.utils.StringUtils;

public class ProductMgrImpl extends BaseManager implements ProductMgr {

	private static Logger logger = Logger.getLogger(ProductMgrImpl.class);

	public List searchTop10() throws SystemException {
		String sql = "select id, model,price ,url from product where top<11 order by top asc";
		List list = DBUtils.queryForList(sql);
		return list;
	}
	
	public List search() throws SystemException{
		String sql = "select id, model,price,url from product where top<11 or newlevel<11 order by newlevel,top limit 0,10";
		List list = DBUtils.queryForList(sql);
		return list;
	}

	public List searchNew10() throws SystemException{
		String sql = "select id, model,price,url from product where newlevel<11 order by newlevel";
		List list = DBUtils.queryForList(sql);
		return list;
	}	
	
	public SearchResult fastsearch(ProductVO vo, int intPageNo, int intPageSize)
			throws SystemException {

		SearchResult result = null;
		List params = new ArrayList();
		params.add(StringUtils.formatSearchString(vo.getItemString("MODEL")));
		try {
			result = this
					.baseSearch(intPageNo, intPageSize, "P_SEARCH", params);
		} catch (SystemException e) {
			e.printStackTrace();
		}

		return result;
	}

	@SuppressWarnings("unchecked")
	public SearchResult highsearch(ProductVO vo, int intPageNo, int intPageSize)
			throws SystemException {

		SearchResult result = null;
		String model = "";
		model = vo.getItemString("MODEL");
		if(!model.equals("")){
			model = model.substring(model.indexOf(",") + 2, model.indexOf("]"));
		}
		
		List params1 = new ArrayList();
		List params2 = new ArrayList();
		if (!vo.getItemString("PRICE").equals("")
				&& vo.getItemString("PRICE") != null) {
			String price = vo.getItemString("PRICE");
			String prices[] = price.split(",");
			int price1 = Integer.parseInt(prices[0]);
			int price2 = Integer.parseInt(prices[1]);
			params1.add(price1);
			params1.add(price2);
			params1.add(StringUtils.formatSearchString(model));
			params1.add(model);
			params1.add(StringUtils.formatSearchString(vo
					.getItemString("BRAND")));
			params1.add(vo.getItemString("BRAND"));
			params1
					.add(StringUtils
							.formatSearchString(vo.getItemString("CPU")));
			params1.add(vo.getItemString("CPU"));
			params1.add(StringUtils.formatSearchString(vo
					.getItemString("EMSMEMORY")));
			params1.add(vo.getItemString("EMSMEMORY"));
			params1.add(StringUtils.formatSearchString(vo
					.getItemString("DISPLAY")));
			params1.add(vo.getItemString("DISPLAY"));
			params1.add(StringUtils.formatSearchString(vo.getItemString("HD")));
			params1.add(vo.getItemString("HD"));
			try {
				result = this.baseSearch(intPageNo, intPageSize,
						"P_HIGHSEARCH1", params1);
			} catch (SystemException e) {
				e.printStackTrace();
			}
		} else {
			params2.add(StringUtils.formatSearchString(model));
			params2.add(model);
			params2.add(StringUtils.formatSearchString(vo
					.getItemString("BRAND")));
			params2.add(vo.getItemString("BRAND"));
			params2
					.add(StringUtils
							.formatSearchString(vo.getItemString("CPU")));
			params2.add(vo.getItemString("CPU"));
			params2.add(StringUtils.formatSearchString(vo
					.getItemString("EMSMEMORY")));
			params2.add(vo.getItemString("EMSMEMORY"));
			params2.add(StringUtils.formatSearchString(vo
					.getItemString("DISPLAY")));
			params2.add(vo.getItemString("DISPLAY"));
			params2.add(StringUtils.formatSearchString(vo.getItemString("HD")));
			params2.add(vo.getItemString("HD"));
			try {
				result = this.baseSearch(intPageNo, intPageSize,
						"P_HIGHSEARCH2", params2);
			} catch (SystemException e) {
				e.printStackTrace();
			}
		}
		return result;
	}

	public SearchResult searchAll(ProductVO vo, int intPageNo, int intPageSize)
			throws SystemException {

		SearchResult result = null;
		List params = new ArrayList();
		try {
			result = this.baseSearch(intPageNo, intPageSize, "P_SEARCHALL",
					params);
		} catch (Exception e) {
			e.printStackTrace();
		}

		return result;
	}
	
	public GenericValueObject get(String id) throws SystemException{
		GenericValueObject vo=new GenericValueObject();		
		String sql = "select * from product where id='"+id+"'";
		List list = DBUtils.queryForList(sql);
		if(list.size()>0){
			vo=(GenericValueObject)list.get(0);
		}
	
		return vo;
	}
}