TestNG中基于PageObjectModel使用DataProvider传参的问题咨询

Hey there! Let's get your TestNG test set up to use that Excel-backed DataProvider alongside your POM's workflow creation method. Here's a straightforward breakdown of how to make it work:

1. First, Confirm Your POM Page Class #

Make sure your Pages layer has a clear, reusable method for creating workflows. For example, let's say you have a WorkflowPage.java with this structure (adjust parameters to match your Excel columns):

import org.openqa.selenium.WebDriver;
import org.openqa.selenium.WebElement;
import org.openqa.selenium.support.FindBy;
import org.openqa.selenium.support.PageFactory;

public class WorkflowPage {
    private WebDriver driver;

    // Map page elements using POM's @FindBy annotation
    @FindBy(id = "workflow-name")
    private WebElement workflowNameInput;

    @FindBy(id = "workflow-description")
    private WebElement workflowDescInput;

    @FindBy(css = "button[type='submit']")
    private WebElement submitBtn;

    // Constructor to initialize page elements
    public WorkflowPage(WebDriver driver) {
        this.driver = driver;
        PageFactory.initElements(driver, this);
    }

    // Your core workflow creation method
    public void createNewWorkflow(String wfName, String wfDesc) {
        workflowNameInput.sendKeys(wfName);
        workflowDescInput.sendKeys(wfDesc);
        submitBtn.click();
        // Add post-submission checks here if needed (like verifying success messages)
    }
}

2. Update Your Test Class with the Linked @Test Method #

Now, modify your test class to connect the DataProvider, inject Excel data, and call the POM method. Here's how your full test class might look:

import org.openqa.selenium.WebDriver;
import org.openqa.selenium.chrome.ChromeDriver;
import org.testng.annotations.AfterMethod;
import org.testng.annotations.BeforeMethod;
import org.testng.annotations.DataProvider;
import org.testng.annotations.Test;

public class WorkflowCreationTest {
    private WebDriver driver;
    private WorkflowPage workflowPage;

    // Your existing DataProvider code
    @DataProvider(name="wf") 
    public static String[][] getExcelData() throws Exception{
        ExcelReader read = new ExcelReader();
        String filePath = "path of excelfile";
        return read.getCellData(filePath, "Sheet1");
    }

    @BeforeMethod
    public void testSetup() {
        // Initialize WebDriver (adjust based on your browser setup)
        driver = new ChromeDriver();
        driver.manage().window().maximize();
        // Navigate to the workflow creation page
        driver.get("your-workflow-creation-page-url");
        // Initialize the POM page object
        workflowPage = new WorkflowPage(driver);
    }

    // Link test to DataProvider and inject Excel data as parameters
    @Test(dataProvider = "wf")
    public void testCreateWorkflow(String workflowName, String workflowDescription) {
        // Call the POM method to execute workflow creation with Excel data
        workflowPage.createNewWorkflow(workflowName, workflowDescription);
        // Optional: Add assertions to validate success (e.g., check for success toast)
        // Assert.assertTrue(driver.findElement(By.id("success-toast")).isDisplayed());
    }

    @AfterMethod
    public void testTeardown() {
        if(driver != null) {
            driver.quit();
        }
    }
}

Key Things to Double-Check #

• Parameter Order: Ensure the order of parameters in your @Test method exactly matches the column order in your Excel sheet. If your Excel has 3 columns, your test method needs 3 corresponding parameters.
• ExcelReader Output: Confirm your ExcelReader.getCellData() returns a 2D array where each inner array represents one row of test data from the sheet.
• Isolated Test Runs: The @BeforeMethod and @AfterMethod annotations handle driver setup/teardown per test iteration, which keeps each workflow creation attempt independent.
• Validation: Don't skip adding assertions—they're critical to confirming the workflow was actually created successfully.

内容的提问来源于stack exchange，提问作者Raghu Hoskote