Accessing Multiple Links in the Web Page

One of the common procedures in web testing is to test if all the links present within the page are working. This can be conveniently done using a combination of the Java for-each loop and the By.tagName("a") method. The WebDriver code below checks each link from the Mercury Tours homepage to determine those that are working and those that are still under construction. 

--------------------------------------------------------------------------------------------------------------------------------
 

package com.company;

import org.openqa.selenium.By;
import org.openqa.selenium.*;
import org.openqa.selenium.WebDriver;
import org.openqa.selenium.WebElement;
import org.openqa.selenium.firefox.FirefoxDriver;

import java.util.List;
import java.util.concurrent.TimeUnit;

public class AllLinks {


    public static void main(String[] args) {
        String baseUrl = "http://newtours.demoaut.com/";
        WebDriver driver = new FirefoxDriver();
        String underConsTitle = "Under Construction: Mercury Tours";
        driver.manage().timeouts().implicitlyWait(5, TimeUnit.SECONDS);

        driver.get(baseUrl);
        List<WebElement> linkElements = driver.findElements(By.tagName("a"));
        String[] linkTexts = new String[linkElements.size()];
        int i = 0;

        //extract the link texts of each link element        for (WebElement e : linkElements)
        {
            linkTexts[i] = e.getText();
            i++;
        }

        //test each link        for (String t : linkTexts)
        {
            driver.findElement(By.linkText(t)).click();
            if (driver.getTitle().equals(underConsTitle))
            {
                System.out.println("\"" + t + "\""                        + " is under construction.");
            } else            {
                System.out.println("\"" + t + "\""                        + " is working.");
            }
            driver.navigate().back();
        }
        driver.quit();
    }
}

--------------------------------------------------------------------------------------------------------------------------------
 

How to works with Ajax controls using Selenium Webdriver

AJAX stands for Asynchronous JavaScript and AJAX allows the Web page to retrieve small amounts of data from the server without reloading the entire page. In AJAX driven web applications, data is retrieved from server without refreshing the page.

When we perform any action on Ajax controls, using Wait commands will not work as the page is not actually refreshed here. Pausing the test execution using threads for a certain period of time is also not a good approach as web element might appear later or earlier than the stipulated period of time depending on the system’s responsiveness, load or other uncontrolled factors of the moment, leads to test failures.

The best approach would be to wait for the required element in a dynamic period and then continue the test execution as soon as the element is found/visible.

This can done achieved with WebDriverWait in combination with ExpectedCondition , the best way to wait for an element dynamically, checking for the condition every second and continuing to the next command in the script as soon as the condition is met.

There are many methods which are available to use with wait.until(ExpectedConditions.anyCondition); The below is the image for the number of methods which are available.

The below are the few which we use regularly when testing an application :-

Syntax:

WebDriverWait wait = new WebDriverWait(driver, waitTime); wait.until(ExpectedConditions.presenceOfElementLocated(locator));

The above statement will check for the element presence on the DOM of a page. This does not necessarily mean that the element is visible.

Syntax:

WebDriverWait wait = new WebDriverWait(driver, waitTime); wait.until(ExpectedConditions.visibilityOfElementLocated(locator));

 

The above syntax will for the element present in the DOM of a page is visible.

Some times we may also need to check if the element is invisible or not. To do this we need use the below :

Syntax:

WebDriverWait wait = new WebDriverWait(driver, waitTime); wait.until(ExpectedConditions.invisibilityOfElementLocated(locator));

Some times you will get an exception as ""org.openqa.selenium.WebDriverException: Element is not clickable at point (611, 419). Other element would receive the click:'. The below one is used to wait for the element to be clickable.

Syntax:

WebDriverWait wait = new WebDriverWait(driver, waitTime); wait.until(ExpectedConditions.elementToBeClickable(locator));

Click here for WebDriver Waits example and Synchronization in WebDriver

------------------------------------------------------------------------------------------------------------------

package com.pack.ajax;

import org.openqa.selenium.By;
import org.openqa.selenium.WebDriver;
import org.openqa.selenium.WebElement;
import org.openqa.selenium.firefox.FirefoxDriver;
import org.openqa.selenium.support.ui.ExpectedConditions;
import org.openqa.selenium.support.ui.WebDriverWait;
import org.testng.Assert;
import org.testng.annotations.BeforeClass;
import org.testng.annotations.Test;

public class AjaxExample {
 
 private String URL = "http://demos.telerik.com/aspnet-ajax/
                                  ajax/examples/loadingpanel/explicitshowhide/defaultcs.aspx";
 
 WebDriver driver;
 WebDriverWait wait;
 
 @BeforeClass
 public void setUp() {
  driver=new FirefoxDriver();
  driver.manage().window().maximize();
  driver.navigate().to(URL);
 }
 
