Read CSV from file



File Format
ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued
1,Chai,1,1,10 boxes x 20 bags,18,39,0,10,FALSE
2,Chang,1,1,24 - 12 oz bottles,19,17,40,25,FALSE
...
Code
CsvReader reader = new CsvReader("products.csv");

reader.readHeaders();

while (reader.readRecord())
{
	String productID = reader.get("ProductID");
	String productName = reader.get("ProductName");
	String supplierID = reader.get("SupplierID");
	String categoryID = reader.get("CategoryID");
	String quantityPerUnit = reader.get("QuantityPerUnit");
	String unitPrice = reader.get("UnitPrice");
	String unitsInStock = reader.get("UnitsInStock");
	String unitsOnOrder = reader.get("UnitsOnOrder");
	String reorderLevel = reader.get("ReorderLevel");
	String discontinued = reader.get("Discontinued");
	
	// perform program logic here

}

reader.close();