package cart;
import java.sql.*;
import java.util.*;
import java.math.*;
import javax.sql.*;

public class OrderItemEntity
{
	private String id;
	private String orderId;
	private String productId;
	private String productNum;
	
	private int price;//only for session use
	
	
	public static String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
	public static String sConnStr = "jdbc:odbc:cart";
	public static Connection conn = null;
		
	public OrderItemEntity(String id,String orderId,String productId,String productNum,int price)
	{
		try 
		{
			Class.forName(sDBDriver); 
	    	}
	  	catch(java.lang.ClassNotFoundException e) 
	  	{
			System.err.println("OrderItemEntity: " + e.getMessage());
		}
		
		this.id=id;
		this.orderId=orderId;
		this.productId=productId;
		this.productNum=productNum;
		this.price=price;
	}
	
	public void insertOrderItem() throws SQLException
	{
		//insert into database
		String sql="insert into order_item(order_id,product_id,product_num) values(?,?,?) ";
	
		
		ResultSet rs = null;
		try 
		{
			conn = DriverManager.getConnection(sConnStr); 
			PreparedStatement prepStmt = conn.prepareStatement(sql);
			
			prepStmt.setString(1,orderId);
			prepStmt.setString(2,productId);
			prepStmt.setString(3,productNum);
			
			
			prepStmt.executeUpdate();
		} 
		catch(SQLException ex) 
		{ 
			System.err.println("OrderItemEntity executeQuery: " + ex.getMessage());
		}
		
	}
	
	public static Vector queryOrderItem(String orderId) throws SQLException
	{
		try 
		{
			Class.forName(sDBDriver); 
	    	}
	  	catch(java.lang.ClassNotFoundException e) 
	  	{
			System.err.println("OrderItemEntity: " + e.getMessage());
		}
                
                //query from database
		String sql="select id,order_id,product_id,product_num from order_item where order_id= ? ";
		Vector v=new Vector();
		ResultSet rs = null;
                
		try 
		{
			conn = DriverManager.getConnection(sConnStr); 
			PreparedStatement prepStmt = conn.prepareStatement(sql);
			
			prepStmt.setString(1,orderId);
			
			rs = prepStmt.executeQuery();
		} 
		catch(SQLException ex) 
		{ 
			System.err.println("OrderItemEntity executeQuery: " + ex.getMessage());
		}
		
		while(rs.next())
		{
			v.add(new OrderItemEntity(rs.getString(1),rs.getString(2),rs.getString(3),rs.getString(4),0));
		}
		
		return v;
		
	}
	
	public String getOrderId()
	{	
		return orderId;
	}
	
	public void setOrderId(String orderId)
	{	
		this.orderId=orderId;
	}
	
	public String getOrderItemId()
	{
		return id;
	}
	
	public String getProductId()
	{
		return productId;
	}
	
	public String getProductNum()
	{
		return productNum;
	}
	
	public void setProductNum(String productNum)
	{
		this.productNum=productNum;
	}
	
	public int getPrice()
	{
		return price;
	}
	
}