www.pudn.com > online-trading.rar > ProductMgr.java

package com.bjsxt.shopping.product; 
 
import java.util.List; 
 
public class ProductMgr { 
	private static ProductMgr mgr = null; 
	 
	private static ProductDAO dao = new ProductMySQLDAO();  
	 
	private ProductMgr() {} 
	 
	public static ProductMgr getInstance() { 
		if(mgr == null) { 
			mgr = new ProductMgr(); 
		} 
		return mgr; 
	} 
	 
	public List getProducts() { 
		return dao.getProducts(); 
	} 
	 
	public int getProducts(List products, int pageNo, int pageSize, boolean lazy) { 
		return dao.getProducts(products, pageNo, pageSize, lazy); 
	} 
	 
	public void add(Product p) { 
		dao.add(p); 
	} 
	 
	public void update(Product p) { 
		dao.update(p); 
	} 
	 
	public void delete(int id) { 
		dao.delete(id); 
	} 
	 
	public Product loadById(int id) { 
		return dao.loadById(id); 
	} 
	 
	public void delete(String[] idArray) { 
		String conditionStr = " where id in ("; 
		for (int i = 0; i < idArray.length; i++) { 
			conditionStr += idArray[i]; 
			conditionStr += ","; 
		} 
		conditionStr = conditionStr.replaceAll(".$", ")"); 
		//conditionStr = conditionStr.substring(0, conditionStr.length() - 1) + ")"; 
System.out.println(conditionStr); 
		dao.delete(conditionStr); 
	} 
	 
	public int find(List products, int pageNo, int pageSize, int categoryId) { 
		String queryStr = " where p.categoryid = " + categoryId; 
		return dao.find(products, pageNo, pageSize, queryStr); 
	} 
	 
	public int find(List products, int pageNo, int pageSize, String keyword) { 
		String queryStr = " where p.name like '%" + keyword + "%' or p.descr like '%" + keyword + "%'";  
		return dao.find(products, pageNo, pageSize, queryStr); 
	} 
	 
	public int find(List products, int pageNo, int pageSize, ProductSearchFormBean bean) { 
		String queryStr = " where 1=1 "; 
		if(bean.getCategoryId() != -1) { 
			queryStr += " and p.categoryid = " + bean.getCategoryId(); 
		} 
		if(bean.getName() != null && !bean.getName().trim().equals("")) { 
			queryStr += " and p.name like '%" + bean.getName() + "%'"; 
		} 
		if(bean.getLowNormalPrice() != 0.0) { 
			queryStr += " and p.normalprice >= " + bean.getLowNormalPrice(); 
		} 
		if(bean.getHighNormalPrice() != 0.0) { 
			queryStr += " and p.normalprice <= " + bean.getHighNormalPrice(); 
		} 
		if(bean.getLowMemberPrice() != 0.0) { 
			queryStr += " and p.memberprice >= " + bean.getLowMemberPrice(); 
		} 
		if(bean.getHighMemberPrice() != 0.0) { 
			queryStr += " and p.memberprice <= " + bean.getHighMemberPrice(); 
		} 
		if(bean.getStartDate() != null && !bean.getStartDate().trim().equals("")) { 
			queryStr += " and p.pdate >= '" + bean.getStartDate() + " 00:00:00'"; 
		} 
		if(bean.getEndDate() != null && !bean.getEndDate().trim().equals("")) { 
			queryStr += " and p.pdate <= '" + bean.getEndDate() + " 00:00:00'"; 
		} 
		return dao.find(products, pageNo, pageSize, queryStr); 
	} 
	 
	public List loadById(int[] ids) { 
		return null; 
	} 
	 
	public static void main(String[] args) { 
		String[] idArray = {"1", "2", "3"}; 
		ProductMgr.getInstance().delete(idArray); 
	} 
}