FILLO:WHERE METHOD:
=====================
Syntax:
======
Recordset recordset=connection.executeQuery("Select * from Sheet1").where("COLUMN=VALUE").where("COLUMN=VALUE'");
//Example on where method in fillo
public class Filo_Where
{
public static void main(String[] args) throws InterruptedException
{
Fillo fillo=new Fillo();
Connection connection=fillo.getConnection("C:\\Ramesh\\Test.xlsx");
//with where method
Recordset recordset=connection.executeQuery("Select * from Sheet1").where("Name=Ramesh").where("Course='Selenium'");
connection.close();
}
}
=====================
Syntax:
======
Recordset recordset=connection.executeQuery("Select * from Sheet1").where("COLUMN=VALUE").where("COLUMN=VALUE'");
//Example on where method in fillo
public class Filo_Where
{
public static void main(String[] args) throws InterruptedException
{
Fillo fillo=new Fillo();
Connection connection=fillo.getConnection("C:\\Ramesh\\Test.xlsx");
//with where method
Recordset recordset=connection.executeQuery("Select * from Sheet1").where("Name=Ramesh").where("Course='Selenium'");
connection.close();
}
}
No comments:
Post a Comment