Data Driven in Selenium Webdriver

 

Data driven in Selenium webdriver . Read Data from excel sheet and fill the username and password of gmail.

Source code:

import java.io.FileInputStream;

import jxl.Sheet;
import jxl.Workbook;

import org.openqa.selenium.By;
import org.openqa.selenium.WebDriver;
import org.openqa.selenium.firefox.FirefoxDriver;
import org.testng.annotations.AfterClass;
import org.testng.annotations.BeforeClass;
import org.testng.annotations.Test;

public class EmailTest {
private WebDriver driver;

@BeforeClass
public void Startup() {
driver = new FirefoxDriver();
}

@Test(description = "Read Gmail account")
public void Login() throws Exception {
FileInputStream fi = new FileInputStream("E:\\testemail.xls");
Workbook w = Workbook.getWorkbook(fi);
Sheet s = w.getSheet(0);
driver.get("http://www.gmail.com");
try {
for (int i = 1; i < s.getRows(); i++) {
// Read data from excel sheet
String s1 = s.getCell(0, i).getContents();
String s2 = s.getCell(1, i).getContents();
driver.findElement(By.name("Email")).sendKeys(s1);
driver.findElement(By.name("Passwd")).sendKeys(s2);
driver.findElement(By.name("signIn")).click();
Thread.sleep(9000);

}
} catch (Exception e) {
System.out.println(e);
}
}

@AfterClass
public void teardown() {
driver.quit();
}
}

Display Alert Message of Test case

We can display alert message in screen to know which test case is executing or to show user of respective action.



Method to display alert Message of test case -

public void Show_ScriptMessage_Close(String Message , int time) throws Exception
  {
     
      time = time * 1000; // 1 value to 1000
       final ImageIcon icon = new ImageIcon("C:\\Selenium\\Test_data\\prathip.png");
        final JOptionPane optionPane = new JOptionPane(Message, JOptionPane.INFORMATION_MESSAGE, JOptionPane.DEFAULT_OPTION, icon , new Object[]{}, null);

        final JDialog dialog = new JDialog();
        dialog.setTitle("Selenium Scripting - Prathip");
       
        dialog.setModal(true);
       
        dialog.setLocationRelativeTo(null);
        dialog.setLocation((Toolkit.getDefaultToolkit().getScreenSize().width)/2 - dialog.getWidth()/2, (Toolkit.getDefaultToolkit().getScreenSize().height)/2 - dialog.getHeight()/2);
        dialog.setContentPane(optionPane);

        dialog.setDefaultCloseOperation(JDialog.DO_NOTHING_ON_CLOSE);
         
     
        dialog.pack();
       
      //create timer to dispose of dialog after 5 seconds
        // 1 sec = 1000
        Timer timer = new Timer(time, new AbstractAction() {
            @Override
            public void actionPerformed(ActionEvent ae) {
                dialog.dispose();
            }
        });
        timer.setRepeats(false);//the timer should only go off once

        //start timer to close JDialog as dialog modal we must start the timer before its visible
        timer.start();

        dialog.setVisible(true);
     
  }




how to call the function -

Show_ScriptMessage_Close("Google Search" , 5);