FILLO::MULTIPLE WHERE CONDITION IN FILLO:
========================================
Syntax:
=====
========================================
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