How to do Data Driven Testing using TestNG

There are many ways to do Data driven tests.I used Excel sheet for reading data and FileInputStream method.

Below script explains you how to Read data from excel sheet and use the data to search google.

I am using Eclipse, selenium RC, TestNG and Excel sheet for this script.


--->Create a Java project in eclipse.
--->Create a new class DatadriventestNG.
--->Paste the below code in Eclipse.
--->Chnage the path of excel file according to your requirement.

Please note that selenium will support only .xls format plese do not forget to change the excel file to .xls if you are using MS-office2007.

Below is the code

package test;

import com.thoughtworks.selenium.*;

import org.openqa.selenium.server.*;

import org.testng.annotations.*;

public class DefaultTNG {

public Selenium selenium;

public SeleniumServer seleniumserver;

  @BeforeClass

  public void setUp() throws Exception {

RemoteControlConfiguration rc = new RemoteControlConfiguration();

seleniumserver = new SeleniumServer(rc);

selenium = new DefaultSelenium("localhost", 4444, "*iexplore", "http://");

seleniumserver.start();

selenium.start();

}

@Test

public void testDefaultTNG()throws Exception {

FileInputStream fi=new FileInputStream("F:\\Framework\\testdata\\search.xls");
Workbook w=Workbook.getWorkbook(fi);
Sheet s=w.getSheet(0);
selenium.open("http://www.google.com");
selenium.windowMaximize();
for (int i = 1; i < s.getRows(); i++)
 { 

//Read data from excel sheet
 selenium.type("name=q",s.getCell(0,i).getContents());
 selenium.click("btnG");
 Thread.sleep(1000); } 

}
@AfterClass
 public void tearDown() throws InterruptedException{
selenium.stop();
seleniumserver.stop();

 

 }

 }

 Please let me know if you need more information regarding Data driven testing....