/**
* <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
}
}