I have a list of n-logins that I would use to n times run the logon script to the site. I have a simple script that logs :
public class loginGoogle {
private WebDriver driver;
private String baseUrl;
private boolean acceptNextAlert = true;
private StringBuffer verificationErrors = new StringBuffer();
@Before
public void setUp() throws Exception {
driver = new FirefoxDriver();
baseUrl = "https://accounts.google.com/";
driver.manage().timeouts().implicitlyWait(30, TimeUnit.SECONDS);
}
@Test
public void testLoginGoogle() throws Exception {
driver.get(baseUrl + "/AccountChooser?continue=https%3A%2F%2Fmail.google.com%2Fmail%2F&hl=pl&service=mail&scc=1");
assertEquals("Logowanie – Konta Google", driver.getTitle());
driver.findElement(By.id("account-chooser-add-account")).click();
driver.findElement(By.id("Email")).clear();
driver.findElement(By.id("Email")).sendKeys("LOGIN");
driver.findElement(By.id("Passwd")).clear();
driver.findElement(By.id("Passwd")).sendKeys("PASSWORD");
driver.findElement(By.id("signIn")).click();
driver.findElement(By.cssSelector("span.gb_X.gbii")).click();
driver.findElement(By.id("gb_71")).click();
}
@After
public void tearDown() throws Exception {
driver.quit();
String verificationErrorString = verificationErrors.toString();
if (!"".equals(verificationErrorString)) {
fail(verificationErrorString);
}
}
}
and I have a script that retrieves data from oracledb:
package orclConn;
import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class orclConn {
public static void main(String[] argv) throws SQLException {
System.out.println("-------- Oracle JDBC Connection Testing ------");
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
} catch (ClassNotFoundException e) {
System.out.println("Where is your Oracle JDBC Driver?");
e.printStackTrace();
return;
}
System.out.println("Oracle JDBC Driver Registered!");
Connection connection = null;
try {
connection = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:mybase", "user",
"password");
} catch (SQLException e) {
System.out.println("Connection Failed! Check output console");
e.printStackTrace();
return;
}
if (connection != null) {
System.out.println("You made it, take control your database now!");
} else {
System.out.println("Failed to make connection!");
}
String sql ="select rownum,login from users";
PreparedStatement preStatement = connection.prepareStatement(sql2);
ResultSet result = preStatement.executeQuery();
while(result2.next()){
System.out.println("Sheet " + result2.getString("rownum") + " login : " + result2.getString("login"));
}
System.out.println("done");
connection.close();
}
}
How does it connect to run the test example. 40 times? Login = password.
