Selenium中的数据提供程序与TestNG不匹配

Question

public class testngexcel {

    public static ExcelReader excel = null;
    @Test(dataProvider = "newdata")
    public void testData(String username, String password, Integer age) {
        System.out.println(username + " - " + password + " - " + age);
    }

    @DataProvider(name = "newdata")
    public static Object[][] getData() {

            if (excel == null) {
                excel = new ExcelReader("C:\\Users\\Anjali.Nautiyal\\Desktop\\selenium\\testngdata.xlsx");
            }

            String sheetName = "login";
            int rows = excel.getRowCount(sheetName);
            int cols = excel.getColumnCount(sheetName);

            Object[][] data = new Object[rows - 1][cols];

            for (int rowNum = 2; rowNum <= rows; rowNum++) {
                for (int colNum = 0; colNum < cols; colNum++) {
                    data[rowNum - 2][colNum] = excel.getCellData(sheetName, colNum, rowNum);
                }
            }
            return data;

错误：

失败：testData org.testng.internal.reflect.MethodMatcherException：数据提供程序不匹配方法：testData([参数{index=0,Type=java.lang.String,DeclaredAnnotations=[]},参数{index=1,Type=java.lang.String,DeclaredAnnotations=[]},参数{index=2,Type=java.lang.Integer,DeclaredAnnotations=[]}])参数：分别（suiterunner.java:375)在org.testng.suiterunner.java:340)在org.testng.suiterunner.run（suiterunner.java:289)在org.testng.suiterunnerworker.runsuite（suiterunner.java:52)在org.testng.suiterunnerworker.runsuite（suiterunner.java:86)在org.testng.suiterunnerworker.runsuite（suiterunner.java:86)在

Answer 1

我看到的唯一问题是，您是从excel读取的，所以可能所有的值都是以string的形式出现的，除非您将其转换为integer。但是，在测试中，您希望第三个参数age为integer

将type更改为string应可解决此问题

@Test(dataProvider = "newdata")
public void testData(String username, String password, String age) {
        System.out.println(username + " - " + password + " - " + age);
}

下面的代码将引发相同的错误。

@DataProvider(name = "newdata")
public static Object[][] getData() {
    return new Object[][]{
            {"20"},
            {"30"}
    };
}

@Test(dataProvider = "newdata")
public void testData(Integer age) {

    System.out.println(age);

}