Tuesday, 2 February 2016

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();
}
}


No comments:

Post a Comment