orderinfo_bean.java~52~

模仿Taobao购物网

package taobaoproject;

import java.io.*;
import java.sql.*;
import java.util.*;

public class orderInfo_Bean {
    public orderInfo_Bean() {
        try {
            jbInit();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }

    private Connection conn;
    private PreparedStatement past;
    private ResultSet rst;
    private String orderDate;
    private float goodsFee;
    private float shipFee;
    private float totalPrice;
    private String shipType;
    private String payType;
    private int memberID;
    private String receiverName;
    private String receiverPhone;
    private int isConfirm;
    private int isPayment;
    private int isConsignment;
    private int isPigegonhole;
    private String receiverPostCode;
    private String receiverAdress;
    private String userName;
    private int orderID;
    private ArrayList shouJiList;
    private int buynum;
    private String goodsname;
    private int goodsID;
    private float memberPrice;
    public Connection getConn() {
        DB_Bean dbBean = new DB_Bean();
        conn = dbBean.getConn();
        return conn;
    }

    public int selectOf(String _userName) {
        getConn();
        try {
            past = conn.prepareStatement("select MemberID from tb_Member where Name = ?");
            past.setString(1,_userName);
            rst = past.executeQuery();
            rst.next();
            memberID = rst.getInt("MemberID");
        } catch (SQLException ex) {
            java.lang.System.out.println(ex);
        }
        try {
            rst.close();
            past.close();
            conn.close();
        } catch (SQLException ex1) {
            java.lang.System.out.println(ex1);
        }
        return memberID;
    }

    public int selectOrderID(int memberID) {
        getConn();
        try {
            past = conn.prepareStatement("select top 1 OrderID from tb_OrderInfo where MemberID = ? order by OrderID desc");
            past.setInt(1,memberID);
            rst = past.executeQuery();
            rst.next();
            orderID = rst.getInt("OrderID");
        } catch (SQLException ex) {
            java.lang.System.out.println(ex);
        }
        try {
            rst.close();
            past.close();
            conn.close();
        } catch (SQLException ex1) {
            java.lang.System.out.println(ex1);
        }
        return orderID;
    }

    //查询我的订单
    public ArrayList selectOrder(String _username) {
        memberID = this.selectOf(_username);
        shouJiList = new ArrayList();
        getConn();
        try {
            past = conn.prepareStatement("select * from tb_OrderInfo where MemberID = ? order by OrderID desc");
            past.setInt(1,memberID);
            rst = past.executeQuery();
            while(rst.next()) {
                orderInfo_Bean orderInfo = new orderInfo_Bean();
                orderInfo.setOrderID(rst.getInt("OrderID"));
                orderInfo.setOrderDate(rst.getString("OrderDate"));
                orderInfo.setGoodsFee(rst.getFloat("GoodsFee"));
                shouJiList.add(orderInfo);
            }
        } catch (SQLException ex) {
            java.lang.System.out.println(ex);
        }
        try {
            rst.close();
            past.close();
            conn.close();
        } catch (SQLException ex1) {
            java.lang.System.out.println(ex1);
        }
        return shouJiList;
    }

    public boolean isInsert() {
        boolean isIn = false;
        getConn();
        try {
            past = conn.prepareStatement(
                    "insert into tb_OrderInfo(OrderDate,GoodsFee,ShipFee,TotalPrice,ShipType,PayType,MemberID,ReceiverName,ReceiverPhone,ReceiverPostCode,ReceiverAdress) values(?,?,?,?,?,?,?,?,?,?,?)");
            past.setString(1,getGBK(orderDate));
            past.setFloat(2,goodsFee);
            past.setFloat(3,shipFee);
            past.setFloat(4,totalPrice);
            past.setString(5,getGBK(shipType));
            past.setString(6,getGBK(payType));
            past.setInt(7,memberID);
            past.setString(8,getGBK(receiverName));
            past.setString(9,getGBK(receiverPhone));
            past.setString(10,getGBK(receiverPostCode));
            past.setString(11,getGBK(receiverAdress));
            int i = past.executeUpdate();
            if(i > 0) {
                isIn = true;
                past.close();
                conn.close();
            }
        } catch (SQLException ex) {
            java.lang.System.out.println(ex);
        }
        return isIn;
    }

    public void isInsertxi(int _OrderID,int _GoodID,int _OrderQuantity) {
        //boolean isIn = false;
        getConn();
        try {
            past = conn.prepareStatement(
                    "insert into tb_OrderDetails(OrderID,GoodID,OrderQuantity) values(?,?,?)");
            past.setInt(1,_OrderID);
            past.setInt(2,_GoodID);
            past.setInt(3,_OrderQuantity);
            int i = past.executeUpdate();
            //isIn = true;
            past.close();
            conn.close();
        } catch (SQLException ex) {
            java.lang.System.out.println(ex);
        }
        //return isIn;
    }

    public ArrayList selectddif(int _OrderID) {
        getConn();
        shouJiList = new ArrayList();
        try {
            past = conn.prepareStatement(
                    "select a.*,b.GoodsName,b.GoodsID,b.MemberPrice from  tb_OrderDetails as a,tb_GoodsInfo as b where a.GoodID = b.GoodsID and a.OrderID = ?");
            past.setInt(1,_OrderID);
            rst = past.executeQuery();
            while(rst.next()) {
                orderInfo_Bean order = new orderInfo_Bean();
                order.setBuynum(rst.getInt("OrderQuantity"));
                order.setGoodsname(rst.getString("GoodsName"));
                order.setGoodsID(rst.getInt("GoodsID"));
                order.setMemberPrice(rst.getFloat("MemberPrice"));
                shouJiList.add(order);
            }
            past.close();
            conn.close();
        } catch (SQLException ex) {
            java.lang.System.out.println(ex);
        }
        return shouJiList;
    }

    public void setOrderDate(String orderDate) {
        this.orderDate = orderDate;
    }

    public void setGoodsFee(float goodsFee) {
        this.goodsFee = goodsFee;
    }

    public void setShipFee(float shipFee) {
        this.shipFee = shipFee;
    }

    public void setTotalPrice(float totalPrice) {
        this.totalPrice = totalPrice;
    }

    public void setShipType(String shipType) {
        this.shipType = shipType;
    }

    public void setPayType(String payType) {
        this.payType = payType;
    }

    public void setMemberID(int memberID) {
        this.memberID = memberID;
    }

    public void setReceiverName(String receiverName) {
        this.receiverName = receiverName;
    }

    public void setReceiverPhone(String receiverPhone) {
        this.receiverPhone = receiverPhone;
    }

    public void setIsConfirm(int isConfirm) {
        this.isConfirm = isConfirm;
    }

    public void setIsPayment(int isPayment) {
        this.isPayment = isPayment;
    }

    public void setIsConsignment(int isConsignment) {
        this.isConsignment = isConsignment;
    }

    public void setIsPigegonhole(int isPigegonhole) {
        this.isPigegonhole = isPigegonhole;
    }

    public void setReceiverPostCode(String receiverPostCode) {
        this.receiverPostCode = receiverPostCode;
    }

    public void setReceiverAdress(String receiverAdress) {
        this.receiverAdress = receiverAdress;
    }

    public void setUserName(String userName) {
        this.userName = userName;
    }

    public void setOrderID(int orderID) {
        this.orderID = orderID;
    }

    public void setBuynum(int buynum) {
        this.buynum = buynum;
    }

    public void setGoodsname(String goodsname) {
        this.goodsname = goodsname;
    }

    public void setGoodsID(int goodsID) {
        this.goodsID = goodsID;
    }

    public void setMemberPrice(float memberPrice) {
        this.memberPrice = memberPrice;
    }

    public String getOrderDate() {
        return orderDate;
    }

    public float getGoodsFee() {
        return goodsFee;
    }

    public float getShipFee() {
        return shipFee;
    }

    public float getTotalPrice() {
        return totalPrice;
    }

    public String getShipType() {
        return shipType;
    }

    public String getPayType() {
        return payType;
    }

    public int getMemberID() {
        return memberID;
    }

    public String getReceiverName() {
        return receiverName;
    }

    public String getReceiverPhone() {
        return receiverPhone;
    }

    public int getIsConfirm() {
        return isConfirm;
    }

    public int getIsPayment() {
        return isPayment;
    }

    public int getIsConsignment() {
        return isConsignment;
    }

    public int getIsPigegonhole() {
        return isPigegonhole;
    }

    public String getReceiverPostCode() {
        return receiverPostCode;
    }

    public String getReceiverAdress() {
        return receiverAdress;
    }

    public String getUserName() {
        return userName;
    }

    public int getOrderID() {
        return orderID;
    }

    public int getBuynum() {
        return buynum;
    }

    public String getGoodsname() {
        return goodsname;
    }

    public int getGoodsID() {
        return goodsID;
    }

    public float getMemberPrice() {
        return memberPrice;
    }

    private void jbInit() throws Exception {
    }

    public String getGBK(String str)
    {
        try {
            String ff = new String(str.getBytes("ISO-8859-1"),"GBK");
            return ff;
        } catch (UnsupportedEncodingException ex) {
            return "";
        }
    }
}