Testcase file. Testcase with fillo query data driven

Suppose when the query (String qry="Select \* from Sheet1 where ACC='M' and GEN='F'";) returns 5 data rows for one test case and i want to use the same qry for the next case but with different data row

```
public class Testcases {
    public WebDriver driver;
    Fillo fillo;
    static ExtentReports report;
    ExtentTest test;
    //String PAGE_URL = "Your_page_Url";

    @BeforeClass public static void allTestsPrep(){     
        report  = new ExtentReports("Report.html",true);
    }

    @AfterClass public static void allTestCleanUp() {
        report.flush();
    }

    @Before
    public void setUp() {
        String browserName = getParameter("browser");   
        if (browserName.equalsIgnoreCase("chrome")){        
            driver = new ChromeDriver();
        } 
        else if(browserName.equalsIgnoreCase("firefox")) {
            driver = new FirefoxDriver();}
        else if (browserName.equalsIgnoreCase("ie")) {              
            driver = new InternetExplorerDriver();
        }   
        driver.manage().timeouts().implicitlyWait(10, TimeUnit.SECONDS);
        driver.manage().window().maximize();
        // driver.get(PAGE_URL);
    }

    @Test 
    public void Testcase001() throws FilloException, InterruptedException {
        String qry="Select * from Sheet1 where ACC='M' and GEN='F'";
        test = report.startTest("Testcase 1 - Test findpage");
        Useragreement usragr = new Useragreement(driver);
        usragr.CheckboxSelectall();             
        test.log(LogStatus.PASS, "VERIFIED");//report          
    }

    @After
    public void close() { 
        driver.close(); 
        test = null;
    }

    private String getParameter(String name) {
        String value = System.getProperty(name);

        if (value == null)
            throw new RuntimeException(name + " is not a parameter!");
        if (value.isEmpty())
            throw new RuntimeException(name + " is empty!");

        return value;
    }
}

```

Fillo file
Now the code will be `FILLO.inputText(Phone\_Number,"Pno",qry)``;

```
public class FILLOAPP {
    public static String getTestValue(String fieldName, String qry) throws FilloException{
        String testString=xlTesting(fieldName,qry);
        return testString;
    }   
    public static String xlTesting(String fieldName, String qry) throws FilloException{
        String testval=null;
        Fillo fillo=new Fillo();

        Connection connection=fillo.getConnection("resources/TestData.xlsx");
        String sqry=qry;
        Recordset recordset=connection.executeQuery(sqry);

        while(recordset.next()){
            ArrayList<String> dataColl=recordset.getFieldNames();
            Iterator<String> dataIterator=dataColl.iterator();

            while(dataIterator.hasNext()){
                for (int i=0;i<=dataColl.size()-1;i++){
                    String data=dataIterator.next();
                    String dataVal=recordset.getField(data);
                    if (data.equalsIgnoreCase(fieldName)){
                        String testData=dataColl.get(i);   
                        String testValue= recordset.getField(testData);
                        testval=testValue;
                    }
                }

                break;
            }
        }

        recordset.close();
        connection.close();
        return testval; 
    }

    public static void inputText(WebElement driver, String fieldName, String  qry) throws FilloException{
        String fval=getTestValue(fieldName, qry);
        driver.sendKeys(fval);
    }
}

```