orderbean.java

项目名称eShop

/*
 * 创建日期：2006-7-17 10:37:20
 *
 * 代码作者：Administrator
 * 
 * 项目名称：eShop
 * 
 * Copyright 2005 Metarnet, Inc. All right reserved.
 */
package eshop.business;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.*;
import eshop.business.*;
import eshop.common.DBConnection;
import java.math.*;


/**
 * <h5>功能说明:</h5>
 *
 * <h5>对应需求:</h5>
 * 
 *
 * @version 1.0
 * @author Administrator
 */
public class OrderBean
{
    
   
    /**@param OrderVO 
     * @删除订单  根据订单号，订单状态删除 */
    public int deleteOrder(String strOrderID)throws Exception
    {
        int intResult=0; 
        Connection conn=DBConnection.getConnection();        
        Statement stmt=conn.createStatement();        
        try
        {   
                      
           String strSQL="delete from T_ORDER where F_ORDERID='"+strOrderID+"'";
           
          intResult=stmt.executeUpdate(strSQL); //返回成功执行的行计数 
        }
        catch(Exception e)
        {
            intResult=0;
            e.printStackTrace();
            throw e;
        }
        finally
        {
            conn.close();             
        }
       
        return intResult;  
    }
    

    /**@param OrderVO 
     * @获得某张订单的信息  根据订单号，订单状态
     *      在此只是列出除了图书信息以外的订单信息 */
    public OrderVO getOrder()
    {
       // TODO: implement
       return null;
    }
    
    /**@param UserCode 
     * @获得某用户所有订单  根据用户名UserCode */
    public Vector getOrders(String strUserCode)throws Exception
    {
        Connection conn=DBConnection.getConnection();        
        Statement stmt=conn.createStatement();     
        ResultSet rs=null;
        int intDoneNum=0;
        float fltTotalPaid=0;
        
        Vector vecOrders=new Vector();
        try
        {   
            String strSQL="select * from T_ORDER where F_USERCODE='"+strUserCode+"' order by F_ORDERID desc";
            
            rs=stmt.executeQuery(strSQL);
            
           while(rs.next())
           {
               String strOrderID=rs.getString("F_ORDERID");            
               String strOrderState=rs.getString("F_ORDERSTATE");
               String strRecName=rs.getString("F_RECNAME");        
               float  fltPaid=rs.getFloat("F_PAID");
               BigDecimal bdPaid=BigDecimal.valueOf(fltPaid);
               
               
               OrderVO order=new OrderVO();
               
               order.setOrderID(strOrderID);
               order.setOrderState(strOrderState);
               order.setRecName(strRecName);
               order.setPaid(bdPaid);
               if(strOrderState.equals(new String("已到货")))
               {
                   intDoneNum++;
               }
               fltTotalPaid+=fltPaid;
               vecOrders.addElement(order);
           }
           vecOrders.addElement(new Integer(intDoneNum));
           vecOrders.addElement(new Float(fltTotalPaid));
        }
        catch(Exception e)
        {
            e.printStackTrace();
            throw e;
        }
        finally
        {
            conn.close();             
        }
       
       return vecOrders;
    }
   
    
    /**@param OrderVO中的订单金额和订单状态 
     * @确认订单  将订单总费用存入数据库，将订单状态修改为“未处理” */
    public int addOrder(OrderVO aOrder,int intBookID,int intBookNum)throws Exception
    {
        int intResult=0; 
        Connection conn=DBConnection.getConnection();        
        Statement stmt=conn.createStatement();        
        try
        {   
            String strOrderID=aOrder.getOrderID(); 
            String strUserCode=aOrder.getUserCode();
            String strOrderDate=aOrder.getOrderDate();
            String strOrderState=aOrder.getOrderState();
            String strRecName=aOrder.getRecName();
            String strAddress=aOrder.getRecAddress();
            String strPostCode=aOrder.getRecPostCode();
            String strTel=aOrder.getRecTel();
            String strEmail=aOrder.getRecEmail();
            String strDeliverMethod=aOrder.getDeliverMethod();
            String strPayMethod=aOrder.getPayMethod();
            BigDecimal bdPaid=aOrder.getPaid();
            float fltPaid=Float.parseFloat(String.valueOf(bdPaid));
            
           String strSQL="insert into T_ORDER(F_ORDERID,F_USERCODE,F_ORDERDATE," +
           		"F_BOOKID,F_ORDERNUM,F_ORDERSTATE,F_RECNAME,F_RECADDRESS"+
                      ",F_RECPOSTCODE,F_RECTEL,F_RECEMAIL,F_DELIVERMETHOD"+
                      ",F_PAYMETHOD,F_PAID) values('"+strOrderID+"','"+strUserCode+
                      "','"+strOrderDate+"',"+String.valueOf(intBookID)+","+String.valueOf(intBookNum)+
                      ",'"+strOrderState+"','"+strRecName+"','"+strAddress+
                      "','"+strPostCode+"','"+strTel+"','"+strEmail+"','"+strDeliverMethod+
                      "','"+strPayMethod+"',"+fltPaid+")";
           
          intResult=stmt.executeUpdate(strSQL); //返回成功执行的行计数 
        }
        catch(Exception e)
        {
            intResult=0;
            e.printStackTrace();
            throw e;
        }
        finally
        {
            conn.close();             
        }
       
        return intResult;  
    }
}