Handling Window based pop ups using web driver

    public void handleWindowsPopup() throws InterruptedException, AWTException {

        driver=new FirefoxDriver();

        driver.get("http://www.google.co.in");

        driver.findElement(By.id("gbqfq")).sendKeys("java download");

        Thread.sleep(3000);

        driver.findElement(By.id("gbqfb")).click();

        Thread.sleep(5000);

        driver.findElement(By.xpath("//h3[@class='r']/a")).click();

        Thread.sleep(5000);

        driver.findElement(By.xpath("//a[@class='jvdla0']")).click();

        Thread.sleep(5000);

        driver.findElement(By.xpath("//a[@class='jvdla0']")).click();

        Thread.sleep(5000);

        Robot robot=new Robot();

        robot.keyPress(KeyEvent.VK_TAB);

        Thread.sleep(2000);

        robot.keyPress(KeyEvent.VK_ENTER);

        Thread.sleep(5000);

        //driver.quit();

    }

     

Reading values from DB using Web driver

public class DBdataintoArraylist {

      public void studentData() throws SQLException, ClassNotFoundException {

            List<GetDBvaluesofAllDatatypes> list = new ArrayList<GetDBvaluesofAllDatatypes>();

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

            String dburl = "jdbc:mysql://localhost/test";

            String usrname = "root";

            String pswd = "root";

            String query = "SELECT * FROM Student WHERE section='A'";

            Class.forName(driver);

            Connection conn = DriverManager.getConnection(dburl, usrname, pswd);

            Statement stmt = conn.createStatement();

            ResultSet rs = stmt.executeQuery(query);

            while (rs.next()) {

                  GetDBvaluesofAllDatatypes gdb = new GetDBvaluesofAllDatatypes(

                              rs.getString("First_Name"), rs.getString("Last_Name"), rs.getInt("marks"),

                              rs.getString("Grade"), rs.getString("Section"), rs.getString("Birth_Date"));

                  list.add(gdb);

            }

            for (GetDBvaluesofAllDatatypes gdb : list) {

                  System.out.println(gdb.getFname());

                  System.out.println(gdb.getLname());

                  System.out.println(gdb.getGrade());

                  System.out.println(gdb.getMarks());

                  System.out.println(gdb.getSection());

                  System.out.println(gdb.getDate());

            }

      }

           

Connection string for mysql from QTP

server="10.1.1.1"
dbname="testdb"
dbuname="test"
dbpwd="testpwd"

Set rs=createobject("adodb.recordset")
set contf=Createobject("ADODB.Connection")
contf.Open "Driver={MySQL ODBC 3.51 Driver};SERVER=" & server & ";DATABASE=" & dbname & ";user id=" & dbuname & ";password=" & dbpwd & ";Pooling=True"
contf.CommandTimeout =300

rs.Open "SELECT user_id FROM user_details WHERE first_name='testname'",con
msgbox rs(0).value

Sort the column of a java table

The below code unsets the sort for all the columns and sets the descending order to the 2nd column of the java table

On error resume next
For i=0 to JavaWindow("Administrator").JavaTable("Pending").GetROProperty("cols")-1
    JavaWindow("Administrator").JavaTable("Pending").Object.setSortMode i,0
Next
JavaWindow("Administrator").JavaTable("Pending").Object.setSortMode 2,4
On error goto 0

Set date to date control of a java application

dt1=date-50
dt1=monthname(month(dt1),true) & " " & day(dt1) & ", " & year(dt1)
JavaWindow("Title").JavaList("To").Object.addItem dt1
JavaWindow("Title").JavaList("To").Select dt1
JavaWindow("Title").JavaButton("Go").Click

Check the background color of a row in a java table

set obj=JavaWindow("Title").JavaTable("JTable").Object
set obj1=obj.getCellRenderer(1,0)
obj.prepareRenderer obj1,1,0
set color=obj1.getBackground
If color.tostring="javax.swing.plaf.ColorUIResource[r=255,g=255,b=255]" Then
    msgbox "Its white color"
Else
    msgbox "Its not white color"
End if

Read the selected value from dropdown using Web Driver

Get selected option from dropdown:

      public String getSelecteduser(String ele) {

            WebElement dropdown = driver.findElement(By.id(ele));

            Select select = new Select(dropdown);

            WebElement option = select.getFirstSelectedOption();

            String str = option.getText();

            return str;

           

      }

Contributed by Ch. Suma