Pages

Thursday, 15 December 2011

AUTOMATE MULTPLE URLS USING DATABASE

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();
   }
}

No comments:

Post a Comment