數(shù)據(jù)驅(qū)動框架（Apache POI – Excel）

import org.apache.poi.hssf.usermodel.HSSFCell;import org.apache.poi.hssf.usermodel.HSSFRow;import org.apache.poi.hssf.usermodel.HSSFSheet;import org.apache.poi.hssf.usermodel.HSSFWorkbook; import java.io.File;import java.io.FileInputStream;import java.io.FileOutputStream;import java.io.IOException; public class ExcelUtils {   private static HSSFWorkbook workbook;    private static HSSFSheet sheet;    private static HSSFRow row;    private static HSSFCell cell;    public void setExcelFile(String excelFilePath,String sheetName) throws IOException {       //創(chuàng)建一個File類的對象來打開xls文件       File file =    new File(excelFilePath);              //創(chuàng)建FileInputStream類的對象以讀取excel文件       FileInputStream inputStream = new FileInputStream(file);              //正在創(chuàng)建引用.xls文件的工作簿實例       workbook=new HSSFWorkbook(inputStream);              //創(chuàng)建圖紙對象        sheet=workbook.getSheet(sheetName);    }     public String getCellData(int rowNumber,int cellNumber){       //從rowNumber和cell Number獲取單元格值        cell =sheet.getRow(rowNumber).getCell(cellNumber);                //以字符串形式返回單元格值        return cell.getStringCellValue();    }     public int getRowCountInSheet(){       int rowcount = sheet.getLastRowNum()-sheet.getFirstRowNum();       return rowcount;    }     public void setCellValue(int rowNum,int cellNum,String cellValue,String excelFilePath) throws IOException {      //在行中創(chuàng)建新單元格并為其設(shè)置值          sheet.getRow(rowNum).createCell(cellNum).setCellValue(cellValue);              FileOutputStream outputStream = new FileOutputStream(excelFilePath);      workbook.write(outputStream);    }}

package utilities; public class Constants {    public static final String URL = "https://demoqa.com/automation-practice-form";    public static final String Path_TestData = "E:\\Projects\\src\\testData\\";    public static final String File_TestData = "TestData.xls";

package testCases;  import org.openqa.selenium.By;import org.openqa.selenium.JavascriptExecutor;import org.openqa.selenium.WebDriver;import org.openqa.selenium.WebElement;import org.openqa.selenium.chrome.ChromeDriver;import utilities.Constants;import utilities.ExcelUtils;import java.io.IOException;import java.util.concurrent.TimeUnit; public class RegisterStudentTest {     //創(chuàng)建ExcelUtils類的對象    static ExcelUtils excelUtils = new ExcelUtils();        //將常量類值用于excel文件路徑    static String excelFilePath =Constants.Path_TestData+Constants.File_TestData;     public static  void main(String args[]) throws IOException {        //設(shè)置Chrome驅(qū)動程序路徑        System.setProperty("webdriver.chrome.driver","E:\\Projects\\chromedriver.exe");                //創(chuàng)建ChromeDriver對象        WebDriver driver = new ChromeDriver();                //啟動指定的URL        driver.get("https://demoqa.com/automation-practice-form");                //確定學(xué)生登記表的WebElements        WebElement firstName=driver.findElement(By.id("firstName"));        WebElement lastName=driver.findElement(By.id("lastName"));        WebElement email=driver.findElement(By.id("userEmail"));        WebElement genderMale= driver.findElement(By.id("gender-radio-1"));        WebElement mobile=driver.findElement(By.id("userNumber"));        WebElement address=driver.findElement(By.id("currentAddress"));        WebElement submitBtn=driver.findElement(By.id("submit"));                //調(diào)用ExcelUtils類方法初始化工作簿和工作表        excelUtils.setExcelFile(excelFilePath,"STUDENT_DATA");         //遍歷所有行以打印每個單元格中的數(shù)據(jù)。        for(int i=1;i<=excelUtils.getRowCountInSheet();i++)        {          //在firstname、lastname、mobile、email、address中輸入從Excel讀取的值          firstName.sendKeys(excelUtils.getCellData(i,0));          lastName.sendKeys(excelUtils.getCellData(i,1));          email.sendKeys(excelUtils.getCellData(i,2));          mobile.sendKeys(excelUtils.getCellData(i,3));          address.sendKeys(excelUtils.getCellData(i,4));                  //使用javascript單擊gender單選按鈕          JavascriptExecutor js = (JavascriptExecutor) driver;          js.executeScript("arguments[0].click();", genderMale);                 //單擊“提交”按鈕          submitBtn.click();                  //驗證確認消息            WebElement confirmationMessage = driver.findElement(By.xpath("http://div[text()='Thanks for submitting the form']"));                        //檢查是否顯示確認消息            if (confirmationMessage.isDisplayed()) {              // 如果顯示消息，則使用excel方法在excel表中寫入PASS              excelUtils.setCellValue(i,6,"PASS",excelFilePath);            } else {                //如果未顯示消息，請使用excel方法在excel表中寫入FAIL                excelUtils.setCellValue(i,6,"FAIL",excelFilePath);            }             //close the confirmation popup            WebElement closebtn=driver.findElement(By.id("closeLargeModal"));            closebtn.click();                     //單擊“關(guān)閉”按鈕后，等待頁面返回注冊頁面            driver.manage().timeouts().implicitlyWait(2000,TimeUnit.SECONDS);        }        //關(guān)閉驅(qū)動程序        driver.quit();    }}