购物车

/**
 * <p>Title: 购物车</p>
 * <p>Description: 实现对商城购物车的操作</p>
 * <p>Copyright: Copyright (c) 2004</p>
 * <p>Company: 公司</p>
 * @author 网络信息部 范庆丰
 * @version 1.0
 */

package cartbean;
import java.util.*;
import java.sql.*;
import sqlbean.*;
public class CartBean {
  protected Hashtable itemHashtable = new Hashtable();

  public CartBean() {
  }
  public void setItemHashtable(Hashtable ht)
  {
    itemHashtable=ht;
  }
  public Hashtable getItemHashtable()
  {
    return itemHashtable;
  }

  /**
   * 增加上商品到购物车
   * @param id int 商品ID
   * @param desc String 商品ISBN编号
   * @param price double 商品单价
   * @param qty int 数量
   */
  public void addItem(int id,String  isbn,String desc ,double price,int qty)
  {
    String[] item={Integer.toString(id),isbn,desc,Double.toString(price),Integer.toString(qty)};
    if(itemHashtable.containsKey(Integer.toString(id)))
    {
      String[] workItem=(String[])itemHashtable.get(Integer.toString(id));
      int workQty=Integer.parseInt(workItem[4]);
      qty=qty+workQty;
      workItem[4]=Integer.toString(qty);
    }
    else
      itemHashtable.put(Integer.toString(id),item);

  }

  /**
   * 修改购物车某种商品的数量
   * @param id int 商品ID
   * @param desc String 商品ISBN编号
   * @param price double 商品单价
   * @param qty int 数量
   */
  public void changeItem(int id,int qty)
  {
    if(itemHashtable.containsKey(Integer.toString(id)))
    {
      String[] workItem=(String[])itemHashtable.get(Integer.toString(id));
      workItem[4]=Integer.toString(qty);
    }
  }

  /**
   * 删除购物车中的某种商品
   * @param id int
   */
  public void removeItem(int id)
  {
    if(itemHashtable.containsKey(Integer.toString(id)))
    {
      itemHashtable.remove(Integer.toString(id));
    }
  }
  public Enumeration getEnumeration()
  {
    return itemHashtable.elements();
  }

  /**
   * 购物车商品总金额
   * @return double
   */
  public double getCost()
  {
    Enumeration enum=itemHashtable.elements();
    String[] workItem;
    double totalCost=0.00;
    while(enum.hasMoreElements())
    {
      workItem=(String[])enum.nextElement();
      totalCost=totalCost+(Integer.parseInt(workItem[4])*Double.parseDouble(workItem[3]));
    }
    return totalCost;
  }

  /**
   * 购物车商品类数
   * @return int
   */
  public int getNumofItem()
  {
    Enumeration enum=itemHashtable.elements();
    String[] workItem;
    int num=0;
    while(enum.hasMoreElements())
    {
      workItem=(String[])enum.nextElement();
      num=num+Integer.parseInt(workItem[4]);
    }
    return num;
  }

  /**
   * 清空购物车记录
   */
  public void ClearItem()
  {
    itemHashtable.clear();
  }

  public void InsertCart(CartBean a,int PPUserID)
    { Connection con;
      try
        {
            Conn conn=new Conn();
            con=conn.getConn();
            Statement statement=con.createStatement();
            Enumeration b=a.getEnumeration();
            String c[];
            while(b.hasMoreElements())
            {
              c=(String[])b.nextElement();
              String values;
              values=PPUserID+","+c[0]+","+c[3]+","+c[4];
              statement.executeUpdate("insert into Cart(UserID,ProductID,Price,Num) values("+values+")");
            }
            conn.FreeConn();
        }//try
        catch(Exception e)
            {
                System.out.println(e.getMessage());
            } //catch
    }

 

}