shouji_bean.java

模仿Taobao购物网

package taobaoproject;

import java.sql.*;

public class ShouJI_Bean implements java.io.Serializable {
    private Connection conn;
    private PreparedStatement past;
    private ResultSet rst;
    private int goodsID;
    private String goodsName;
    private float memberPrice;
    private int buynum;
    private float marketPrice;

    public Connection getConn() {
        DB_Bean dbBean = new DB_Bean();
        conn = dbBean.getConn();
        return conn;
    }

    public void buy(int _goodsID,int _buynum) {
        getConn();
        //String sql = "select * from tb_GoodsInfo where GoodsID = " + _goodsID;
        try {
            past = conn.prepareStatement("select * from tb_GoodsInfo where GoodsID = ?");
            past.setInt(1,_goodsID);
            rst = past.executeQuery();
            rst.next();
            goodsID = _goodsID;
            goodsName = rst.getString("GoodsName");
            marketPrice = rst.getFloat("MarketPrice");
            memberPrice = rst.getFloat("MemberPrice");
            buynum = _buynum;
            //java.lang.System.out.println(sql);
        } 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);
        }
    }

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

    public void setGoodsName(String goodsName) {
        this.goodsName = goodsName;
    }

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

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

    public void setMarketPrice(float marketPrice) {
        this.marketPrice = marketPrice;
    }

    public int getGoodsID() {
        return goodsID;
    }

    public String getGoodsName() {
        return goodsName;
    }

    public float getMemberPrice() {
        return memberPrice;
    }

    public int getBuynum() {
        return buynum;
    }

    public float getMarketPrice() {
        return marketPrice;
    }
}