Tuesday, 2 February 2016

FILLO SELENIUM@Data driven testing framework(insert)


INSERT IN SQL:
=============
SYNTAX:
========
INSERT INTO TABLE_NAME (column1, column2, column3,...columnN)]
VALUES (value1, value2, value3,...valueN);

Here, column1, column2,...columnN are the names of the columns in the table into which you want to insert data.


//EXAMPLE INSERT COMMAND

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')";

connection.executeUpdate(strQuery);

connection.close();
}
}

No comments:

Post a Comment