public synchronized static DataTable<OrderItem> findOrderItemsbyCustomerID(int customerID) throws SQLException
	{
		DataTable<OrderItem> result = new DataTable<OrderItem>();
		Connection connection = null;
		PreparedStatement  prepStmt = null;

		try 
	    {
			connection = DB.getConnection();
			connection.setAutoCommit(true);

			prepStmt = connection.prepareStatement("SELECT OT.* FROM CustomerOrder CO INNER JOIN OrderItem OT ON CO.OrderItemID	=  OT.OrderItemID WHERE CustomerID = ?;");
			prepStmt.setInt(1, customerID);
			prepStmt.setMaxRows(1); 

			ResultSet rs = prepStmt.executeQuery();

			while (rs.next()) 
			{
				OrderItem order = new OrderItem();

				order = new OrderItem();
				order.OrderItemID 	= rs.getInt("OrderItemID");
				order.ProductID 	= rs.getInt("ProductID");
				order.Quantity 		= rs.getInt("Quantity");
				order.Discount 		= rs.getDouble("Discount");
				order.OrderDate 	= rs.getDate("OrderDate");
				order.ShippingDate 	= rs.getDate("ShippingDate");
				order.Delivered 	= rs.getBoolean("Delivered");

				order.loadProduct();
				result.addRow(order);
			}
			rs.close();
			prepStmt.close();
			DB.closeConnection();

			return result;
		}
		catch (Exception e) 
		{
	    	throw e;
		}
	}