package dataDriven;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import org.openqa.selenium.By;

import org.openqa.selenium.WebDriver;

import org.openqa.selenium.chrome.ChromeDriver;

import org.testng.annotations.Test;

import com.mysql.cj.jdbc.Driver;

import io.github.bonigarcia.wdm.WebDriverManager;

public class Test2 {

@Test

public void tc3() throws SQLException {

//Step:1 register the database

Driver driver=new Driver();

DriverManager.registerDriver(driver);

//step:2 connect to database

Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/wsa01","root","root");

//Step:3 create sql query statement

Statement statement = con.createStatement();

String query="select * from logindetails";

//Step:4 execute the query

ResultSet result = statement.executeQuery(query);

while(result.next()) {

System.out.println(result.getString(1));

System.out.println(result.getString(2));

WebDriverManager.chromedriver().setup();

WebDriver driver1=new ChromeDriver();

driver1.get("https://demoapp.skillrary.com/login.php?type=login");

driver1.findElement(By.id("email")).sendKeys(result.getString(1));

driver1.findElement(By.id("password")).sendKeys(result.getString(2));

//Step:5 close the connection /db

con.close();

}

}

}