Selenium MySQL Database connectivity

Here is the code for the connection to a mysql Database using Microsoft SQL Server JDBC driver.

public void DBtest() throws Exception
// Load Microsoft SQL Server JDBC driver.
// Prepare connection url.
String url = “jdbc:mysql://localhost/TEST_DB”;
// Get connection to DB.
Connection con = DriverManager.getConnection(url, “root”, “admin”);
// Create statement object which would be used in writing DDL and DML
// SQL statement.
Statement stmt = con.createStatement();
// Send SQL SELECT statements to the database via the
// method which returns the requested information as rows of data in a
// ResultSet object.
ResultSet result = stmt.executeQuery(“select email from user”);
if ({
// Fetch value of “email_address” from “result” object.
String emailaddress = result.getString(“email”);
// Use the fetched value to login to application.“/”);
selenium.type(“login_email”, emailaddress);

Leave a Reply

Your email address will not be published. Required fields are marked *