51Testing软件测试论坛

标题: selenium 入门学习 (四) [打印本页]
作者: 海鸥一飞    时间: 2018-2-7 15:16
标题: 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;

  5. private int rowNum = 0;
  6. private int curRowNo = 0;
  7. private int columnNum = 0;
  8. private String[] columnName;
  9. private int singleline = 0;

  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.         }

  24.         if (this.singleline > 0) {
  25.             this.curRowNo = this.singleline;
  26.         } else {
  27.             this.curRowNo++;
  28.         }

  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. }

  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. }

  52. @Override
  53. public Object[] next() {
  54.     Cell[] c = sheet.getRow(this.curRowNo);
  55.     Map<String, Object> s = new LinkedHashMap<String, Object>();

  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. }

  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.   }

  7.     @DataProvider(name = "test_selenium1")
  8.     public Iterator<Object[]> dataProvider() {
  9.         return new ExcelIterator("D:\\data\\ErShouFangWebDetailTest.xls", "testEsfWebDetail");
  10.     }
  11. }
复制代码
    Excel展示：
[attach]110689[/attach]
     Excel读取执行用例结果：
[attach]110690[/attach]


作者: 梦想家    时间: 2018-5-14 16:53




欢迎光临 51Testing软件测试论坛 (http://bbs.51testing.com/) Powered by Discuz! X3.2