productoper.java

采用java实现的网上商店

package com.ata.java2.shoppingcart;
import java.util.ArrayList;

public class ProductOper {
  public ProductOper() {
		super();
	}
 
  public ArrayList findProductAll(){
	     ORMDBProduct dbp=new ORMDBProduct();
		 String sql="select *from product";
		 ArrayList list=dbp.select(sql);
		 return list;  
  }
 
  public void showUserAll(){
		 ArrayList list=findProductAll();
	  	for(int i=0; i< list.size();i++)
	  	{
	  		 Product pro = (Product)list.get(i);
		     String proId = pro.getProductId();
			 String proName = pro.getProductName();
			 
		   	 System.out.println("商品ID号："+proId);
		   	 System.out.println("商品名称："+proName);  
	   	}
	   	  
} 
  
  public ArrayList selectById(String id){
	     ORMDBProduct dbp=new ORMDBProduct();
		 String sql="select *from product where productId="+"'"+id+"'";
		 ArrayList list=dbp.select(sql);
		 return list;  
	  
  }
  
  public ArrayList selectByName(String name){
	     ORMDBProduct dbp=new ORMDBProduct();
		 String sql="select *from product where productName="+"'"+name+"'";
		 ArrayList list=dbp.select(sql);
		 return list;  
	  
  }
 
  public ArrayList selectByBrand(String brand){
	     ORMDBProduct dbp=new ORMDBProduct();
		 String sql="select *from product where productBrand="+"'"+brand+"'";
		 ArrayList list=dbp.select(sql);
		 return list;  
	  
  }
  public void increaseProduct(Product pro){
	     ORMDBProduct dbp=new ORMDBProduct();
		 dbp.insert(pro);
}     
  
  public void DeleteProduct(Product pro){
	     ORMDBProduct dbp=new ORMDBProduct();
		 dbp.delete(pro);
}      
  
  
  public static void main(String[] args) {		 
	 
	 ProductOper po=new ProductOper();
	 ArrayList list=po.findProductAll();
	 	for(int i=0; i< list.size();i++)
	  {
	  		 Product pro = (Product)list.get(0);
			 String proId = pro.getProductId();
			 String proName = pro.getProductName();
			 System.out.println("商品编号："+proId);
		     System.out.println("商品名称："+proName);      
		   	 po.increaseProduct(pro);
	   	}
	   
  }
}