shoppingaction.java

商品购物车程序

package shopping;

import javax.servlet.http.HttpServletRequest;
import java.sql.*;
import java.util.*;
import shopping.connectionDB;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.lang.*;
import shopping.objectType.*;

public class shoppingAction {
    private static Statement statement = null;
    private connectionDB connectiondb=new connectionDB();
    private static Cart cart = new Cart();
    public static Vector productVector;

    public shoppingAction() {
    	try{
    	     statement=connectiondb.setDBConnection();
    	}catch(Exception e)
    	{
             System.out.println("connection db is error");
    	}
    }
    /**
     * 按查询条件获得所有的商品
     * @param jsp_product_id form shoppingAction.jsp
     * @return Vector
     */
    public Vector getProduct(String jsp_product_id) throws Exception {

    	jsp_product_id=(jsp_product_id==null)? "":jsp_product_id.trim();
    	String condition="";
    	if(jsp_product_id.length()>1)
    		condition=" where productid ='"+jsp_product_id+"'";
    	Vector v_results=new Vector();
        v_results.clear();
        String sql="select * from products ";
        sql+=condition;
        System.out.println(sql);
        ResultSet results=statement.executeQuery(sql);
	while(results.next())
	{
		String resultsArray[]=new String[4];
		for(int i=0;i<resultsArray.length;i++)
		{
			String getDBItem=results.getString(i+1);
			getDBItem = (getDBItem==null ? "" : getDBItem.trim());
			resultsArray[i]=getDBItem;
		}
		v_results.addElement(resultsArray);
	}
	results.close();
	return v_results;
    }
    /**
     * 按照规定的格式获取当前日期
     * @param timeModel 获取时间的格式
     * @return String
     */
    public String getSystemTime(String timeModel)
    {
         String s_time="";
         Date now_date = new Date();
         SimpleDateFormat formatter = new SimpleDateFormat(timeModel);
         s_time = formatter.format(now_date);

         return s_time;

    }
    /**
     * 从购物车中删除指定id的商品
     * @param jsp_product_id form ShoppingForm
     */
    public void removeProduct(String jsp_product_id) {
    	if(jsp_product_id.length()>0)
    	{
    	Product product = null;
        for (int i = 0; i < cart.size(); i++) {
        	CartItem cartitem=(CartItem)cart.elementAt(i);
        	product=cartitem.getProduct();
            if (product.getProductId().equals(jsp_product_id)) {
                break;
            }
        }
        if (product != null) {
        	System.out.println("the product will delete "+product.getproductName());
            cart.removeProduct(product);
        }
    	}
    }
    /**
     * 添加一个商品到购物车
     * @param jsp_product_id,jsp_product_number form ShoppingForm
     */
    public void addProduct(String jsp_product_id,
                           String jsp_product_number) {

        Product product = new Product(jsp_product_id);
        System.out.println("productid==>" + jsp_product_id);
        System.out.println("quantity==>" + jsp_product_number);

        if (product != null) {
        	Integer quantity;
            try {
                quantity = new Integer(jsp_product_number);
            } catch (Exception e) {
                quantity = new Integer(1);
            }
            cart.addProduct(product, quantity);
        }
        System.out.println("cart===> " + cart.size());
    }
    /**
     * 返回当前登录顾客购物车里的商品
     */
    public Vector getCartProduct()
    {
    	return cart;
    }
    /**
     * 顾客结帐
     * @param jsp_product_count 是该订货单总计
     * @param jsp_product_count form ShoppingForm
     */
    public void checkOut(String jsp_product_count) throws Exception {

    	String user_id="admin";
    	String order_id="OR"+this.getSystemTime("yyMMddkkmmss");
    	String order_time=this.getSystemTime("yyyy-MM-dd kk:mm:ss");
    	String order_status="0";

        String sql="insert into orders (orderid,userid,orderTime,"+
	               "orderstatus,ordercount) values ('"+order_id+"',"+
	               "'"+user_id+"','"+order_time+"',"+
	               "'"+order_status+"',"+jsp_product_count+")";
       try{
          statement.execute(sql);
          System.out.println("sql==> " + sql);
       }catch(Exception e)
       {
    	   System.out.println("insert order is error ");
       }

       for (int i = 0; i < cart.size(); i++) {
            CartItem cartitem = (CartItem) cart.elementAt(i);
            Product product=cartitem.getProduct();
            String orderitem_id="OI"+this.getSystemTime("yyMMddkkmmss")+"0"+(i+1);
            Integer product_number=cartitem.getQuantity();
            String product_id=product.getProductId();

	        String sqlitem="insert into orderitem (orderitemid,quantity,productid,"+
	   	                   "orderid) values ('"+orderitem_id+"',"+
	   	                   "'"+product_number+"','"+product_id+"',"+
	   	                   "'"+order_id+"')";

            try{
                statement.executeQuery(sqlitem);
                System.out.println("sqlitem==> " + sqlitem);
             }catch(Exception e)
             {
          	System.out.println("insert orderitem is error ");
             }
       }
       cart.clear(); //清空购物车
    }
}