Here is the code to Automate multiple URL's stored in a Database table name MultiLogin......
package qtt.selenium;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.Statement;
import com.thoughtworks.*;
import com.thoughtworks.selenium.DefaultSelenium;
import org.junit.*;
import org.openqa.selenium.server.SeleniumServer;
public class DBtestURL
{
DefaultSelenium selenium;
SeleniumServer ss;
String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
String url = "jdbc:odbc:TestDB";
String username = "";
String password = "";
@Before
public void setup()throws Exception
{
ss= new SeleniumServer();
ss.start();
selenium = new DefaultSelenium("127.0.0.1",4444,"*chrome","http://");
selenium.start();
}
@Test
public void test()throws Exception
{
Class.forName(driver);
Connection conn = DriverManager.getConnection(url, username, password);
Statement st = conn.createStatement();
st = conn.createStatement();
ResultSet rs = st.executeQuery("SELECT * FROM MultiLogin");
while(rs.next())
{
String URL =rs.getString(1);
System.err.println(URL);
selenium.open(URL);
selenium.windowMaximize();
Thread.sleep(20000);
}
}
@After
public void teardown() throws Exception
{
selenium.stop();
ss.stop();
}
}
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.Statement;
import com.thoughtworks.*;
import com.thoughtworks.selenium.DefaultSelenium;
import org.junit.*;
import org.openqa.selenium.server.SeleniumServer;
public class DBtestURL
{
DefaultSelenium selenium;
SeleniumServer ss;
String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
String url = "jdbc:odbc:TestDB";
String username = "";
String password = "";
@Before
public void setup()throws Exception
{
ss= new SeleniumServer();
ss.start();
selenium = new DefaultSelenium("127.0.0.1",4444,"*chrome","http://");
selenium.start();
}
@Test
public void test()throws Exception
{
Class.forName(driver);
Connection conn = DriverManager.getConnection(url, username, password);
Statement st = conn.createStatement();
st = conn.createStatement();
ResultSet rs = st.executeQuery("SELECT * FROM MultiLogin");
while(rs.next())
{
String URL =rs.getString(1);
System.err.println(URL);
selenium.open(URL);
selenium.windowMaximize();
Thread.sleep(20000);
}
}
@After
public void teardown() throws Exception
{
selenium.stop();
ss.stop();
}
}
No comments:
Post a Comment