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


public class ProductEntity
{
	private String id;
	private String productName;
	private String productPrice;
	private String productNote;
	
		
	public static String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
	public static String sConnStr = "jdbc:odbc:cart";
	public static Connection conn = null;
	
	
	public ProductEntity(String id,String productName,String productPrice,String productNote)
	{
		try 
		{
			Class.forName(sDBDriver); 
	    	}
	  	catch(java.lang.ClassNotFoundException e) 
	  	{
			System.err.println("ProductEntity: " + e.getMessage());
		}
		
		this.id=id;
		this.productName=productName;
		this.productPrice=productPrice;
		this.productNote=productNote;
	}
	
	public static Vector queryProduct(String productId,int pageCount,int pageSize) throws SQLException
	{
		pageCount=pageCount-1;//the pageCount start with 1.
		try 
		{
			Class.forName(sDBDriver); 
	    	}
	  	catch(java.lang.ClassNotFoundException e) 
	  	{
			System.err.println("ProductEntity: " + e.getMessage());
		}
            
                //query from database
		String sql="select id,product_name,product_price,product_note from product ";
		if(productId.compareTo("")!=0)
			sql=sql+" where id = ? ";
		Vector v=new Vector();
		
		ResultSet rs = null;	
		try 
		{
			conn = DriverManager.getConnection(sConnStr); 
			PreparedStatement prepStmt = conn.prepareStatement(sql);
			
			if(productId.compareTo("")!=0)
				prepStmt.setInt(1,Integer.parseInt(productId));
						
			rs = prepStmt.executeQuery();
		} 
		catch(SQLException ex) 
		{ 
			System.err.println("OrderItemEntity executeQuery: " + ex.getMessage());
		}
		
		int i=0;
		while(rs.next())
		{
			++i;
			if(i>pageCount*pageSize)
			{
				if(i<=(pageCount+1)*pageSize)
					v.add(new ProductEntity(rs.getString(1),rs.getString(2),rs.getString(3),rs.getString(4)));
				else
					break;
			}
			
		}
		
		return v;
		
	}
	
	
	public String getProductId()
	{
		return id;	
	}

	public String getProductName()
	{
		return productName;
	}
	
	public String getProductPrice()
	{
		return productPrice;
	}

	public String getProductNote()
	{
		return productNote;
	}
		
}