package serverBag;

import java.sql.Connection;
import java.sql.PreparedStatement;

import publicBag.ConnectDB;
import publicBag.UpdateDB;

public class OrderDetails implements UpdateDB{
	private Connection con;
    //JavaBean屬性
	private int orderID;
	private int cdID;
	private String cdName;
	private double price;
	private int quantity;
	
	public int getOrderID(){ return orderID;}
	public void setOrderID(int inOrderID){ orderID = inOrderID;}	
	public int getCdID(){ return cdID;}
    public void setCdID(int inCdID){ cdID = inCdID;} 
    public String getCdName(){ return cdName;}
    public void setCdName(String inCdName){ cdName = inCdName;}  
    public double getPrice(){return price;}
    public void setPrice(double inPrice){price = inPrice;}
    public int getQuantity(){return quantity;}
    public void setQuantity(int inQuantity){quantity = inQuantity;}
    
	public OrderDetails() {
		try
        {
            con = ConnectDB.connectMusicDB();            	
        }
        catch(Exception e)
        {
            e.printStackTrace();           
        }
	}

	public boolean insertInfo() {
		// TODO 自動生成方法存根
		try
        {        	
            PreparedStatement stat = 
            	con.prepareStatement("INSERT OrderDetails VALUES(?,?,?)");
            stat.setInt(1,this.getOrderID());
            stat.setInt(2,this.getCdID());
            stat.setInt(3,this.getQuantity());
            int res = stat.executeUpdate();
            if(res > 0) return true;
            else return false;
        }
        catch(Exception e)
        {
            e.printStackTrace();
            return false;
        } 
	}

	public boolean deleteInfo() {
		// TODO 自動生成方法存根
		try
        {        	
            PreparedStatement stat = 
            	con.prepareStatement("DELETE OrderDetails WHERE iOrderID=? AND iCDID=?");
            stat.setInt(1,this.getOrderID());   
            stat.setInt(2,this.getCdID());
            int res = stat.executeUpdate();
            if(res > 0) return true;
            else return false;
        }
        catch(Exception e)
        {
            e.printStackTrace();
            return false;
        } 
	}

	public boolean updateInfo() {
		// TODO 自動生成方法存根
		try
        {        	
            PreparedStatement stat = 
            	con.prepareStatement("UPDATE OrderDetails SET iQuantity=? WHERE iOrderID=? AND iCDID=?"); 
            stat.setInt(1,this.getQuantity());
            stat.setInt(2,this.getOrderID());
            stat.setInt(3,this.getCdID());
            int res = stat.executeUpdate();
            if(res > 0) return true;
            else return false;
        }
        catch(Exception e)
        {
            e.printStackTrace();
            return false;
        } 
	}

}