Bean Test: January 2013

Sunday, January 27, 2013

Selenium IDE

1. Introduction:

Selenium is toot support for application which is running in Web such as: Firefox, Internet Explorer, Safari,…with some Operation System such as: Windows, Linux, Mac,…

It is support with some language such as: Java, C#, PHP, Python, Ruby,…

It is combined with other tools: Junit,… but some people only want to run normal , do not using with other tool.

It included with set of tools to test functions of web: Selenium IDE, Selenium Remote Control (RC), Selenium Core and Selenium Grid.

Selenium IDE:

It is release below extension application (add-on) in Mozilla Firefox.

It support record and Playback to help Tester record her/his objects by set of statements “Selenese”(language to developments for Selenium IDE and Selenium Core-with HTML type). After you run them to test.

Selenium IDE support to saving with many type language such as: Java, PHP, C#, Ruby, Python, Perl

2. Setup and Using

With Firefox 18.0,1, go to Web Developer -> Get more Tool -> Write “Selenium IDE” into ‘Search for collections’ and click [->] button.
After you have finished setup, please re-start Firefox. And you see item Selenium IDE in Tool folder if you have setup its successful

3. General assessment

- Selenium IDE is easily using in setup and simple.

- It is record and play back ok but no catch control with alert.

- Ii is stopped and show error when step can’t executed

HoaLe

Thursday, January 3, 2013

Pro-Testing: Tutorial Connecting to DataBase using Selenium Web...

Pro-Testing: Tutorial Connecting to DataBase using Selenium Web...: Web Driver cannot directly connect to Database. You can only interact with your Browser using Web Driver. For this we use JDBC("Java Data...

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

Here is the code for it.

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");

The below example illustrates how to use/connect MySQL with Selenium using Java.

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();

}

Tuesday, January 1, 2013

Creating an HTML5 Page

You make steps such as:

1. Select Window->Preferences from the menu bar.

2. Expand Web and select HTML Files.

3. Select ISO 10646/Unicode(UTF-8) from the Encoding drop-down.

4.   Click OK.
Creating an HTML5 page is easy. Simply follow these steps:
1.   Select File->New->Other.
2.   Expand Web and select HTML File. Click Next.
3.   Enter a file name, select the parent folder and click Next.

4. Click on [Next] button
5. Input file name
6. Click [Next] button

7. Select New HTML File (5) for the template and click Finish

8. You see generated code:

9. Open it by default web Browser

Opening the Web Page in a Browser

Some browsers are changed by:

1.   Select Window->Preferences from the menu bar.
2.   Expand General and click Web Browser.
3.   Click New.
4.   Type the name of the browser and specify its location using the Browse button

5.   Click OK.
6.   Click the Use external web browser button.
7.   Check the box next to the new browser (e.g., Google Chrome).
8.   Click OK.
9. Open link

Reference

Bean Test