shoppingmgrimpl.java

来自「本文论述了一个前台笔记本销售系统的开发过程」· Java 代码 · 共 58 行

package com.set.system.business;


import java.util.List;

import com.set.appframe.business.BaseManager;
import com.set.appframe.exception.SystemException;
import com.set.db.DBUtils;
import com.set.home.model.Product;
import com.set.system.model.Shopping;
import com.set.system.model.ShoppingVO;
import com.set.utils.Converter;

public class ShoppingMgrImpl extends BaseManager implements ShoppingMgr{

	public List search(String userid) throws SystemException{
		List list = null;
		String sql="select * from shopping where userid='"+userid+"'";
		list=DBUtils.queryForList(sql);
	    return list;	
	}
	
	public void deleteAll(String userid) throws SystemException{
		String sql="delete from shopping where userid='"+userid+"'";
		DBUtils.update(sql);
	}
	public void delete(String userid,String id) throws SystemException{
		String sql="delete from shopping where userid='"+userid+"' and id='"+id+"'";
		DBUtils.update(sql);
		
	}
	
	public void create(ShoppingVO vo)throws SystemException{
		String productId=vo.getProductId();
		Product product = (Product) entityDAO.getObject(productId, Product.class);
		vo.setId("");
		vo.setProductModel(product.getModel());
		vo.setPrice(String.valueOf(product.getPrice()));
		vo.setTotalPrice(String.valueOf(product.getPrice()));
		vo.setNumber("1");
		Shopping entity=new Shopping();
		Converter.converVO2PO(vo, entity);
		entityDAO.saveObject(entity);
		
	}
	
	public void update(String [] id, String [] number)throws SystemException{
		for(int i=0;i<id.length;i++){			
			Shopping entity = (Shopping) entityDAO.getObject(id[i], Shopping.class);
			entity.setNumber(Integer.parseInt(number[i]));
			entity.setTotalPrice(Integer.parseInt(number[i])*entity.getPrice());
			entityDAO.saveObject(entity);
		}
		
	}

}