selenium 入门学习 (四)

海鸥一飞

     通过Excel对用例参数进行配置
     pom.xm依赖:

1. <dependency>
   
2.     <groupId>net.sourceforge.jexcelapi</groupId>
   
3.     <artifactId>jxl</artifactId>
   
4.     <version>2.6.12</version>
   
5. </dependency>

复制代码

    Excel读取类：通过迭代器实现，这样比较方便封装，实现Excel读取类型的多态性；这里用的是
Map实现；

1. public class ExcelIterator implements Iterator<Object[]> {
   
2. private Workbook book = null;
   
3. private Sheet sheet = null;
   
4. 
   
5. private int rowNum = 0;
   
6. private int curRowNo = 0;
   
7. private int columnNum = 0;
   
8. private String[] columnName;
   
9. private int singleline = 0;
   
10. 
    
11. public ExcelIterator(String filename, String testMethodname) {
    
12.     try {
    
13.         FileInputStream fs = new FileInputStream(filename);
    
14.         this.book = Workbook.getWorkbook(fs);
    
15.         this.sheet = book.getSheet(testMethodname);
    
16.         this.rowNum = sheet.getRows();
    
17.         Cell[] c = sheet.getRow(0);
    
18.         this.columnNum = c.length;
    
19.         columnName = new String[c.length];
    
20.         for (int i = 0; i < c.length; i++) {
    
21.             columnName[i] = c[i].getContents().toString();
    
22.         }
    
23. 
    
24.         if (this.singleline > 0) {
    
25.             this.curRowNo = this.singleline;
    
26.         } else {
    
27.             this.curRowNo++;
    
28.         }
    
29. 
    
30.     } catch (FileNotFoundException e) {
    
31.         System.out.println("文件IO异常");
    
32.     } catch (BiffException e) {
    
33.         e.printStackTrace();
    
34.     } catch (IOException e) {
    
35.         e.printStackTrace();
    
36.     }
    
37. }
    
38. 
    
39. @Override
    
40. public boolean hasNext() {
    
41.     if (this.rowNum == 0 || this.curRowNo >= this.rowNum) {
    
42.         book.close();
    
43.         return false;
    
44.     }
    
45.     if (this.singleline > 0 && this.curRowNo > this.singleline) {
    
46.         book.close();
    
47.         return false;
    
48.     }
    
49.     return true;
    
50. }
    
51. 
    
52. @Override
    
53. public Object[] next() {
    
54.     Cell[] c = sheet.getRow(this.curRowNo);
    
55.     Map<String, Object> s = new LinkedHashMap<String, Object>();
    
56. 
    
57.     for (int i = 0; i < this.columnNum; i++) {
    
58.         String data = c[i].getContents().toString();
    
59.         s.put(this.columnName[i], data);
    
60.     }
    
61.     this.curRowNo++;
    
62.     return new Object[] { s };
    
63. }
    
64. 
    
65. @Override
    
66. public void remove() {
    
67.     // TODO Auto-generated method stub
    
68. }
    
69. }

复制代码

    读取Excle用例示例：

1. public class TestDriverData {
   
2.     @Test(dataProvider = "test_selenium1")
   
3.     public void f(Map<String, String> data) {
   
4.         System.out.println("用例标题：" + data.get("comment"));
   
5.   }
   
6. 
   
7.     @DataProvider(name = "test_selenium1")
   
8.     public Iterator<Object[]> dataProvider() {
   
9.         return new ExcelIterator("D:\\data\\ErShouFangWebDetailTest.xls", "testEsfWebDetail");
   
10.     }
    
11. }

复制代码

    Excel展示：

     Excel读取执行用例结果：

梦想家