selenium利用Excel进行参数化（简单示例）
上篇搭建好环境后，正真开始我的自动化之旅了....
开始之前特别说明一下testNG的版本，不能直接使用Eclipse直接线上下载的版本，线上版本太高，不能兼容，运行程序会报以下错误，需要自行下载低一级的版本。
1、下载jexcelapi_2_6_12.tar.gz，在上篇的项目基础上创建com.testNG包，并且引入下载的jar包，用于Excel函数调用。
2、创建IData接口
1 package com.testNg;
2 /**
3 * @author bjlijia
4 * @version 1.0.0
5 */
6 public interface IData {
7
8 public Object[][] getData(String caseName, String dataFile);
9
10 public Object[][] getData(String caseName, String dataFile,int colNum) ;
11
12 public Object[][] getData(String caseName, String dataFile,int beginNum,int endNum) ;
13
14 }
3、创建类BaseExcelData
package com.testNg;
import java.io.*;
import java.util.ArrayList;
import jxl.*;
import jxl.read.biff.BiffException;
/**
* @author kaixie
* @version 1.0.0
*/
public class BaseExcelData implements IData{
String defaultPath = "D:/";
public Object[][] getData(String caseName, String dataFile){
return getData(caseName, dataFile, 0);
}
public Object[][] getData(String caseName, String dataFile, int rowNum) {
Object[][] data = null;
try {
data = addList(caseName, dataFile, rowNum);
} catch (FileNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return data;
}
public Object[][] getData(String caseName, String dataFile, int beginRowNum, int endRowNum) {
Object[][] data = null;
try {
data = addList2(caseName, dataFile, beginRowNum, endRowNum);
} catch (FileNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return data;
}
private Object[][] addList(String caseName,String dataFile,int rowNum) throws FileNotFoundException{
ArrayList<Object> list = new ArrayList<Object>();
// 文件路径
InputStream is = new FileInputStream(defaultPath + dataFile);
Object[][] data = null;
try {
Workbook wb = Workbook.getWorkbook(is);
Sheet rs = wb.getSheet(caseName);
//获取表格总行数
int rsRows = rs.getRows();
//获取表格总列数
int rsColumns = rs.getColumns();
if(rs!=null){
for (int i = 1; i <= rsRows-1; i++){
for (int j=0; j <= rsColumns-1; j++){
Cell c = rs.getCell(j, i);
String cz = c.getContents();
list.add(cz);
}
}
//System.out.println(list);
}
if (rowNum <= 0 || rowNum >= rsRows) {
data = new Object[rsRows-1][rsColumns];
int k = -1;
for (int i = 0; i < rsRows-1; i++) {
for (int j = 0; j < rsColumns; j++) {
if (k < list.size())
k++;
data[i][j] = list.get(k);
//System.out.println("i="+i+","+"j="+j+","+data[i][j]);
}
}
} else {
int k = -1;
data = new Object[rowNum][rsColumns];
for (int i = 0; i < rowNum; i++) {
for (int j = 0; j < rsColumns; j++) {
if (k < list.size())
k++;
if (i <= (rowNum - 1)) {
data[i][j] = list.get(k);
}
}
}
}
wb.close();
} catch (BiffException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return data;
}
private Object[][] addList2(String caseName, String dataFile, int beginNum,
int endNum) throws FileNotFoundException {
ArrayList<Object> list = new ArrayList<Object>();
// 文件路径
InputStream is = new FileInputStream(defaultPath + dataFile);
Object[][] data = null;
try {
Workbook wb = Workbook.getWorkbook(is);
Sheet rs = wb.getSheet(caseName);
//获取表格总行数
int rsRows = rs.getRows();
//获取表格总列数
int rsColumns = rs.getColumns();
if(rs!=null){
for (int i = 1; i <= rsRows-1; i++){
for (int j=0; j <= rsColumns-1; j++){
Cell c = rs.getCell(j, i);
String cz = c.getContents();
list.add(cz);
}
}
//System.out.println(list);
}
int sub = (endNum - beginNum) + 1;
data = new Object[sub][rsColumns];
if (beginNum <= 0 || endNum > rsRows) {
if(beginNum <= 0&&endNum > rsRows){
beginNum=0;
endNum=rsRows;
data = new Object[rsRows][rsColumns];
for (int i = 0; i < sub; i++) {
for (int j = 0; j < rsColumns; j++) {
if (beginNum < rsRows*rsColumns)
data[i][j] = list.get(beginNum);
beginNum++;
}
}
}else if (beginNum <= 0&&endNum <= rsRows){
beginNum=0;
sub=(endNum - beginNum);
data = new Object[endNum][rsColumns];
for (int i = 0; i < sub; i++) {
for (int j = 0; j < rsColumns; j++) {
if (beginNum < sub * rsColumns)
data[i][j] = list.get(beginNum);
beginNum++;
}
}
}else {
endNum=rsRows;
sub=(endNum - beginNum) + 1;
data = new Object[sub][rsColumns];
for (int i = 0; i < sub; i++) {
for (int j = 0; j < rsColumns; j++) {
if (beginNum <=sub * rsColumns)
data[i][j] = list.get(beginNum-1);
beginNum++;
}
}
}
} else {
int k = 0;
int a=beginNum*rsColumns;
for (int i = 0; i < sub; i++) {
for (int j = 0; j < rsColumns; j++) {
if (k < sub * rsColumns)
data[i][j] = list.get(a+k-2);
k++;
}
}
}
wb.close();
} catch (BiffException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return data;
}
}
4、创建类ExcelDataProvider
package com.testNg;
import java.io.FileNotFoundException;
import java.lang.reflect.Method;
import org.testng.annotations.DataProvider;
/**
* @author kaixie
* @version 1.0.0
*/
public class ExcelDataProvider {
// 从XML文本文件中获得数据
@DataProvider(name = "GetDataFromXml")
public static Object[][] getTestDataFromXml(Method m) throws FileNotFoundException {
// 通过反射获得函数名称，可以为多个测试方法提供数据驱动
Object[][] o = new Object[][] {};
// 取用例数据集d1Test的全部数据(excel数据源)
if (m.getName().equals("test1")) {
return new BaseExcelData().getData("testA", "DataProvider.xls",0,3);
}
if (m.getName().equals("test2")) {
return new BaseExcelData().getData("testB", "DataProvider.xls",2,5);
}
//取用例数据集d2Test的全部数据(excel数据源)
/*if (m.getName().equals("test1")) {
return new BaseExcelData.getData("d1Test","caipiaoTest.xls")
}*/
return o;
}
}
5、创建测试类Baidutest
package com.testNg;
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.Test;
public class Baidutest {
@Test(dataProvider = "GetDataFromXml", dataProviderClass = ExcelDataProvider.class)
public void test1(String URL, String context) {
//String expected = "";
//如果火狐浏览器没有默认安装在C盘，需要制定其路径
//System.setProperty("webdriver.firefox.bin", "D:/Program Files/Mozilla firefox/firefox.exe");
WebDriver driver = new FirefoxDriver();
driver.get(URL);
driver.manage().window().maximize();
WebElement txtbox = driver.findElement(By.name("wd"));
txtbox.sendKeys(context);
WebElement btn = driver.findElement(By.id("su"));
btn.click();
driver.close();
}
}
6、测试用例如下：
7、右击选择TestNG运行测试并且测试结果如下：
也可以在项目路径下D:\study\WebDriverDemo\test-output\Default suite\Default test.html，TestNG默认的HTML测试报告，如下所示：
