Road to data driven testing in webdriver java TestNg Part 2

In my previous two post, I have posted two approaches for data driven testing using java webdriver one for using testNG and another without testNg using excel file.

1. Data driven testing using java webdriver TestNg framework.
2. Road to data driven testing in webdriver java Part 1

In this post I am going to show you, how to perform data driven testing in webdriver with testNG framework using data from external excel file. I am continuing from my previous post “Road to data driven testing in webdriver java Part 1”

I have created below java file using TestNg data provider annotation for the same data which I have used in my previous post Road to data driven testing in webdriver java Part 1.

package com.webdriver.test;

import java.util.List;
import java.util.concurrent.TimeUnit;
import org.openqa.selenium.By;
import org.openqa.selenium.WebDriver;
import org.openqa.selenium.firefox.FirefoxDriver;
import org.testng.Assert;
import org.testng.annotations.AfterSuite;
import org.testng.annotations.BeforeSuite;
import org.testng.annotations.DataProvider;
import org.testng.annotations.Test;

public class NavigateURL {

       private WebDriver driver;
       private String baseUrl;

       @DataProvider(name = "myTest")
        public Object[][] createData1() {

                  ReadXLS readXls = new ReadXLS();
                  List dataList = readXls.getData();
                  Object obj[][] = new Object[dataList.size()][2];
                  for (int i = 1; i < dataList.size(); i++) {
                         String[] test = (String[]) dataList.get(i);
                         String countryName = test[0];
                         String countryDesc = test[1];
                         obj[i][0] = countryName;
                         obj[i][1] = countryDesc;
                  }
                  return obj;                     
         }

        @BeforeSuite
         public void setUp() throws Exception {
                    driver = new FirefoxDriver();
                    baseUrl = "http://www.wikipedia.org/";
                    driver.manage().timeouts().implicitlyWait(30, TimeUnit.SECONDS);
           }

         @Test(dataProvider = "myTest")
         public void testSearchCountry(String country, String desc) throws Exception {
                    driver.get(baseUrl + "/wiki/Main_Page");
                    driver.findElement(By.id("searchInput")).clear();
                    driver.findElement(By.id("searchInput")).sendKeys(country);
                    driver.findElement(By.id("searchButton")).click();
                    String str = driver.findElement(
                                         By.xpath("//h1[@id='firstHeading']/span")).getText();
                    System.out.println(desc);
                    Assert.assertTrue(str.contains(country));
            }
                   

          @AfterSuite
          public void tearDown() throws Exception {
                    driver.quit();
           }
}

Run above test you should see that test will execute separate for each set of data. Failed test for any set of data does not impact on other data set.