FILLO SELENIUM@Data driven testing framework(mULTIPLE where CONDITIONS)

FILLO::MULTIPLE WHERE CONDITION IN FILLO:
========================================
Syntax:
=====
Recordset recordset=connection.executeQuery("Select * from Sheet1 where column1=value1 and column2=value2 and column3=value3 and column4=value4");


//Example



public class Filo_Update

{

public static void main(String[] args) throws InterruptedException 

{

Fillo fillo=new Fillo();

Connection connection=fillo.getConnection("C:\\Ramesh\\Test.xlsx");

String strQuery="INSERT INTO Sheet1(Name,Course) VALUES('RAMESH','SELENIUM WITH JAVA')";

//with multiple where conditions

Recordset recordset=connection.executeQuery("Select * from Sheet1 where column1=value1 and column2=value2 and column3=value3");

Recordset recordset=connection.executeQuery("Select * from Sheet1 where Name=Ramesh and Course=SELENIUM WITH JAVA and ID=3");

connection.close();

}

}