 @Test
 public void test_AjaxExample() {

  /*Wait for grid to appear*/
  By container = By.cssSelector(".demo-container");
  wait = new WebDriverWait(driver, 5);
  wait.until(ExpectedConditions.presenceOfElementLocated(container));
  
  /*Get the text before performing an ajax call*/
  WebElement noDatesTextElement = driver.findElement(By.xpath("//div[@class='RadAjaxPanel']/span"));
  String textBeforeAjaxCall = noDatesTextElement.getText().trim();
  
  /*Click on the date*/
  driver.findElement(By.linkText("1")).click();
 
  /*Wait for loader to disappear */
  By loader = By.className("raDiv");
  wait.until(ExpectedConditions.invisibilityOfElementLocated(loader));
  
  /*Get the text after ajax call*/
  WebElement selectedDatesTextElement = driver.findElement(By.xpath("//div[@class='RadAjaxPanel']/span"));
  wait.until(ExpectedConditions.visibilityOf(selectedDatesTextElement));
  String textAfterAjaxCall = selectedDatesTextElement.getText().trim();
  
  /*Verify both texts before ajax call and after ajax call text.*/
  Assert.assertNotEquals(textBeforeAjaxCall, textAfterAjaxCall);
  
  String expectedTextAfterAjaxCall = "Thursday, January 01, 2015";
  
  /*Verify expected text with text updated after ajax call*/
  Assert.assertEquals(textAfterAjaxCall, expectedTextAfterAjaxCall);
 }

}

------------------------------------------------------------------------------------------------------------------

Connect Database Using Selenium WebDriver

Tutorial Connecting to DataBase using Selenium WebDriver 

Web Driver cannot directly connect to Database. You can only interact with your Browser using Web Driver. For this we use JDBC("Java Database Connectivity").The JDBC API is a Java API for accessing virtually any kind of tabular data.The value of the JDBC API is that an application can access virtually any data source and run on any platform with a Java Virtual Machine.

In simplest terms, a JDBC technology-based driver ("JDBC driver") makes it possible to do three things:

1.Establish a connection with a data source
2.Send queries and update statements to the data source
3.Process the results

 1.Establish a connection with a data source
The traditional way to establish a connection with a database is to call the method
DriverManager.getConnection(URL,  "username", "password" )
URL :   jdbc:<subprotocol>:<subname>
<subprotocol>-the name of the driver or the name of a database connectivity mechanism
<subname> - The point of a subname is to give enough information to locate the data source .(Includes IP address , Port number and exact name of DataSource)

For connecting to MYSQL URL will be
jdbc:mysql://localhost:3306/hoale

2.Send queries and update statements to the data source
A Statement object is used to send SQL statements to a database over the created connection in Step 1.
Statement-created by the Connection.createStatement methods. A Statement object is used for sending SQL statements with no parameters.
PreparedStatement-created by the Connection.prepareStatement methods. A PreparedStatement object is used for precompiled SQL statements. These can take one or more parameters as input arguments (IN parameters).
CallableStatement-created by the Connection.prepareCall methods. CallableStatement objects are used to execute SQL stored procedures
In Short
createStatement methods-for a simple SQL statement (no parameters)
prepareStatement methods-for an SQL statement that is executed frequently
prepareCall methods-for a call to a stored procedure

3.Process the results
A ResultSet is a Java object that contains the results of executing an SQL query.We will have separate post on it.The JDBC API provides three interfaces for sending SQL statements to the database.

Prerequisites:

-      mysql-connector-java-5.1.0-bin.jar  or above versions

-      Create table Employee in Navicat

-      Reading a old http://howtesting.blogspot.com/2013/01/creating-html5-page.html create a sample webform

This is example for connection DataBase(mysql) using Selenium WebDriver

 

package com;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

import org.openqa.selenium.By;

import org.openqa.selenium.WebDriver;

import org.openqa.selenium.WebElement;

import org.openqa.selenium.firefox.FirefoxDriver;

import org.testng.annotations.AfterTest;

import org.testng.annotations.BeforeTest;

import org.testng.annotations.Test;

import com.mysql.jdbc.ResultSet;

import com.mysql.jdbc.Statement;

import com.thoughtworks.selenium.SeleneseTestBase;

public class ConnectDB extends SeleneseTestBase{

     WebDriver driver;

     String url ="";

     @BeforeTest

public void setUp() throws Exception{

     driver = new FirefoxDriver();

     url = "file:///D:/ECLIPSE/workspace_eclipseclassic/ConnectDB/src/com/modules/HTML5Demo.html";

     driver.get(url);

}

     @Test

     public void CreateDB() throws InstantiationException, IllegalAccessException, ClassNotFoundException, SQLException{

           //Prepare connection

           String url1 ="jdbc:mysql://localhost:3306/hoale";

           // Load Microsoft SQL Server JDBC driver

           String dbClass = "com.mysql.jdbc.Driver";

           Class.forName(dbClass).newInstance();

           //Get connection to DB

           Connection con = DriverManager.getConnection(url1, "root", "");

           //Create Statement

           Statement stmt = (Statement) con.createStatement();

           // method which returns the requested information as rows of data

           ResultSet result = (ResultSet) stmt.executeQuery("select * from employee");

           if(result.next())

           {

                String id = result.getString("ID");

                String info = result.getString("Info");

                driver.getCurrentUrl();

                WebElement a = driver.findElement(By.id("txtID"));

                a.sendKeys(id);

                WebElement b = driver.findElement(By.id("txtInfo"));

                b.sendKeys(info);

                WebElement btnclick = driver.findElement(By.id("btnclick"));

                btnclick.click();

                System.out.print("Passed");

           }

     }

    

     @AfterTest

public void tearDown(){

     driver.close();

}

}